Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought626across 8 categories
Net value£18,437ex VAT, at contract prices
Largest category41.9%Chemicals
Average price£29.45per 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 figures8 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Chemicals | chemicals | 262 | £3,715 | 3 | £14.18 |
| Workwear | workwear | 236 | £4,062 | 2 | £17.21 |
| Janitorial | janitorial | 43 | £949 | 3 | £22.08 |
| Washroom & Paper | washroom | 42 | £860 | 4 | £20.47 |
| NTRL Eco | ntrl | 32 | £467 | 2 | £14.59 |
| Machines | machines | 4 | £8,245 | 2 | £2,061.29 |
| Catering Hygiene | catering | 4 | £52 | 1 | £13.03 |
| PPE | ppe | 3 | £87 | 1 | £29.10 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.