Why Your Best-Selling Shopify Product Might Be Losing You Money

How a best-seller becomes a margin drain

Discounting erodes margin faster than it appears

A product with 50% gross margin discounted by 20% doesn't have 30% gross margin, it has 37.5% (the discount applies to revenue, not to cost). But if that product drives the majority of discounted orders because it's what customers search for and buy on sale, the store's blended margin deteriorates in a way that's invisible unless you're tracking gross margin by product. The bestseller becomes the vehicle through which discounts flow.

Returns concentrate on high-volume products

Return rates cluster on popular products for a simple reason: more units sold means more units returned. A 15% return rate on your number-two product by volume is a manageable cost. The same rate on your bestseller, which ships five times more units, means five times more returns eating into net margin. Shopify reports returns as a revenue adjustment but doesn't surface the per-product margin impact.

Shipping costs hit some products harder than others

Dimensional weight pricing means a large, light product can cost as much to ship as something heavy. If your bestseller happens to be bulky relative to its price point, you're absorbing a shipping cost that doesn't show up in COGS but comes directly out of net margin on every order. Free shipping thresholds make this worse: customers who buy just the bestseller are often the ones triggering free shipping at the lowest margin.

Ad spend follows sales, not profit

Advertising algorithms optimize for conversion, which means budget flows toward the product that converts best. The product that converts best is usually the bestseller. But conversion rate and margin are different things, and an ad campaign that drives high revenue at low margin is worse than a campaign that drives lower revenue at high margin. Stores running paid traffic without per-product margin visibility are likely funding their worst-margin products most aggressively.

How to find out

The honest answer is that Shopify's native analytics won't tell you. You can see revenue by product and units sold by product, but you cannot see gross margin by product after returns and fulfilled shipping costs. That requires either a spreadsheet built from exported Shopify data, or a dashboard that captures cost of goods at the time of sale and builds the margin view for you.

Flumen does the second. For WooCommerce stores, it captures cost of goods recorded on each order at the time of sale and surfaces gross margin by product and by category over time, so the product that looks like your hero on revenue actually gets measured against what it costs to sell it. The products quietly outperforming it stop being invisible.

Learn more about Flumen Data Analytics →

The bottom line

Revenue rankings and profit rankings are different lists. Every store has products that outperform their revenue rank on margin, and products that underperform it. Shopify shows you the first list clearly and the second list not at all.

The fix isn't complex: cost of goods at the product level, attributed to each sale, surfaced as a margin trend over time. That's the view that turns the best-seller question from a guess into an answer.