Why imports fail before the data rows
Most header-related import failures come from one of these problems:
Common Scenarios:
- A header was renamed by Excel auto-formatting, e.g. 'Body HTML' instead of 'Body (HTML)'.
- The file was saved without UTF-8 BOM and non-English characters turned into garbage.
- A custom column was added that Shopify does not recognize.
- Columns were reordered and Shopify reads values into the wrong fields.
Get the file right from the first row
ShopTools provides the exact 51-column header as a downloadable CSV template. Use it as a base and run the result through the validator to catch any formatting mistakes before import.
Features:
- Exact Shopify headers: All 51 columns in the correct order and spelling
- UTF-8 BOM: Opens correctly in Excel, WPS and Google Sheets
- Validator-ready: Drop the finished file into the ShopTools checker before import