Why Your Shopify Product Export Fails on Reimport (6 Silent Errors)
Published 2026-05-09
You exported your Shopify products, edited some prices in Excel, and reimported the CSV. Shopify says "import complete" — but your inventory shows 0 across the board, some images are in the wrong order, and two products silently merged into one. No error message anywhere.
This happens because Shopify's export format is not the same as its import format. The export includes columns the importer doesn't accept, leaves required fields blank, and trusts encoding that Excel silently corrupts. Here are the 6 specific failures and what causes each one.
1. Export-only columns cause "invalid column" errors
Shopify's product export includes columns like Variant ID, Product ID, and metafield columns (custom.care_instructions, custom.material). These columns exist only in exports — the importer does not accept them. Leaving them in your CSV causes the import to reject rows or ignore data silently.
Fix: strip every column that isn't in Shopify's 49-column import spec before uploading.
2. Missing Variant Inventory Tracker = stock silently stays at 0
This is the most common reimport failure and the hardest to diagnose. If the Variant Inventory Tracker column is blank, Shopify silently sets inventory tracking to "not tracked" — which means your Variant Inventory Qty value is ignored. Your product shows 0 stock, you get no error, and you might not notice for days.
Fix: every variant row must have Variant Inventory Tracker set to "shopify" (lowercase). The export often leaves this blank.
3. Excel replaces straight quotes with curly quotes
Open a Shopify export CSV in Excel, save it, and Excel silently replaces straight quotes (" and ') with curly/smart quotes (“ ” and ‘ ’). Shopify's CSV parser chokes on these — you get "illegal quoting" errors or corrupted product descriptions with garbled characters.
This also affects barcodes: Excel converts long numeric barcodes to scientific notation (1.23457E+12), permanently destroying the original value.
Fix: convert all curly quotes back to straight quotes. Better yet, don't open the export in Excel at all — upload it directly.
4. Handle corruption causes silent product merges
Shopify uses the Handle column to identify products. Handles must be lowercase, hyphenated slugs (e.g. "classic-cotton-tee"). If Excel or manual editing introduces uppercase letters, spaces, or special characters, two products that had different handles might end up with the same sanitized handle — and Shopify silently merges them on import.
Fix: slugify all handles to lowercase-hyphenated format before reimport.
5. Image positions get scrambled
When you edit rows in Excel — deleting some, reordering others — the Image Position column often ends up with gaps (1, 3, 5) or duplicates. Shopify uses this column to order product images. Wrong positions mean your hero image might appear last, or a detail shot becomes the thumbnail.
Fix: renumber Image Position sequentially (1, 2, 3, ...) within each product (Handle group).
6. Missing required fields cause destructive imports
Several columns cause failures when blank:
- Variant Price — blank means $0.00; your product is free
- Variant Grams — blank can cause shipping calculation errors
- Variant Inventory Policy — must be "deny" or "continue"; blank causes undefined behavior
- Variant Fulfillment Service — must be "manual" or a fulfillment service handle; blank rows get skipped
- Option1 Name / Option1 Value — blank on a parent row creates a product with no default variant, which breaks the Shopify admin UI
- Vendor — must be at least 2 characters; single-character vendors are rejected silently
The fix: run the export through csvtocsv before reimporting
csvtocsv.com/shopify-reimport handles all 6 of these automatically. Drop your Shopify export CSV, and the output has export-only columns stripped, required fields filled, encoding fixed, handles sanitized, and image positions renumbered. The result imports cleanly on the first try.
Try it with the sample file on the page — it includes all 6 failure modes so you can see exactly what gets fixed.