Skip to content
Importing products from XLSX

Importing products from XLSX

Importing products from XLSX

You can bulk-import your product catalog from an Excel file.

Steps

  1. In the Products module click Import
  2. Download the XLSX template
  3. Fill in the template following the column guide below
  4. Upload the file
  5. Review the preview (name, SKU, price, VAT %)
  6. Click Import to confirm

Template columns

ColumnRequiredNote
nameYesProduct name
skuNoProduct code
descriptionNoDescription
unitOfMeasureNoDefault kom; see allowed values
defaultPriceNoNumber with decimal comma or dot
currencyNoDefault EUR
pdvPostoNoVAT % as a number (e.g. 25, not 25%) — must match an existing active rate
kpdCodeNoFormat 00.00.00 or raw digits (column preserved as text to prevent Excel reformatting)

Example rows

name                  | sku       | unitOfMeasure | defaultPrice | pdvPosto | kpdCode
Consulting services   | CONS-001  | h             | 100.00       | 25       | 62.00.00
Software license      | SW-LIC-01 | god           | 500.00       | 25       | 58.20.00
Transport             | TRANS-001 | km            | 1.50         | 25       | 49.41.00

Import errors

  • Each invalid row is reported individually
  • Valid rows are imported even when other rows have errors
  • pdvPosto that does not match any active VAT rate → row error
  • Missing product name → row error
Excel can auto-format KPD codes (e.g. converting 62.00.00 to a date). The template protects the kpdCode column as text — do not change the column format.