Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought340across 4 categories
Net value£6,991ex VAT, at contract prices
Largest category88.2%Workwear
Average price£20.56per 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 figures4 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Workwear | workwear | 300 | £4,281 | 1 | £14.27 |
| Janitorial | janitorial | 28 | £669 | 2 | £23.88 |
| Washroom & Paper | washroom | 11 | £407 | 1 | £36.99 |
| Machines | machines | 1 | £1,635 | 1 | £1,634.62 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.