Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought1,496across 5 categories
Net value£37,872ex VAT, at contract prices
Largest category53.5%Chemicals
Average price£25.32per 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 |
|---|---|---|---|---|---|
| Chemicals | chemicals | 800 | £15,160 | 1 | £18.95 |
| Janitorial | janitorial | 410 | £11,039 | 1 | £26.92 |
| Washroom & Paper | washroom | 266 | £6,823 | 1 | £25.65 |
| NTRL Eco | ntrl | 18 | £399 | 1 | £22.15 |
| Machines | machines | 2 | £4,451 | 1 | £2,225.61 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.