Profit per category — what it tells you that profit per product cannot

Most profit reports open on a list of products sorted by revenue, and that list is genuinely useful: it tells you which items earn. But almost nobody makes a decision about one product. Decisions get made about a range - what to reorder, what to promote, what to drop, where the next thousand of buying budget goes.

Those are category questions, and four things about them cannot be seen in a product list at all.

One product’s margin is noise; a category’s is a signal

A single product’s recorded margin moves for reasons that have nothing to do with whether it is a good product. One bulk purchase at a better price, one clearance week, one order where the customer used a coupon, one supplier invoice that included freight this time. At four orders a month, any of those swings the number by ten points.

A category aggregates hundreds of lines. The same one-off events are still in there, but they stop steering the total. When the mugs category moves from 48% to 41% over a quarter, something actually happened. When one mug does the same, it may just be a Tuesday.

This has a practical consequence for how you read the two views: look for problems in the category numbers, then use the product list to find which items caused them. Doing it the other way round means investigating noise.

The long tail only speaks in aggregate

A product list is sorted by revenue, and attention stops somewhere around row thirty. Below that sits most of your catalogue: hundreds of items each contributing a fraction of a percent, none of them ever individually worth a look.

That tail is invisible one row at a time and can be substantial in total. Two hundred products at 0.1% of revenue each is 20% of the shop. If that 20% carries a materially worse margin than the rest - which is common, because slow movers are where old purchase prices and forgotten discounts accumulate - a product list will never tell you. A category total will, in one line.

Your pricing rules are category-level, so your mistakes are too

Almost nobody prices product by product. They price by rule: accessories at times two-point-two, electronics at cost plus fifteen percent, own-brand at whatever the market takes. The rule is a property of the range.

Which means the interesting question is not “what is this product’s margin” but “is this range still obeying its rule”. A category sitting six points below the rule you set is either a pricing drift nobody noticed, a supplier increase that never reached your prices, or a promotion that outlived its campaign. All three are fixable, and all three are only visible at the level where the rule was set in the first place.

The mix effect: margin falls while nothing gets less profitable

This is the one worth the whole page.

Your overall margin can drop sharply in a month in which no price changed, no cost changed, and every single product remained exactly as profitable as it was. It happens because the mix of what you sold moved toward a lower-margin part of the shop.

Two categories, one shop:

Next month a hardware review sends traffic to the electronics, and mugs have a quiet month. No price is touched. No supplier changes anything.

Identical revenue. Identical margin in both categories. Six thousand less profit and six points off the overall margin.

From the summary alone this looks like a pricing problem or a cost increase, and the instinct is to go hunting for the leak. From the product list it looks like nothing at all - open any product and its margin is unchanged. Only the category view says what really happened: your margins did not fall, your mix moved.

The two situations demand opposite responses. A real margin problem means fixing prices or costs. A mix shift means deciding whether you are happy selling more of the cheaper thing - sometimes you very much are, because 26 000 on the same revenue with less handling may beat 32 000. What you cannot afford is treating one as the other.

What the category view cannot tell you

Four honest limits, because a view that is sold as more than it is stops being useful the first time someone checks it.

Categories overlap, so the totals do not add up to the shop. A product in Mugs, Gifts and New in counts in all three. WooCommerce has no concept of a primary category, and inventing one would be worse than the overlap. Read categories as views of the shop, never as slices of it. The full explanation.

Parent and child are separate. A product in Mugs → Thermal is not counted under Mugs unless it is assigned to both. A parent category that looks surprisingly small is usually this, not a collapse in sales.

Coverage differs per category, and this is the trap that produces confident nonsense. Margin is computed only on the revenue that has a cost recorded against it. A category where costs were filled in for the top few items and left empty for the rest will report a margin calculated on a fraction of its revenue - and it will look precise. Always read a category’s margin next to that category’s coverage; a 60% margin at 20% coverage is not a finding, it is four products with costs. How missing costs are handled.

A category is a merchandising object, not an accounting one. It exists to help customers find things, and it gets reorganised for reasons that have nothing to do with reporting. Renaming or re-parenting a category changes your history at the same moment it changes your shop.

Reading the two views together

1. Start at category level to find where something moved.
2. Check that category’s coverage before believing the number.
3. Then open the product list filtered to that range to find which items caused it.
4. Before diagnosing a margin problem, check the mix. If category margins held and the total fell, nothing is broken - your shop sold a different basket.
5. Compare like periods. A category driven by seasonality compared month to month will produce a story that is entirely calendar.
6. Export monthly. Category structure changes and refunds both rewrite history; a CSV taken at month end is the only version nothing goes back and edits.

How the same numbers are put together, and what is deliberately left out of them, is set out in how profit is calculated. If a category in your shop behaves differently from what is described here, say so - these pages get corrected when they turn out to be wrong.