Import Guide
Bulk-load products and variants from a CSV or Excel file — from Dashboard → Products → Import, or POST /api/imports/csv.
File requirements
.csv,.xlsxor.xls, up to 10 MB.- Up to 5,000 rows per import.
- The first row must be a header row. Column order doesn't matter.
- At least a Name or SKU column must be recognized, or the import is rejected before anything is read.
Column matching
Headers are matched case-insensitively against a list of known aliases, so you rarely need to rename your existing export columns. Any column that doesn't match a known field is ignored rather than rejected.
Product-level fields
| Field | Recognized column names | Required |
|---|---|---|
| name | Product Name, Title, Item Name | Yes |
| sku | Item Code, Item Number, Reference, Article Number | Yes |
| description | Short Description, Details | — |
| category | Product Type, Item Category, Group | — |
| brand | Vendor, Manufacturer, Marque | — |
Variant-level fields
All five of these must be present on a row for it to create or update a fully specified variant — a row can still create/update the product with fewer.
| Field | Recognized column names |
|---|---|
| color | Colour |
| size | Dimension |
| production_location | Place of Production, Manufacturing Location, Origin |
| material_composition | Material, Composition, Materials, Fabric |
| care_instructions | Care, Washing Instructions |
Optional variant fields
variant_namegtinean / barcodeseasoncollectionweight_kgpricecurrencyquantityPreview before committing
Every import runs in dry-run modefirst — the file is parsed and every row validated against your company's validation rules with no database writes. You get a per-row breakdown of valid, invalid and warning rows, plus detected duplicate SKUs, before you confirm the actual import. SKUs that already exist are updated in place rather than duplicated.
After import
Each import run is logged as an audit record (rows processed, created, failed, duplicates, and who ran it), viewable from your import history. If a row includes both material composition and weight, Normatrack runs the same automatic carbon-footprint screening estimate it runs for variants created manually — see Getting Started.