Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought217across 7 categories
Net value£5,596ex VAT, at contract prices
Largest category22.6%Washroom & Paper
Average price£25.79per 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 figures7 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Washroom & Paper | washroom | 49 | £1,516 | 2 | £30.94 |
| NTRL Eco | ntrl | 46 | £640 | 1 | £13.91 |
| Workwear | workwear | 44 | £1,686 | 2 | £38.31 |
| Janitorial | janitorial | 29 | £812 | 2 | £28.00 |
| PPE | ppe | 24 | £238 | 1 | £9.91 |
| Chemicals | chemicals | 20 | £555 | 2 | £27.75 |
| Catering Hygiene | catering | 5 | £150 | 1 | £30.00 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.