How to Fix Shopify CSV Import Errors (Complete Guide 2026)
Updated April 2026 · 5 min read
If you've ever tried importing products into Shopify and hit a wall of red error messages, you're not alone. Shopify's CSV importer is strict — column names must match exactly, booleans must be in a specific format, and every product needs a handle. One wrong value and the whole import fails silently or skips rows without telling you why.
This guide covers the five most common Shopify CSV import errors, what causes each one, and how to fix them — either manually or automatically.
1. Wrong column headers
Shopify expects exact column names with specific casing: Handle, Title, Vendor, Variant Price, and so on. Export a CSV from another platform — WooCommerce, Etsy, a supplier spreadsheet — and you'll get headers like Brand instead of Vendor, Price instead of Variant Price, or handle (lowercase) instead of Handle (capitalised).
Manual fix: Open your CSV in a text editor, compare each header against Shopify's official column list, and rename each one. With 65+ possible columns, this takes 20–30 minutes.
2. Boolean format errors
Shopify requires TRUE or FALSE (all caps) for columns like Published, Variant Requires Shipping, and Variant Taxable. Files exported from other tools commonly use Yes / No, 1 / 0, or true / false (lowercase). Shopify will either reject the row or treat the product as unpublished.
Manual fix: In Excel or Google Sheets, use Find & Replace to swap Yes → TRUE and No → FALSE across every boolean column. Be careful not to replace values in other columns accidentally.
3. Missing or duplicate handles
The Handle column is mandatory. It's the unique URL slug for each product (e.g. blue-denim-jacket). If it's blank, Shopify skips the row. If two products share the same handle, Shopify merges them — overwriting the first product with the second's data.
Manual fix: For missing handles, write a formula in Excel: =LOWER(SUBSTITUTE(B2," ","-")) to generate a slug from the Title column. For duplicates, append -2, -3 manually to each one.
4. Encoding issues from Excel
When you save a CSV in Microsoft Excel on Windows, it defaults to Windows-1252 encoding instead of UTF-8. Characters like é, ñ, ü, £, and € get mangled into gibberish when Shopify reads the file. You might also see an invisible UTF-8 BOM character at the start of the file that breaks the first column header.
Manual fix: Open your file in Notepad++ or VS Code, check the encoding shown in the status bar, then re-save as UTF-8 (without BOM). In Excel, use Save As → CSV UTF-8 (comma-delimited) — this option only exists in newer versions of Office 365.
5. Price formatting issues
The Variant Price column must be a plain number: 19.99. Currency symbols ($, €, £), thousand separators (1,299.00), or locale-specific decimals (19,99 in European formats) all cause import failures or zero-price products.
Manual fix: In Excel, select the price column and use Find & Replace to strip symbols. Then format the column as Number with 2 decimal places and re-export.
Fix all of these automatically in 30 seconds
Doing all five fixes manually on a 500-row product file easily takes an hour — and one missed cell means another failed import. EcomCSVFix detects and repairs all of these issues automatically: it normalises headers, converts booleans, generates missing handles, deduplicates, fixes encoding, and strips price formatting in a single pass.
Upload your file, see a full report of everything that was fixed, then download the clean file — ready to import directly into Shopify.
Fix your Shopify CSV automatically
Upload once. Get a clean, import-ready file in under 30 seconds.
Fix my CSV for free →No account required · Up to 5 files free
Common Shopify CSV import errors
These errors come up constantly. Each one has its own fix.