Shopify’s CSV Is a Specific Contract
Shopify product CSVs are not generic product tables. Handles, variant rows, image columns, and inventory fields must follow Shopify’s template. Inventing headers or merging variant rows incorrectly creates duplicate products or missing SKUs.
Always start from Shopify’s sample CSV or an export from your own store.
Which Shopify CSV Do You Need?
Different admin screens export different shapes.
| CSV | Typical use |
|---|---|
| Products | Catalog create/update, migrations, bulk edits |
| Customers | List imports, marketing migrations |
| Orders (export) | Fulfillment analysis, accounting, ops |
| Inventory | Location-level quantity updates |
| Discount / other | Follow that feature’s own template |
Step-by-Step: Product Import
A safe bulk catalog workflow.
- Export products from Shopify (or download the sample template).
- Edit in Excel/Sheets carefully—or clean in the Online CSV Editor.
- Keep Handle stable; variants share a handle with different Option values.
- Ensure Variant SKU uniqueness where you rely on SKUs.
- Use UTF-8 CSV; avoid Excel mutating barcodes and SKUs.
- Save via Excel to CSV if needed, then Import in Shopify Admin.
- Review the import results email/log for failed rows.
Product Matrix Essentials
Variants are multiple rows, not multiple columns of unrelated products.
- First row for a handle often carries shared title/body/image fields.
- Subsequent variant rows repeat the handle with option/SKU/price/inventory.
- Blank required fields on variant rows can wipe data on update—know update vs create behavior.
- Image URLs must be publicly fetchable for Shopify to download them.
Customers and Orders
Customer imports need valid emails and consent fields as required by your region and Shopify’s template. Order exports are usually analytical—edits rarely re-import cleanly as new orders; use them for ops and accounting, not casual round-trips.
Real-World Examples
Common Shopify CSV jobs.
Store migration
Merchant exports from an old platform, maps to Shopify’s product CSV, pilots 20 SKUs, then imports the full catalog.
Seasonal price update
Ops exports products, changes Variant Price only, re-imports, and spot-checks the storefront.
Wholesale customer load
B2B emails cleaned in CSV, tags added, then customer import with tags for segmentation.
Common Mistakes
Shopify’s importer is strict for good reasons.
- Changing handles unintentionally and creating duplicate products.
- Scientific notation on barcodes after Excel.
- Broken image URLs (401/404).
- Wrong inventory column for multi-location shops.
- Re-importing a stale export and overwriting newer admin edits.
Best Practices
Catalog hygiene.
- Version catalog CSVs (catalog_2026-07-25.csv).
- Pilot imports on a development store when possible.
- Keep SKUs and barcodes as text.
- Document which columns you intentionally update.
- Use Convert CSV Online to fix encoding and preview before upload.
Why Use Convert CSV Online?
Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview Shopify exports, convert Excel workbooks to UTF-8 CSV, and catch SKU/barcode mutations before Admin import. Client-side workflows work on Windows, macOS, and Linux browsers.
See variants as rows
Confirm handle grouping and option columns in the Online CSV Editor before you upload.
Conclusion
Shopify CSV imports work when you respect the official template, keep handles and SKUs stable, and verify UTF-8 text fields. Export, edit carefully, pilot, then import.
FAQ
How do I import products into Shopify with CSV?
Start from Shopify’s product CSV template or an export, edit rows carefully (especially handles and variants), save UTF-8 CSV, and use Admin → Products → Import.
Why are my Shopify variants wrong after import?
Usually handle mismatches or incorrect option columns. Variants must share a handle and use Option1/2/3 fields as documented.
Can I update prices with a Shopify CSV?
Yes—export, change price fields, and re-import. Pilot a few SKUs first so you do not overwrite unintended columns.
How do I stop Excel from breaking barcodes?
Format columns as text before editing, or use the Online CSV Editor / Excel to CSV with care so IDs stay strings.
Can I re-import Shopify order CSV to create orders?
Order exports are mainly for analysis. Creating orders usually needs Admin, API, or specialized apps—not a casual CSV round-trip.
Where is Shopify’s official CSV documentation?
In Shopify Help under importing/exporting products and customers with CSV files—always match the current template.
References
Convert your CSV in the browser
Preview, clean, and convert CSV files free with Convert CSV Online—no installation and no account required for everyday conversions.