Go to Products > Inventory, click Export, choose a location or all locations, choose All states or Available, choose which variants, and click Export inventory. You get a CSV with a row per variant per location (All states) or a column per location (Available). For stock value, sales rates or adjustment history, export the matching report from Analytics instead. Purchase orders download as PDFs, and stock counts can't be exported at all.
The short version
- Inventory counts: Products > Inventory > Export.
- All states shows every state per location, and is the one to edit and import back.
- Available is simpler: one column per location, available only.
- Value, sales and history: export the report from Analytics > Reports.
- Stock counts can't be exported; purchase orders download one at a time as a PDF.
Exporting counts step by step
- Products > Inventory > Export.
- Export from: one location, or All locations.
- Inventory states shown: All states (recommended) or Available.
- Export: current page, all variants, selected variants, or variants matching your search.
- Export as: pick the file format.
- Export inventory.
What the two formats look like
All states, one row per variant per location:
| Handle | Location | Incoming | Unavailable | Committed | Available | On hand (current) | On hand (new) |
|---|---|---|---|---|---|---|---|
| lilikoi-butter | Kitchen | 0 | 2 | 6 | 40 | 48 | |
| lilikoi-butter | Market | 0 | 0 | 0 | 12 | 12 |
Available, one column per location:
| Handle | Kitchen | Market |
|---|---|---|
| lilikoi-butter | 40 | 12 |
For a year-end count sheet, All states is better: on hand is what's on the shelf. Shopify inventory CSV template explains every column.
Exporting other inventory data
| What you want | Where |
|---|---|
| Stock value at cost | Analytics > Reports > Month-end inventory value > Export |
| Units sold per day | Inventory sold daily by product |
| Adjustments beyond 180 days | Inventory adjustment changes |
| Product details, SKUs, costs, barcodes | Products > Export (the product CSV) |
| A purchase order | Open it > download as PDF |
A made-up example: year-end for the accountant
Kahuku Farms Jam closes its year on December 31. The owner exports All states for all locations on the morning of January 1, before any orders ship, and the Month-end inventory value report for December. The accountant gets both, plus a separate list of fruit, sugar and jars counted by hand, because those aren't in Shopify. Shopify year-end inventory covers the full routine.
Where this stops working
An export is a snapshot of finished products. It doesn't include ingredients or packaging, doesn't say which batch each unit came from, and is out of date the moment an order comes in. Many makers end up exporting every week to update a spreadsheet of ingredients, and the spreadsheet is always a little behind. Shopify raw materials inventory and Shopify bulk update inventory cover the round trip.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and keeps ingredients, packaging and finished products in one place, with stock value by site and month ready to print or export as a spreadsheet. Counts include everything on the shelf, and finished products' new quantities go back to Shopify, so there's no weekly export to keep a sheet in step. Free for 14 days.
