Stock Management
CSV Format:
lookup_code, type (g=glass/s=spacer/e=extra/HW=hardware), measure (m2/Ea/Mt/%age), description, cost_rate_m2, cost_rate_each, cost_rate_mtr_run, cost_rate_percentage, time_minutes, thickness
PLEASE NOTE:
Your newly created data set included a sample set of glass stock files, they are all set to £1.00 per mt - YOU NEED TO AMEND THE FILES to reflect your current purchase prices. This can be done two ways:
a) edit each stock item one by one (you can also delete stock items you do not require, and add new files) or
b) Back up the stock file, open the file in excel and edit all the prices, and save the file again - open the saved file, check its saved correctly, then click Clear All Stock - then upload the edited csv file back to the app.
| Lookup Code | Type | Measure | Description | Cost/m² | Cost/Each | Cost/mtr | %age | Time (min) | Thickness (mm) | Actions |
|---|