Vissza a bloghoz

Profit Margin Analysis: How to Find Out Which of Your Products Is Actually Losing Money

July 14, 20268 min read
Waterfall chart: revenue minus the costs leaves the profit

The classic mistake: "this product sells well, so it must be making money." Revenue and profit, however, are two separate metrics — and at the product level they often point in opposite directions.

The three levels of profit

What's left after the purchase price

Selling price minus purchase price. The most superficial number, yet most people stop here.

Gross profit

Sales minus VAT, the purchase price and the order's direct costs: shipping, payment fees and ad spend. This shows how much a product or order contributes toward covering fixed costs.

Net profit and margin

Gross profit minus your expenses (packaging, software, salaries, warehouse). Margin is net profit as a percentage of revenue. For comparison: in publicly listed retail, net margin is typically 5–6% — (NYU Stern, Damodaran: Margins by Sector; U.S. public-market data, not a Hungarian SME benchmark).

How should you sort your products?

By profit after all costs, not by revenue. A practical split:

  • Scalable: profitable, worth spending more on.
  • Needs optimization: price, shipping or ads need adjusting.
  • Loss-making: in the red after all costs.

For loss-making products, it's worth checking why: deep discounts, units given away, many returns, the ad spend linked to the product, or simply that nothing is left after VAT, the purchase price and shipping.

Illustrative example: two products, two different worlds

The table below contains illustrative, made-up figures — it demonstrates the logic, not an industry average.

MetricProduct AProduct B
Selling price12,990 Ft4,990 Ft
Purchase cost6,500 Ft1,800 Ft
Margin on purchase price50%64%
Shipping + packaging1,200 Ft1,100 Ft
Payment fee (1.5% + 85 Ft)280 Ft160 Ft
Return rate4%18%
Estimated net margin~34%~11%

Product B looks better on paper (64% margin on purchase price), yet in reality it generates significantly less: the fixed-style shipping and packaging cost hits a low-cart-value product disproportionately hard, and the high return rate further erodes the result.

What should you do now?

  1. Rank your products by net profit over the last 90 days, not by revenue.
  2. Go through the loss-making ones: some items may be worth discontinuing or repricing.
  3. Shift ad budget toward profitable, scalable products.
  4. Keep purchase prices up to date — supplier prices and shipping rates change.

With a few dozen products, this can be managed in Excel; with a larger catalog, it can't. ShopMap calculates gross and net profit, margin and ROI per product from your webshop's orders, and automatically tags every product as Scalable, Needs optimization or Loss-making. Under loss-making products it also shows what took the profit. You enter purchase prices (by hand or from Excel); ad spend is counted against a product when you link the expense to that product.

Sources

  1. A. Damodaran (NYU Stern): Margins by Sector — stern.nyu.edu
  2. Stripe Hungarian price list (transaction fee) — stripe.com

Frequently asked questions

What's the difference between gross profit and net profit?
Gross profit is what's left of sales after VAT, purchase price, shipping, payment fees and ad spend. Net profit also deducts your expenses (e.g. packaging, software, salaries) — that's your real profit, and margin is net profit as a share of revenue.
How often should you recalculate product margin?
At least monthly, because supplier prices, shipping rates, and payment fees change continuously.

More articles