In Products, Export CSV writes the product list to a file you can open in Excel. Import CSV/Excel reads a CSV or Excel file: products whose SKU already exists are updated, the others are created.
Export
- Open Products and press Export CSV.
- Choose where to save the file. Open it in Excel or any spreadsheet program.
Import
- Prepare a file with one product per line and the column names in the first line. The easiest way is to export first and keep the same columns.
- In Products, press Import CSV/Excel and choose the file (.csv, .txt or .xlsx).
- The till shows how many products were created and updated, and lists the lines it could not read.
Columns the till recognises (other names for the same thing are accepted too):
| Column | Meaning |
|---|---|
| sku | your product code; decides whether a line updates or creates |
| name, name_ar, name_fr | the names |
| barcode | one or several barcodes |
| price, cost | selling price and cost |
| department, category, brand | created when they do not exist yet |
| tax | the name of the tax rate |
| unit, weighed, plu | for goods sold by weight |
| stock | opening stock for a new product |
| reorder_point, active | reorder level; active yes / no |
- It needs the right to import products. Make a backup first when the file is large.
- To move everything from another point-of-sale program (products, customers, suppliers), use the import wizard: see How do I bring my products and customers over from another point-of-sale program?.
For: Manager Owner since version 1.0.0
Did this help?
Thank you. Your answer helps us improve the help.