← ImportSift

Shopify CSV: "Illegal quoting" / unclosed quote error

What's happening: A text field (usually Body (HTML) or Title) has a stray or unclosed double quote, so the importer reads the rest of the file as one giant field.

How to fix it

1. Find the row the error names and look for a " inside the text, e.g. 12" frame.
2. Inside a quoted field, every literal quote must be doubled: "12"" frame".
3. Easiest fix: open the file in Google Sheets and download it again as CSV. Sheets escapes quotes correctly.

Not sure which rows are affected? Drop the CSV into the free checker: it lists every problem row by row, in your browser (the file isn't uploaded).

Check my CSV free

Other import errors

• Shopify CSV: variants import as separate products (blank Handle)
• Shopify CSV: option value without an option name
• Shopify CSV: "variant already exists" / duplicate variants
• Shopify CSV: garbled characters (’, é) after import
• Shopify CSV: product images don't import
• Shopify CSV: inventory tracker / policy / weight columns rejected
• Shopify CSV: "Illegal quoting" / unclosed quote error
• Shopify CSV: columns shifted / values in the wrong column
• Shopify CSV: "Title can't be blank"
• Shopify CSV: blank Variant Price

ImportSift is independent and not affiliated with Shopify. · support@importsift.com