Documentation
Shopify inventory CSV template
Columns Import Ready includes in Shopify product CSV export — inventory policy, tracker, barcode, options, status — and how to prepare a file for Shopify Admin.
Use this guide as a practical Shopify inventory / product CSV checklist. Import Ready exports a Shopify-oriented product CSV you can upload in Shopify Admin → Products → Import.
Columns included in Shopify export
| Shopify column | Source in Import Ready |
|---|---|
| Handle | Generated from product name (+ SKU fallback) |
| Title | Product Name |
| Body (HTML) | Supplier / description mapping |
| Vendor | Brand |
| Product Category | Product Group |
| Option1 Name / Option1 Value | Option1 fields (defaults to Title / Default Title) |
| Variant SKU | SKU |
| Variant Inventory Tracker | Inventory Tracker (shopify or blank when untracked) |
| Variant Inventory Qty | Stock Qty |
| Variant Inventory Policy | Inventory Policy (deny / continue) |
| Variant Price | Price |
| Variant Compare At Price | Compare At Price |
| Variant Barcode | Barcode |
| Image Src | Image |
| Status | Status (active / draft / archived) |
Minimum columns for a clean inventory update
If you are mainly updating stock for existing variants, ensure these are correct:
- Variant SKU — unique identifier Shopify can match
- Variant Inventory Qty — numeric on-hand quantity
- Variant Inventory Policy —
denyorcontinue - Variant Inventory Tracker — usually
shopify
Missing policy is a frequent Admin failure. See inventory policy is not included in the list.
Workflow
- Download a template from Upload a file or start from a Shopify export
- Match columns so Shopify headers map to Import Ready fields
- Fix issues in import preview
- Export Shopify product CSV from Download & export
- Import the file in Shopify Admin (test a small batch first)
Compare before you import
If stock in Shopify does not match your warehouse file, use the free Compare inventory tool or read Fix Shopify inventory mismatch.