Shopify product import fails: duplicate handles, prices or TRUE/FALSE fields
The most common reasons a Shopify product CSV is rejected or creates wrong products, and how to clean them up.
The message you see
Shopify import: duplicate handles / Validation failedFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Prices contain currency symbols or a comma as decimal separator (€12,50).
- Published or Requires Shipping contain values other than TRUE/FALSE.
- Handles have spaces or capitals, or the same SKU appears twice.
How to fix it
- 1Write prices as plain numbers with a dot: 12.50.
- 2Use only TRUE or FALSE in yes/no columns.
- 3Make handles lowercase with dashes and check for duplicate SKUs.
Related guides
Shopify
Shopify CSV import: “Illegal quoting on line …”
HubSpotHubSpot import error: “Make sure each column with data has a header”
Google SheetsPhone numbers turn into dates or lose their leading zero in Sheets/Excel
Still stuck? Ask SheetFix Support