A revenue report shows the numbers. A margin analysis shows which of them actually earn and which just turn over. These are two completely different answers – and most stores regularly get only the first.
A store specializing in batteries and rechargeables. Three of its own product lines – premium batteries, a cheaper series and an economy line – complemented by genuine Duracell, Energizer and Varta. Over 3,250 active SKUs, almost EUR 3.9 million in revenue over five months.
Asked “how’s it going?”, the owner would answer: well. Revenue is growing. Orders keep coming. The new QuickCell series hit the market and started pulling volume.
Until the moment purchase costs landed in DataOrganizer and the LLM got a question about margin.
Total revenue January–May 2026: 3,831,009 EUR · 20,099 orders · 3,250 active SKUs.
| # | Product | Revenue | Qty | Share |
|---|---|---|---|---|
| 1 | Alkaline batteries AA [LR6] 20-pack – PowerMax | 54,032 EUR | 710 | 1.41% |
| 2 | Alkaline batteries AA [LR6] 10-pack – PowerMax | 33,194 EUR | 430 | 0.87% |
| 3 | Alkaline batteries AAA [LR03] 20-pack – QuickCell | 33,167 EUR | 340 | 0.87% |
| 4 | Alkaline batteries AA [LR6] Multipack 3×20 – PowerMax | 32,136 EUR | 449 | 0.84% |
| 5 | Alkaline batteries AA [LR6] 24-pack [Set] – Duracell | 29,118 EUR | 252 | 0.76% |
| 6 | Alkaline batteries AA [LR6] 20-pack – QuickCell | 27,494 EUR | 579 | 0.72% |
| 7 | Lithium batteries CR2032 5-pack – Duracell | 26,960 EUR | 159 | 0.70% |
The catalog is very fragmented – the top 20 products generate just 13% of revenue combined. Reaching 80% of turnover takes 854 SKUs. The volume growth is clear – orders keep rising, and QuickCell appears more and more often in the ranking.
Nothing alarming. A large, fragmented catalog, rising orders, a new series entering the top 10. It all looks like healthy growth.
But a revenue report has no “margin” column. To see that you need purchase costs – and the right question for the LLM.
One question changes the perspective
Purchase costs were loaded into DataOrganizer for the entire catalog – every SKU has a unit cost assigned. The LLM now has access to the get_margin_segments tool, which splits the assortment into three segments: high margin (above 30%), medium (10–30%) and low (below 10%). Batteries are a category where margins can differ dramatically – a contract-manufactured private label vs genuine products from well-known makers is a completely different economics.
Cost coverage: 100% of SKUs – every product has a purchase cost assigned. Total revenue: 3,831,009 EUR over 141 days.
Alarm signal: the low-margin segment generates 1,098,509 EUR in revenue at a 2.77% gross margin – that’s 30,452 EUR of gross profit. On over a million in turnover. After subtracting advertising, shipping and handling costs, this segment is probably loss-making.
What’s more – in the previous comparable period this segment was just 108,696 EUR. It grew by +910%.
29% of revenue, 2.77% gross margin. On EUR 1.1M of turnover in the low-margin segment the store earned 30,452 EUR gross. Shipping, advertising and handling cost more than that. This segment doesn’t earn – it just turns over.
Where does this million come from?
The segment breakdown is only the first step. Knowing that almost 30% of revenue sits in the alarm zone, the next question is natural: which products, which brands, which categories are behind it?
Revenue breakdown by brand – mapped against the margin segments:
The answer is unambiguous. The value of the low-margin segment (1,098,509 EUR) matches the QuickCell brand’s revenue (1,098,163 EUR) almost exactly. The entire private-label economy battery line is sold at a negligible 2.77% gross margin – probably below the full cost of fulfilling an order.
A private label as a margin problem
This is surprising – because a private label is usually associated with a higher margin, not a lower one. PowerMax, the in-house premium line of alkaline and lithium batteries, has a gross margin above 75%. A private-label product should be profitable – you cut out the middleman, control the price and build recognition.
But QuickCell is a different story. The “economy” line – the cheapest in the catalog, aimed at the lowest-price shopper – was priced too aggressively. With a production and purchase cost that left no room for margin, every order generated an operating loss once shipping and handling were factored in.
The low-margin segment grew by +910% versus the previous comparable period. The line sells better and better – which, without cost data, looked like a success. With cost data: every additional order deepens the loss. Volume growth in a loss-making segment is an accelerated cash drain.
The mix is shifting – and you can see it in the trend
A comparison with the previous comparable period (a similar 141 days) shows the problem isn’t static – it’s growing.
The revenue report showed growth. QuickCell was rising, orders kept coming, customers kept buying. Without costs – everything looked fine. With costs – you can see that 29% of turnover works at a loss, and that share grows every month.
What next with this information?
Knowing what you know, you have several paths to choose from. You can raise QuickCell prices – you’ll give up some volume, but start earning on every order. You can deliberately keep the line as an acquisition channel – treating the loss as the cost of acquiring a lowest-price shopper, provided those people come back for PowerMax or Duracell. Or you can go back to the supplier and renegotiate the purchase cost at higher volumes.
Any of these decisions is better than no decision born of missing data. And missing data was the norm here for the past few months – not because no one was looking, but because the costs weren’t connected to the analytics tools.
Takeaway
By combining product costs with sales data, you identify a problem – or an opportunity – before you can even write a report. Here: QuickCell generates over a million in turnover at a 2.77% margin. Without connected costs, this information doesn’t exist. With them connected – it surfaces in a single question.
It opens room to act that wasn’t there before: raise the price, renegotiate the purchase cost with the supplier, deliberately keep the line as an acquisition channel – or simply know the problem exists. Any of these decisions is better than no decision born of missing data.
DataOrganizer · MCP
Load it into DataOrganizer and ask the LLM about margin. The analysis takes a minute – and the results may surprise you.