The three ways drift enters a file
Drift is almost always introduced in one of these places:
Common Scenarios:
- Unquoted description text: '100% cotton, pre-shrunk' without quotes becomes two columns.
- Pasted data from web pages: HTML entities or commas from copy-paste break the row.
- Hand-built header rows: a header row with an unquoted comma shifts every data row below it.
Detect drift before it reaches your store
ShopTools' validator counts values per row, flags rows that drift, and repairs unquoted commas automatically - so prices and SKUs stay in the columns Shopify expects.
Features:
- Column count check: Flags rows whose value count differs from the header
- Quote repair: Wraps unquoted commas and quotes in the right fields
- Row-level reporting: Points to the exact row that drifted
Find and fix drift
- Open the CSV in a plain text editor - not Excel, which hides the damage.
- Look for rows where the value count differs from the header count.
- Find the field that contains the unquoted comma and wrap it in double quotes.
- Re-validate the file and confirm every row now has the same number of columns.
Before and after
- Before: Title: Men's Shirt, Cotton, Variant Price: 19.99 (unquoted comma -> price lands in next column) After: "Men's Shirt, Cotton", Variant Price: 19.99 (quoted -> price stays put)
- Before: Row has 6 values where header has 7 (one column missing at the end) After: Row has 7 values matching the header
Who gets hit by drift
- Supplier CSV imports: Supplier files are the most common source of unquoted commas
- Stores with mysteriously wrong data: Wrong prices or SKUs that imported 'successfully'
Frequently Asked Questions (FAQ)
- What is column drift exactly?
- An unquoted comma is read as a column separator, so every value after it shifts one column to the right. The import succeeds but the data lands in the wrong fields.
- Why does Excel not show the problem?
- Excel reads the file the same way the parser does, so the damage is already in the data. You need to compare value counts, not eyeball the spreadsheet.
- Can drift happen with quoted fields?
- No - fields wrapped in double quotes are read literally, commas included. The problem is always unquoted commas or quotes.
- Does ShopTools fix drift automatically?
- It detects rows with mismatched column counts and re-quotes the fields that need it, then re-exports a clean CSV.