Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought183across 5 categories
Net value£4,196ex VAT, at contract prices
Largest category69.9%Chemicals
Average price£22.93per 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 | 128 | £3,323 | 1 | £25.96 |
| NTRL Eco | ntrl | 32 | £527 | 2 | £16.48 |
| PPE | ppe | 17 | £247 | 2 | £14.54 |
| Workwear | workwear | 4 | £72 | 1 | £17.93 |
| Catering Hygiene | catering | 2 | £27 | 1 | £13.33 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.