Product-level profitability analysis subtracts each product's real cost — purchase price, shipping, commissions and return costs — from its sale price to reveal its true net contribution; without this analysis, businesses routinely confuse their best-selling product with their most profitable one. At an e-commerce business with $200,000 in monthly revenue, a product group that makes up 30% of that revenue can generate just 8% of total profit once high commissions and return rates are factored in — a gap you can only see with product-level analysis.
Why Isn't Your Top Seller Your Top Earner?
Your top-selling product is whichever one has the highest unit sales or total revenue; your top-earning product is whichever one delivers the highest net contribution after every real cost is subtracted from the sale price — and these are often two different products. Here's a worked example: at a cosmetics retailer, Product A sells 500 units a month at $20 each, for $10,000 in monthly revenue. Product B sells 80 units a month at $60 each, for $4,800 in revenue.
If Product A's real cost (purchase + shipping + commission) is $17.50 per unit, its net profit is $2.50 x 500 = $1,250. If Product B's real cost is $38 per unit, its net profit is $22 x 80 = $1,760. Product A looks like it's winning on revenue by more than double, but Product B contributes more profit. An owner who never sees this gap keeps pointing marketing budget and shelf space at the wrong product.
What Should Real Cost Include?
Real cost isn't just the purchase price; it needs to include shipping, marketplace or card processing fees, and the cost of returns. An e-commerce product might have a $10 purchase price, but with $3 in shipping, a 15% marketplace commission on the sale price, and an 8% average return rate for that category, the real cost is much higher than it first appears.
Factoring in returns matters most in high-return categories like apparel: for a product with a 20% return rate, the round-trip shipping cost and repackaging time for the returned unit needs to be spread across the profit from the other four sales. A business that overlooks these line items can keep selling a product that looks profitable on paper but actually loses money, for months on end. The first step to tracking these line items systematically is pulling sales and purchase data into one place; we covered how to set that up in our expense tracking guide.
What Should You Do With a Loss-Making Product?
When you find a product that's losing money or running on a very thin margin, you have three options: reprice it based on real cost, switch suppliers to bring the cost down, or drop it from your lineup. At a grocery store, if a certain drink brand is sold at a competitive-pressure price and loses a small amount per unit — a few cents on each bottle — once commission and waste are subtracted, it might be kept deliberately as a loss leader to draw customers in; that's a conscious strategy, and it needs to be balanced by the margin on other products.
But an unconscious loss is different: if the owner doesn't realize the product is losing money, that usually traces back to a pricing mistake. We covered how to combine cost-plus, competitor-based and value-based methods when repricing in our product pricing strategies article; it's worth applying that framework before deciding whether to fix a loss-making product with a price increase or drop it from the list.
How Do You Calculate Product-Level Profitability at a Service Business?
At service businesses (clinics, beauty salons, hair salons), product-level profitability is calculated per session, package or treatment type instead of per physical product sold; the real cost of each service is made up of its duration, the consumables it uses, and staff time. At an aesthetics clinic, if a laser session takes 45 minutes and the combined cost of specialist staff time, equipment depreciation and consumables for that session comes to $100, then even at a $150 session price, the net contribution is only $50 — and a clinic that doesn't account for this can easily confuse its most in-demand service with its most profitable one.
Package sales make this even more complicated: even if a 10-session package is paid upfront, the sessions get used over several months, and the real cost of each session can shift with that month's staff and material prices. We covered how to set up session- and package-level tracking in our session and package tracking article; that tracking is the core data source behind service-level profitability calculations.
What Mistakes Are Common in Profitability Analysis?
The most common mistake is looking only at the buy-sell gap (gross margin) and ignoring indirect costs like shipping, commissions, returns and staff time; a product that looks like it carries a 40% margin on paper can leave only 10-15% in real net profit. The second mistake is running the analysis once and never updating it; once a supplier's price or a commission rate changes, the old analysis stops being valid, but the owner keeps making decisions on the old assumptions without noticing.
The third mistake is judging profitability only at the unit level and ignoring total contribution: a product with a low per-unit margin but very high volume can generate more total cash than a product with a high per-unit margin but low volume. Making the right call means looking at unit margin and total volume together; an analysis that focuses on just one of the two gives a misleading result.
How Do You Run an 80/20 Analysis?
An 80/20 analysis (Pareto analysis) ranks products by their contribution to profit from highest to lowest and finds the point where the cumulative share reaches 80%; typically, 15-25% of your products account for 75-85% of total profit. Run this analysis on a stock of 300 SKUs and you'll usually find the first 50-60 products carry most of the profit, while the remaining 240 are spread thin across small shares.
The practical payoff is this: give the top 20% that drives profit priority on stock, shelf space and marketing budget, and hold only the minimum stock needed to meet demand for the bottom 80%. If 40 items at a stationery store account for 78% of total profit, it makes sense to never let those 40 run out of stock, while moving the remaining 260 to a monthly rather than weekly order cycle. Running an 80/20 analysis will also surface which products have genuinely turned into dead stock; we covered that in more depth in our year-end inventory closing article.
How Does Product-Level Profitability Shape Pricing Decisions?
Product-level profitability data shows you which products can take a price increase without losing customers, and which are already sitting at the edge of what's competitive. At an electronics store, if Product C carries an 8% margin while Product D — which sells at similar demand levels — carries 22%, it's worth testing a small price increase (3-5%) on Product C and watching how demand responds; for Product D, holding the price steady may make more sense to protect its competitive edge.
Making that call on instinct alone, without data, is risky: owners tend to keep the price low on whichever product gets the most complaints or the most haggling, even though that product may already carry a thin margin — and cutting the price further only deepens the loss. Pricing decisions backed by profitability data use both instinct and numbers together; we went into how to strike that balance in our product pricing strategies article.
Who Should Review the Profitability Report, and How Often?
The owner or general manager should review the profitability report monthly; at businesses where more than one person makes sales or pricing calls, the relevant category leads should review it weekly. A profitability report that only gets looked at once, at year-end, catches margin erosion far too late; monthly review, by contrast, makes the effect of a supplier price increase or a commission change visible within a few weeks.
At businesses with a sales team of 5-10 people, sharing the profitability report by department — so each category lead knows the margin on their own product group — lets pricing and promotion decisions get made faster without routing through one central person; how much detail that sharing should include (full cost, or just the margin percentage) depends on the business's culture around sharing information.
How Often Should You Revisit Profitability Data?
Profitability data should be revisited monthly for businesses selling seasonal products, and quarterly for businesses with stable year-round sales. Monthly review keeps a supplier price change or a commission increase from quietly eating into profit for months unnoticed; if a marketplace raises its commission rate from 12% to 16%, a seller who isn't watching closely will notice the margin erosion far too late.
Redoing this analysis every month in a manual spreadsheet takes hours and usually gets skipped; a reporting system tied directly to sales does the calculation automatically. Welda Stock's profitability reports compare each product's real cost — purchase, shipping and commission included — against its sale price and show the margin live; it also builds the 80/20 ranking automatically, making it clear exactly which products deserve your attention.
Is the Profitability Calculation Different for Retail vs. E-Commerce?
In physical retail, profitability calculations mainly account for purchase price, waste, and shelf/staff cost; in e-commerce, you also need to add shipping, marketplace commission and return logistics — which is why the same product might leave a 30% margin in a physical store but drop to 12-15% through an e-commerce channel once commission and shipping are subtracted. A business selling through multiple channels (both a store and a marketplace) that doesn't calculate the same product's profitability separately by channel can end up prioritizing the wrong one.
If a shoe brand sells the same model through its own store and three different marketplaces, each channel's commission and return rate differ, so looking at 'which channel sells more' without a channel-by-channel net profit comparison is misleading; the real question should be 'which channel leaves more net profit.' Managing stock and order data from a single hub for multi-channel selling is also what makes this kind of channel-level profitability comparison possible; we covered that integration in our e-commerce integrations guide.
How Do You Turn Profitability Analysis Into Decisions?
A profitability analysis shouldn't be a report you file away — it should be a decision tool. Every analysis should produce three concrete actions: revisit price or supplier for low-margin, high-volume products; increase shelf space or visibility for high-margin, low-volume products; and make a clear call — fix or drop — on products that are losing money. A business that reviews these three actions every month closes out the year with both less stock and a higher profit margin.
Profitability and cash flow tension aren't independent of each other; a product that looks profitable can still cause a cash crunch if collection on it is slow, so profitability reports should be read alongside receivables data. Get in touch with us to put a system in place for tracking product-level profitability.