Find the actual header row

Suppliers often place a price-list date or brand name above the table. Choose the row containing the column labels in Map columns. Confirm that the first data record appears directly below it. Blank rows are skipped.

Map fields by meaning

Start with Title. Map Item Code to SKU, Selling Rate to Price, and Colour to Option1 value only if colors really represent purchasable variants. Select the worksheet and preview its rows before accepting suggestions. When two labels could both mean SKU, pick the one that identifies a particular variant.

Review skipped columns

Inspect the list of unmapped columns. A supplier may include cost, stock or shipping dimensions that this converter does not export. If you need those values in Shopify, prepare them separately using the appropriate workflow. Columncraft saves mappings by unique header name, so a reordered supplier catalog can still match.

Reference Shopify’s product CSV reference.