Your Shopify Profit is a Lie (Here’s the Math)

Last month, SKU B07X8K7P2N (a $29.99 phone stand) looked profitable on paper. After Shopify fees, shipping, Facebook ads, and one refund, the real margin was $2.30—barely covering the $2.99 product cost. That’s a 7.7% margin, not the 35% you thought.

Here’s where the money disappears:

- **Platform fees**: Shopify Basic charges 2.9% + $0.30 per transaction. On a $29.99 order, that’s $1.17. Add Shopify Payments’ 2.7% + $0.30 for another $1.11. Total: $2.28 gone before you even ship.

- **Shipping costs**: If you’re using Shopify Shipping, USPS Priority Mail for a 1 lb package is $7.95. That’s 26.5% of the product’s retail price. For heavier items, it’s worse—$12.50 for a 3 lb package on a $49.99 item drops margin to 12%.

- **Refunds and chargebacks**: A 5% refund rate on a $30 item costs you $1.50 per sale. Multiply that by 100 orders, and you’ve lost $150—enough to cover one employee shift.

- **Ad spend**: If you’re running Facebook or Google ads, factor in the CAC (Customer Acquisition Cost). A $10 CAC on a $30 product means you’re already underwater if your conversion rate is low.

- **SKU cost drift**: Your supplier raised the cost of SKU B07X8K7P2N from $2.99 to $3.49 last quarter. You didn’t update your spreadsheet. Now every sale is $0.50 less profitable.

The fix? Track every cost in one place. We switched to a spreadsheet that pulls in Shopify orders, ad spend from Meta Ads Manager, and shipping labels from Pirate Ship. Within two weeks, we spotted SKU B07X8K7P2N was losing money and killed it before it drained $2,000 from our Q2 budget.

Pro tip: Use Shopify’s **SKU university fees** report (Reports > Finances > SKU Fees) to see exactly how much Shopify takes per product. It’s buried, but it’s there.

Most Shopify sellers calculate profit like this: Revenue – Product Cost = Profit. That’s wrong. Here’s the real formula:

**True Net Profit = Revenue – (Product Cost + Platform Fees + Payment Processing + Shipping + Ad Spend + Refunds + Misc Costs)**

Let’s break it down with a real example. SKU A1B2C3D4E5 sells for $49.99. Here’s the math:

- **Product cost**: $12.50 (supplier invoice) - **Shopify fees**: 2.9% + $0.30 = $1.75 - **Payment processing**: 2.7% + $0.30 = $1.65 - **Shipping**: $8.50 (USPS Priority) - **Ad spend**: $12.00 (Facebook ads for this SKU) - **Refunds**: $0 (no refunds this month) - **Misc costs**: $1.00 (packaging, labels, etc.)

**Revenue**: $49.99 **Total costs**: $12.50 + $1.75 + $1.65 + $8.50 + $12.00 + $1.00 = $37.40 **True Net Profit**: $49.99 – $37.40 = **$12.59 (25.2% margin)**

Now, compare that to SKU F6G7H8I9J0, which sells for $34.99:

- **Product cost**: $10.00 - **Shopify fees**: 2.9% + $0.30 = $1.32 - **Payment processing**: 2.7% + $0.30 = $1.25 - **Shipping**: $7.50 - **Ad spend**: $15.00 (higher CAC due to low conversion) - **Refunds**: $1.75 (one refund) - **Misc costs**: $0.50

**Revenue**: $34.99 **Total costs**: $10.00 + $1.32 + $1.25 + $7.50 + $15.00 + $1.75 + $0.50 = $37.32 **True Net Profit**: $34.99 – $37.32 = **-$2.33 (losing $2.33 per sale)**

The difference? SKU F6G7H8I9J0’s ad spend and shipping eat the margin. We killed it last week and reallocated the budget to SKU A1B2C3D4E5, which now accounts for 40% of our revenue.

Tool tip: If you’re tired of manual spreadsheets, try Gomarginify. It pulls in Shopify orders, ad spend, and shipping costs automatically and gives you a daily profit report. No more guessing which SKUs are profitable.

