CATALOGFIX FIELD NOTES · SHOPIFY CSV

All guides

How to convert a supplier Excel file to Shopify CSV

Your supplier's spreadsheet describes its catalog. Shopify expects product data in its own structure. The useful work happens between those two formats.

Updated 22 November 2026 · By CatalogFix

Already have a correctly formatted Shopify CSV? You may not need a converter. Use Shopify's native importer. CatalogFix is for preparing supplier files that still need column matching or corrections.

Start with a small, understandable file

Keep a copy of your original workbook. Use one header row and put each product or variant on its own data row. For this walkthrough, the fields are product name, SKU, price, color, size and stock.

Download the free supplier CSV

Fictional source data for practice. This is a supplier-format example, not a ready-to-import Shopify template. No payment or signup is needed for this download.

Three variants of one fictional product
Product nameSKUPriceColorSizeStock
Demo T-shirtDEMO-BL-S19.90BlueS10
Demo T-shirtDEMO-BL-M19.90BlueM11
Demo T-shirtDEMO-GR-S21.90GreenS0

Match what each column means

Open CatalogFix and choose your file. The app recognizes supported column labels such as “Product name”, “SKU” and “Price”. Review the detected columns and correct the mapping if your supplier uses different labels.

Check that the selling price is the value you intend to charge. A supplier's cost column is not automatically your retail price. Similarly, a reference code may identify a product family rather than an individual variant.

Check grouping before you export

In CatalogFix, rows with the same name or handle are grouped into one product. Our example has one T-shirt and three color/size combinations. If two unrelated items share a name, give them distinct names or handles before continuing.

Review the variant combinations as well as the SKUs. The same color and size repeated twice may mean a duplicated row. A quantity of zero is meaningful; it is different from a missing quantity.

Review, export and test the import

  1. Resolve the findings reported by the app and run the checks again.
  2. Check the product preview against your source file. Confirm names, combinations, prices and quantities.
  3. If the result suits your needs, choose the corrected CSV export. It costs €9.90 total; checking and previewing are free.
  4. In Shopify, open Products and use Import to review the CSV before proceeding. Start with a small test and back up existing product data before making changes.

Shopify requires its expected CSV columns and related data. Its current product CSV reference explains the format, and its import guide explains the import steps.

Know the limits. CatalogFix accepts UTF-8 CSV and XLSX up to 2 MB and 10,000 data rows. Preview shows up to 100 rows. The export includes all validated rows. Inventory is intended for one Shopify location. The tool does not check your live store, promise import acceptance or perform a lossless update of existing products.

What if the file has errors?

Use our walkthrough of common supplier CSV problems to practice fixing a duplicate SKU and a non-numeric price. You can work on the fictional example before uploading any real catalog.

Check my supplier file