Merchandise sales by item, with each size underneath

The item total, then the sizes

The existing top-products list groups on the name the register wrote, so every size is its own row and no amount of reading fixes it. A sweatshirt shows up five times and the total exists only in your head. This report groups on the product instead: the item appears once with its total units sold, and its variants sit underneath it.

Paddles work the same way, so you can see how many of one model went out and then how that splits by colour or shape. The CSV export gives each variant its own row with the item repeated, so it pivots cleanly in a spreadsheet.

Two kinds of zero, told apart

An empty shelf means one of two completely different things, and until now the report said the same thing about both. Sold out means it was stocked and has run down, so it is worth buying again. Never ordered means that size or colour has never been bought, received or sold, so the zero is not a sale you are missing.

That distinction is the reason the reorder count is trustworthy: never-ordered rows are left out of it on purpose. A report that counted them would tell you to restock a size you chose not to carry.

Which rows to act on

The top of the page says how many items need reordering, and the rows it counts are tagged Reorder in the Stock column, so you are not picking them out by colour. Some rows show a state with a reason beside it: those are shown for the record and are not counted, because an archived item or one you keep no stock number for is not a buying decision.

Each variant's reorder point sits next to what is on the shelf, so the number you set and the number you are reading are on the same screen. One number covering every variant is the item's Low Stock Alert; a variant that needs its own gets it from that variant's own row.

Why this count can be higher than the Low Stock page

Both numbers are right and they answer different questions, so it is worth knowing which you are reading. This report counts an item when any one of its variants has reached its reorder point. The Low Stock page adds up the stock across an item's variants and compares that total to the item's own number.

A sweatshirt with 4 smalls, 20 mediums and 20 larges adds up to 44, so the Low Stock page reads it as healthy. You still cannot sell a small. This report shows that size as Low, which is the whole point of looking per variant.

Honest about its edges

• Units sold and returned follow the date range. On hand and the reorder point do not, because they are current stock: narrowing the dates will not change them.
• Returns are reported beside units sold rather than taken off them, because a return does not un-sell something and a single netted figure means neither.
• Long catalogues are capped on screen, and the page says so rather than looking complete. The CSV still carries everything.
• A variant with no reorder point of its own follows the item's, which is why most rows show the same figure. That is working as intended.
• Reading it needs the view POS reports permission.