Why stock needs checking location by location
When a Shopify store has more than one location, each variant has its own stock quantity at each location. A product CSV's quantity column doesn't cover that: Shopify applies it only to stores with one location. Stock for each location goes through the inventory CSV instead, so that's the file to check.
1. Export Shopify's inventory with one row per location
In Shopify admin, go to Products, then Inventory, and select Export. Choose All states, so each location has its own row, and export.
The other format, Available, puts each location in its own column. It's harder to compare, and Shopify's help notes that it doesn't protect against accidental overwrites.
In the All states export you'll find, for each variant and location:
On hand (current), Shopify's stock when you exported;
On hand (new), the column you edit to set a new quantity;
Available, Committed, Unavailable and Incoming, which are marked not editable;
Not stocked, where a location has never stocked that variant.
2. Decide which number you're comparing
Before you compare, decide what your own file counts:
A count of stock on hand compares with On hand (current).
A figure for stock that's available to sell compares with Available.
If you're not sure, compare with On hand, and note that you did.
Committed, Unavailable and Incoming are Shopify's own figures. Read them as context; they aren't something your count should match.
3. Match items and locations exactly
Each row in both files needs the same item and the same location:
Match items by SKU when every variant has its own SKU. If two variants share a SKU, that SKU can't be matched one to one; use the product handle and option values instead.
Match locations by name. Location names must be the same as in Shopify. Decide for each name in your file which Shopify location it is, or leave its rows out on purpose and write down that you did.
If your file has two rows for the same item at the same location, resolve that first; there's no single quantity to compare.
4. Compare the two files
For each item and location, look up the Shopify row and compare the quantities:
The numbers differ: note both, and the difference.
Shopify says Not stocked at that location, but your file has a quantity: note it separately, because Shopify doesn't stock the item there.
The row is only in your file: check the SKU or handle, since Shopify's export has no such item at that location.
The row is only in Shopify's export: that's expected if you counted only some items.
A quantity of 0 is still a quantity. A row with 0 is compared like any other, not treated as missing.
This works by hand or with a spreadsheet lookup for a small count. It gets slow with many variants and locations.
5. Before you import, find the rows Shopify would skip
An inventory CSV import sets stock; it doesn't add to it. Shopify replaces the quantity with the value in On hand (new), and leaves the quantity unchanged when On hand (new) is empty.
If stock changes in Shopify after you export, Shopify skips the affected rows when you import and keeps its own number. To find them before you import:
Export Shopify's inventory again.
For each row in your planned file, compare its On hand (current) with the new export's On hand (current).
Rows where they differ would be skipped. Export again and redo those rows before you import.
Shopify emails you about the rows it didn't import, so check that email after you import.
Shopify's inventory CSV is limited to 15 MB, and quantities are whole numbers.
6. Or check it in your browser
Crowdfile makes Shopify Inventory Location Check, a free tool that runs steps 2 to 5 in your browser tab. You choose Shopify's inventory export and either your count or warehouse file or the inventory CSV you plan to import.
With a count file, you choose the SKU (or handle and option values), location and quantity columns, say whether the quantity is stock on hand or stock available to sell, and match or ignore each location name. With an import file, it uses Shopify's own columns.
For each location it lists what differs, what's Not stocked at this location, what's In uploaded file only or In Shopify only, and what Would be skipped. Rows with an empty On hand (new) are shown as Left as is, and rows it can't match one to one are listed rather than counted as matches. You can download a receipt as CSV or text. Your files stay in your browser and are never uploaded. Crowdfile is not affiliated with Shopify.
7. What this guide can't do
It can't tell you which number is right; it shows where your files and Shopify differ. It doesn't change any stock. To change quantities, edit On hand (new) in your planned file, check it again, and import it in Shopify.