Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought855across 7 categories
Net value£13,326ex VAT, at contract prices
Largest category73%Chemicals
Average price£15.59per 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 |
|---|---|---|---|---|---|
| Chemicals | chemicals | 624 | £6,502 | 3 | £10.42 |
| PPE | ppe | 85 | £2,710 | 3 | £31.88 |
| Washroom & Paper | washroom | 72 | £2,837 | 1 | £39.40 |
| Janitorial | janitorial | 58 | £973 | 2 | £16.78 |
| NTRL Eco | ntrl | 8 | £122 | 2 | £15.29 |
| Workwear | workwear | 5 | £158 | 1 | £31.60 |
| Catering Hygiene | catering | 3 | £24 | 1 | £7.89 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.