Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought124across 5 categories
Net value£2,927ex VAT, at contract prices
Largest category41.9%Janitorial
Average price£23.60per 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 figures5 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Janitorial | janitorial | 52 | £660 | 2 | £12.69 |
| Chemicals | chemicals | 43 | £1,291 | 2 | £30.03 |
| PPE | ppe | 20 | £763 | 1 | £38.16 |
| Catering Hygiene | catering | 6 | £135 | 1 | £22.50 |
| NTRL Eco | ntrl | 3 | £77 | 1 | £25.75 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.