Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought128across 4 categories
Net value£3,686ex VAT, at contract prices
Largest category31.3%Catering Hygiene
Average price£28.80per 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 figures4 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Catering Hygiene | catering | 40 | £1,663 | 1 | £41.57 |
| Workwear | workwear | 37 | £598 | 2 | £16.16 |
| Chemicals | chemicals | 33 | £731 | 2 | £22.14 |
| PPE | ppe | 18 | £695 | 1 | £38.61 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.