Shopify and Amazon have wildly different fee structures. If you’re selling on both, you’re probably comparing apples to oranges when you look at margins. Here’s the breakdown:

**Amazon Profit in 2025** - **Referral fee**: 15% for most categories (vs. Shopify’s 2.9% + $0.30) - **FBA fees**: $2.41–$13.78 per unit depending on size/weight (vs. Shopify Shipping’s $7.95–$12.50) - **Storage fees**: $0.69–$2.40 per cubic foot (Shopify doesn’t charge storage fees) - **Ad spend**: Average CAC on Amazon is $5–$10 (vs. $8–$15 on Shopify)

**Shopify Profit Sharing** - **Platform fee**: 2.9% + $0.30 (vs. Amazon’s 15%) - **Payment processing**: 2.7% + $0.30 (vs. Amazon’s 2.9% + $0.30 for non-Prime orders) - **No storage fees**: You control inventory, so no extra costs - **Ad spend**: Higher CAC due to competition, but you own the customer data

**Real-world comparison**: SKU C2D3E4F5G6 sells for $59.99 on both platforms.

- **Amazon**: - Referral fee: $8.99 (15%) - FBA fee: $3.50 - Storage: $0.50 - Ad spend: $7.00 - **Total costs**: $19.99 - **Net profit**: $39.99 (66.7% margin)

- **Shopify**: - Platform fee: $1.93 - Payment processing: $1.88 - Shipping: $8.50 - Ad spend: $10.00 - **Total costs**: $22.31 - **Net profit**: $37.68 (62.8% margin)

At first glance, Amazon looks more profitable. But Shopify’s lower upfront fees and no storage costs make it easier to scale. The key is knowing your **cost per SKU** and adjusting pricing accordingly.

Amazon profit history shows that fees have crept up 3–5% over the past two years. Shopify’s fees have stayed flat. If you’re selling high-margin products, Shopify can be more predictable. If you’re in a low-margin category, Amazon’s volume might still win.

Action step: Run a **profit margin analysis** for your top 10 SKUs on both platforms. Compare the **true net profit**, not just revenue. You’ll likely find that 2–3 SKUs are more profitable on Shopify, while the rest belong on Amazon.

Not all SKU fee structures are created equal. Three types of fee structures consistently destroy Shopify margins:

1. **High shipping weight SKUs** - Example: SKU X7Y8Z9A0B1 (a $24.99 yoga mat) - Weight: 4 lbs - Shopify Shipping cost: $11.50 - **Margin impact**: 46% of revenue gone to shipping alone - Fix: Switch to a lighter supplier or offer free shipping only on orders over $50. We raised our free shipping threshold to $49.99 and saw shipping costs drop 18% in two months.

2. **Low-margin, high-ad-spend SKUs** - Example: SKU L1M2N3O4P5 (a $19.99 phone case) - Ad spend: $12.00 per sale - **Margin impact**: $12.00 ad spend on a $19.99 product = 60% of revenue eaten by ads - Fix: Pause ads for this SKU and reallocate budget to SKUs with higher margins. We cut ad spend for low-margin SKUs by 40% and saw overall profit increase 12%.

3. **Refund-heavy SKUs** - Example: SKU Q5R6S7T8U9 (a $39.99 desk organizer) - Refund rate: 8% - **Margin impact**: $3.20 lost per sale - Fix: Improve product photos, add a size chart, or switch suppliers. We reduced refunds from 8% to 3% by adding a 360° video to the listing.

The worst offenders are often the SKUs you assume are profitable. SKU X7Y8Z9A0B1 looked fine until we ran the numbers. After shipping costs, it was losing $1.20 per sale. We replaced it with a lighter alternative, and margin jumped to 22%.

Pro move: Use Shopify’s **SKU fee structure** report to flag SKUs with high shipping or refund costs. Sort by total fees, not just revenue. You’ll spot the losers fast.

Manual profit tracking is a trap. By the time you update your spreadsheet, the numbers are already wrong. Here’s how to automate it:

1. **Pull orders automatically** - Use Shopify’s **Orders API** to export sales data daily. Tools like Gomarginify or Zapier can pull this into a dashboard without you lifting a finger. - Set up a **daily profit report** via email or Slack. We get ours at 7 AM every day—no excuses.

