Shopify import error · from WooCommerce
Shopify CSV import fails: illegal quoting, shifted columns or garbled characters
The import fails outright with a quoting error on some line, or the products arrive with text in the price column and garbled accents. The file is broken before Shopify reads the first product.
Why it happens
A CSV is plain text where a delimiter separates the cells and double quotes wrap the cells that contain delimiters, quotes or line breaks. WooCommerce descriptions are full of all three. If the file is opened and saved again in a spreadsheet, edited by hand, or written by a plugin that does not escape properly, one stray quote shifts every cell after it: the importer either gives up or reads values into the wrong columns. Excel in many countries also saves with semicolons instead of commas.
Encoding is the other half. Shopify expects UTF-8. Saving the export from Excel often writes another encoding, and accented letters, € or ™ come out as � or é.
How the free check finds it
The check reads the file with full support for quoted cells and line breaks inside descriptions, accepts comma, semicolon or tab as delimiter, and compares the number of cells on every row with the header: rows that do not match are flagged with their line number, which is where a quote or delimiter is broken. Replacement characters (�) anywhere in the file are flagged as an encoding problem. If the Type and Name columns are not found at all, the file is reported as not a WooCommerce product export; English and Italian headers are both recognised.
These are the findings the check reports for this problem, each with the lines of your file where it found them:
- Changes silently
Row with the wrong number of columns
Values can end up in the wrong field, usually because of a stray quote or delimiter in the original export.
What to do: Fix the quote or delimiter in that row and export again.
- Changes silently
Export not saved as UTF-8
Accented and special characters would show up as � in Shopify.
What to do: Export again without opening the file in Excel, or save it as CSV UTF-8.
- Must fix
File not recognised as a WooCommerce export
Without the type and name columns (or an email/phone column for customers) nothing can be converted.
What to do: Export again from WooCommerce > Products > Export with all columns selected.
Fix it by hand
- Export again from WooCommerce > Products > Export and upload that file without opening it in a spreadsheet first.
- If you have to edit it, use an editor that saves as CSV UTF-8, and keep descriptions wrapped in quotes.
- Look at the lines the check reports: the broken quote is usually in the description of that row or of the row just before it.
Find this in your own export, free
Upload your WooCommerce product export (and customers, if you like). In about a minute you see every row this affects, with line numbers, before anything touches Shopify. No account, no access to your store.