Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought395across 7 categories
Net value£10,049ex VAT, at contract prices
Largest category50.6%Chemicals
Average price£25.44per 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 figures7 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Chemicals | chemicals | 200 | £4,790 | 1 | £23.95 |
| Janitorial | janitorial | 97 | £2,589 | 4 | £26.69 |
| Catering Hygiene | catering | 43 | £635 | 3 | £14.76 |
| Washroom & Paper | washroom | 25 | £724 | 1 | £28.97 |
| Workwear | workwear | 19 | £997 | 1 | £52.45 |
| NTRL Eco | ntrl | 8 | £196 | 2 | £24.49 |
| PPE | ppe | 3 | £119 | 1 | £39.54 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.