Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought306across 6 categories
Net value£12,556ex VAT, at contract prices
Largest category38.6%Chemicals
Average price£41.03per 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 figures6 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Chemicals | chemicals | 118 | £4,435 | 2 | £37.58 |
| Washroom & Paper | washroom | 112 | £1,588 | 2 | £14.18 |
| PPE | ppe | 72 | £4,263 | 1 | £59.21 |
| Machines | machines | 2 | £2,248 | 1 | £1,123.92 |
| NTRL Eco | ntrl | 1 | £6 | 1 | £6.15 |
| Workwear | workwear | 1 | £17 | 1 | £17.13 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.