Product profitability analysis helps online sellers understand how much money each product earns after accounting for its costs. Although strong sales can look impressive, high revenue doesn’t always translate into healthy profits.
Imagine selling a cosmetic jar for $10. The product costs $4, leaving an apparent profit of $6.
At first glance, that sounds attractive. However, marketplace fees, advertising, packaging, and fulfillment can quickly reduce your earnings.
As a result, the product may contribute much less than expected.
For ecommerce businesses, understanding these expenses is essential. Not only does it support better pricing, but it also helps sellers decide which products deserve more investment.
In this guide, you’ll learn how to calculate product margins, compare profitability, and evaluate products using practical examples.
What Is Product Profitability Analysis?
Product profitability analysis measures the financial performance of individual products by comparing their revenue with relevant costs.
Rather than looking only at sales figures, this approach examines how much money remains after accounting for the expenses associated with each sale.
For example, two products may generate identical revenue but have very different margins.
One might require expensive packaging, while another relies heavily on paid advertising.
Consequently, their contribution to the business can differ significantly.
By reviewing these differences, sellers can make more informed purchasing and pricing decisions.
Why Product Profitability Matters
Revenue shows how much customers spend. However, it doesn’t reveal how much the business keeps.
For that reason, profitability analysis supports several important decisions.
Identify Products With Better Margins
Some products generate more contribution per sale than others.
By comparing their margins, businesses can identify products that may support stronger financial performance.
Nevertheless, margin percentage shouldn’t be the only consideration. Sales volume also affects total earnings.
Improve Pricing Decisions
A profitable selling price must account for more than the supplier’s quotation.
For instance, marketplace commissions and fulfillment expenses may consume a significant share of revenue.
Therefore, sellers should include these costs when evaluating prices.
Evaluate Advertising Performance
Advertising can increase product visibility and generate additional orders.
However, higher sales don’t automatically create higher profits.
If advertising costs rise too quickly, the remaining contribution may become very small.
Support Inventory Planning
Products with reliable demand and healthy margins may deserve additional purchasing attention.
Even so, sellers should review inventory turnover and available capital before increasing stock.
Product Profitability Analysis Formula
A useful starting point is contribution per unit.
Contribution per Unit = Net Sales Revenue per Unit − Variable Costs per Unit
Variable costs may include product acquisition costs, marketplace fees, packaging, fulfillment, and advertising expenses that vary with sales.
Next, calculate the contribution margin:
Contribution Margin (%) = (Contribution per Unit ÷ Net Sales Revenue per Unit) × 100
This percentage shows how much revenue remains after variable costs.
However, contribution margin isn’t the same as net profit margin.
Fixed operating expenses still need consideration before calculating overall business profit.
How to Calculate Product Profitability
Let’s examine a hypothetical ecommerce product.
Suppose a seller offers a cosmetic jar for $10.
Step 1: Identify Net Sales Revenue
Start with the revenue the business earns from each sale.
For this example, assume net sales revenue is $10 per unit.
In practice, discounts, refunds, and applicable sales taxes may affect this figure.
Step 2: Record Product Costs
The cosmetic jar has a landed cost of $4.
This amount represents its applicable inventory acquisition cost.
Step 3: Include Marketplace Fees
Suppose the marketplace charges $1.20 per sale.
Because this fee reduces earnings, it belongs in the contribution calculation.
Step 4: Add Fulfillment Expenses
Packaging and fulfillment cost another $1 per order.
At this point, the combined product, marketplace, and fulfillment expenses reach $6.20.
Step 5: Account for Advertising
Assume advertising costs average $1 per unit sold.
Although actual advertising expenses may vary, this estimate provides a starting point.
Step 6: Calculate Contribution
Now, combine the figures.
| Component | Amount |
|---|---|
| Net Sales Revenue | $10.00 |
| Landed Cost | $4.00 |
| Marketplace Fees | $1.20 |
| Packaging and Fulfillment | $1.00 |
| Advertising | $1.00 |
| Contribution per Unit | $2.80 |
The calculation is:
$10.00 − $4.00 − $1.20 − $1.00 − $1.00 = $2.80
Next, calculate the contribution margin:
($2.80 ÷ $10.00) × 100 = 28%
Therefore, the product generates a 28% contribution margin under these assumptions.
However, the business must still cover its fixed operating expenses.
Gross Margin vs. Contribution Margin vs. Net Margin
Although these measurements relate to profitability, they answer different questions.
Gross Margin
Gross margin compares net revenue with the cost of goods sold.
Use this formula:
Gross Margin = (Net Revenue − COGS) ÷ Net Revenue × 100
For example, a product sells for $10 and has a cost of goods sold of $4.
Its gross margin is:
($10 − $4) ÷ $10 × 100 = 60%
However, this calculation doesn’t include ordinary selling expenses.
Contribution Margin
Contribution margin deducts variable costs from revenue.
As a result, it helps businesses understand how much each sale contributes toward fixed expenses and profit.
For ecommerce sellers, these variable costs often include marketplace fees and order fulfillment expenses.
Net Profit Margin
Net profit margin considers all relevant expenses, including fixed operating costs.
However, calculating net profit for an individual product may require allocating shared expenses.
Therefore, businesses should apply consistent allocation methods when comparing products.
How to Compare Product Margins
Comparing products becomes easier when you use the same cost categories.
Consider three hypothetical products.
| Metric | Product A | Product B | Product C |
|---|---|---|---|
| Net Selling Price | $10.00 | $15.00 | $8.00 |
| Variable Costs | $7.00 | $12.00 | $5.20 |
| Contribution per Unit | $3.00 | $3.00 | $2.80 |
| Contribution Margin | 30% | 20% | 35% |
Product C has the highest contribution margin percentage.
Meanwhile, Products A and B generate more contribution per unit.
Neither result automatically identifies the best product.
Instead, businesses should consider expected sales volume, inventory requirements, and purchasing costs.
Why Sales Volume Matters
A product with a lower margin can sometimes generate more total contribution.
To evaluate this, use:
Total Contribution = Contribution per Unit × Units Sold
Suppose Product A generates $3 per unit and sells 500 units.
Its total contribution is:
$3 × 500 = $1,500
Meanwhile, Product C generates $2.80 per unit and sells 800 units.
Its total contribution becomes:
$2.80 × 800 = $2,240
Despite earning less per unit, Product C generates more total contribution.
Therefore, sellers should evaluate both margins and sales volume.
However, this comparison assumes unit economics remain stable across the quantities shown.
How Advertising Changes Profitability
Advertising can influence product margins significantly.
For example, suppose a product generates $10 in revenue and incurs $6 in variable costs before advertising.
Its contribution before advertising is:
$10 − $6 = $4
If advertising costs $2 per sale, the remaining contribution becomes:
$4 − $2 = $2
However, increasing advertising costs to $4.50 per sale changes the result.
The new contribution is:
$4 − $4.50 = −$0.50
In this situation, each attributed sale generates a negative contribution under the assumptions used.
Consequently, higher advertising spending may increase revenue without improving profitability.
For this reason, businesses should monitor advertising costs alongside product margins.
Calculate Break-Even Sales Volume
Contribution analysis also helps estimate how many units a business must sell to cover relevant fixed costs.
Use this formula:
Break-Even Units = Fixed Costs ÷ Contribution per Unit
Suppose a product line has $1,200 in monthly fixed costs.
Each unit generates $3 in contribution.
The calculation is:
$1,200 ÷ $3 = 400 units
Therefore, the product line needs to sell 400 units to cover those fixed costs under the stated assumptions.
However, businesses selling multiple products may need a more detailed break-even model.
How Returns and Discounts Affect Margins
Returns and promotional discounts can reduce product profitability.
For example, a discount lowers the revenue collected from each sale.
Meanwhile, a returned order may create additional shipping or handling expenses.
The financial impact also depends on whether the business can resell the returned product.
Therefore, sellers should review historical return patterns when estimating profitability.
When reliable data isn’t available, conservative assumptions can help prevent overly optimistic forecasts.
Product Profitability Analysis Template
A spreadsheet provides a practical way to compare product performance.
For consistent reporting, record the following information.
| Column | Information |
|---|---|
| SKU | Unique product identifier |
| Product Name | Product description |
| Net Selling Price | Revenue per unit |
| Landed Cost | Inventory acquisition cost |
| Marketplace Fees | Fees per sale |
| Fulfillment Cost | Packaging and delivery expenses |
| Advertising Cost | Attributable advertising expense |
| Other Variable Costs | Additional costs linked to sales |
| Contribution per Unit | Revenue minus variable costs |
| Contribution Margin | Contribution percentage |
| Units Sold | Sales quantity |
| Total Contribution | Contribution multiplied by units sold |
In addition, include the reporting period and data source.
This makes comparisons easier when prices or expenses change.
Calculate Product Margins in Excel
Excel can automate contribution calculations.
Suppose you enter the following values:
| Cell | Description | Value |
|---|---|---|
| B2 | Net Selling Price | 10.00 |
| B3 | Landed Cost | 4.00 |
| B4 | Marketplace Fees | 1.20 |
| B5 | Fulfillment Cost | 1.00 |
| B6 | Advertising Cost | 1.00 |
First, calculate contribution per unit:
=B2-SUM(B3:B6)
The result is $2.80.
Next, calculate contribution margin:
=(B2-SUM(B3:B6))/B2
After formatting the cell as a percentage, Excel displays 28%.
For a larger product catalog, you can repeat these calculations across multiple SKUs.
Additionally, consider adding columns for returns, discounts, and sales volume.
Common Profitability Analysis Mistakes
Even simple calculations can produce misleading results when important costs are missing.
Ignoring Marketplace Fees
Marketplace commissions and transaction charges reduce earnings.
Therefore, include all relevant fees in your calculations.
Using Supplier Prices Instead of Landed Costs
Supplier quotations may exclude freight and import charges.
As a result, using only the purchase price can overstate margins.
Focusing Only on Margin Percentage
A high margin percentage doesn’t always produce the highest total contribution.
Instead, compare margins with expected sales volume.
Overlooking Advertising Expenses
Paid advertising may generate additional sales while reducing contribution.
Therefore, review advertising expenses whenever reliable product-level data is available.
Ignoring Returns
Returned orders may reduce realized revenue and create extra expenses.
Consequently, historical return data can improve profitability estimates.
Confusing Contribution With Net Profit
Contribution margin excludes fixed operating expenses.
For that reason, a positive contribution doesn’t automatically mean the business earns a net profit.
Best Practices for Evaluating Product Profitability
Effective product profitability analysis begins with accurate and consistent cost records.
Start by recording the actual landed cost of each product.
Next, identify marketplace fees, fulfillment expenses, and other variable costs.
Where reliable data exists, allocate advertising expenses using a consistent method.
After calculating contribution margins, compare the results with sales volume.
In addition, review inventory turnover before making purchasing decisions.
A product may generate a healthy margin but still tie up capital if it sells slowly.
Finally, update your calculations whenever supplier prices, shipping charges, or marketplace fees change.
By reviewing these figures regularly, businesses can identify products that support sustainable profitability.
Final Thoughts
Reliable product profitability analysis helps ecommerce sellers look beyond revenue and understand how individual products perform financially.
Although strong sales are encouraging, profitability depends on the costs associated with each order.
Therefore, businesses should calculate landed costs, marketplace fees, fulfillment expenses, and advertising costs before evaluating product margins.
At the same time, sales volume and inventory requirements deserve attention.
By combining accurate cost data with regular performance reviews, sellers can make better pricing and purchasing decisions.
A successful product doesn’t simply generate sales. It contributes enough value to support the business after accounting for the costs of selling it.