Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought37across 3 categories
Net value£1,083ex VAT, at contract prices
Largest category59.5%Washroom & Paper
Average price£29.28per 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 figures3 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Washroom & Paper | washroom | 22 | £653 | 1 | £29.66 |
| Janitorial | janitorial | 8 | £98 | 1 | £12.29 |
| Workwear | workwear | 7 | £333 | 1 | £47.50 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.