Your Best-Selling Product May Not Be Your Most Profitable One. Here’s How to Find Out

SKU profitability analysis

Your bestseller sells 5,000 units a month.

It gets the biggest marketing budget. It appears first on your website. Your team talks about it in every performance review.

Naturally, it feels like your most valuable product.

But what if another SKU selling half as much is actually generating more profit?

This is where SKU profitability analysis changes the way a D2C business looks at growth.

Revenue tells you what customers are buying. Profitability tells you what the business is actually earning after product cost, discounts, marketplace commissions, shipping, payment charges, advertising, returns and RTO are taken into account.

For D2C founders and e-commerce finance teams, this distinction is critical.

A ₹1 crore monthly sales number can look impressive while individual products quietly lose money. High-return SKUs may inflate gross sales. COD-heavy products may generate significant COD return cost. Marketplace commissions can make the same product profitable on your website but unattractive on another channel.

So the better management question is not:

“Which product sells the most?”

It is:

“Which product leaves the most money after we actually deliver it?”

That is the purpose of Financial Analytics, a decision-ready Business Dashboard, strong MIS Reporting Services, and finance-led CFO Advisory Services.

Most e-commerce dashboards naturally rank products by:

  • Units sold
  • Gross merchandise value
  • Revenue
  • Orders
  • Conversion rate

Those numbers matter.

But none of them automatically tells you whether the SKU is financially attractive.

Suppose Product A sells for ₹1,500 and Product B sells for ₹1,200.

Product A generates twice the revenue.

But Product A also has:

  • Higher COGS
  • A deeper discount
  • More paid-media dependence
  • Higher shipping costs
  • A 25% return/RTO rate
  • Higher marketplace commissions

Product B, meanwhile, sells mostly through organic and repeat customers with fewer returns.

Your bestseller may therefore create the largest top line while Product B creates more actual contribution.

That is the difference between a sales report and SKU profitability analysis.

Interest: E-Commerce Growth Can Hide Expensive Product-Level Leakage

India’s D2C sector continues to grow quickly. Unicommerce’s FY2026 analysis, based on more than 410 million shipments across 6,000+ brands, reported approximately 33% growth in D2C GMV, driven primarily by higher order volumes rather than higher pricing.

But more sales do not automatically mean more profitable sales.

The same dataset found that 58% of COD orders during the festive peak were returned, illustrating how drastically delivery behaviour can alter the economics of certain product and customer cohorts.

Returns are not only an Indian COD issue. The National Retail Federation estimated that 19.3% of online sales would be returned in 2025, with total retail returns approaching $849.9 billion.

There is another reason SKU-level analysis matters: complexity itself can destroy margin. In one consumer-goods example studied by McKinsey, a company reduced SKU count by 25% after analysing the real value and cost of its assortment. Gross margins subsequently improved by 2 to 4 percentage points.

The message for D2C founders is straightforward:

A product can be popular and still be economically inefficient.

Revenue alone cannot reveal that.

The SCQA Framework: Why Your Bestseller Can Mislead You

Situation

Your business tracks product revenue and knows which SKUs sell fastest.

Complication

Every product has a different cost structure.

Some require more advertising.

Some attract larger discounts.

Some are heavier to ship.

Some have higher COD exposure.

Some generate more customer returns.

Some sell on marketplaces where commissions reduce margins.

Question

How do you determine which products genuinely create profit?

Answer

Calculate profitability at individual SKU level using net realised revenue minus every variable cost required to sell and fulfil that SKU.

Then rank products by:

  • Contribution profit
  • Contribution margin %
  • Profit per order
  • Return/RTO-adjusted margin
    SKU profitability analysis


Desire: What SKU Profitability Analysis Should Reveal

A useful SKU profitability analysis should help answer:

  • Which product generates the highest contribution?
  • Which bestseller generates surprisingly little profit?
  • Which SKU becomes unprofitable after advertising?
  • Which products have the highest return rates?
  • Which products have the highest COD return cost?
  • Which marketplace is profitable for each SKU?
  • Which SKU should receive more marketing budget?
  • Which SKU needs a price increase?
  • Which product should be bundled instead of sold individually?
  • Which SKU should potentially be discontinued?

This takes your finance function from reporting the past to helping management decide what to do next.

Gross Margin Is Not SKU Profitability

This is one of the most common mistakes.

Suppose a product sells for ₹2,000.

Its manufacturing or landed cost is ₹700.

You may calculate:

Gross Profit = ₹1,300

Gross Margin = 65%

That looks excellent.

But now add:

  • Seller-funded discount: ₹200
  • Shipping: ₹120
  • Packaging: ₹40
  • Payment gateway/COD fee: ₹40
  • Marketplace commission: ₹180
  • Average return/RTO cost allocation: ₹100
  • Advertising cost per order: ₹450

