Shopify CSV Error Directory
Did your product import fail? Find your exact error code below and learn how to fix it instantly without manual Excel editing.
"Missing or stray quote in line"
This is one of the most common and frustrating Shopify CSV import errors. It happens when your supplier's Excel or CSV file contains unescaped quotation marks (like for inches: 12"), which breaks Shopify's strict CSV parser.
"Line 1: Invalid CSV header"
Shopify expects very specific column names (like 'Title', 'Variant SKU', 'Option1 Value'). If your supplier provides columns named 'Item Name', 'Item Code', or 'Color', Shopify will instantly reject the file.
"Validation failed: Options are not unique"
Shopify requires every variant of a product to have a unique combination of Option values (e.g., Size and Color). If two rows have the same Handle and the same Options, the import will fail.
"Variant Inventory Qty cannot be blank"
If you are tracking inventory, Shopify requires a valid number in the 'Variant Inventory Qty' column. Suppliers often put text here which breaks the import.