Shopify CSV import troubleshooting
Most Shopify product CSV failures come from a small set of formatting problems: bad headers, wrong encoding, duplicate handles, broken variants, or missing required fields. EcomCSVFix checks those issues automatically and gives you a clean file ready to import.
Fix wrong casing, extra spaces, unsupported columns, and hidden BOM characters in the header row.
Convert Windows-1252, BOM-prefixed, or special-character CSV files into clean UTF-8.
Find repeated product handles and make separate products unique without breaking real variants.
Repair missing Option1 Name, Option1 Value, and inconsistent variant structures.
Generate missing handles, flag blank product titles, and normalize product row identifiers.
Shopify product imports are strict because one CSV can create products, variants, prices, inventory settings, images, SEO fields, and product status all at once. A spreadsheet that looks normal in Excel can still fail if the first row does not use Shopify's exact column names, if the file is saved in the wrong encoding, or if the same product handle appears where Shopify expects a unique product.
The most important columns are structural. Handle identifies the product and usually becomes the product URL slug. Title names the product on the first product row. Option1 Name and Option1 Value describe variants such as Size or Color. Fields like Variant Price, Variant SKU, Image Src, and Status must also use Shopify-friendly formats.
The safest way to debug an import failure is to separate structure problems from data problems. First check the header row. Then check encoding. Then sort by Handle and review product groups. Finally inspect variant rows and required fields. That is the same order EcomCSVFix follows when it repairs a file.
Invalid header errors happen when Shopify cannot recognize the first row. The fix is to use exact headers such as Handle, Title, Vendor, Variant Price, Image Src, and Status. Lowercase headers, trailing spaces, supplier-only columns, and a hidden BOM before Handle can all make the file fail before Shopify reads the product rows.
Encoding errors usually come from Excel on Windows, older ERPs, or supplier exports saved as Windows-1252 instead of UTF-8. You may see broken accented characters, currency symbols, or a file that Shopify rejects without a helpful row number. Convert the file to UTF-8 without BOM before importing.
A handle should identify one product. Variant rows for the same product can share a handle, but two separate products should not. Sort by Handle, decide whether repeated rows are true variants or duplicate products, then rename separate products with suffixes such as -2, -3, or a descriptive product word.
Variant problems happen when product rows and variant rows are mixed incorrectly. The first row should include the product Title and option names. Later variant rows keep the same Handle, usually leave Title blank, and provide values such as Small, Medium, Blue, or Black under the same option columns.
Missing Handle and Title values stop Shopify from knowing what product to create. Generate handles from titles using lowercase words and hyphens, then confirm every product parent row has a title. Variant rows can leave Title blank, but the product itself still needs a valid first row.
A clean CSV uses Shopify's exact headers, a UTF-8 file encoding, unique handles for separate products, and consistent option data for variants. A simple two-variant product might look like this:
Handle,Title,Vendor,Option1 Name,Option1 Value,Variant Price
blue-shirt,Blue Shirt,Acme,Size,Small,19.99
blue-shirt,,,Medium,19.99Upload your broken Shopify CSV and get a corrected file plus a clear report of what was fixed.
Free for up to 5 files/month. No credit card.
Invalid headers are one of the most common blockers because Shopify expects exact column names. Handle, Title, Variant Price, Image Src, and other headers need precise spelling and casing.
Yes, but Excel exports can introduce encoding, delimiter, and formatting problems. Saving as CSV UTF-8 and checking the header row before import reduces failures.
Variants break when option names or option values are missing, when later rows repeat product titles incorrectly, or when different rows use inconsistent option columns.
Rename duplicate handles when they represent separate products. Keep the same handle only for rows that are true variants of one product.
Yes. Upload the CSV to EcomCSVFix and it can repair common header, encoding, handle, variant, price, boolean, whitespace, and status issues automatically.
The cleaned file only changes what you import. If you import over existing products, review handles and SKUs carefully because Shopify uses those fields to match or create records.