So I am attempting to update my product inventory counts in bulk via CSV file exporting/importing. Everything is set for shopify to track inventory, so I exported a single product to CSV from the Shopify Inventory page, including all of it's variants. Manually edited the "Variant Inventory Qty" fields, saved the CSV, and then finally imported via the Inventory page on Shopify. A message pops up that says everything imported okay without any errors, and I also get an email saying basically the same, no errors. The only problem is that when I go back to the products page in the Shopify backend, none of the quantities are updated at all, and nothing has changed. What exactly am I doing wrong here? FYI, I only have 1 location in Shopify.
Hello @Craig40 , Perhaps, CSV is still working. You just need to fill 'Inventory Tracker' column with 'Shopify' for each Variants and simply import it. You can test it for 1 style with multiple variants.
Inventory was separated from products a couple of years ago and it was completely deprecated in October. You can still update inventory using csv files but they are separate from product csv files: https://help.shopify.com/en/manual/products/inventory/inventory-csv
The reason that you need to run 2 separate csv files is that the data is stored in separate tables so you cannot updates inventory values at same time as your product csv import.
Hi Tom and others,
this thread is a few months old, but I just stumbled across it while trying to find out why the shopify help says product csv should not be used to update inventory quantities. You say the same; may I ask for more information about it? As far as I see it, I can upload product csv files including "Variant Inventory Qty" amounts and it processes fine. Am I missing something? Or are you and the shopify help just refering to situations with more than one location, in which case it must be the inventory csv for updates?
Thank you for clarification!
This option still remains:
|Variant Inventory Qty|
The number of items you have in stock of this product or variant. This column is used only for Shopify stores that have a single location.
If your store manages inventory at multiple locations, then this column isn't included. If you want to import or export inventory quantities, then use the inventory CSV file.
Required, but can be blank.
Learn more about how overwriting existing products affects the data in this column.
Hi @GV-Dallas ,
Throwing our hat in here as well. You can use Mixtable's Excel-like spreadsheet interface to directly update your Shopify product inventory in bulk without having to export/import CSVs. Mixtable will also show you a message if the inventory update fails for some reason (e.g., you haven't set up Shopify to track inventory for a specific product).
I am so frustrated I could throw this computer. I find it very hard to believe that this has to be such a long drawn out process.
I don't find this beginner friendly at all. & I have been all day long trying to make this easy, I just cant figure it out.
When I update one product at a time for quantities, Im fine. ONE PRODUCT NOW JUST ONE!
When I try to do in bulk It wont take all the products or it takes some of them.
Yes Im using CSV files .
Hats off to your Spotify pros cuz this is kickin my butt. I have venders now and I dont know what Im going to do.
How in the HELL am I going to load 3000 products. It'll take me a until the end of summer.
Thanks again for being beginner friendly