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).

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'

Did this answer your question?