How to fix a Shopify product CSV before you import it
5 min read
A Shopify product CSV looks like a simple spreadsheet, but one stray currency symbol or broken image link can fail an import or publish hundreds of half-finished listings. Here is how to fix a Shopify product CSV properly, and what to check before you press Import.
Understand how Shopify structures the file
Shopify does not store one product per row. Every row that shares the same Handle belongs to the same product: the first row carries the title, description, vendor, type, tags and SEO fields, and the rows below it hold extra variants and extra images.
That is why sorting or filtering the file in a spreadsheet is risky. If variant rows are separated from their first row, or a handle is repeated further down for a different product, Shopify will merge or overwrite products in ways you did not intend.
The problems that break Shopify CSV imports
Most failed or messy imports come down to a short list of issues:
- Prices with currency symbols or thousands separators, such as “$1,299.00” instead of 1299.00.
- Image Src values that are not full http or https URLs.
- Variant rows with no price or no SKU.
- The same handle used for two different products.
- A compare-at price that is lower than the selling price, so no discount shows.
- Empty titles, or titles pasted from a supplier in ALL CAPS.
Fix prices, SKUs and handles first
Start with anything that can stop the import. Variant Price and Variant Compare At Price must be plain numbers with a dot as the decimal separator. Remove currency symbols, currency codes, spaces and thousands separators.
Then look for duplicate SKUs and handles. Duplicates are not always errors, but they are rarely intentional, and they cause inventory and URL conflicts. Decide which product is the real one before importing rather than letting Shopify decide for you.
Then fix what shoppers and search engines see
Once the file will import, improve the content. Every product should have a description, at least one working image, and alt text for each image. Fill in SEO Title (around 60 characters) and SEO Description (120 to 160 characters); if they are empty, a sensible default is the product title and the first sentence or two of the description.
Tidy the titles as well: convert ALL CAPS to Title Case, remove double spaces and keep titles under about 70 characters so they are not cut off in search results.
Check a Shopify CSV automatically
Doing this by hand across a thousand rows takes hours and is easy to get wrong. Catalio reads your Shopify export in the browser, groups rows by handle the way Shopify does, runs 25 checks on every product and fixes the safe ones automatically, then gives you a CSV with exactly the same columns to import back.