Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought73across 6 categories
Net value£3,949ex VAT, at contract prices
Largest category30.1%Janitorial
Average price£54.10per 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 |
|---|---|---|---|---|---|
| Janitorial | janitorial | 22 | £741 | 1 | £33.70 |
| Workwear | workwear | 16 | £896 | 1 | £55.98 |
| PPE | ppe | 13 | £393 | 1 | £30.24 |
| NTRL Eco | ntrl | 12 | £169 | 1 | £14.06 |
| Washroom & Paper | washroom | 8 | £195 | 1 | £24.39 |
| Machines | machines | 2 | £1,555 | 1 | £777.60 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.