Your actual contribution becomes dramatically smaller.

Gross margin answers:

“What remains after product cost?”

SKU profitability answers:

“What remains after selling this product?”

That difference is central to understanding ecommerce unit economics.

A Bestseller vs a More Profitable SKU: A Simple Example

Consider two products.

Metric SKU A — Bestseller SKU B
Gross sales ₹12,00,000 ₹6,00,000
Discounts ₹1,50,000 ₹30,000
Returns/RTO impact on revenue ₹1,20,000 ₹20,000
Net realised revenue ₹9,30,000 ₹5,50,000
COGS ₹3,20,000 ₹1,50,000
Marketplace commission ₹90,000 ₹35,000
Shipping & fulfilment ₹80,000 ₹30,000
Payment/COD charges ₹20,000 ₹10,000
Advertising ₹2,50,000 ₹80,000
RTO/reverse logistics ₹40,000 ₹10,000
Contribution profit ₹1,30,000 ₹2,35,000
Contribution margin 14.0% 42.7%

SKU A generated twice the gross sales.

But SKU B generated approximately ₹1.05 lakh more contribution profit.

If management looks only at revenue:

SKU A wins.

If management looks at profitability:

SKU B wins comfortably.

That is why every serious D2C finance function should maintain both:

Revenue Ranking

and

Contribution Profit Ranking

How to Calculate SKU Level Profitability for an Ecommerce Business

Here is a practical framework founders can implement.

Step 1: Start With Gross Product Sales

Calculate actual product-level sales from:

  • Your website
  • Marketplaces
  • Social-commerce channels
  • Offline channels where relevant

Keep units and revenue separately.

Do not confuse orders created with successfully completed sales.

Step 2: Deduct Discounts and Credit Notes

Track seller-funded discounts at SKU level.

This may include:

  • Coupon codes
  • Promotional discounts
  • Bundle discounts
  • Sale-event pricing
  • Credit notes

Marketplace-funded promotions should be distinguished from discounts actually borne by your business.

Your Accounting Services India provider should ensure promotional revenue and deductions reconcile with marketplace settlement statements.

Step 3: Adjust for Returns and RTO

Returns can completely change product economics.

Track separately:

  • Customer returns after delivery
  • RTO
  • Refunds
  • Exchanges
  • Damaged returns
  • Non-resaleable inventory

A SKU with 10% higher sales but double the return rate may be far less attractive than it looks.

For COD-heavy businesses, good RTO accounting should also allocate:

  • Forward freight
  • Reverse freight
  • Packaging loss
  • Reprocessing
  • Advertising associated with failed orders

Step 4: Calculate Accurate COGS

COGS should reflect the genuine product cost.

Depending on your business, this may include:

  • Manufacturing cost
  • Purchase cost
  • Import duty
  • Inward freight
  • Processing
  • Product packaging
  • Other landed costs

Do not use outdated standard costs if actual landed cost has changed significantly.

Poor cost data produces poor Financial Analytics.

Step 5: Add Marketplace Commission

The same SKU may have completely different economics across channels.

Suppose your product generates:

₹500 contribution on your website

but only:

₹220 on a marketplace

after commission, fulfilment fees and marketplace advertising.

You should therefore analyse:

SKU × Channel

not SKU alone.

McKinsey has similarly highlighted that online assortment decisions should consider whether individual products can actually be profitable online once channel-specific economics are taken into account.

Step 6: Add Shipping and Fulfilment

Allocate:

  • Forward freight
  • Warehousing
  • Pick-and-pack
  • Packaging
  • COD fees
  • Shipping-zone surcharges

Heavy, fragile or oversized products may have very different fulfilment economics despite similar selling prices.

Step 7: Allocate Payment Charges

Include:

  • Payment gateway fees
  • COD collection fees
  • Marketplace payment deductions
  • Applicable transaction charges

They may appear small individually but can materially affect low-ticket SKUs.

Step 8: Allocate Advertising Spend

This is often the hardest part.

Where campaigns are product-specific, allocate ad spend directly.

Where advertising supports multiple products, use a consistent allocation method based on factors such as:

  • Product-specific attributed sales
  • Landing-page sessions
  • Orders
  • New-customer revenue

The goal is not theoretical perfection.

The goal is a management view accurate enough to make better decisions.

Step 9: Calculate Contribution

A simplified formula is:

SKU Contribution = Net Realised Revenue − COGS − Selling Costs − Fulfilment Costs − Returns/RTO Costs − Allocated Marketing

Then calculate:

Contribution Margin % = SKU Contribution ÷ Net Realised Revenue × 100

This becomes one of the most useful measures of D2C profitability.

Use Two Levels of Contribution Margin

A useful management structure is:

