CATALOGFIX FIELD NOTES · SHOPIFY CSV
All guidesHow 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.
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
| Product name | SKU | Price | Color | Size | Stock |
|---|---|---|---|---|---|
| Demo T-shirt | DEMO-BL-S | 19.90 | Blue | S | 10 |
| Demo T-shirt | DEMO-BL-M | 19.90 | Blue | M | 11 |
| Demo T-shirt | DEMO-GR-S | 21.90 | Green | S | 0 |
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.
- Product name: the customer-facing title.
- SKU: your reference for a specific product or variant.
- Price: a numeric amount in your intended store currency.
- Color and size: the variant choices represented by each row.
- Stock: an explicit quantity for every row if you use inventory, including zero.
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
- Resolve the findings reported by the app and run the checks again.
- Check the product preview against your source file. Confirm names, combinations, prices and quantities.
- If the result suits your needs, choose the corrected CSV export. It costs €9.90 total; checking and previewing are free.
- 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.
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.