Shopify CSV guides

Practical explanations and checked examples for common Shopify product CSV import errors.

Shopify CSV “Illegal quoting on line”: how to fix it

Check that your product CSV is UTF-8, then inspect missing or stray straight quotes near the reported line. Do not import the file until its structure is valid.

Shopify CSV “Invalid CSV header: missing headers”: what to check

Check the first CSV row for the exact product column names your import needs. A missing Title header is a common cause, but required columns depend on whether you create products, update them, or add variants.

Shopify CSV “Validation failed: options are not unique”: how to fix it

Look for two variant rows with the same Option1–3 value combination under one product handle. Do not change every repeated handle: variants of one product normally share it.