Shopify's inventory CSV has one row per variant per location. The required columns are Handle, Location and Option1 Value (plus Option2 and Option3 Value when a product has them). To change stock, fill in On hand (new). If you keep the On hand (current) column from your export, Shopify compares it with the live count and skips any row that changed since you exported, so you can't overwrite a sale by accident. Get the template by exporting from Products > Inventory, not by building it from scratch.
The short version
- Export from Products > Inventory > Export, choose All states, and edit that file.
- Change only On hand (new). Leave it blank for rows you aren't changing.
- Whole numbers only. Use Not stocked for a product never stocked at that location.
- Location names are case sensitive and must match Shopify exactly.
- The file can be up to 15 MB. Rows that fail come back in an email.
The two formats
| Format | Layout | Overwrite protection |
|---|---|---|
| All states (recommended) | A row per variant per location, a column per state | Yes, via On hand (current) |
| Available | A row per variant, a column per location, available only | No |
The columns in the All states file
| Column | Edit it? | Notes |
|---|---|---|
| Handle | No | Identifies the product |
| Title | No | For reading only |
| Option1 Name / Value | No | Value identifies the variant; "Default Title" if no options |
| Option2, Option3 | No | Required when the variant has them |
| SKU | No | Shown for reference; change SKUs in the product CSV |
| HS Code, COO | Optional | Duty code and country of origin |
| Location | No | Must match a location name exactly |
| Bin name | Optional | One bin per variant per location |
| Incoming, Unavailable, Committed, Available | No | Shown, not editable |
| On hand (current) | No | The count at export, used for the overwrite check |
| On hand (new) | Yes | The number you want on hand |
A filled-in example
Kahala Kombucha, an invented brewery, sells cans from its brewery and a taproom. After a Sunday count, the edited rows:
| Handle | Option1 Value | Location | Bin name | On hand (current) | On hand (new) |
|---|---|---|---|---|---|
| ginger-kombucha | 4-pack | Brewery | C-01 | 120 | 112 |
| ginger-kombucha | 4-pack | Taproom | 36 | 36 | |
| guava-kombucha | 4-pack | Brewery | C-02 | 80 | |
| guava-kombucha | 4-pack | Taproom | 18 | 15 |
The guava row at the brewery is left blank, so nothing changes there. If the taproom sold a ginger 4-pack between the export and the import, its On hand (current) no longer matches, so Shopify skips that row and emails the owner instead of overwriting the sale.
Common mistakes
- Editing in a spreadsheet that reformats. Barcodes and handles that look like numbers lose leading zeros. Import as text.
- Typing the location slightly differently. "taproom" isn't "Taproom".
- Clearing On hand (current) to make an import go through. Shopify allows it for emergencies, but it removes the overwrite protection.
- Using the inventory CSV to create products. It updates stock only; new products go in the product CSV. Shopify inventory export covers the reverse trip.
Where this stops working
The CSV moves numbers. It doesn't know why they changed, so an import doesn't carry a reason the way an adjustment does, and the history won't tell you whether 8 cans went missing or were drunk at a tasting. It also only holds what you sell. The tea, sugar, cans and lids behind those 4-packs have no rows. Shopify bulk update inventory compares the CSV with the bulk editor, and Shopify stocktake covers counting before you import.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and counts on a phone, works with no signal in the brewhouse, and shows what each difference is worth before you post it. Ingredients and packaging are counted in the same pass. When you post, the finished products' new quantities go to the matching Shopify locations, so there's no file to export, edit and import. Free for 14 days.
