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