Updating stock quantities for the items not in the import file

  • Resolved digimarky

    (@digimarky)


    4 years, 5 months ago

    I am in a bit of a predicament. I have a CSV import file with about 1000 products. This file gets updated once a day from my supplier. I download the stock quantity of these 1000 products Every day mapping the unique SKU id. The problem is that every new update has about 50 SKU’s missing as they go out of stock. When I download the file, quantities update just alright except the missing SKU’s on my website have no way to update since they’re not on the file. Is there a way for me to import a CSV in a way where it updates stock for all sku’s in the file and the sku’s that were not in the file, set them to quantity = 0. Thanks for much for your help and support.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WP All Import

    (@wpallimport)

    Hi @digimarky

    Is there a way for me to import a CSV in a way where it updates stock for all sku’s in the file and the sku’s that were not in the file, set them to quantity = 0.

    If you’re using an “Existing Items” import, I’m afraid there’s currently no way to do that because WP All Import does not know which products are not in the file. You may be able to write custom code that uses our API (see documentation) to do it, but it would be a bit complicated.

    Is it possible for you to get a file that only contains the products that were removed from the stock feed?

    Thread Starter digimarky

    (@digimarky)

    Hello, thanks for your reply. Unfortunately there no way for me to get the file with out of stock products file.

    Plugin Author WP All Import

    (@wpallimport)

    Hi @digimarky

    Unfortunately there no way for me to get the file with out of stock products file.

    That’s unfortunate.

    Does the stock update file include all of the product information? In other words, could you use it in a “New Items” import to initially create the products and then re-run that same import to update the stock when the file is updated (see documentation)?

    Or, does it only contain stock information and SKUs?

    Plugin Author WP All Import

    (@wpallimport)

    Hey @digimarky,

    I’m going to mark this as resolved since it’s been a while. Feel free to follow up here if you still have questions about this.

    Anyone else, please open a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Updating stock quantities for the items not in the import file’ is closed to new replies.