Skip to content

How to Export Inventory From Shopify

How to export inventory counts from Shopify by location, the All states and Available formats, exporting reports and history, and what never comes out.

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 · 3 min read

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

  1. Products > Inventory > Export.
  2. Export from: one location, or All locations.
  3. Inventory states shown: All states (recommended) or Available.
  4. Export: current page, all variants, selected variants, or variants matching your search.
  5. Export as: pick the file format.
  6. 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.

Questions people also ask

Can I export Shopify inventory to Excel?

Yes. The export is a CSV, which opens in Excel or Google Sheets. Format barcode and SKU columns as text so leading zeros stay.

How do I export inventory for one location?

Choose that location in the Export from menu.

Can I export Shopify stock counts?

No. Shopify's help center says stock counts can't be exported. Export inventory right after approving the count instead.

Does the export include cost?

The inventory export doesn't. The product CSV has cost per item, and the Month-end inventory value report has cost times quantity.

Sources

  1. Shopify Help Center: Exporting and importing inventory with a CSV file · read October 27, 2026
  2. Shopify Help Center: Inventory reports · read October 27, 2026
  3. Shopify Help Center: Viewing inventory adjustment history · read October 27, 2026
  4. Shopify Help Center: Using CSV files to import and export products · 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.