Product-mix report
What /reports/product-mix.csv counts for every store of this account. POS items are matched by item ID. Every sold item that is in no category gets its own line, by its ingredient amount (qty_unit) unless configured below.
Test and download
Test shows where every number of the report comes from, including items sold that are not configured yet. Download CSV gives the same file Excel reads. One store, up to 92 days.
Categories
Each sold POS item adds its quantity times the multiplier to the category, under the category's code.
Individual items
Overrides for items reported on their own line: the name in the report, and whether to count the ingredient amount (toppings) or the quantity sold (drinks).