Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought173across 6 categories
Net value£3,096ex VAT, at contract prices
Largest category27.2%PPE
Average price£17.89per unit, across everything bought
Product Category BreakdownAll sites - Last 12 weeks
The same category split the shop enforces, the buying list is built on and approvers read.
The figures6 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| PPE | ppe | 47 | £550 | 2 | £11.69 |
| Janitorial | janitorial | 38 | £452 | 2 | £11.89 |
| Washroom & Paper | washroom | 35 | £884 | 2 | £25.25 |
| Chemicals | chemicals | 27 | £441 | 2 | £16.32 |
| Workwear | workwear | 16 | £589 | 2 | £36.82 |
| NTRL Eco | ntrl | 10 | £181 | 2 | £18.10 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.