How to calculate your true profit on Shopify

The Shopify revenue trap

Shopify shows you your gross revenue — total sales before any deductions. It's a volume metric, not a profitability metric. For a merchant, confusing revenue with profit can lead to disastrous decisions: raising your ad budget while every order loses money, for example.

In reality, your true net profit is what's left after many subtractions that Shopify doesn't do for you:

• Cost of goods sold (COGS / product purchase cost)
• Meta, TikTok and Google ad spend
• Outbound shipping costs
• Shopify fees (monthly subscription + transaction fees)
• Payment fees (Shopify Payments: ~2.9% + €0.30)
• Returns and refunds
• Handling and fulfillment costs

The true net profit formula

Worked example: a store doing €50,000 in revenue

Take a Shopify store doing €50,000 in monthly revenue. At first glance, that looks great. But let's look at the breakdown:

Out of €50,000 in revenue, real profit is only €12,300 in this example. Until payment fees, COGS, shipping and returns are subtracted line by line, you'll always think you're more profitable than you really are.

Why Excel spreadsheets are no longer enough

Many merchants try to calculate their profit by hand in Excel or Google Sheets. The problem: it's time-consuming (2-4 hours a week), error-prone and, above all, the data is always behind. You make today's decisions on last week's data.

With ProfitPilotPro, syncing with Shopify is automatic. Every new order updates your KPIs in real time. Meta, TikTok and Google ad spend syncs automatically every hour.

How ProfitPilotPro calculates your profit automatically

ProfitPilotPro connects directly to your Shopify store through the official API and pulls in all your orders, products and cost data. At the same time, it connects to your ad accounts to pull your actual spend by campaign.

COGS (purchase cost) is pulled for each variant from Shopify's “Cost per item”, and any change also applies to your past orders. Shopify fees are calculated automatically based on your plan (Basic, Shopify, Advanced or Plus). Payment fees are applied per order based on your payment processor.

The result: a real-time dashboard that shows your net profit, your margin, your true ROAS and your NCPA (new customer acquisition cost) — with zero manual work. And thanks to server-side tracking (Meta CAPI), even conversions lost on iOS are counted.

The 5 key metrics to watch

Shopify profit: common pitfalls to avoid

Three mistakes come up again and again with merchants who see their true profit for the first time:

• Forgetting returns and refunds. An 8% return rate (15%+ on footwear) can turn an 18% net margin into 4%.
• Confusing gross margin with net margin. Gross margin (revenue − COGS) doesn't cover Shopify fees, payment processing, ads or shipping. A 60% gross margin can leave you with less than a 10% net margin.
• Underestimating payment fees. Shopify Payments takes 2.9% + €0.30 per order on average. On a €45 AOV, that's about 4% of revenue going to fees.

A Triple Whale, Lifetimely and Polar Analytics alternative

Profit tracking tools like Triple Whale, Polar Analytics, Lifetimely and BeProfit bill in US dollars. ProfitPilotPro is built in France for e-commerce merchants, with pricing in euros starting at €39/month.