Importing products from XLSX
Importing products from XLSX
Importing products from XLSX
You can bulk-import your product catalog from an Excel file.
Steps
- In the Products module click Import
- Download the XLSX template
- Fill in the template following the column guide below
- Upload the file
- Review the preview (name, SKU, price, VAT %)
- Click Import to confirm
Template columns
| Column | Required | Note |
|---|---|---|
name | Yes | Product name |
sku | No | Product code |
description | No | Description |
unitOfMeasure | No | Default kom; see allowed values |
defaultPrice | No | Number with decimal comma or dot |
currency | No | Default EUR |
pdvPosto | No | VAT % as a number (e.g. 25, not 25%) — must match an existing active rate |
kpdCode | No | Format 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.00Import errors
- Each invalid row is reported individually
- Valid rows are imported even when other rows have errors
pdvPostothat 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.