Introduction
The hosting service has a basic stock monitoring feature. A column called stock has been added to the products table, to record the stock level for each product. When an invoice is uploaded to the server, the corresponding stock levels are debited.
A new section Stock has also been added to the main menu, with the following options:
| Option | Function |
|---|---|
| Adjust stock levels | Uploads a CSV file containing current stock levels.The stock values in the file overwrite the ones in the products table. Other rows are unaffected, and no other columns are changed. |
| List stock levels | Displays the current stock level for each product. |
| Download stock levels | Downloads a CSV file containing the stock levels for all the items in the products table. This file can be modified, and used as input to the Adjust stock levels option. |
CSV File
The CSV file used for stock levels has the following format:
| Name | Contents |
|---|---|
| productId | Unique id of product |
| stock | Stock level |
| name | Name of product (optional, for reference only) |
