How to Find Unprofitable Products in Your Store

Why strong sales do not always mean strong profit

Sales tell you how much money came in. They say nothing about how much was left after everything it cost to earn that money. Two products can bring in the same revenue and leave you with very different results, and a product that sells a lot can leave less than one that sells a little.

Revenue versus contribution profit

Revenue (sales) is the price customers paid, multiplied by the units sold.

Contribution profit is what remains after deducting the product costs and selling expenses included in your analysis:

Contribution profit = sales − discounts − refunds − product cost − platform fees − shipping

Contribution margin puts that in proportion:

Contribution margin = contribution profit ÷ net sales (sales minus discounts and refunds)

It is called “contribution” because it is what each product contributes towards the costs that do not change with sales, such as rent, software and your own time. If a product contributes almost nothing, it cannot help pay for those. It is also not your overall net business profit: that figure comes after all of your business’s costs, including the ones a product-level view leaves out.

How product costs change the picture

Cost of goods is the obvious one, but it is rarely the only one:

• Product cost: what you paid for each unit you sold.
• Platform and payment fees: often a percentage of every sale.
• Shipping and fulfilment: frequently a fixed amount per order or unit, which hurts low-priced products most.
• Discounts and refunds: they reduce what you actually kept.

A small cost you ignore on every unit is a large cost across hundreds of units.

Why high-volume products can still be poor contributors

High volume multiplies whatever margin a product has. A thin margin, multiplied by many units, is still thin. Worse, popular products often attract discounts and attention, so they get the most promotion while quietly contributing the least.

A simple worked example

Illustrative example. These are made-up numbers, not a real customer result.

You sell two products.

On a sales report, the Phone Case wins: more than twice the revenue and six times the units. After costs, it leaves 45. The Water Bottle sold far fewer units yet contributed almost thirty times more profit (1,320 compared with 45).

If you had spent your next advertising budget promoting the best-seller, you would have been promoting the product that gives the least back. Nothing about this was visible in the sales total.

How to spot the products that need attention

Work through your product list with these questions:

1. Which products contribute little or nothing relative to their sales? Sort by contribution margin and look at the bottom.
2. Which products are losing money outright? A negative contribution means each sale costs you.
3. Which high-volume products have a thin margin? These are the ones where a small price or cost change matters most.
4. Where does most of your profit come from? If a handful of products carry the business, that is worth knowing, because those products carry the risk too.
5. Which products have missing or doubtful costs? A margin is only as good as the cost behind it.

For each product that needs attention, the usual choices are: review the price, renegotiate or replace the supplier, reduce discounting, change how it ships, or stop promoting it.

Doing this with Business X-Ray

You can do all of this in a spreadsheet, and many merchants do. It becomes slow once you have more than a few dozen products, and one wrong formula spoils every figure that follows.

Business X-Ray does this calculation for you from a CSV or Excel file you already have. For each product you provide the unit cost, selling price and units sold, and optionally discounts, platform fees, shipping and refunds. It then shows:

• headline sales, contribution profit and contribution margin,
• which products are loss-making, below your target margin or high-volume with a low margin,
• how concentrated your profit is, and
• a ranked list of what to look at first.

The maths is fixed rules, not guesswork, and the analysis runs on your own device: your spreadsheet is not uploaded. There is no account to create.