You can use an Excel file to import products to the product setup. To do this, you should use the columns mentioned below. Add one line per product (split VAT can be added manually at a later stage).

Pay attention! This feature is not designed to export products, make changes to the products and then import the products again. Products will not be overwritten but are rather added as new products.

Name

Short description

Long description

Internal description

Category

Amount per item

Unit

Price

Cost price

VAT percentage

Product code

General ledger number

Have a look at this example including most important columns

Units explanation:

* Units:

'' => 'None'

'pcs' => 'Piece'

'g' => 'Gram'

'kg' => 'Kilogram'

'l' => 'Liter'

'h' => 'Hour'

'day' => 'Day'

'crate' => 'Crate'