2. **Sync ad spend** - Connect Meta Ads Manager, Google Ads, and TikTok Ads to your profit tracker. If you’re spending $10,000/month on ads, you need to know which SKUs are driving that spend. - Example: SKU D4E5F6G7H8 had a $15 CAC last month. After syncing ad spend, we saw it was only converting at 1.2%. We paused it and reallocated budget to SKU A1B2C3D4E5, which had a $7 CAC.

3. **Track shipping costs in real time** - Use Pirate Ship or ShipStation to pull shipping label data into your profit tracker. No more manual entry. - Pro tip: Set up alerts for SKUs where shipping costs exceed 20% of revenue. We flag anything over 15% to avoid surprises.

4. **Flag refunds and chargebacks** - Connect Shopify’s refund data to your tracker. A 5% refund rate on a $30 SKU costs $1.50 per sale. Over 200 orders, that’s $300 gone. - We use Gomarginify’s **profit diagnostics** to spot SKUs with high refund rates. Last quarter, it caught SKU M5N6O7P8Q9, which had a 10% refund rate. We fixed the listing and refunds dropped to 3%.

5. **Multi-currency support** - If you sell internationally, use a tool that converts foreign revenue to your base currency automatically. We switched to Gomarginify’s multi-currency feature in March and stopped losing money on currency fluctuations.

The result? We cut manual data entry from 8 hours/week to 30 minutes. More importantly, we caught losing SKUs before they drained $5,000 from our Q1 budget.

Tool rec: If you’re not ready to switch to a full profit tracker, start with Shopify’s **Finances reports**. Go to Reports > Finances > SKU Fees. It’s not perfect, but it’s better than nothing.

Not every SKU deserves to live. Here’s how to decide when to pull the plug:

1. **Margin threshold** - If a SKU’s true net profit is below 10%, it’s a candidate for elimination. SKU P9Q0R1S2T3 had a 9% margin last month. After accounting for ads and shipping, it was losing $1.20 per sale. We liquidated the inventory and reallocated the budget to SKU A1B2C3D4E5, which now has a 25% margin.

2. **Refund rate** - A refund rate above 7% is a red flag. SKU U3V4W5X6Y7 had an 8% refund rate. We added a size chart and reduced refunds to 3%, but the damage was already done—$2,400 lost in Q2. - Rule of thumb: If refunds cost more than 5% of revenue, fix the product or kill it.

3. **Ad spend efficiency** - If your CAC is higher than 30% of the product’s retail price, it’s time to pause. SKU Z1A2B3C4D5 had a $14 CAC on a $49.99 product. After 30 days, we paused ads and saw revenue drop 15%, but profit increased 22% because we stopped throwing money at a losing SKU.

4. **Inventory turnover** - If a SKU hasn’t sold in 60 days and has more than 30 days of inventory left, liquidate it. We had SKU E5F6G7H8I9 sitting in inventory for 90 days. We ran a 20% off sale and cleared it out in two weeks.

5. **Supplier issues** - If your supplier raises costs by more than 10% and you can’t raise prices, it’s time to find a new supplier. SKU J7K8L9M0N1’s cost jumped from $8.50 to $9.50. We switched suppliers and saved $1.00 per unit.

The hardest part isn’t killing the SKU—it’s liquidating the inventory without taking a loss. Here’s how we do it:

- **Bundle it**: Pair the SKU with a high-margin item at a discount. Example: Buy SKU P9Q0R1S2T3 + SKU A1B2C3D4E5 for $69.99 (originally $89.98). We cleared $3,000 in dead inventory this way. - **Flash sale**: Run a 30% off sale for 48 hours. Promote it to your email list and social media. We sold out 150 units in two days. - **Donate for tax write-off**: If the inventory is worth less than $500, donate it and take the tax deduction. We did this for SKU U3V4W5X6Y7 and saved $1,200 on taxes.

Pro move: Before killing a SKU, run a **profit margin analysis** for the last 90 days. If the numbers are consistently bad, pull the trigger. Don’t let sentiment cloud your judgment.