Most sellers know their best-selling product. Far fewer know their most profitable one — and they are often not the same SKU. A product profitability analysis fixes that by tracing every dollar a product earns down to the profit that survives after costs.
This guide gives you the formula, a full worked example with two look-alike products, the two mistakes that wreck most analyses, and a simple way to rank your catalog by what really matters.
What product profitability analysis actually measures
Revenue tells you what a product brought in. Profit tells you what it kept. Product profitability analysis is the discipline of measuring the second number, product by product.
The goal is not a single company-wide margin. It is a per-product view precise enough to answer: "If I doubled ad spend on this SKU tomorrow, would I make more money or lose it faster?"
That requires pulling apart costs most dashboards blend together. A product with a healthy sticker margin can still lose money once you load in refunds and the ad spend it took to acquire each buyer.
The true-profit formula
The competitors all land on roughly the same equation, and it is the right starting point:
Product profit = Revenue − (COGS + shipping + payment fees + discounts + refunds + ad spend)
The trap is in the details of each term. Get any one wrong and the ranking flips. Here is how each cost behaves for a small Shopify or print-on-demand (POD) store:
- COGS — the direct cost of the units you sold. For POD, that is the supplier's production charge plus their shipping to the customer.
- Payment fees — a percentage plus a flat fee on every transaction, commonly around 2.9% plus 30¢ per online card charge on Shopify Payments' lower-tier plans, according to A2X's breakdown of Shopify fees. The flat 30¢ hurts low-ticket products far more than high-ticket ones.
- Refunds — a refunded order costs you the sale and the original processing fee, which Shopify generally does not return, per the same A2X guide.
- Ad spend — the paid acquisition cost to win each order. This is the term sellers most often misplace, and the rest of this article shows why it matters.
A worked example: same revenue, different truth
Say you run a t-shirt store and two designs each did $3,000 in revenue last month. On the storefront they look equally successful. The profit picture is not close.
Design A — the "premium" tee, sold at $40:
- Orders: 75 (75 × $40 = $3,000 revenue)
- COGS: $13/unit → 75 × $13 = $975
- Payment fees: 2.9% of $3,000 + (75 × $0.30) = $87 + $22.50 = $109.50
- Refunds: 2 orders refunded → $80 back to customers
- Ad spend: $900
- Profit: $3,000 − $975 − $109.50 − $80 − $900 = $935.50
- Per-order profit: $935.50 ÷ 75 = $12.47
Design B — the "value" tee, sold at $20:
- Orders: 150 (150 × $20 = $3,000 revenue)
- COGS: $12/unit → 150 × $12 = $1,800
- Payment fees: 2.9% of $3,000 + (150 × $0.30) = $87 + $45 = $132
- Refunds: 5 orders refunded → $100 back to customers
- Ad spend: $1,050
- Profit: $3,000 − $1,800 − $132 − $100 − $1,050 = −$82
- Per-order profit: −$82 ÷ 150 = −$0.55
Same revenue. Design A keeps roughly $935; Design B loses money on every sale. Two forces drove the gap.
First, the flat 30¢ fee scales with order count, not order value, so Design B's 150 small orders paid $45 in flat fees against Design A's $22.50. Cheaper products get taxed harder by the fixed portion of every fee.
Second, the low ticket left almost no room to absorb acquisition cost — $7 of ad spend per order against a $20 sale is a very different bet than $12 against a $40 sale. A revenue view would have told you to double down on Design B. The profit view tells you to fix its price or its ad spend before it drains the account.
The two mistakes that break most analyses
Two errors show up constantly in small-store books, and either one will hand you the wrong ranking.
Mistake 1: treating your payout as revenue
The deposit Shopify sends to your bank is a net settlement — sales minus fees minus refunds, on a delayed rolling schedule — so it almost never equals your sales for the same window. Booking that payout as "revenue" silently hides every fee and makes per-product margins impossible to compute.
Record gross sales at the top and each fee on its own line; the payout is a cash consequence at the bottom, not your top-line number. Our ecommerce P&L guide walks through the full statement layout, and if fees are the part tripping you up, the deeper dive on payment gateway costs breaks them down line by line.
Mistake 2: hiding ad spend inside product cost
It is tempting to fold acquisition cost into COGS since it scales with sales. Don't. Burying blended ad spend in cost of goods inflates your gross margin and hides the fact that customer acquisition cost — not production — is usually the real risk.
In the example above, both tees had strong product margins before ads. Only after loading ad spend as a separate, visible cost did Design B reveal itself as a loser. Keep ad spend where you can see it move.
Rank products by contribution margin, not gross margin
The number to sort your catalog by is contribution margin: revenue minus all the variable costs of selling one more unit (COGS, fees, shipping, and the ad spend to acquire the buyer). It answers the only question that matters for scaling — does one more sale of this product add money or subtract it?
From the example, Design A contributes about $12.47 per order and Design B loses $0.55. Rank every SKU this way and your decisions get obvious: scale positive contributors, and reprice, re-source, or retire the negative ones.
This is also where the well-known 80/20 pattern shows up. Roughly 20% of products tend to generate around 80% of total contribution, according to Onetribe Advisory's product profitability breakdown — so finding your top contributors is often the highest-leverage hour you'll spend this month.
How to run this every month without a spreadsheet nightmare
The math above is simple; the data plumbing is not. COGS lives with your POD supplier, fees live in Shopify's payout reports, and ad spend lives in Meta and Google. Stitching them per order, by hand, every month, is where most sellers give up.
That's the gap PodVector closes. It connects Shopify, Meta Ads, Google Ads, Printify, Printful, and Stripe, then computes true per-order profit — the same product-by-product number this article walks through, without the manual reconciliation.
PodVector is not a dashboard you have to babysit. Victor, its AI operator, analyzes your live data and proposes moves, and with your approval executes the Shopify-side changes — while reading, never touching, your ad accounts. When you're ready to see a monthly profit-and-loss view built from real order data, the profit-and-loss app is the natural next step, and if you'd rather hand the books to a human, here's how to think about ecommerce bookkeeping near you.
FAQs
What is product profitability analysis in simple terms?
It is measuring how much profit each individual product keeps after every cost of selling it — production, shipping, payment fees, discounts, refunds, and advertising. Instead of asking "which product sells the most," it asks "which product makes the most money," which is frequently a different SKU.
What costs should I include in a product's profitability?
Include every cost that changes with a sale: cost of goods sold, supplier or fulfillment shipping, payment processing fees, discounts applied, refunds, and the ad spend that acquired the buyer. Fixed overhead like your Shopify subscription can be handled at the business level, but the variable, per-unit costs must be loaded onto each product or your ranking will be wrong.
Should ad spend go into COGS or be counted separately?
Count it separately. Folding advertising into cost of goods inflates your gross margin and hides that acquisition cost — not production — is usually your biggest risk. Keep ad spend visible as its own line so you can see exactly when a product's marketing is eating its margin.
Why is my Shopify payout different from my sales?
Because the payout is a net settlement: sales minus fees minus refunds, deposited on a delayed rolling schedule. It almost never matches your sales for the same window. Book gross sales at the top of your records and treat the payout as the cash result at the bottom — never as your revenue figure.
What is contribution margin and why does it matter more than gross margin?
Contribution margin is revenue minus all the variable costs of selling one more unit, including the ad spend to acquire the buyer. Gross margin often looks healthy because it ignores acquisition cost. Contribution margin tells you whether scaling a product adds or subtracts money — which is the decision you actually care about.
How often should I run a product profitability analysis?
Monthly is the practical cadence for a small store, matching how you'd build a monthly profit-and-loss statement. Costs like supplier prices, fees, and especially ad efficiency drift over time, so a product that was profitable last quarter can quietly slip into the red. A monthly review catches the slide while it's still cheap to fix.