Shopify Product CSV columns are shifted or wrong
What this means
A row has more or fewer cells than the header row, or values appear under the wrong Shopify CSV columns. This usually means the CSV structure was changed by a spreadsheet app, manual editing, or pasted text.
Why it matters before Shopify import
Column shifts can make Shopify read prices as inventory, descriptions as titles, or image URLs as unrelated fields. The import error can look unrelated to the real cause.
How to fix it in the CSV
- Check whether every row has the same number of cells as the header row.
- Look for unescaped commas in text fields such as
Body (HTML). - Check for broken quotes or line breaks inside a cell.
- Re-export from Shopify if the edited file is heavily damaged.
Example
| Expected header count | Problem row count | Likely cause |
|---|---|---|
| 52 columns | 54 cells | Extra commas or broken quoting |
In this example, the row has extra cells, so fields after the broken text may be read under the wrong Shopify columns.