Skip to content

Shopify Inventory CSV Template: Every Column Explained

The columns in Shopify's inventory CSV, the All states and Available formats, how the overwrite check works, and a filled-in example for two locations.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 4 min read

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.

Questions people also ask

Where do I find Shopify's inventory CSV template?

Export one from Products > Inventory. Shopify's help center also links a sample file, but your own export already has your handles, options and locations filled in.

Why did some rows fail to import?

Usually because the count changed after export, a location name doesn't match, or a quantity isn't a whole number. Shopify emails the failed rows with the reason.

Can I import inventory for products that aren't tracked?

Turn tracking on first. Shopify track quantity shows where.

Sources

  1. Shopify Help Center: Exporting and importing inventory with a CSV file · read October 27, 2026
  2. Shopify Help Center: Adjusting inventory quantities in bulk · read October 27, 2026
  3. Shopify Help Center: Using CSV files to import and export products · read October 27, 2026
  4. Shopify Help Center: Bin locations · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.