Home Forums Plugins Product Importer Deluxe Support Limited Quantities

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.

Viewing 15 posts - 1 through 15 (of 17 total)
  • Author
    Posts
  • #6568
    Huff360
    Participant

    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 WHERE active = ‘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?

    #6569
    Michael Visser
    Keymaster

    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.

    #6570
    Huff360
    Participant

    Any luck yet?

    I’ve beat my head on this all day today and can’t seem to find anything.

    #6571
    ageorge
    Participant

    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!

    #6572
    Michael Visser
    Keymaster

    Hey all, taking a look at this during the morning. Will update this topic and put together a primer on this.

    #6573
    mpjtone
    Participant

    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

    #6574
    ageorge
    Participant

    Is there any news on this? I really need the ability to import quantities and custom meta fields.

    #6575
    Huff360
    Participant

    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.

    #6576
    ageorge
    Participant

    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 line

    That’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.

    #6577
    ageorge
    Participant

    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!

    #6578
    Michael Visser
    Keymaster

    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.

    #6579
    Michael Visser
    Keymaster

    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.

    #6580
    Huff360
    Participant

    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?

    #6581
    Michael Visser
    Keymaster

    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?

    #6582
    Huff360
    Participant

    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.

Viewing 15 posts - 1 through 15 (of 17 total)
  • The forum ‘Support’ is closed to new topics and replies.