You can't calculate profit by ignoring how you acquired the customer.

If your product margin looks great but you're spending $8 in ads to sell a $45 product, you need to know that immediately.

Most Shopify founders track margin one way (in a spreadsheet) and ad spend another way (in Facebook). They never force them into the same equation.

That's why they scale unprofitable.

The Three Margins Most People Don't Understand

Let's define these clearly, because founders use "margin" loosely and it causes problems.

Gross Margin is selling price minus product cost.

Product: $45 selling price, $16 landed cost = $29 gross margin (64% margin).

Sounds great. But it ignores everything else.

Operating Margin adds back the cost of acquiring that customer.

Same product: $45 selling price, $16 landed cost, $8 ad spend = $21 true margin per unit (47% margin).

That's a huge difference. And it's what actually matters.

Net Margin subtracts everything: COGS, ad spend, fulfillment, packaging, returns, customer support, payment processing.

Most people don't even attempt this calculation, so we'll focus on operating margin here.

The Real-World Version

Let's use a concrete example that probably hits close to home.

Product: A skincare bundle

Selling price: $89

Landed cost: $24

Gross margin: $65 per unit (73%)

Your typical customer acquisition cost: $18 (Facebook ads, $4.50 ROAS on this product)

Actual margin after ad spend: $65 minus $18 = $47 per unit (53% margin)

Notice what happened. Your margin didn't drop by a tiny percentage. It went from 73% to 53%.

That's a 20-percentage-point difference.

And that 53% is still before fulfillment, packaging, returns, and payment processing.

If you were only looking at gross margin (73%), you'd think you're killing it and scale aggressively. But your actual profitability per sale is half that.

This is why scaling too fast destroys brands.

Why Most Founders Get This Wrong

Margin lives in Shopify analytics (or a spreadsheet). Ad spend lives in Facebook Ads Manager. Returns data lives in your 3PL dashboard.

They're three different tools. Three different views of reality. Most founders never force them into one equation.

So they feel like they're doing great based on the margin number Shopify tells them.

Meanwhile, their CAC is climbing and their profit is disappearing.

The second mistake: founders calculate average CAC, not product-specific CAC.

"My CAC is $15 on average."

Great. But you're running 5 different product campaigns. Two of them convert at $12. Two of them convert at $15. One of them converts at $22.

If you allocate the same CAC to each product, you're making terrible scaling decisions.

That $22 CAC product? Maybe you should kill it. But if you're not tracking product-level CAC, you don't know.

How to Calculate It Manually

Step 1: Pick a product.

Step 2: Find these numbers:

Add those costs up. Call it total product cost per unit.

Step 3: Calculate your product-specific CAC.

In Facebook Ads Manager, find the spend for this product's campaign. Divide by the number of units sold from that campaign. That's your product CAC.

Step 4: Actual margin = Selling price minus Total product cost minus CAC.

Let's do a real example:

Margin per unit = $89 minus $32.96 minus $18.26 = $37.78

That's your real profit per sale. 42% margin.

If you're expanding this product or launching variations, you now know the real economics.

The Problem With Manual Tracking

This is a lot of math. And it assumes:

The second something changes (a supplier price, ad performance, return rate), your numbers are outdated.

Most founders calculate this once, feel good about it, and then ignore it for three months.

Then they look at results and wonder why scaling didn't work the way they thought it would.

How Pandly Does This Automatically

Instead of manually pulling data from Shopify, Facebook, your 3PL, and your supplier, Pandly connects to all of them.

It calculates product-specific margin after ad spend, automatically, in real time.

Your dashboard shows:

When something changes (a supplier price, a return spike, an ad campaign shift), your margin recalculates instantly.

No spreadsheets. No guessing. No three-month delays in finding out you've been scaling something unprofitable.

This Week

Pick your three best-selling products.

Manually calculate the margin after ad spend for each using the method above.

Be honest about CAC. Don't use company average. Calculate it per product.

If any of them surprise you, particularly if the margin is lower than you expected, that's your scaling signal.