Bulk import: spreadsheets in, clean catalogue data out

Column mapping is a review step, not a guess

The importer matches incoming headers against a registry of known catalogue fields across every domain, product, variant, category, brand, supplier, delivery, SEO, inventory, images, recommendations and attributes, and then shows you the mapping and a preview. You correct the two columns it read differently to how you meant them, and only then does it import.

It also recognises WooCommerce exports and their attribute column conventions, which removes the most common manual reshaping step when a store moves across.

• Map once, reuse for the next drop from the same supplier
• Preview shows the parsed result, not just the raw file
• Attribute columns are detected rather than typed out by hand

Money and units are normalised on the way in

Prices are converted to integer cents, weights from kilograms to grams and dimensions from centimetres to millimetres. Storing money as cents removes the rounding class of bug entirely, and normalising units means a courier rate table can trust the numbers it is given.

Two doors: admin import and supplier upload

Your team uses the general importer with full field coverage. Suppliers use a narrower upload with a fixed set of core columns, their code, barcode and product name, plus around fourteen optional fields such as short description, colour, weight in grams and dimensions, and an images column. Supplier files land in a reviewable batch rather than in the catalogue.