To import your stock in POSitive Point of Sale you first need to prepare the data to import.
PLEASE NOTE: What you import need to be correct else you will get problems later on.
Use the attached "Stock Import.csv" file to enter all your stock items into using the table below to explain the fields:
| Field | Description / Values | Required |
| Stockcode | The code you use for the item | YES |
| Barcode Number | The EAN barcode printed on the item | |
| Service Item | 0 = Stock Item, 1 = Service Item | |
| Open Priced Item | 0 = Priced, 1 = Cashier must enter price in POS | YES |
| Supplier Name | ||
| Supplier Code | ||
| Supplier Stockcode | ||
| Description | YES | |
| Category 1 | Category 1 Code | |
| Category 2 | Category 2 Code | |
| Category 3 | Category 3 Code | |
| Minimum Stock | ||
| Discountable | 0 = Can not discount, 1 = Can discount | |
| Reorder Qty | ||
| Input Tax | Tax Group e.g. '01 - 15.00' | YES |
| Output Tax | Tax Group e.g. '01 - 15.00' | YES |
| Cost Avg | ||
| Cost Excl | ||
| Cost Incl | ||
| Markup | Percentage e.g. 75.5 | |
| Sell Excl | ||
| Sell Incl | ||
| Price 2 Excl | ||
| Price 2 Incl | ||
| Price 3 Excl | ||
| Price 3 Incl |
Data in the CSV file should not contain:
- / (a forward slash)
- \ (a back slash)
- ' (an apostrophe)
- " (a quote)
- , (NB: a comma)
Once you entered all your items in the CSV file, save it.
On the File menu select Import and then Stockcoeds (CSV)
Click the checkbox "1st Row contains column headers" then select the csv file and click the OK button. Once all items has been loaded, click the Import button.
Last but not the least, ensure you create the Suppliers and Categories you used in your Import sheet.