Advanced Import/Update (CSV)
Back to ProductsCSV Column Structure
Your Excel file must contain exactly 9 columns in the following order. Save it as CSV (Comma delimited).
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
|---|---|---|---|---|---|---|---|---|
| Stock Code e.g. ST1001 |
Product Name e.g. Wood Panel |
Category ID Number |
Unit Cost e.g. 5000 |
Currency USD or NGN |
Prod. Margin % (e.g. 10) |
Sales Margin % (e.g. 25) |
Srv. Margin Type PERCENT, USD, or NGN |
Srv. Margin Val. Number |