Catalog / Import products

Import products from a spreadsheet

What are you importing?

Choose how your spreadsheet should be used. You can switch modes any time before uploading a file.

  1. Template
  2. Upload
  3. Map columns
  4. 4Validate
  5. 5Import

1 · Download the template

Start from our spreadsheet template so column names match. One row per product; add as many Property: columns as your catalog needs.

Product name * Model code * Category * Description Property: Color Property: Power (W) Property: …
Aria 500 Espresso Machine AR-500 Espresso Machines Café-grade espresso at home… Matte Black 1450
Meridian Kettle v1 VL-120 Kettles Rapid-boil 1.7L kettle… Cloud White 2200

* Required columns. Category values must match your existing categories in Categories & properties.

2 · Upload your spreadsheet

Drop your file here, or browse files

.xlsx or .csv, up to 10MB · one product per row

lumen-catalog-2026.xlsx

412 KB · 190 data rows · 9 columns detected

Parsed

3 · Map your columns to IDRUNE fields

We matched most columns automatically. Check anything marked as unmatched before validating.

Spreadsheet columnIDRUNE field
Product Name Auto
SKU / Ref Auto
Cat. Auto
Colour Auto
Internal notes Check

4 · Validation results (dry run)

Nothing has been imported yet. Rows with errors are always skipped — they never slip through silently.

187

rows ready to import

3

rows have errors — will be skipped

190

total rows in file

3 rows need fixing before they can be imported

Row 24

Missing required field: Model code

“Nimbus Air Purifier” has no value in the SKU / Ref column. Every product needs a unique model code.

Missing field
Row 61

Duplicate model code: AR-500

A product with this model code already exists in your catalog (Aria 500 Espresso Machine). Rename it or remove the row.

Duplicate
Row 143

Unknown category: “Kettles & Toasters”

No matching category found. Did you mean Kettles? Create it first in Categories & properties or fix the spelling.

Unknown category

Fix these in your spreadsheet and re-upload, or continue with valid rows only.

5 · Ready to import

187 products will be created as Draft — nothing goes public until you publish each product.