Keep the original identifier as text

A supplier code such as 00142 may identify a different item than 142. In Excel, set the column to Text before entering identifiers. When opening a CSV, use the spreadsheet app’s import dialogue and assign Text to the identifier columns. Double-clicking a CSV can trigger automatic number conversion.

Check the preview

Columncraft reads CSV cells as text and uses the formatted XLSX display value. A numeric XLSX cell with the format 00000 can display 00142, but zeros already missing from both the value and the formatting cannot be recovered. Long numeric identifiers can also lose precision inside Excel. Get a source with identifiers stored as text if precision is in doubt.

Check the CSV without reformatting it

Inspect the exported file in a text editor or import it directly into Shopify. Columncraft exports one untyped barcode per variant in the Barcodes column. If two distinct variants share a SKU or barcode, the review shows both row references so you can confirm whether reuse is intentional.

Reference Shopify’s product CSV reference.