Product Category Breakdown
LiveInventory ReportToday: Business Central and spreadsheets
Replaces: category analysis built by hand from Shopify order exports
Units bought288across 5 categories
Net value£6,154ex VAT, at contract prices
Largest category69.4%Chemicals
Average price£21.37per 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 figures5 rows, the same numbers the chart draws
| Category | Code | Units | Net value | Orders | Average price |
|---|---|---|---|---|---|
| Chemicals | chemicals | 200 | £562 | 1 | £2.81 |
| Janitorial | janitorial | 50 | £1,900 | 1 | £37.99 |
| Catering Hygiene | catering | 30 | £858 | 2 | £28.60 |
| Washroom & Paper | washroom | 6 | £48 | 1 | £8.07 |
| Machines | machines | 2 | £2,786 | 1 | £1,393.02 |
How it is worked out. Ordered lines in the window against the product record, grouped by the category the catalogue carries.