CSV product import

Almost every migration starts as a spreadsheet, and almost every spreadsheet has columns in an order nobody else would have chosen.

How it works

• Columns are mapped to fields explicitly rather than by position, so a file with columns in a different order still imports.
• Variants import against their parent, each with its own SKU, barcode, price and stock.

Import into an empty catalogue first

The dangerous import is the second one. The first populates an empty shop and any mistake is obvious. Later imports run against a catalogue you have improved by hand, and an unmapped column can overwrite descriptions and prices that took weeks.

Treat a re-import as a change to live data, because it is.

What it does not do

It will not clean your data. Inconsistent brand spellings, missing barcodes and three variations of the same size label come in exactly as they are — and they matter later, because channel exclusion rules and barcode matching both depend on that data being consistent.