To import data, go to Settings > Import.
1. Download the template
2. Input or copy and paste your data into the excel. Here are some general guidelines :
- 1. The import file should be in .xlsx format
- 2. All the cells in the excel data file should be in TEXT format (NOT date, boolean etc).
- 3. The header of excel MUST be the same as the template
3. Upload your template.
Note on product data :
| Field | Note | Format |
|---|---|---|
| *** Name (Required) | Bill name is displayed on the receipt as the item purchased by the parents. | TEXT |
| *** Price (Required) | The price of the product | NUMERIC |
| Quantity | NUMERIC | |
| Unit Cost | Cost of the product. For record only. | NUMERIC |