Prepare first
Every unit you use in the file must already exist under Products > Units. If a unit is missing, the system refuses the file and tells you which row has the problem.
Import products
- 1. Open Products > Import Products.
- 2. Tap Download template file.
- 3. Open the file in Excel. Do not change the order of the columns. The first row holds the column headings, so products start on the second row.
- 4. Fill in one product per row, for example Product A.
- 5. Save the file as .xls, .xlsx or .csv.
- 6. Go back to the Import Products page and choose your file under File To Import.
- 7. Tap Submit.
The columns that matter
The Import Products page has an Instructions table listing every column. The required ones are:
- Product Name.
- Unit: the name of a unit already in the system.
- Manage Stock?: type 1 for yes or 0 for no.
- Selling Price Tax Type: inclusive or exclusive.
- Product Type: single or variable.
- Purchase Price: fill in either the Including Tax or the Excluding Tax one. One is enough.
Opening stock
There are two ways to bring stock in:
- New products: fill in the Opening Stock column in the products file. If you leave Opening stock location blank, your first branch is used.
- Products already added: use Products > Import Opening Stock. This needs the opening stock permission. Download its template, fill in SKU, Quantity and Unit Cost (Before Tax), plus Location if you want. Upload as above.
If the file is rejected
If one row has an error, the system rejects the whole file and adds nothing. Read the error message, fix that row in Excel and upload again. That way you never end up with half a list in the system.
How many products you can import depends on your package. After importing, check a few products in List Products, and print labels for the ones with no barcode.
For keeping your list clean afterwards, read how to manage inventory.