
Shopify Inventory Location Check Released
Shopify Inventory Location Check
Compare Shopify stock with your count, location by location.
Your files stay in this browser tab. They’re never uploaded, stored or sent anywhere, and the check never changes them.
How it decides
Stock receipt
Choose Shopify’s inventory export and your stock count, warehouse file or the inventory CSV you plan to import. See which variants and locations differ, which aren’t stocked in Shopify, which are in only one file, and which rows an import would skip.
Check your files
Shopify inventory export
From Shopify admin: Products, Inventory, Export, with “All states” selected. It has one row per variant and location.
Your count or warehouse file
A CSV with a SKU or product handle, a location and a quantity in each row.
Match your file’s columns
Your file’s columns don’t have fixed names, so choose which column holds each value. Nothing is filled in for you.
Match your location names
Location names must match Shopify’s exactly. Names that match are already set. Choose a Shopify location or Ignore for the others.
Each file up to 15 MB.
What it checks
- Variants and locations where Shopify’s on-hand stock differs from your file
- Rows your file has for locations where Shopify doesn’t stock the item
- Rows in only one of the two files
- Rows an inventory import would skip because stock changed since your export
What it won’t do
- It never changes stock, imports anything or connects to Shopify, a 3PL or a POS.
- It doesn’t say which number is right. It shows where the two files differ.
- It doesn’t use the product CSV’s quantity column, which Shopify only applies to stores with one location.
- It doesn’t calculate committed or incoming stock. Those are shown as Shopify exported them.
How to get the files
Shopify’s inventory export: in Shopify admin, go to Products, then Inventory, and select Export. Choose All states, so each location has its own row, and export.
Your count or warehouse file: any CSV with a column for the SKU (or the product handle and option values), a column for the location and a column for the quantity. You’ll choose which column is which.
Checking an import: export the inventory first, edit the quantities in On hand (new), and check that file before you import it. If stock changes in Shopify after your export, Shopify skips those rows when you import, and this check shows which ones.
Your privacy
- Your files are read by your browser, in this tab. They’re never uploaded, stored or sent anywhere.
- The check never connects to Shopify, a 3PL or a POS, and never changes your files.
- The receipt lists items, locations and the two quantities, with no costs, supplier names or columns you didn’t choose.
- When this page counts visits, it sends only content-free events. It never sends file names, items, locations, quantities or counts.
Crowdfile is not affiliated with Shopify.
Compare Shopify stock with your count, location by location.
Free. No account.
Choose your files