Shopify or WooCommerce product CSV import fails or garbles products
Last reviewed 2026-09-19
Store platforms expect exact column names and specific formats: handles, prices as plain numbers, yes/no values, and one image per row for extra images. A product export from another system almost never matches, and a single bad column name can make the import ignore whole fields.
Messages you might see
- “Import failed: missing required column (Title / Handle)”
- “Duplicate handles or SKUs”
- “Prices or inventory imported wrongly, images missing”
Why it happens
- Column headers that don't match the platform's exact names.
- Prices with currency symbols or thousands separators, or quantities that aren't whole numbers.
- Duplicate SKUs or handles, or garbled accented characters.
- Several image URLs crammed into one cell.
Try this first (free, no tool needed)
- Download the platform's sample product CSV and compare its headers with yours.
- Import a handful of products first to check the mapping.
- Check prices, inventory and yes/no columns for stray symbols.
If that didn't work
These tools run in your browser. Your file is read and repaired on your own device and is never uploaded.
Shopify/WooCommerce Product CSV Fixer
Detects the platform, renames columns to its exact headers, repairs garbled text, cleans prices, quantities and yes/no columns, generates or tidies Shopify handles, splits extra image URLs onto their own rows, and reports missing required columns, duplicate SKUs and compare-at prices below the price. It reports missing required data; it does not invent it.
Open Shopify/WooCommerce Product CSV FixerCommon questions
Does it work for every platform?
It detects the common ones. Check the report to see which it recognised and compare with the platform's own sample file.
Is my file uploaded anywhere?
No. The tool runs as a program inside your own browser, so the file is read and repaired on your device and never sent to a server.