Contribution Margin 1

Net Sales − COGS − Marketplace Fees − Payment Charges − Shipping − Returns/RTO

This tells you whether the basic transaction is commercially attractive before advertising.

Contribution Margin 2

Contribution Margin 1 − Marketing Cost

This tells you what remains after customer acquisition.

If CM1 is weak:

You probably have a pricing, product-cost, channel or logistics problem.

If CM1 is strong but CM2 is weak:

Your marketing economics may be the problem.

That distinction helps teams fix the right thing.

Your Business Dashboard Should Show Revenue and Profit Side by Side

A strong Business Dashboard should not display only GMV and ROAS.

At SKU level, show:

  • Units sold
  • Gross revenue
  • Net realised revenue
  • Discount %
  • COGS
  • Gross margin %
  • Return %
  • RTO %
  • COD return cost
  • Marketplace fees
  • Shipping cost
  • Ad spend
  • Contribution profit
  • Contribution margin %
  • Inventory days
  • Stock cover

Most importantly, include:

Revenue Rank vs Profit Rank

This one view can completely change management conversations.

Why Your Bestseller Might Still Be Worth Keeping

Finding a low-margin bestseller does not mean you should immediately stop selling it.

A SKU may have strategic value.

It might:

  • Acquire first-time customers
  • Increase brand awareness
  • Drive repeat purchases
  • Lead customers to higher-margin products
  • Improve cart size
  • Support subscriptions
  • Strengthen marketplace ranking

This is why CFO Advisory Services should combine numbers with commercial context.

The correct question may be:

“Is this SKU unprofitable—or is it deliberately acting as an acquisition product?”

If a low-margin hero product brings customers who later purchase high-margin products, its economics should also be examined at cohort level.

But that strategy should be intentional.

“It’s our bestseller” is not enough.

What to Do With an Unprofitable Bestseller

Once you identify the issue, there are many options before discontinuing the SKU.

Increase Price

Even a small price adjustment can significantly improve contribution.

Reduce Discounts

Analyse whether customers genuinely require the current promotional depth.

Negotiate COGS

Higher-volume hero SKUs may provide stronger supplier negotiation leverage.

Move Customers Toward Prepaid

If COD return cost is the problem, offer financially sensible prepaid incentives.

Change Packaging

Reducing weight or dimensions may lower shipping costs.

Bundle the SKU

Combining a low-ticket item with a higher-margin product can improve order economics.

Reduce Paid Acquisition Dependence

Use retention, email, WhatsApp, organic content and repeat-purchase campaigns to improve blended acquisition costs.

Change Channel Strategy

A SKU may belong on your own website but not on a high-commission marketplace—or vice versa.

Why Bookkeeping Quality Matters

SKU profitability cannot be calculated properly when finance data is messy.

Good Bookkeeping Services India should preserve enough detail to connect:

Order → SKU → Channel → Settlement → Fees → Return → Payment → Accounting Entry

Your finance stack may include:

  • Shopify or another storefront
  • Amazon/Flipkart/other marketplaces
  • OMS
  • WMS
  • Courier aggregators
  • Payment gateways
  • Meta/Google advertising
  • Accounting software

If each system has a different product name or SKU code, profitability analysis quickly becomes unreliable.

Your Accounting Services India team should maintain a clean SKU master and reconcile these systems regularly.

MIS Reporting Services: Make This a Monthly Management Habit

A one-time profitability study is useful.

Monthly MIS Reporting Services are far more powerful.

Every month, management should review:

Top 10 Revenue SKUs

Which products are driving sales?

Top 10 Contribution SKUs

Which products are driving money?

Bottom 10 Margin SKUs

Which products need attention?

Highest Return/RTO SKUs

Which products are creating reverse-logistics leakage?

Fastest-Improving SKUs

Which actions are working?

Inventory vs Profitability

Are you holding large amounts of stock in low-margin products?

McKinsey has documented cases where rationalising unnecessary product complexity improved margins, reduced cost and freed operational capacity.

This is exactly the type of decision good MIS should enable.

What CFO Advisory Services Should Tell a Founder

A CFO should not simply say:

“Your gross margin is 52%.”

That company-wide average can hide enormous differences.

Useful CFO Advisory Services should be able to say:

“SKU A generates 28% of revenue but only 9% of contribution profit because discounting, paid acquisition and RTO are high.”

And:

“SKU B generates only 14% of revenue but 24% of contribution. Increasing its marketing budget may produce more profitable growth.”

That changes the conversation from accounting to capital allocation.

Should you spend another ₹10 lakh promoting the bestseller?

Or should you move part of that budget toward a smaller but more profitable SKU?

That is the type of question Financial Analytics should answer.

SKU profitability analysis

Action: Run This SKU Profitability Review Every Month

