Home › Forums › Plugins › Product Importer Deluxe › Support › Limited Quantities
- This topic has 16 replies, 4 voices, and was last updated 13 years, 1 month ago by Support Team.
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.
-
AuthorPosts
-
August 31, 2010 at 4:11 am #6568Huff360Participant
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_forms
WHEREactive
= ‘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?
September 1, 2010 at 9:43 pm #6569Support TeamParticipantHi 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.
September 11, 2010 at 7:19 am #6570Huff360ParticipantAny luck yet?
I’ve beat my head on this all day today and can’t seem to find anything.
September 16, 2010 at 12:58 am #6571ageorgeParticipantI’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!
September 16, 2010 at 7:31 am #6572Support TeamParticipantHey all, taking a look at this during the morning. Will update this topic and put together a primer on this.
September 16, 2010 at 7:46 am #6573mpjtoneParticipantMichael, 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
September 21, 2010 at 12:06 am #6574ageorgeParticipantIs there any news on this? I really need the ability to import quantities and custom meta fields.
September 22, 2010 at 1:24 am #6575Huff360ParticipantNope. 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.
September 23, 2010 at 2:30 am #6576ageorgeParticipantSuccess! 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.
September 23, 2010 at 3:32 am #6577ageorgeParticipantOne 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!
September 23, 2010 at 9:44 am #6578Support TeamParticipantHi 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.
September 23, 2010 at 10:59 am #6579Support TeamParticipant2.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.
September 25, 2010 at 6:38 am #6580Huff360ParticipantSeems 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?
September 27, 2010 at 8:35 am #6581Support TeamParticipantHi 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?
September 27, 2010 at 11:53 pm #6582Huff360ParticipantFor 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.
-
AuthorPosts
- The forum ‘Support’ is closed to new topics and replies.