Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought267across 5 categories
Net value£5,660ex VAT, at contract prices
Largest category64%NTRL Eco
Average price£21.20per 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 |
|---|---|---|---|---|---|
| NTRL Eco | ntrl | 171 | £4,447 | 2 | £26.00 |
| Washroom & Paper | washroom | 28 | £108 | 1 | £3.87 |
| Catering Hygiene | catering | 25 | £489 | 2 | £19.56 |
| Chemicals | chemicals | 22 | £69 | 1 | £3.14 |
| Janitorial | janitorial | 21 | £547 | 1 | £26.03 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.