How to import items from Excel
Specifications :
If you want to be quick, open your Excel file and click on Save as and selectthe formatUnicode Text(*.txt)format.
If you want more detailled specifications :
- The first line is the header. Each cell should contain one of the fields described below
- Encoding : UTF-8 (sometimescalled Unicode)
- Number separator : bothdot or comma separator are allowed
By default, the separator is the tabulation but you can modify it.
Fields :
| Name of the field | Description | Example |
|---|---|---|
| name | Name of the product | Orange |
| price | Price of the product. That price does not include tax | 10 |
| pricewithtax | Price of the product. That price includes tax | 11.55 |
| tax | Tax rate | 15.5 |
| barcode | Barcode | 7891321541 |
| reference | Reference of the product.Will be used if you want to update your products. | 110 |
Every column of your file must have a header which is the name of the field.
Theonly mandatory field is “name”, you can use only this one.
You should only use one of the column price or pricewithtax, but if you want to mix them, you can fill the right column and put 0 in the other field.
Precisions for the format of the tax / price
You should use numeric format.
The separator can be the dot or the comma (. or ,).
You can use space with the thousands separator.
Example of file : (separator: ,)
name,tax,price,barcode,reference
product1,20,10,11,1
product2,10,15,1232,2
Below two example of file (separator TAB):