Use this checklist:

  1. Export SKU-level orders.
  2. Remove cancelled orders.
  3. Reconcile successful deliveries.
  4. Adjust for discounts and returns.
  5. Allocate accurate COGS.
  6. Add marketplace commissions.
  7. Add payment charges.
  8. Add forward shipping.
  9. Add COD return cost and reverse logistics.
  10. Allocate marketing.
  11. Calculate contribution profit.
  12. Calculate contribution margin %.
  13. Rank SKUs by revenue.
  14. Rank them again by profit.
  15. Investigate every major difference.

Do this monthly and you will begin managing your catalogue very differently.

Bonus How-To: Transitioning Your Home to Renewable Energy

This section is separate from e-commerce profitability, but the same financial principle applies: evaluate the complete economics rather than only the headline benefit.

Step 1: Review Electricity Usage

Analyse around 12 months of electricity bills to understand your consumption pattern.

Step 2: Assess Your Rooftop

Review:

  • Shadow-free area
  • Structural suitability
  • Sunlight exposure
  • Ownership or society permissions

Step 3: Estimate Solar Capacity

Choose system capacity based on actual household consumption and usable rooftop area.

Step 4: Compare the Complete Economics

Consider:

  • Upfront installation cost
  • Expected annual generation
  • Warranty
  • Maintenance
  • Electricity savings
  • Estimated payback period

Step 5: Follow the Official Process

Residential consumers can use the Government of India’s rooftop-solar framework and relevant DISCOM process. The Ministry of New and Renewable Energy directs consumers to the PM Surya Ghar portal for rooftop-solar installation information.

Step 6: Compare Vendors

Do not choose only on quoted price. Compare system specifications, warranties, projected generation and after-sales support.

Step 7: Monitor Actual Savings

Once installed, compare actual monthly solar generation with projected output and electricity-bill savings.

Electricity Usage → Roof Assessment → System Size → Installation → Solar Generation → Monthly Savings → Payback

Key Takeaways

Your bestseller gives you revenue.

It does not automatically give you the most profit.

A meaningful SKU profitability analysis should account for:

  • COGS
  • Discounts
  • Marketplace commission
  • Shipping
  • Payment fees
  • Advertising
  • Customer returns
  • RTO
  • COD return cost

Only after these costs are connected to individual products can you properly understand ecommerce unit economics and D2C profitability.

For founders, the biggest shift is simple:

Stop asking only:

“What are our top-selling products?”

Start asking:

“What are our top contribution-generating products?”

Strong Bookkeeping Services India and Accounting Services India create the underlying data.

MIS Reporting Services organise it.

A Business Dashboard makes it visible.

Financial Analytics explains it.

And CFO Advisory Services help management decide what to price differently, promote more aggressively, bundle, renegotiate—or stop selling altogether.

Because scaling a ₹10 lakh bestseller that leaves ₹1 lakh of contribution may be far less valuable than scaling a ₹6 lakh product that leaves ₹2.5 lakh.

If you ranked every product in your catalogue by contribution profit instead of revenue today, would the same SKU still be your number-one product?

Frequently Asked Questions

1. What is SKU profitability analysis?

SKU profitability analysis measures the financial contribution generated by each individual product after accounting for its revenue and relevant costs. These may include COGS, discounts, commissions, shipping, payment fees, advertising, customer returns and RTO expenses. It gives management a clearer view than simply ranking products by sales.

2. How do I calculate SKU-level profitability for an e-commerce business?

Start with net realised revenue for the SKU, then subtract COGS, seller-funded discounts, marketplace fees, payment charges, fulfilment, shipping, returns, RTO costs and allocated marketing spend. The remaining amount is the SKU’s contribution profit. Divide contribution profit by net realised revenue to calculate its contribution margin percentage.

3. Why can my best-selling SKU be less profitable than a lower-selling product?

A bestseller may require deeper discounts, higher advertising spend, more expensive shipping or marketplace commissions. It may also have higher customer-return or RTO rates. A lower-volume product with stronger margins, more organic demand and fewer returns can therefore generate more contribution profit despite producing less revenue.

4. Should RTO and customer returns be included in SKU profitability?

Yes. They are particularly important for Indian D2C businesses. RTO accounting should capture forward and reverse freight, packaging loss, handling, advertising associated with failed orders and any inventory damage. Customer returns should also be reflected in realised revenue and product-level cost calculations.

5. How can Financial Analytics and CFO Advisory Services improve SKU profitability?

Financial Analytics can identify differences between revenue rank and profit rank, highlight high-return or high-RTO products and compare profitability by SKU and channel. CFO Advisory Services can then help management decide whether to change pricing, discounts, marketing spend, marketplace strategy, packaging, procurement costs or product assortment to improve overall profitability.