Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought271across 6 categories
Net value£5,508ex VAT, at contract prices
Largest category60.5%NTRL Eco
Average price£20.33per 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 |
|---|---|---|---|---|---|
| NTRL Eco | ntrl | 164 | £2,541 | 1 | £15.50 |
| Workwear | workwear | 46 | £1,812 | 2 | £39.40 |
| Washroom & Paper | washroom | 25 | £667 | 3 | £26.69 |
| Catering Hygiene | catering | 19 | £323 | 1 | £17.00 |
| Chemicals | chemicals | 16 | £157 | 1 | £9.81 |
| PPE | ppe | 1 | £7 | 1 | £7.38 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.