How to fix it
- Go to the line the checker names and close or double the quote.
- If the quote is part of a measurement such as 12" frame, write it as 12"" inside a quoted cell, or write in for inches.
Example
A file with this problem
Title,URL handle,Price Frame,frame,20.00 "12 in Frame,frame-12,25.00
What the checker says about it
- A quoted field that starts on or after line 3 is never closed. The file may be cut off or have a stray double quote. Shopify reports this as "Illegal quoting" or "Missing or stray quote".
Once the listed rows are fixed, check the file again; the checker also looks for every other problem Shopify documents, so you do not trade one error for the next.
Questions
- What does "Missing or stray quote on line" mean in Shopify?
- Same cause as "Illegal quoting": a quote mark opens a cell that never closes, or sits in the middle of an unquoted cell. Shopify then reads the rest of the file as one long cell.
- How do I fix it?
- Go to the line the checker names and close or double the quote. If the quote is part of a measurement such as 12" frame, write it as 12"" inside a quoted cell, or write in for inches.
Other Shopify import errors
- Validation failed: options are not unique
- Validation failed: price can't be blank
- Inventory quantity can't be blank
- Inventory quantity is not a number
- Inventory policy is not included in the list
- Fulfillment service can't be blank
- All checks
Sources
- Shopify Help Center: Solutions to common product CSV import problems: https://help.shopify.com/en/manual/products/import-export/common-import-issues
Based on Shopify's help pages for product CSV import. Not tested on a live store.