If you already run a store, you don't need another article telling you to "track your margins." You need to know which of your SKUs actually clear a profit once ads, returns, and fees come out — and which ones are draining the account while the orders dashboard says they're winning.
That gap is the whole point of SKU profitability. Revenue and unit volume lie. A SKU doing 90 orders a month can be your single biggest cash leak, and you won't see it until you stack the costs order by order.
What SKU profitability actually measures
SKU profitability is the profit a single stock-keeping unit generates after all the costs attached to selling that unit are subtracted. The basic shape is simple: revenue per SKU minus direct costs minus the allocated variable costs of moving it.
The trap is scope. Most sellers compute price − product cost and call it margin. That is gross margin, and it is the most flattering number in your business — it ignores shipping, payment processing, pick-and-pack, returns, and the ad spend that acquired the order.
Real SKU profitability walks all the way down to contribution margin after ads. That is the number that tells you whether selling one more of this SKU adds cash or burns it. Everything above it is a story; this is the scoreboard.
The SKU profit stack, one order at a time
The cleanest way to see it is to walk a single average order for one SKU down the stack. Say you sell a graphic tee at a thirty-one dollar price point in an operating store doing around 340 orders a month.
| Line | Amount | Running total |
|---|---|---|
| Price (revenue) | $31.00 | $31.00 |
| − Product cost (blank + print) | −$12.40 | $18.60 gross profit |
| − Shipping (carrier) | −$4.50 | $14.10 |
| − Payment processing (2.9% + 30¢ on $31) | −$1.20 | $12.90 |
| − Pick / pack labor | −$1.00 | $11.90 (CM2) |
| − Allocated ad spend (at a ~$9 cost per order) | −$9.00 | $2.90 (CM3) |
The payment-processing line uses the standard online card rate of 2.9% plus thirty cents per transaction documented by Shopify; on a thirty-one dollar order that works out to about a dollar twenty. Every other line is your own cost data.
Notice what happened. A tee that looks like a sixty-percent-margin product leaves $11.90 before ads and just $2.90 after ads — a true contribution margin around nine percent. That is still profitable, but it is a thin cushion, and it only survives because the cost per order stayed under ten dollars.
This is why gross margin alone is dangerous. The number that pays your rent sits four lines lower than the one most dashboards show you. If you want the deeper framework behind these tiers, our guide to ecommerce business intelligence lays out how contribution margin stacks fit into a full reporting view.
Why your best-seller can be your biggest loser
Here is the part competitors gloss over: volume and profit are different axes. A high-order SKU with heavy returns and expensive ads can net negative while a quiet, low-return SKU carries the business.
Say you also sell a fifty-two dollar hoodie that your orders report calls a bestseller. Walk the same stack, then add the cost nobody wants to model — returns.
| Line | Tee ($31) | Hoodie ($52) |
|---|---|---|
| Price | $31.00 | $52.00 |
| − Product cost | −$12.40 | −$26.00 |
| − Shipping | −$4.50 | −$7.00 |
| − Payment processing | −$1.20 | −$1.81 |
| − Pick / pack | −$1.00 | −$1.20 |
| = CM2 (before ads) | $11.90 | $15.99 |
| − Allocated ad spend | −$9.00 | −$14.00 |
| = CM3 (after ads) | $2.90 | $1.99 |
| − Returns (say 1 in 5 comes back, ~$18 each) | $0.00 | −$3.60 |
| = True per-order profit | $2.90 | −$1.61 |
The hoodie's payment line again uses the 2.9%-plus-thirty-cents rate published by Shopify; the rest are example operating costs for illustration, not market facts.
The hoodie outsells the tee and loses $1.61 on every order. Returns are the killer: apparel return rates run high, and the true cost of a return is reverse shipping plus the lost product plus the labor to inspect and restock. Spread one eighteen-dollar return across five orders and it erases the whole thin CM3.
Checkout friction compounds this at the catalog level — the average documented online cart abandonment rate sits near seventy percent according to Baymard's research, so the SKUs you promote hardest are also the ones where paid traffic leaks before it ever converts. A SKU that needs heavy ad spend to move is doubly exposed.
The costs competitors hand-wave
Two inputs decide whether your SKU-level numbers are honest or fiction: returns and ad allocation. Most guides list them and move on. Here is how to actually assign them.
Returns. Don't use a blanket store-wide rate. Returns cluster by SKU — fit-sensitive apparel and seasonal items come back far more than basics. Track the return rate per SKU and cost each return at reverse shipping plus unrecoverable product plus handling, then amortize across that SKU's orders.
Ad spend. Allocating a blended ad number across all SKUs hides the losers. Tie spend to the SKU or campaign that actually drove the order using your platform's cost-per-order, not a store average. A SKU with a fourteen-dollar acquisition cost and a sixteen-dollar CM2 is one bad return away from red.
Getting this per-SKU allocation right is exactly where spreadsheets break down, and it's the core job of a real analytics setup — see how the leading tools compare in our breakdown of the best ecommerce analytics platforms.
Turning SKU profit into decisions
The point of the analysis is the action it unlocks. Once you have true per-order profit by SKU, the moves are obvious:
- Kill or fix the losers. A SKU that's negative after returns and ads gets a price increase, a cheaper supplier, a lighter shipping profile, or the axe.
- Scale the quiet winners. Low-return SKUs with healthy CM3 deserve more of your ad budget than your "bestseller" does.
- Reprice around break-even. If a SKU's contribution margin can't cover its cost per order, you're buying revenue, not profit.
This is operating cadence, not a one-time audit. Costs drift — suppliers raise prices, carriers reprice, ad auctions get more expensive — so the SKU that cleared a profit last quarter can slide underwater without a single thing changing on your storefront. Pairing SKU profitability with a live marketing dashboard for Shopify keeps the ad-allocation side current.
Where PodVector AI fits
Pulling true per-order profit by SKU means stitching together your store, your print supplier's costs, your payment fees, and your ad spend — the exact data that lives in four different places. PodVector AI's Victor is an AI employee that connects your Shopify store, Meta Ads, Google Ads, and your Printify, Printful, or Gelato supplier, then computes true per-order profit across them.
Victor is not a dashboard you have to read. You can ask which SKUs lose money after ads and returns, and it works the live data and delivers the report to your Google Drive. Every action it takes on your behalf is approval-gated — nothing executes until you say so.
If you'd rather stop rebuilding this stack in a spreadsheet every month, try Victor on your own store data.
For the broader metric set that surrounds SKU profit — ROAS, POAS, CAC, and contribution margin together — our piece on ecommerce performance analytics ties them into one operating view.
FAQs
What is the formula for SKU profitability?
At its simplest, SKU profitability equals revenue per SKU minus direct costs minus allocated variable costs. In practice you walk it down tiers: price minus product cost gives gross profit; subtract shipping, payment fees, and fulfillment labor to get contribution margin before ads (CM2); then subtract allocated ad spend and amortized returns to get your true per-order profit (CM3). The last number is the one that tells you whether to scale or cut.
Why isn't gross margin enough to judge a SKU?
Gross margin only subtracts product cost, so it ignores shipping, payment processing, pick-and-pack, returns, and ads — often half or more of the real cost of a sale. A SKU can show a sixty-percent gross margin and still lose money per order once ads and returns come out. Gross margin tells you if a product is worth making; contribution margin after ads tells you if it's worth selling through your current channels.
How do I account for returns in SKU profitability?
Track return rate per SKU, not store-wide, because returns cluster heavily in fit-sensitive and seasonal products. Cost each return at reverse shipping plus the unrecoverable product cost plus handling labor, then spread that total across the SKU's order volume. A one-in-five return rate at eighteen dollars a return quietly removes several dollars of profit from every order of that SKU.
How often should I run SKU profitability analysis?
Treat it as an ongoing read, not an annual audit. Supplier prices, carrier rates, and ad costs all drift, so a SKU that cleared a profit last quarter can turn negative with nothing changing on your storefront. Checking monthly at minimum — or continuously if your tooling allows — catches the slide before it eats a quarter of margin.
Can my best-selling product really be unprofitable?
Yes, and it's common. High order volume often comes from aggressive ad spend and promotion, which drives up acquisition cost, and bestsellers in apparel frequently carry the highest return rates. When heavy ad allocation and returns both land on the same SKU, its true per-order profit can go negative even as it tops your sales report. That's the exact blind spot SKU-level analysis exists to close.