Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought212across 5 categories
Net value£3,048ex VAT, at contract prices
Largest category53.8%NTRL Eco
Average price£14.38per 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 | 114 | £1,261 | 1 | £11.06 |
| Janitorial | janitorial | 48 | £824 | 1 | £17.17 |
| Workwear | workwear | 24 | £561 | 1 | £23.39 |
| Chemicals | chemicals | 14 | £130 | 1 | £9.31 |
| Washroom & Paper | washroom | 12 | £272 | 1 | £22.66 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.