Template repair

Shopify CSV Template Fixer

Repair product spreadsheet structure so it looks more like Shopify expects.

Tool entry

Start with your product workbook.

The current self-service workflow accepts XLSX uploads. If your catalog is a CSV, save it as an XLSX workbook first, then use this entry to run the relevant Shopify CSV cleanup flow.

Open upload workflow

Scenario

A product spreadsheet can contain good product data but still use the wrong template for Shopify. Supplier files, marketplace exports, ERP reports, and manual Excel sheets often use column names that Shopify does not recognize. Product names, colors, sizes, prices, inventory, and image links may all be present, but they need to be mapped into Shopify’s product CSV format before import.

This page focuses on template-level repair. It helps users understand whether the problem is not the products themselves, but the structure of the file: column headers, missing fields, product grouping, variant option columns, price fields, and image URL placement. That distinction matters because a file can fail even when the underlying product data is useful.

Use this entry when the spreadsheet looks close to a product catalog but not close enough to Shopify’s expected CSV. The output should be easier to validate, review, and import, while keeping the original supplier data available for comparison.

Real example

Input and output for this workflow.

Input

A supplier Excel file uses columns like Item Name, Color, Size, Cost, Stock, Photo 1, and Photo 2.

Output

A Shopify-style CSV draft with Title, Handle, Option1 Name, Option1 Value, Option2 Name, Option2 Value, Variant Price, and Image Src fields.

FAQ

Common questions before upload.

What is a Shopify CSV template?

It is the column structure Shopify expects for product import, including product fields, option fields, variant fields, inventory fields, and image fields.

Can I fix supplier column names?

Yes. This page is designed around mapping supplier or export column names into Shopify-style product CSV fields.

Do I need every Shopify CSV column?

No. Not every column is required for every import, but key product and variant fields need to be consistent.

How are image columns handled?

Image links can be normalized into Shopify image fields so the output is easier to review before import.

Related tools

Continue with the closest Shopify CSV task.