- This topic has 16 replies, 4 voices, and was last updated 10 years, 11 months ago by
.
Welcome to our community support forums! We're here to help - but if you have an urgent request for a Pro Plugin, you will get a prioritised response through our Premium Support page.
-
Posts
-
I saw there was a new version available, so I’ve updated to 2.4
I’ve hit my next hurdle trying to get all the products imported –I can’t seem to make the ‘limited quantity’ option work. I’ve tried several times with my csv and also with your sample-deluxe.csv download. None of the items are being marked as limited.
I’m not seeing any errors on import, everything seems to work fine. I am seeing entries in php-errors.log file:
[30-Aug-2010 17:59:25] WordPress database error Table ‘hp.wp_wpsc_checkout_forms’ doesn’t exist for query SELECT * FROM
wp_wpsc_checkout_formsWHEREactive= ‘1’; made by require_once, require_once, require_once, include_once, require_once, require_once, wpsc_purchaselogs->wpsc_purchaselogs, wpsc_purchaselogs->getall_formdata[30-Aug-2010 17:59:25] WordPress database error Table ‘hp.wp_wpsc_wishlist’ doesn’t exist for query SELECT COUNT(id) FROM wp_wpsc_wishlist made by do_action, call_user_func_array, vl_wpscn_html_page
Any ideas?
Hi Huff360, I’ll take a look at Limited quantity tomorrow; as far as I was aware it was working, this may have changed later in WP e-Commerce 3.7 series. Will update this topic when I know more.
I’m having the same problem. The quantity field isn’t importing from my CSV. Also, the checkbox “I have a limited number of this item in stock.” isn’t checked either. Please advise…thanks!
Hey all, taking a look at this during the morning. Will update this topic and put together a primer on this.
Michael, while you’re at it, can you give an update on the item I posted last week where the Importer doesn’t work at all in a WP3.0 Multi-site environment? If it’s too hard to fix right away, I understand, but please give us some guidance as to whether the problem can be tackled or not.
http://www.visser.com.au/wp-ecommerce/forums/topic.php?id=50
Nope. Haven’t heard a word. I’ve given up on trying to figure it out myself, I just don’t know enough. That’s why I paid for a plugin that someone else made……. Turns out, that may not have been the best idea.
Success! I messed around with the code for Product Importer Deluxe version 2.4 and I was able to get both the “quantity” and “quantity_limited” to import successfully. Here are my alterations, beginning at line 1050:
‘special_price’ => $wpsc_special, // added a comma at the end of this line
‘quantity’ => $wpsc_quantity, // added this new line
‘quantity_limited’ => ‘1’ // added this new lineThat’s all there is to it! I hope this helps everybody!
Now I just need to figure out how to import all my custom meta fields.
One more thing…the new code in my previous post only works for newly imported products. It won’t update the quantity on existing products (i.e. when you check the box “Are you merging changes into existing Products?”). I messed with the code some more, and I think that I’ve fixed that issue as well. After you’ve applied the changes in my post above, add this block of code after line 1205:
/* Update Product Quantity */ //ZZZZZ added this block to update quantity on existing products
if( $productdata->quantity <> $wpsc_quantity ) {
$wpdb->update( $wpdb->prefix.”wpsc_product_list”, array(
‘quantity’ => $wpsc_quantity
), array( ‘id’ => $wpsc_db_id ) );
}Again…hope this helps everybody!
Hi ageorge, good eye! I’ll get a minor fix out with those changes. I’m back on my feet after a nasty cold and am looking at WordPress 3.0 multi-site support.
2.5 has been released, I’ve included fixes for product quantities provided by ageorge as well as some other related issues. Keen to hear if this resolves the issues you’re experiencing. I’m publishing a post to discuss the best way to manage and impliment custom Product meta support in Product Importer Deluxe and WP e-Commerce.
Seems to be working as it should now. I changed a bit of code to make it see a 0 quantity as just that, rather than unlimited. I think a ‘NULL’ or blank should be unlimited and a 0 simply an item that isn’t in stock. If you need to do that, just comment out the IF statement at lines 1168 and 1174 of version 2.5
Now I’d like to be able to set the tickbox to unpublish items when out of stock. Anyone have any ideas?
Hi Huff360, I could add a new option item under Import Options to control whether all imported Products have this option selected or not. I think this is the best approach, thoughts?
For me, that would be perfect. I’m not sure that I would force it to be an all or nothing option though as I am sure there will be people who need to apply it to certain products only. I can’t imagine a scenario when that would be needed, but I am sure that it is out there.
How about adding a column to the CSV file that allows you to control this? i.e. You put “Yes” or “No” in the ‘auto-hide’ column. Or maybe a 1 or 0 or something.
- The forum ‘Support’ is closed to new topics and replies.
