Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought137across 4 categories
Net value£3,673ex VAT, at contract prices
Largest category44.5%Workwear
Average price£26.81per 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 | 61 | £1,810 | 1 | £29.67 |
| Janitorial | janitorial | 46 | £869 | 1 | £18.89 |
| Chemicals | chemicals | 24 | £901 | 1 | £37.56 |
| PPE | ppe | 6 | £93 | 1 | £15.53 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.