I want to use a CSV to update quantities on multiple different products but I read that I cannot update quantities on a product CSV, only on the Inventory CSV which is almost impossible to find a) the template or b) figure out how the heck to export the inventory for a SPECIFIC group of anything!
I swear I was able to do this last week and this HAS to be a new change because I've been working with importing the product CSV for a few months now. I have product groups with HUNDREDS of products that will need to be updated, I really need to be able to do this through an import, not manually on the bulk editor.
Where can I find the CSV template for inventory updates?
Solved! Go to the solution
This is an accepted solution.
I also encountered this problem today. Upon digging more, I found out that this happened as I enabled local delivery. Below is the way I solved it.
Step 1 : Exported the inventory sheet from inventory section here: https://care-n-cure-pharmacy.myshopify.com/admin/products/inventory
Step 2 : Update the excel sheet that we received with new inventory quantities.
Step 3: Imported the revised sheets and inventory was perfectly updated.
This should also work for you. Please do let me know if you need any more help.
This is an accepted solution.
You need to use inventory csv import now. You were able to use product csv import to update quantity in the past.
The only fields you need to have in your csv inventory file import is Handle and Name of location
<Name of location> - The amount of inventory in the location specified by the column name.
The column heading is case sensitive and must be the name of one of your locations. Include a column for each location where you want to update inventory. Remove any other location columns and headings.
The number can be positive, negative, or 0. You can also enter Not stocked to indicate that the product is never stocked at the location.
Also note: To uniquely identify a variant, specify values for the Handle, Option1 Value, Option2 Value, and Option3 Value columns.
If you are updating quantity on a regular basis we could automate the process depending on how you are currently getting new inventory values. This could eliminate the need to import csv files manually.
Sorry saw your reply after I posted. You could still export using product export to generate a specific list of products in your csv file. Then you simply remove all columns apart from "Handle" and add the inventory location as your second column. I know it is a bit annoying you can't filter the inventory list. Hopefully they add it in the future.
Your feedback solved the problem for me. Thank You Shansalam!!
In the past I've been able to update my inventory using the Product Inventory IMPORT ... all-of-a-sudden I noticed my quantities were out of whack and customers were buying items that are no longer in stock. Everything was working just fine ... something changed on the backend out of the blue and there goes an entire day of hacking on something that WAS working!
For those reading it's no longer
Products :: All Products :: Import
>> It's now Products :: Inventory :: Import
>>> Learn more about importing inventory
Thank you, I also figured this out (thanks to my IT husband who also read the help file and told me which columns to use) but my question is WHY WHY WHY do I have to now, export and file, which was was going to use to edit various fields and then do TWO SEPARATE imports, one for all 25 other fields I can update and the other for JUST THE INVENTORY!!?? Why can't I update it when I do the product import changes? This has added three extra steps for me. I now have to do this the way you described, which just seems ridiculous.
When did this change?
The products table no longer stores inventory level but rather it links to the inventory table through an ID. So basically you can only use a csv import into one table and as the data is stored in 2 tables you need to run 2 csv imports. There is an inventory_quantity value on product but that is simply a sum of your inventories from locations so you cannot update this value directly.
The product level inventory API was meant to have been deprecated October 1 so sometime after this the change would have taken place to remove that option for updating inventory on the product level. The ability to use inventory separately was implemented in 2018. Probably needed some additional notifications for people that use csv imports that the system was changing.
OK! So it changed in October!? Wow, that was recently, and that means I'm NOT (completely) crazy then!!
YES to adding MORE NOTIFICATIONS and YES to they should have SAID SOMETHING! Sometimes making updates to how the shipping purchase page looks or a few cosmetic changes are not nearly as important as the administrative changes that have a HUGE impact on NUMBERS. I mean, I don't even know how many items I thought I was updating that weren't actually changed.
By the way, I know it's not your fault since you're nice to enough to answer my questions. But hopefully someone from Shopify actually reads this and senses my frustration about this change.