The most common Shopify CSV import errors (and how to fix them)
A Shopify CSV import error rarely says which cell is wrong. These are the problems behind most failed product imports, usually caused by a file that drifted away from the Shopify CSV template — and what the fixer does with each one.
1. Column headers Shopify doesn't recognise
Shopify matches columns by their exact name. A typo such as Varient Price or variant sku means the column is ignored. The fixer suggests the correct Shopify header — a close misspelling is offered as a rename you confirm — and flags a missing Handle column. Columns that aren't part of the Shopify template (your own notes, metafields) are kept as they are.
2. Encoding: “Café” instead of “Café”
Files saved by Excel on Windows are often not UTF-8, and a file decoded twice shows garbled accents. The fixer reads Windows-1252 files correctly, repairs double-encoded text when the original can be recovered with certainty, removes the byte-order mark, and always exports UTF-8.
3. Prices with commas or currency symbols
Variant Price → fixed
19,90 → 19.90
$12.50 → 12.50
€ 1 299,00 → 1299.00
1,250 → needs manual review (1250 or 1.25?)Shopify expects a plain number with a dot as decimal separator. When a value could be read two ways, the fixer never guesses: it marks it for review.
4. Yes/No instead of TRUE/FALSE
Published, Variant Requires Shipping, Variant Taxable and Gift Card accept TRUE or FALSE. Values like yes, no, 1 or 0 are converted; anything else is flagged.
5. Broken rows and wrong separators
Rows with missing cells, extra empty cells, unbalanced quotes or a semicolon delimiter (common in European Excel exports) are reported. Safe cases are fixed; a row with an extra value — usually an unquoted comma inside a description — is left for you to check.
Why variants in a Shopify CSV are not duplicates
In a Shopify products CSV, one product spans several rows: the first row holds the product details and the following rows with the same Handle hold its variants or extra images. A generic duplicate remover would destroy them. The fixer understands this structure and checks what actually breaks imports:
Handle,Title,Option1 Name,Option1 Value,Variant SKU
classic-tee,Classic Tee,Size,S,TEE-S
classic-tee,,,M,TEE-M ← variant, fine
classic-tee,,,M,TEE-M2 ← same option "M" twice: flagged- two variants with the same option values;
- a variant without an
Option1 Valuewhen the product has several variants; - option values with no
Option1 Nameon the product's first row; - a different Title, Vendor or Type on a variant row (Shopify ignores it);
- rows of one product split across the file, or rows with no Handle at all.
How the Shopify CSV validator works
- Load your products CSV, open it from the CSV viewer with the “Shopify” button, or try the sample file.
- Review each issue: where it is, why Shopify cares, and the value before and after the fix.
- Apply the fixes you select in one batch — and undo any batch.
- Download a clean UTF-8 CSV and import it in Shopify under Products → Import.
Nothing is sent to a server and the tool never connects to your store. That keeps supplier prices and unreleased products private.
Preparing the file from scratch? Our step-by-step guide covers encoding, separators, required columns and a pre-import checklist: how to clean a CSV before a Shopify import (in French).
Step-by-step guides
- Fix Shopify CSV prices with commas or currency symbols
- Fix broken accents in a Shopify CSV (UTF-8 encoding)
- Fix duplicate variant combinations in a Shopify CSV
- Fix Shopify CSV column names (and map supplier headers)
Free vs Pro
The diagnosis is free for any file: you see every problem with its explanation and the suggested fix. Applying the fixes and exporting the corrected file are part of CSV Viewer Pro (3,99€/month, or 2,99€ for a 24-hour pass if you only have one import to clean up). Receive the same supplier file every week? Map its columns once, save the steps as a cleanup recipe, and replay them on the next file in one click. Pro also removes the limits on merging supplier files and on opening very large catalogs.
Frequently asked questions
- Why does Shopify reject my product CSV?
- The usual causes are a misspelled or missing column header (Shopify needs "Handle" to group variants), a file that is not UTF-8, prices written with a comma or a currency symbol, values other than TRUE/FALSE in columns like Published, and variant rows that repeat the same option combination. The fixer above checks all of these and tells you the exact row and column.
- Is this an official Shopify validator?
- No. It is an independent tool that checks your file against Shopify’s documented product CSV format. It never connects to your store — the file is analyzed entirely in your browser and is never uploaded.
- Will it delete rows that share the same Handle?
- No. In a Shopify CSV, several rows with the same Handle are the variants (and extra images) of one product, so they are never treated as duplicates. Only two variants with exactly the same option values are flagged — and that is left for you to resolve.
- Does it change values automatically?
- Nothing changes until you click Apply. Unambiguous fixes are pre-ticked ("19,90" becomes 19.90, "yes" becomes TRUE) and you can untick any of them; guessed column renames are offered but left unticked. A price like "1,250" (one thousand two hundred fifty, or 1.25?) is marked “needs manual review” and never changed. Every batch of fixes can be undone.
- Are my extra columns and row order kept?
- Yes. Columns Shopify does not know — metafields, notes, supplier data — are kept as they are, and rows stay in their original order. The export is a plain UTF-8, comma-separated file ready for Products → Import.
- What is free and what needs Pro?
- Checking a file is free: you see every problem with an explanation. Applying fixes and downloading the corrected CSV need CSV Viewer Pro (3,99€/month, or a 24-hour pass for 2,99€). You can try the full before/after on the sample file for free.