How to Identify Your Most — and Least — Profitable Products

Your bestselling product is probably not your most profitable one. This is one of the most reliably surprising findings for store owners who run their first real product-level P&L. Volume and profit are different animals — and optimizing for the wrong one can quietly hollow out your margins.

Here's how to actually figure out which products are making you money, which are just making you busy, and what to do about it.

Why Revenue-Based Rankings Mislead You

Most Shopify analytics rank products by revenue or units sold. This tells you what customers want to buy — which is useful for inventory planning. But it tells you nothing about what's actually worth selling.

Consider two products sold by the same store:

Product B generates 72% more revenue. It appears twice in the monthly "top sellers" report. The store owner has been pushing ad spend toward it because it converts well. But Product A generates 7.4× more profit per order. The store would be significantly better off if the situation were reversed.

The Four Dimensions of Product Profitability

1. Gross margin per unit

Start simple: selling price minus COGS. This is your gross margin. Every product needs a current, accurate COGS — including packaging. If your supplier raised prices three months ago and you haven't updated this number, every decision downstream is wrong.

2. Net margin per order (after all costs)

Gross margin doesn't account for shipping, fulfillment, payment processing, or ad attribution. A product with a 60% gross margin that requires expensive shipping and generates 25% returns may have a net margin below 10%.

3. Return rate impact

High-return products are profit destroyers that hide in revenue reports. A product with a 25% return rate doesn't just cost you 25% of its revenue — it costs you the refund, the return shipping (if you cover it), restocking time, and sometimes the product itself if it can't be resold. Track return rate and model it as a per-order cost, not an exception.

4. Ad efficiency by product

If you're running product-specific ads, your cost per acquisition (CPA) varies by product. A low-margin product with a high CPA is burning cash. The question isn't just "does this product sell?" but "at what cost does it sell, and is that cost sustainable given its margin?"

How to Run a Product Profit Audit

Here's a practical process to do this yourself:

1. List every product with its current COGS. Export from Shopify, then update any COGS that haven't been reviewed in the last 90 days.
2. Calculate average shipping cost per product. Weight-based products vary significantly. Pull your last 60 days of shipping invoices and calculate average fulfillment cost per SKU.
3. Pull return rate by product. Shopify shows returns — segment by SKU. Any product above 15% return rate deserves investigation.
4. Attribute ad spend by product. If you're running product-level campaigns in Meta or Google, pull CPA by product. If you're running blended campaigns, use your blended CAC as a cost allocation.
5. Calculate net profit per unit for every product. Rank the list by net profit per unit, not by revenue. Your priorities will shift immediately.

What to Do With What You Find

Double down on quiet winners

Products with high net margins and low return rates deserve more ad spend, better placement in your store, and active promotion. These are the products that scale your business profitably.

Fix or kill revenue traps

For products with poor margins, ask: is this a pricing problem, a supplier cost problem, a shipping problem, or a returns problem? Each has a different fix. If none of the fixes are feasible, consider discontinuing the product — even if it's popular by volume.

Price strategically, not emotionally

Many store owners under-price products because they're worried about competitiveness. But if your true net margin is 8% at current prices, you have almost no buffer for anything — ad cost increases, supplier price hikes, or a bad return month. Know your minimum viable price for each product and don't go below it.

Build bundles around your winners

If Product A has a 52% net margin, bundling it with a complementary product increases average order value while keeping margin healthy. This is more sustainable than pushing a high-volume, low-margin SKU through expensive ads.