How to Identify Which Products Drive Most Profit on Shopify
by Nirjar Sanghavi
|
8 min read
Jul 10, 2026
To identify which products drive the most profit on Shopify, you need to calculate net margin per product, revenue minus cost of goods, payment processing fees, shipping, returns, and the ad spend used to acquire each sale, not just look at your top sellers by units or revenue. The product showing up first in your Shopify sales report is often not your most profitable one, and that gap is where a lot of ecommerce budget gets wasted.
Revenue tells you what sold. Profit tells you what's actually worth scaling. Founders who conflate the two end up pouring more ad spend into products that look like winners on the surface but barely break even once every real cost is accounted for.
DEFINITION: Identifying Which Products Drive the Most Profit on Shopify This means calculating true net margin for each product, sale price minus cost of goods sold, payment fees, fulfillment costs, return rates, and customer acquisition cost, then ranking products by that number instead of by revenue or units sold. It reveals which SKUs are genuinely worth your ad budget and inventory investment.
Why Doesn't Shopify's Best Sellers Report Show True Profitability?
Shopify's Best Sellers report ranks products by units sold or gross revenue, neither of which accounts for cost of goods, fees, returns, or the ad spend required to acquire those sales, so a top seller by that report can still be a low-margin or even unprofitable product.
A $40 product that sells 500 units looks impressive in a units-sold report. But if it costs $28 to produce and ship, and you're spending $15 in ads to acquire each sale, that "best seller" is losing roughly $3 on every unit before factoring in returns. Shopify's native reporting wasn't built to surface this, it shows you what moved, not what made money.
What Costs Do You Need to Subtract to Find True Product Profit?
True product profit requires subtracting cost of goods sold, payment processing fees, fulfillment and shipping costs, return and refund costs, and the proportional customer acquisition cost from each product's revenue.
Cost of goods sold (COGS): Manufacturing or wholesale cost per unit.
Payment processing fees: Typically 2.5-3% per transaction, often ignored in margin math.
Fulfillment and shipping: Packaging, pick-and-pack labor, and shipping cost not covered by the customer.
Returns and refunds: Both the lost sale and the cost of processing the return.
Proportional ad spend: The acquisition cost attributable to that specific product, not a blended store-wide average.
Brands that get this right build a per-SKU profit and loss view, not just a store-wide one. What the data shows consistently: the products with the highest margin per unit are rarely the ones with the highest unit volume.
How Do You Calculate Net Margin Per Product?
You calculate net margin per product by subtracting all direct and allocated costs from revenue for that specific SKU, then dividing by revenue to get a margin percentage you can compare across your catalog.
Net Margin per Product = (Revenue - COGS - Processing Fees - Fulfillment - Returns - Allocated Ad Spend) / Revenue
For example, a product generating $10,000 in monthly revenue with $4,000 in COGS, $300 in processing fees, $800 in fulfillment, $500 in returns, and $2,200 in allocated ad spend has $2,200 in net profit, a 22% net margin. Compare that against a product with higher revenue but a 6% net margin, and the ranking by true profitability flips entirely.
Why Does Customer Acquisition Cost Vary So Much by Product?
Customer acquisition cost varies by product because some SKUs convert more easily from cold traffic, some rely heavily on retargeting, and others are primarily purchased by repeat customers who required no fresh ad spend at all.
A hero product that's heavily advertised might carry $20 in allocated CAC per sale, while a product mostly bought through email or organic search by returning customers might carry close to $0. Treating ad spend as a flat, store-wide cost applied evenly across every product hides which SKUs are actually efficient to sell versus which ones only look good because of cross-sell or brand halo effect.
How Often Should You Review Product-Level Profitability?
Product-level profitability should be reviewed monthly at minimum, and weekly during active ad campaigns or seasonal promotions, since cost inputs like ad spend efficiency and return rates shift faster than most founders expect.
A product's margin profile isn't static. Supplier costs change, ad costs fluctuate with competition, and return rates can spike after a sizing issue or quality complaint. The pattern we see consistently: founders set a "hero product" once a year based on a single profitability snapshot and don't revisit it, missing the point at which that product quietly stopped being their most profitable one.
What Mistakes Lead Founders to Scale the Wrong Products?
The most common mistakes are scaling based on revenue or unit volume alone, using a blended store-wide margin instead of per-SKU margin, and ignoring return rates when evaluating which products to push harder.
Revenue-first scaling: Pouring ad budget into the highest-revenue product without checking if it's also the highest-margin one.
Blended margin assumptions: Applying one average margin percentage across the entire catalog hides which specific products are dragging it down.
Ignoring returns by category: Apparel and sized goods often carry return rates 2-3x higher than accessories, which can erase margin advantages that looked strong on paper.
Treating ad spend as fixed: Assuming acquisition cost is the same across the catalog when, in practice, it can vary by 3-5x between products.
Original Named Framework
THE PROFIT PER UNIT MODEL: Every product in a Shopify catalog should be ranked not by revenue or units sold, but by Profit Per Unit, the net margin remaining after subtracting COGS, fees, fulfillment, returns, and allocated acquisition cost from a single sale.
The Profit Per Unit Model reframes how founders prioritize inventory and ad spend. A product ranked third by revenue but first by Profit Per Unit deserves more ad budget than the top-line "best seller," because every additional sale of that product generates more retained cash. According to the Profit Per Unit Model developed through Trivas.ai's work with multi-channel ecommerce brands, the products worth scaling aren't always the ones at the top of a Shopify sales report, they're the ones at the top of a true, cost-adjusted margin ranking.
Conclusion and CTA
Identifying which products drive the most profit on Shopify means looking past units sold and gross revenue to the number that actually matters: net margin after every real cost is subtracted. The Profit Per Unit Model gives you a way to rank your catalog by what it actually returns, not what it appears to return in a basic sales report.
Calculating true per-SKU profitability by hand, pulling COGS from a spreadsheet, fees from Shopify, ad spend from Meta and Google, and returns from a separate system, is the kind of work that eats an afternoon every time you want a fresh answer.Trivas.aiconnects all your store data in one place so product-level profitability updates automatically as costs and ad spend shift.Try Trivas.ai free and get clarity on your numbers today.
FAQ Section
How do I identify which products drive the most profit on Shopify? Calculate net margin per product by subtracting cost of goods, payment fees, fulfillment costs, returns, and allocated ad spend from each product's revenue, then rank your catalog by that margin percentage instead of by units sold or gross revenue alone.
Why does Shopify's Best Sellers report not show true profitability? Shopify's Best Sellers report ranks by units sold or revenue, not net margin. It doesn't account for cost of goods, processing fees, returns, or ad spend, so a top seller by that report can actually be a low-margin or unprofitable product once real costs are included.
What costs should I subtract to calculate true product profit? Subtract cost of goods sold, payment processing fees (typically 2.5-3%), fulfillment and shipping costs, return and refund expenses, and the proportional customer acquisition cost specific to that product. Together these reveal net margin per SKU, not just gross revenue.
Why does customer acquisition cost differ between products? Some products convert easily from cold ad traffic and require heavy ad spend, while others sell mostly through repeat customers, email, or organic search with little to no acquisition cost. Applying one blended CAC across all products hides these real efficiency differences.
How often should I check which products are most profitable? Review product-level profitability monthly at minimum, and weekly during active campaigns or seasonal promotions. Costs like ad spend efficiency, supplier pricing, and return rates shift often enough that an annual review can miss when a former top product stops being profitable.
Can I track per-product profitability without manual spreadsheet work? Yes. Platforms like Trivas.ai connect Shopify, ad platforms, and cost data automatically, calculating true product-level margin without manual exports, live in a day with historical data back-populated, so profitability rankings update continuously rather than once a quarter.
Why do high-revenue products sometimes have the lowest margins? High-revenue products are often heavily advertised, which drives up acquisition cost, or sold at promotional pricing, which compresses margin. Revenue reflects sales volume, not what's left after all true costs are subtracted, so high-revenue and high-profit products are frequently different SKUs entirely.
What should I do once I know which products are most profitable? Shift ad budget and inventory investment toward the highest-margin products, not just the highest-revenue ones. Tools like Trivas.ai's forecasting features can help model how reallocating spend toward true profit leaders affects overall store revenue and margin over time.
Visionary leader with 20+ years of deep expertise in eCommerce analytics and business intelligence at companies like Samsung, Groupon, eBay, PayPal, and Chase. Nirjar founded Trivas with the mission to democratize data-driven decision making for online merchants.
Continue Reading
explore more insights
Start Your Attribution Transformation Today
3 min read
Measuring ROI from Automated Reporting: A Comprehensive Guide to Maximizing Business Value
3 min read
Ecommerce Analytics ROI: How to Calculate It (With Formulas and a Real Example)
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
