Profit Per Product on Shopify: How to Calculate It Right
Your best seller by revenue can be your worst product by profit. Here's how to calculate profit per product on Shopify after ads, shipping and returns, and why the ranking flips.
Your best seller might be the product quietly eating your month.
Here's the profit per product Shopify math, done right. Take each product's net sales and subtract five things: product cost, the shipping you paid, payment fees, the returns that refunds don't cover, and the ad spend that product needed. What's left is what that product actually put in your bank. Then divide it by that product page's sessions, so a $12 item and a $149 item can stand on the same scale.
Do that for your top five products and something uncomfortable usually happens. The ranking flips. The product at the top of your sales report slides toward the bottom, and a product you barely advertise climbs to first.
And that changes where your traffic should go.
Revenue tells you which product is loud. Profit tells you which one is paying the rent.
What does Shopify's profit report actually show you?
Shopify does give you a starting point. Its Gross profit by product report lists net quantity, net sales, cost, gross margin and gross profit for each product.
Here's the catch. That gross profit is net sales minus product cost. That's it. Shipping you paid, ad spend and returns handling are not in it.
Two more things bite founders here:
- It only counts what you recorded. Shopify reports profit only for products and variants that had a cost per item saved at the time they sold. Add costs today and last quarter stays blank.
- Costs are frozen per sale. Change a supplier price and old reports don't recalculate. That's good for accuracy, bad if you never entered costs in the first place.
You set the cost in the Pricing section of each product, in the Cost per item field. When Shopify launched cost and profit reporting, cost per item came to every plan, while the profit reports went to the Shopify plan and up. Check your own Reports page to see what your plan shows today.
So the report is a solid first line of the math. It's the top of the ledger, and most of the costs that decide a product's fate sit below it.
How do you calculate profit per product the right way?
Five subtractions, in this order:
- Start with net sales per product for the month.
- Subtract product cost: cost per item times units sold.
- Subtract outbound shipping and payment fees you paid.
- Subtract returns cost that refunds don't already cover.
- Subtract the ad spend that product drove.
Step 2 should be your landed cost, freight and duties included. If you haven't rebuilt that number since tariffs moved, the landed cost worksheet walks through it line by line.
Step 4 matters more than most people think. The NRF and Happy Returns estimate that 19.3% of online sales would be returned in 2025. Refunds already come out of net sales. What doesn't come out: return labels, inspection time, and units that come back too scuffed to sell as new.
Step 5 is the one everyone skips, because the spend lives in Meta and Google, and the sales live in Shopify. That's why the ranking lies to you.
What happens when you rank five products by profit instead of revenue?
Run the math on a store like this, a hypothetical: a coffee gear brand on Shopify with five products, one month of numbers, one unit per order, payment fees at 3% of sales.
| Product | Net sales | Product cost | Shipping | Fees | Returns cost | Ad spend | Profit |
|---|---|---|---|---|---|---|---|
| Burr grinder ($149, 200 sold) | $29,800 | $13,600 | $3,200 | $894 | $1,540 | $7,900 | $2,666 |
| Gooseneck kettle ($89, 260 sold) | $23,140 | $8,840 | $2,860 | $694 | $920 | $5,200 | $4,626 |
| Pour-over starter kit ($64, 280 sold) | $17,920 | $5,320 | $2,520 | $538 | $275 | $2,100 | $7,167 |
| Ceramic dripper ($34, 360 sold) | $12,240 | $2,880 | $2,520 | $367 | $220 | $1,400 | $4,853 |
| Paper filters ($12, 700 sold) | $8,400 | $1,470 | $2,800 | $252 | $0 | $600 | $3,278 |
Here's the revenue ranking, the one Shopify shows you first:
A hypothetical coffee gear store. The burr grinder leads on revenue.
Now the same five products, ranked by what they kept after ads, shipping, fees and returns:
Same hypothetical store, same month. Net sales minus product cost, shipping, fees, returns cost and ad spend.
The grinder goes from first to last.
It brings in 33% of the store's sales ($29,800 of $91,500). It takes 46% of the ad budget ($7,900 of $17,200). And it returns 12% of the profit ($2,666 of $22,590). That's a 9% margin after ads, against 40% on the starter kit.
The product getting the most ad money was the one giving the least back. Nobody decided that. The revenue report decided it for them.
Which number should decide where traffic goes?
Profit per session. Revenue per product rewards products that get the most traffic, and the most traffic usually follows the most ad spend. Circular.
So divide each product's profit by its page sessions. Say the grinder page got 10,000 sessions last month and the starter kit page got 8,000.
The grinder converts at 2.0% with a $149 average order value, so its revenue per visitor is $2.98. The kit converts at 3.5% at $64, so its revenue per visitor is $2.24. On revenue, the grinder still looks like the winner. Here's the math on profit: $2,666 over 10,000 sessions is $0.27 per session for the grinder. $7,167 over 8,000 sessions is $0.90 per session for the kit. More than 3x.
If you want this split by page for your whole catalog, the guide on how to calculate revenue per visitor on Shopify shows where to pull sessions per product. And if the ad spend column looks heavy next to the sales it brought in, the Facebook ads benchmarks for ecommerce show what a normal cost per purchase looks like before you blame the product.
I'll admit something. When I was running my own brands, the hero product got the budget because it was the hero product. Biggest revenue line, biggest ad set, end of discussion. It took a bad quarter and a spreadsheet to see that the product I was proudest of was the one I was overpaying to sell.
Should you cut the product that ranks last?
Usually not. And this is where most "kill your losers" advice goes wrong.
Look at why the grinder ranks last. It isn't a bad product. It burns $0.79 of ads per session ($7,900 over 10,000) while the kit burns $0.26 ($2,100 over 8,000). The grinder is expensive to sell because its page only closes 2 out of every 100 visitors at $149.
Watch what happens if the grinder page converts at 3.0% instead of 2.0%, with the same 10,000 sessions and the same $7,900 in ads. 300 units, $44,700 in net sales. Take off $20,400 in product cost, $4,800 shipping, $1,341 fees and $2,310 in returns (still 14% of units at $55 each), and the grinder keeps $7,949. Same traffic, same ad bill, almost 3x the profit. Now it ranks first.
Then the filters. At $12 they look tiny, and $4 shipping eats a third of every sale. But in a real coffee store, filters ride in the same box as a dripper or a kit. Shipped together, that $4 mostly disappears. That's a bundle decision, and the bundles guide covers how to build one that lifts order value without gutting margin.
A product at the bottom of the profit ranking is either a page problem, a shipping problem or a pricing problem. Find which one before you touch the delete button.
Where does AI fit into profit per product today?
Two places, and both are real right now.
First, pulling the Shopify side of the numbers. Shopify's Sidekick can turn plain-language questions into analytics reports and handle follow-up questions on the same thread. Asking for net sales and units by product for September takes seconds instead of a report-builder session. Ad spend per product still lives in your ad accounts, so you join that part yourself or with a profit app that connects them.
Second, fixing the page that's dragging a product down. In the grinder example, the lever was conversion rate on one page. That used to mean a copywriter, a designer and a month. AI can now draft the copy, the images and the page around the questions buyers ask before they pay $149 for a grinder.
That's the part we see move profit per order the most. One of our Amazon-to-Shopify clients went from $7.73 net profit per sale on Amazon to $78.87 per sale on Shopify, after paying for ads and inventory, with ad spend per sale rising from $5.99 to $63.40. See the full breakdown on our results page. Real client numbers, not typical results, and not a promise of what your store will do. The ad bill per sale went up about 10x, and profit per sale went up about 10x right alongside it. Ad spend was never the enemy. A page that couldn't carry it was.
For the full system across products, pages and channels, the ecommerce profit analytics guide is the long version. And if you want to see how a "healthy" revenue line can hide a store losing money, read the $60K store that was actually losing money. If the problem turns out to be the price, here's how to run Shopify price testing without angering buyers.
What to do next
This week, rank your top five products twice. Once by net sales, straight from Shopify. Once by profit per session, with shipping, fees, returns and ad spend taken off. If the top of the two lists isn't the same product, you've found where your next ad dollar and your next page rebuild belong.
Running a sale soon? Do this first, because a discount hits a 9% product far harder than a 40% one. The Black Friday profit margin breakdown shows how fast that goes negative.
Frequently asked questions
How do I calculate profit per product on Shopify? Take each product's net sales for the period, then subtract product cost, the shipping you paid, payment fees, the cost of returns that refunds don't cover, and the ad spend that drove that product. Divide what's left by page sessions to compare products fairly.
Does Shopify show profit by product? Yes, through the Gross profit by product report, but only for items with a cost per item recorded when they sold. It subtracts product cost only, so shipping, ads and returns still have to come off.
Where do I enter cost per item in Shopify? In the Pricing section of each product in your admin, in the Cost per item field, per variant if costs differ. Enter it before the sale, because Shopify doesn't rewrite old reports.
Why is my best selling product not my most profitable? Because revenue ignores what it cost to win and keep the sale. In our hypothetical coffee gear store, the top revenue product took 46% of ad spend and returned 12% of profit.
What's a good profit margin per product on Shopify? There isn't one universal number. Rank products by profit per session first, then decide where the next ad dollar and the next page rebuild go.
Book Your Profit Audit
If your top revenue product is quietly ranking last on profit, the fix usually starts on its page, not in the ad account. Get your free profit audit and we'll show you which product is leaking and how to rebuild a high-converting product sales page in less than 15 minutes.
Or go here to check it out → revenueflows.ai
P.S. The product that brings in the most money and the product that keeps the most money are rarely the same one. Feed the one that keeps it.
Frequently asked questions
How do I calculate profit per product on Shopify?
Take each product's net sales for the period, then subtract product cost, the shipping you paid, payment fees, the cost of returns that refunds don't cover, and the ad spend that drove that product. What's left is profit per product. Divide it by the product page's sessions and you can compare a $12 product and a $149 product fairly.
Does Shopify show profit by product?
Yes. Shopify's Gross profit by product report shows net sales, cost and gross profit per product, but only for items that had a cost per item recorded when they sold. It subtracts product cost only, so shipping, ad spend and returns still have to come off before you have real profit per product.
Where do I enter cost per item in Shopify?
Open the product in your Shopify admin and type the amount in the Cost per item field in the Pricing section, for each variant if costs differ. Shopify stores that cost on each sale, so changing it later doesn't rewrite old reports. Enter it before the sale, not after.
Why is my best selling product not my most profitable?
Because revenue ignores what it cost to win and keep the sale. A high-ticket hero product often carries most of the ad budget, heavier shipping and more returns. In our hypothetical coffee gear store, the top revenue product took 46% of ad spend and returned 12% of profit.
What's a good profit margin per product on Shopify?
There isn't one universal number. A product earning 9% after ads can be fine if it brings in customers who come back, and a 40% product can be starved if nobody sees it. Rank products by profit per session first, then decide where the next ad dollar and the next page rebuild go.