@itstaytime Can you share a sample CSV file you’re working with? Feel free to PM me with the link if you’d prefer. I’ll take a look.
Topic summary
Recurring CSV import errors when importing products, most often “Invalid CSV Header: Missing headers: Title” (also shown in German) and “Illegal quoting.” Root cause is frequently file formatting rather than missing data.
Key fixes and guidance:
- Avoid Excel; it can alter characters on save. Use Google Sheets or Apple Numbers, then export as CSV. Copying the contents into a fresh CSV resolved several cases.
- Use Shopify’s official product CSV template and ensure headers match exactly. UTF-8 alone isn’t sufficient if structure/formatting is off.
- Variants/options: put Option 1 Name and the corresponding Option 1 Value on the same row; don’t list variant values on a new line. Remove Option 3 Name if Option 3 Value is empty.
- Status column: if present, it must have values; otherwise omit it.
- Handles (the product URL slug) must match existing products when updating; duplicates or mismatches cause skips and update failures.
- Ensure image URLs are accessible.
Actions: Trevor tested and shared corrected CSVs, identified column/variant issues, and requested files/screenshots; some users received email follow-up.
Outcomes: Multiple users resolved issues by reformatting in Google Sheets/Numbers and aligning with the template. Latest post reports “Option value provided for unknown options”; thread remains open with ongoing troubleshooting.