Most ecommerce founders can tell you their best-selling product. Far fewer can tell you which products actually make money after every cost is accounted for. Revenue and profitability are not the same thing, and the gap between the two is where margin leaks hide.
A product profitability analysis breaks down the true cost of selling each SKU, from raw materials and fulfillment fees to advertising spend and return rates. Without it, founders end up scaling products that look profitable on the surface but quietly erode cash flow underneath. The result is a catalog full of activity and a bank account that never seems to grow.
Why Top-Line Revenue Hides the Real Story
Ecommerce platforms show revenue by product. That number feels like progress. But revenue is only one half of the equation. The other half, cost, gets scattered across invoices, ad platforms, shipping labels, and marketplace fee reports. Reassembling those costs at the SKU level takes work most founders never do.
Consider a brand selling five products. Product A does $40,000 per month in revenue and Product B does $12,000. Product A looks like the winner. But if Product A carries a 15% return rate, $6,000 in monthly ad spend, and a landed cost of goods sold of 55%, the real margin might be 8%. Product B, with a 3% return rate, $800 in ad spend, and 35% COGS, could be running at a 42% margin. Product B is the business. Product A is the distraction.
This is the core problem product profitability analysis solves. It moves the conversation from "what sells" to "what earns."
The Anatomy of Per-SKU Profitability
True product profitability requires layering costs in a specific order. Each layer peels away another piece of the revenue until the real margin is visible.
Layer 1: Gross Margin
Start with the sale price minus the direct cost of goods sold. For physical products, this includes raw materials, manufacturing, packaging, and inbound freight. A product that sells for $45 with a $16 landed cost has a gross margin of 64%.
Many founders stop here. That is a mistake. Gross margin is the starting line, not the finish.
Layer 2: Fulfillment and Shipping Costs
Fulfillment includes pick-and-pack fees, shipping labels, dimensional weight charges, and packaging materials. For sellers using third-party logistics (3PL) or Amazon FBA, these fees can range from $3 to $12 per unit depending on size and weight.
A $45 product with a 64% gross margin and $7 in fulfillment costs drops to a 49% margin after fulfillment. That 15-point drop is common, and it gets worse for heavy or oversized items.
Layer 3: Marketplace and Payment Processing Fees
Selling on Amazon, Shopify, Walmart, or any other marketplace comes with referral fees, payment processing charges, and subscription costs. Amazon's referral fee alone runs 8% to 15% depending on category. Shopify Payments charges 2.6% to 2.9% plus $0.30 per transaction.
For the same $45 product on Amazon at a 15% referral fee, that is another $6.75. The margin after fulfillment and fees is now around 34%.
Layer 4: Advertising and Customer Acquisition
Most ecommerce brands spend between 15% and 30% of revenue on advertising. But that spend is rarely distributed evenly across the catalog. Some products run profitably on organic traffic. Others require $15 in ad spend to generate a single sale.
Product-level ad spend is the layer that creates the biggest surprises. A product that seemed healthy at 34% margin after fees might drop to 12% once $10 in average ad cost per unit is applied.
Layer 5: Returns and Replacements
Return rates vary wildly by category. Apparel can run 20% to 30%. Electronics might sit at 5% to 10%. Home goods land somewhere in between.
Returns are not just lost revenue. They carry reverse logistics costs, restocking fees, and in many cases, inventory that cannot be resold at full price. A 15% return rate on a $45 item does not just remove $6.75 from the average. It adds $2 to $4 in processing costs on top of it.
How to Build a Product Profitability Calculator
A Shopify profit calculator or ecommerce profitability spreadsheet does not need to be complicated. It needs to be complete. Here is the framework.
Step 1: Pull Revenue and Units Sold Per SKU
Export sales data from the selling platform for the period being analyzed. Monthly is the minimum useful window. Quarterly provides better signal because it smooths out promotional spikes.
Step 2: Assign Direct Costs Per Unit
For each SKU, document the landed COGS (product cost plus inbound shipping, duties, and packaging). If the brand sources from multiple suppliers, use the weighted average cost.
Step 3: Add Variable Costs Per Unit
Pull fulfillment fees, marketplace fees, and payment processing charges. Most platforms provide this data at the transaction level. For FBA sellers, the Amazon Fee Preview report breaks this out by ASIN.
Step 4: Allocate Advertising Spend by SKU
This is where most analyses fall apart. Ad platforms report at the campaign or ad group level, not always at the SKU level. Founders need to map ad spend to individual products, either through campaign structure (one campaign per SKU) or by using platform-level attribution reports.
For brands running broad campaigns, a reasonable approach is to allocate ad spend proportionally based on attributed revenue per SKU within that campaign.
Step 5: Factor in Returns
Apply the return rate for each product to adjust both revenue and cost. The formula:
Adjusted Revenue = Gross Revenue x (1 - Return Rate)
Return Cost = (Units Returned x Reverse Logistics Cost per Unit) + Inventory Write-Down
Step 6: Calculate True Margin Per SKU
With all five cost layers applied, the final calculation looks like this:
True Profit per Unit = Sale Price - COGS - Fulfillment - Fees - Ad Cost per Unit - Return Cost per Unit
True Margin % = True Profit per Unit / Sale Price x 100
A healthy ecommerce product should land somewhere between 15% and 30% true margin after all costs. Products below 10% deserve scrutiny. Products below 5% are likely losing money once overhead is included.
What to Do With the Results
Running the analysis is step one. Acting on it is where the value compounds. Here are the four most common outcomes.
Raise Prices on Hidden Losers
Some products carry strong demand but weak margins because the price was set before all costs were understood. A $2 to $5 price increase on a product with steady demand and low price sensitivity can move it from breakeven to profitable without affecting volume.
Cut Ad Spend on Low-Margin SKUs
If a product only makes money when acquired organically, stop paying to acquire customers for it. Redirect that ad budget to higher-margin products that can absorb the acquisition cost and still generate profit.
Renegotiate Supplier Costs for Top Sellers
Products with high volume and thin margins are candidates for supplier negotiation. A $1.50 reduction in COGS on a product selling 2,000 units per month is $3,000 in monthly margin improvement, or $36,000 annually.
Retire or Sunset Low Performers
Some SKUs do not deserve optimization. They deserve retirement. Products with low volume, low margin, high return rates, and high support cost drain attention from the catalog items that actually drive contribution margin. Cutting them simplifies operations and frees up working capital tied to slow-moving inventory.
Ecommerce Profit Margins by Category
Understanding where a product sits relative to category benchmarks helps contextualize the results. These are rough ranges for true margin (after all costs, not just gross margin):
- Consumables and supplements: 20% to 35%
- Beauty and personal care: 15% to 30%
- Home and kitchen: 12% to 25%
- Apparel and accessories: 8% to 20% (high return rates compress margins)
- Electronics and gadgets: 5% to 15%
- Pet products: 15% to 28%
Products falling below the low end of their category range warrant immediate investigation. Products above the high end may be under-invested in growth.
Common Mistakes in Product Profitability Analysis
Ignoring Returns Entirely
Many ecommerce bookkeeping setups track returns as a line item on the P&L but never tie them back to individual SKUs. This makes the overall return rate visible but hides which products are driving it.
Using Gross Margin as the Decision Metric
A 60% gross margin means nothing if fulfillment, fees, and ads eat 50 points. Gross profit margin is a starting point, not a decision tool. True margin, after all variable costs, is what determines whether a product should be scaled or shelved.
Running the Analysis Once
Product profitability is not a one-time exercise. Costs change. Supplier pricing shifts. Ad costs fluctuate seasonally. Return rates spike after quality issues. Founders who run this analysis quarterly catch margin erosion before it becomes a cash flow problem. Those who run the numbers once tend to discover the damage months too late.
Forgetting Overhead Allocation
Variable costs tell most of the story, but overhead matters too. Warehouse rent, software subscriptions, team salaries, and other fixed costs need to be spread across the product catalog. The simplest approach is to allocate overhead proportionally by revenue or units sold, then verify that total product-level profit exceeds total overhead.
From Spreadsheet to System
Building a product profitability calculator in a spreadsheet works at small scale. With 10 to 20 SKUs, it is manageable. With 200 SKUs across multiple channels, spreadsheets become fragile and outdated within days of being built.
The shift from manual analysis to automated tracking is where real unit economics visibility begins. Instead of running the numbers once a quarter, founders can see margin shifts in real time and make decisions before small problems become big ones.
Futureproof automates this process by connecting sales, costs, and fees into a single view, so ecommerce founders can see exactly which products make money and which ones are quietly burning cash. Join the Futureproof ecommerce waitlist and stop guessing which SKUs deserve your next dollar of ad spend.
