Your Best-Seller Is Probably a Profit Loser: Here's How to Find Out

Your Shopify dashboard shows a product doing $18,000 in sales this month. You're happy. You scale ads. You buy more inventory.

Then you look at your bank account and wonder where the money went.

Here's the problem: Shopify tracks revenue. It doesn't track profit. Those are two completely different numbers, and confusing them is one of the most expensive mistakes a Shopify store owner can make.

What Shopify Shows You

When you open your Shopify analytics, you see gross revenue per product. Sometimes gross profit if you've entered COGS manually. That's it.

What it doesn't account for:

Ad spend allocated to that specific product
Refund rate per SKU (some products get returned at 3x the average)
Shopify transaction fees and payment processing (2.9% + $0.30, or your plan rate)
Shipping cost per order for that product (weight, size, carrier)
Any bundling or discount applied at checkout

A product with $18,000 in revenue and a 40% gross margin looks great on paper. Add $4,200 in Meta ads driving those sales, 12% refund rate, and $1,800 in shipping costs - and you're looking at a product that's barely breaking even. Or losing money.

The Real Math Behind a "Best-Seller"

Let's run the actual numbers on a hypothetical product doing $18,000/month:

| Line item | Amount | |---|---| | Gross revenue | $18,000 | | COGS (40% margin) | -$7,200 | | Ad spend (Meta/Google) | -$4,200 | | Shopify fees (~2%) | -$360 | | Shipping costs | -$1,800 | | Refunds (12% rate) | -$2,160 | | Real net profit | $2,280 |

That's a 12.7% net margin on what looked like a strong 40% margin product. If you scaled that product 3x, you wouldn't make 3x the profit - you'd likely compress margins further as you push into a wider (less targeted) audience.

This isn't a worst-case scenario. This is how the math works for a huge percentage of Shopify stores.

Why This Matters More as You Scale

The gap between revenue and real profit gets wider as you grow.

At $20k/month, you can keep track of this manually. A spreadsheet, some rough estimates, a feel for which products are working.

At $200k/month, that approach breaks. You have 40+ SKUs, multiple ad accounts, bundled products, varying refund rates by product category. The spreadsheet becomes a full-time job - and it's still wrong.

This is the exact point where most DTC founders scale spend on the wrong products. They're optimizing for ROAS when they should be optimizing for net profit per order.

How to Find Your Actual Profit Per Product

The process is straightforward, but it requires pulling data Shopify doesn't surface on its own:

Step 1: Get real COGS per SKU. Not estimated. Actual landed cost including supplier cost, shipping to warehouse, and any import duties.

Step 2: Pull refund rate per SKU from Shopify's orders export. Some products refund at 2%, others at 18%. The average is meaningless.

Step 3: Allocate ad spend per product. If you're running product-specific campaigns, this is direct. If you're running broad catalog campaigns, you need to allocate proportionally by revenue contribution - it's an approximation, but it's better than ignoring it.

Step 4: Add Shopify fees and shipping. Shopify fees are consistent. Shipping varies by product weight/size and carrier - pull your actual fulfillment costs from your 3PL or Shopify Shipping.

Step 5: Calculate net margin per SKU. Revenue minus all of the above. Sort descending. The bottom of that list is where you're probably leaving (or losing) the most money.

What Usually Happens When You Do This

Most store owners find two or three things:

One product that looks average on revenue but has unusually high margin - low refunds, lightweight, efficient ad targeting. This is the product you should be scaling.

One product that's a volume leader but margin negative after real costs. This is the one eating your cash flow while making your dashboard look good.

And a long middle section that's fine but not exciting - the kind of product that fills orders but doesn't drive the business.

The lever isn't always cutting the losers. Sometimes it's cutting the ad spend on them and letting them sell organically. Sometimes it's negotiating better COGS. Sometimes it's killing the SKU entirely and redeploying that ad budget to the real winner.

But you can't make that decision without the actual numbers.

The Spreadsheet Approach vs. Automated Tracking

You can do all of this manually. It takes 3-4 hours per month if you're disciplined about it, and it's better than not doing it at all.

The problem is that 3-4 hours of manual work gets skipped when you're busy. It's always "I'll do it next week." And the decisions you make in the meantime are based on incomplete information.

Tools like Shopsterra connect to your Shopify store via OAuth, pull in your orders, COGS, and fees, and show you real net profit per product without the manual work. Setup takes about 5 minutes. The data is there the same day.

It's not the only way to do this. But if you're running a store at $200k+ GMV and you're still working from spreadsheets, the ROI on automating profit tracking is usually immediate.

The Takeaway

Shopify's revenue numbers aren't wrong. They're just incomplete.

Before you scale your next ad campaign, before you reorder inventory on your "best-seller," take 30 minutes to run the real math. Product revenue minus COGS, minus ad spend, minus fees, minus shipping, minus refunds.

The answer is usually surprising. Sometimes it's good news - a product you've underinvested in. More often it's a product you've been overinvesting in for months.

Either way, you're better off knowing.

Shopsterra is a profit tracking tool for Shopify stores. Connect your store and see real net profit per product in 5 minutes. Free during beta.