SKU-Level Profitability Analysis for Marketplace Sellers

SKU-level profitability analysis shows whether each individual marketplace product is generating real contribution profit after selling fees, fulfilment costs, advertising, discounts, returns, taxes on services, packaging, product cost, and operational losses.

Marketplace revenue alone can be misleading. A product may generate strong gross sales while losing money because of a high referral fee, oversized shipping slab, heavy ad spending, frequent returns, damaged inventory, seller-funded discounts, low selling price, or incorrect cost allocation.

This guide explains how Amazon, Flipkart, Meesho, Myntra, AJIO, JioMart, ONDC, and multi-marketplace sellers can build a practical SKU profitability model without assuming one universal fee rate. Marketplace charges change by category, price band, fulfilment channel, package size, weight, service, promotion, and commercial agreement. Always use the current seller portal rate card and transaction-level settlement reports.

What Is SKU-Level Profitability?

A SKU is a seller-defined stock keeping unit used to identify a specific product or variant. Different colours, sizes, pack quantities, materials, or models should normally have separate SKUs when their costs, price, returns, inventory, or conversion can differ.

SKU-level profitability calculates the financial result of each sellable SKU rather than evaluating only the brand, account, marketplace, or category total.

It helps answer:

• Which products generate contribution profit?
• Which high-sales products are actually loss-making?
• Which variants have high return or cancellation losses?
• Which fulfilment channel is more profitable?
• How much advertising can each SKU afford?
• What is the minimum profitable selling price?
• Which SKUs should receive more inventory?
• Which products should be repriced, bundled, redesigned, or discontinued?

Revenue Is Not Profit

Metric	Meaning	Main limitation
Gross merchandise value	Total order value before many adjustments	Does not represent seller earnings
Gross sales	Value of products ordered or shipped	May include cancelled or returned orders
Net sales	Sales after selected discounts, cancellations, or refunds	Definition can vary between reports
Settlement	Amount transferred after marketplace additions and deductions	May include adjustments relating to other periods
Gross profit	Revenue minus product cost	Ignores marketplace and fulfilment expenses
Contribution profit	Revenue remaining after variable costs	Requires complete and accurate cost data
Net profit	Profit after variable and allocated fixed costs	Can be distorted by arbitrary overhead allocation

Recommended Profitability Levels

Level 1: Order Contribution

Measures the contribution from one order after order-level variable expenses.

Level 2: SKU Contribution

Aggregates all sales, fees, advertisements, returns, and costs for one SKU over a selected period.

Level 3: Marketplace Contribution

Combines all SKUs sold on one marketplace and adds account-level charges.

Level 4: Business Operating Profit

Adds salaries, software, rent, professional fees, finance expenses, and other fixed or semi-fixed costs.

Start with contribution profit because it is usually the clearest metric for pricing, advertising, and assortment decisions.

Core SKU Profitability Formula

SKU Contribution Profit = Net Product Revenue - Marketplace Fees - Fulfilment and Logistics Cost - Advertising Cost - Product Cost - Packaging Cost - Return and Cancellation Loss - Other Variable Cost

Contribution Margin Percentage

Contribution Margin Percentage = SKU Contribution Profit / Net Product Revenue x 100

Profit per Delivered Unit

Profit per Delivered Unit = Total SKU Contribution Profit / Delivered Units

Profit per Ordered Unit

Profit per Ordered Unit = Total SKU Contribution Profit / Ordered Units

Profit per ordered unit is useful when cancellation and return behaviour differs significantly by SKU.

Data Required for SKU Profitability

Data source	Required fields
Order report	Order ID, order date, SKU, quantity, selling price, discount, status
Settlement report	Transaction ID, fee type, fee amount, tax, refund, recovery, payout
Advertising report	SKU or ASIN, spend, sales, orders, clicks, campaign
Return report	SKU, return reason, reverse cost, condition, recoverable inventory
Inventory report	Opening stock, received units, sold units, returned units, damaged units
Product cost master	Purchase or manufacturing cost, inward freight, duties, conversion cost
Packaging master	Box, bag, label, tape, insert, protective material, labour
Marketplace rate card	Current category, price-band, fulfilment, shipping, storage, and service charges
Finance records	Fee invoices, tax records, TCS, TDS, credits, claims, and bank receipts

Build a Reliable SKU Master

Create one central master table with:

• Internal SKU
• Marketplace SKU
• ASIN, FSN, style ID, listing ID, or platform identifier
• Parent product
• Brand
• Category and subcategory
• Colour, size, pack quantity, and model
• HSN or tax classification
• Product cost
• Packaging cost
• Actual weight
• Volumetric weight
• Package dimensions
• Fulfilment channel
• Default selling price
• Minimum profitable price
• Target contribution margin

Do not combine different variants only because they share one product page. Their selling price, product cost, return rate, and logistics slab may differ.

Marketplace Fee Components

1. Referral or Commission Fee

This is commonly based on category, selling price, product type, or commercial agreement. Some marketplaces may use zero-commission structures for selected categories or price bands while charging other service or logistics costs.

2. Closing, Fixed, or Per-Order Fee

A fixed fee can have a large impact on low-priced products. Evaluate the fee as a percentage of selling price.

3. Shipping or Weight-Handling Fee

Shipping can depend on:

• Actual weight
• Volumetric weight
• Package dimensions
• Delivery distance
• Local, regional, or national zone
• Standard or expedited service
• Fulfilment channel
• Customer delivery charge

4. Pick and Pack Fee

Fulfilment-centre programmes may charge for handling each unit. This cost should be attributed to the specific SKU and fulfilment channel.

5. Storage Fee

Storage costs depend on inventory volume and time. Slow-moving, oversized SKUs can appear profitable per order but become unprofitable after storage and ageing costs.

6. Removal, Disposal, or Liquidation Cost

Include costs related to removing, returning, disposing, or liquidating unsold fulfilment-centre inventory.

7. Collection or Payment Processing Fee

Some marketplaces or payment arrangements may apply transaction, collection, or payment-related charges.

8. Reverse Logistics Cost

Returns can create forward and reverse shipping charges, inspection costs, repackaging, lost packaging, damaged stock, and customer refunds.

9. Promotional Contribution

Separate marketplace-funded, bank-funded, and seller-funded discounts. Only the seller-funded amount should reduce the seller's SKU revenue directly.

10. Tax on Marketplace Services

Marketplace fee invoices may include GST or other applicable tax. Keep the base fee and tax in separate fields. Accounting treatment and eligible tax credits should be reviewed with a qualified professional.

11. Optional Programme Fees

Include account management, launch programmes, premium support, catalogue services, fulfilment programmes, warehousing, and other optional services when applicable.

TCS and TDS Are Not the Same as Marketplace Fees

TCS, TDS, withholding, and similar statutory deductions should be tracked separately from commission and logistics charges.

They may reduce the immediate settlement amount but can have a different accounting and tax treatment from an operating expense.

Maintain separate fields for:

• Marketplace service fee
• GST on service fee
• TCS
• TDS
• Refund adjustment
• Marketplace recovery
• Seller credit
• Net bank payout

Use current tax law, platform reports, and professional advice for final accounting.

Product Cost Calculation

Product cost should represent the cost of making the unit available for sale.

For Purchased Products

Landed Product Cost = Supplier Price + Inward Freight + Duty + Non-Recoverable Tax + Inspection + Conversion or Labelling Cost

For Manufactured Products

Include:

• Raw material
• Direct labour
• Manufacturing conversion cost
• Quality control
• Primary packaging
• Factory wastage
• Inward movement to the marketplace warehouse

Use a Costing Method Consistently

Possible methods include standard cost, weighted average, batch cost, or another approved accounting method. Document the method and update costs when supplier prices or production economics change.

Packaging Cost

Packaging is frequently underestimated.

Include:

• Primary product packaging
• Outer box or courier bag
• Bubble wrap or protective material
• Tape
• Shipping label
• Product insert
• Fragile or liquid protection
• Packaging labour
• Wastage

Create different packaging profiles for small, standard, fragile, liquid, oversized, and multi-unit shipments.

Advertising Cost at SKU Level

Advertising can be attributed through:

• Advertised SKU spend
• Advertised product sales
• Purchased SKU sales
• Campaign-level allocation
• Brand-level allocation

ACOS

ACOS = Advertising Spend / Advertising-Attributed Sales x 100

TACOS

TACOS = Advertising Spend / Total SKU Sales x 100

Break-Even ACOS

Break-Even ACOS = Pre-Advertising Contribution / Advertising-Attributed Sales x 100

The same ACOS target should not be used for every SKU. A high-margin product can afford more advertising than a low-margin product.

Return-Adjusted Profitability

Return rate alone does not show the complete loss. Two SKUs with the same return percentage may have very different financial impact.

Average Return Loss

Average Return Loss = Reverse Logistics + Non-Refunded Forward Fees + Packaging Loss + Damage Loss + Processing Cost - Recoverable Credits

Expected Return Cost per Order

Expected Return Cost per Order = Return Probability x Average Return Loss

Expected Profit per Ordered Unit

Expected Profit = Delivered Probability x Delivered Contribution - Return Probability x Return Loss - Cancellation Probability x Cancellation Loss

Cancellation Cost

Cancellations may create:

• Packaging loss
• Pick and pack charges
• Courier movement or failed-delivery cost
• Inventory reservation cost
• Promotion loss
• Operational handling
• Delayed stock availability

Separate pre-dispatch cancellations, seller cancellations, buyer cancellations, failed delivery, and return-to-origin because their costs differ.

Damage, Loss, and Claims

Track:

• Warehouse-damaged units
• Courier-damaged units
• Lost inventory
• Customer-return damage
• Reimbursement or claim received
• Claim rejected
• Unsellable inventory value

Profitability should include expected claim recovery rather than assuming every loss will be reimbursed.

Settlement-Based Profitability

A practical settlement equation is:

Expected Settlement = Gross Seller Receivable - Marketplace Fees - Logistics - Fee Taxes - Refunds - Recoveries - Statutory Deductions + Credits

Then calculate operational contribution separately:

Contribution Profit = Expected Settlement Adjusted for Statutory Items - Product Cost - Packaging - Advertising - Other Variable Cost

Do not treat bank payout as profit without reconciling every settlement line.

Illustrative SKU Profitability Example

The following numbers are only a calculation example and do not represent an official marketplace rate card.

Component	Illustrative amount per delivered unit
Selling price	INR 1,000
Seller-funded discount	INR 50
Net product revenue	INR 950
Referral or commission fee	INR 95
Closing or fixed fee	INR 20
Shipping and fulfilment	INR 105
Tax on marketplace fees	INR 40
Product cost	INR 420
Packaging cost	INR 25
Advertising allocation	INR 70
Expected return and cancellation cost	INR 45
Other variable cost	INR 10
Illustrative contribution profit	INR 120
Illustrative contribution margin	12.63%

The SKU may still require an allocation for salaries, rent, software, finance cost, and other business overhead before arriving at net profit.

Break-Even Selling Price

Basic Formula

Break-Even Selling Price = Fixed Variable Cost per Unit / (1 - Total Percentage Deduction Rate)

Fixed variable costs may include product cost, packaging, fixed marketplace fee, fixed shipping, and expected return cost. Percentage deductions may include commission, seller-funded discount percentage, and advertising percentage.

Target Selling Price

Target Selling Price = Fixed Variable Cost per Unit / (1 - Total Percentage Deduction Rate - Target Contribution Margin)

Build separate price calculations for each marketplace, fulfilment channel, weight slab, and promotion.

Price-Band and Fee-Cliff Analysis

A small price change can move a product into another fee or shipping band. Before changing price, calculate profitability immediately below and above each threshold.

Test:

• Current selling price
• Promotional price
• Minimum price
• Next fee threshold
• Free-shipping threshold
• Competitor price
• Target-margin price

Fulfilment Channel Comparison

Cost area	Marketplace fulfilment	Marketplace delivery from seller warehouse	Self-ship
Storage	Marketplace fee may apply	Seller bears warehouse cost	Seller bears warehouse cost
Pick and pack	Marketplace fee may apply	Seller bears operational cost	Seller bears operational cost
Shipping	Marketplace charge may apply	Marketplace charge may apply	Seller courier cost
Returns	Programme rules apply	Programme rules apply	Seller courier and handling
Prime or fast-delivery benefit	May be available	May depend on programme eligibility	Depends on marketplace and seller capability
Operational control	Lower seller control	Medium control	Higher control

Compare total cost and conversion impact rather than selecting a channel based only on one visible fee.

Multi-Marketplace SKU Comparison

Field	Marketplace A	Marketplace B	Marketplace C
Selling price	Enter value	Enter value	Enter value
Net revenue	Enter value	Enter value	Enter value
Total marketplace fees	Enter value	Enter value	Enter value
Fulfilment cost	Enter value	Enter value	Enter value
Advertising cost	Enter value	Enter value	Enter value
Return-adjusted loss	Enter value	Enter value	Enter value
Contribution profit	Enter value	Enter value	Enter value
Contribution margin	Enter percentage	Enter percentage	Enter percentage
Payment cycle	Enter current term	Enter current term	Enter current term

Order-to-Settlement Reconciliation

Step 1: Standardize Order Status

Map marketplace-specific statuses to:

• Ordered
• Confirmed
• Shipped
• Delivered
• Cancelled
• Returned
• Refunded
• Lost or damaged

Step 2: Create a Transaction Key

Use order ID, order-item ID, settlement ID, transaction ID, SKU, and quantity to connect reports.

Step 3: Classify Every Settlement Line

Map each line to:

• Product revenue
• Discount
• Commission
• Fixed fee
• Shipping
• Fulfilment
• Storage
• Return charge
• Refund
• Tax
• TCS or TDS
• Claim or reimbursement
• Recovery
• Other credit or debit

Step 4: Allocate Costs to SKU

Use direct allocation whenever possible. Use documented allocation rules only for costs that cannot be directly identified.

Step 5: Reconcile to Bank

The total settlement payout should match the bank credit after considering settlement timing and grouped deposits.

Recommended SKU Profitability Table

Column	Purpose
Marketplace	Identifies the sales channel
SKU	Identifies the sellable variant
Ordered units	Measures customer demand
Delivered units	Measures successful delivery
Returned units	Measures post-delivery loss
Net revenue	Revenue after seller-funded discounts and refunds
Marketplace fees	Commission, fixed, service, and programme charges
Fulfilment and logistics	Forward, reverse, storage, and handling
Advertising	Attributed or allocated spend
Product cost	Landed or manufacturing cost
Packaging	Variable packaging cost
Return and damage loss	Expected or actual operational loss
Contribution profit	Profit before fixed overhead
Contribution margin	Contribution as percentage of revenue
Profit per ordered unit	Accounts for cancellation and return behaviour

SKU Profitability Segmentation

Stars

High sales and strong contribution margin. Protect stock, advertising visibility, ratings, and fulfilment.

Growth Opportunities

Strong margin but limited traffic or sales. Improve listing quality, availability, and advertising.

Revenue Traps

High sales but weak or negative profit. Review price, fees, shipping, ads, discounts, and returns immediately.

Long-Tail Profit Products

Lower sales with healthy margin. Maintain efficient inventory and targeted visibility.

Exit or Repair SKUs

Low sales and negative contribution. Reprice, reduce cost, change pack size, switch fulfilment, or discontinue.

Common Causes of Negative SKU Profit

• Incorrect category or fee assumption
• Package dimensions entered incorrectly
• Volumetric weight ignored
• Price falls into an unfavourable fee band
• Seller-funded discount not included
• Advertising spend allocated only at account level
• Return and RTO costs ignored
• Product cost outdated
• Packaging underestimated
• Storage and removal charges ignored
• Fee tax mixed with recoverable statutory deductions
• Settlement adjustment assigned to the wrong period
• Wrong SKU mapping
• Lost or damaged stock not recorded
• Claims assumed but not received

SKU Profitability Troubleshooting Matrix

Problem	Likely cause	Recommended action
High sales, negative profit	Price, ads, shipping, or returns	Recalculate contribution and pause unprofitable promotion
Unexpected logistics cost	Weight, dimensions, distance, or fulfilment	Audit package master and fee slab
Settlement below expectation	Missing fee, recovery, tax, or refund	Reconcile every transaction line
High ACOS but sales growing	Ads exceed SKU margin	Set SKU-specific break-even ACOS
Return rate acceptable but loss high	Expensive reverse logistics or damage	Measure average return loss, not only return rate
One variant loses money	Different cost, price, or return behaviour	Analyse at variant SKU level
Profit changes after fee update	Outdated rate card	Version fee rules by effective date
Bank payout does not match profit	Statutory deductions and cross-period adjustments	Separate settlement reconciliation from profit calculation

Profitability-Based Advertising Decisions

Use SKU margin to set:

• Break-even ACOS
• Target ACOS
• Maximum CPC
• Daily budget
• Campaign priority
• Promotion eligibility

Maximum Affordable Advertising Cost per Order

Maximum Ad Cost per Order = Pre-Ad Contribution - Target Profit per Order

Maximum CPC

Maximum CPC = Maximum Ad Cost per Order x Advertising Conversion Rate

Use conservative conversion assumptions and update them with recent campaign data.

Inventory Decisions Using Profitability

Inventory allocation should consider both sales velocity and contribution.

Prioritize replenishment for SKUs with:

• Positive return-adjusted contribution
• Stable conversion
• Manageable return rate
• Reliable supply
• Reasonable storage cost
• Strong organic or advertising demand

Do not overstock a high-revenue SKU that creates negative profit after storage and returns.

Fixed Cost Allocation

Fixed and semi-fixed costs can include:

• Employee salaries
• Warehouse rent
• Software
• Account-management services
• Photography and catalogue production
• Professional fees
• Office expenses
• Finance cost

Possible allocation bases include revenue, delivered units, order lines, warehouse space, processing time, or activity-based costing.

Keep contribution profit and fully allocated profit as separate metrics so pricing decisions are not distorted by arbitrary overhead distribution.

Daily, Weekly, and Monthly Workflow

Daily

• Check high-value sales and cancellations
• Check payment and settlement exceptions
• Check sudden advertising-spend changes
• Check top-SKU stock
• Check fee or price anomalies

Weekly

• Refresh order and settlement data
• Review negative-contribution SKUs
• Review advertising against break-even ACOS
• Review returns and RTO
• Review weight and dimension charges
• Review missing claims and credits
• Adjust bids, price, and inventory

Monthly

• Close SKU profitability by marketplace
• Update product and packaging cost
• Update current fee rules
• Reconcile payouts to bank
• Review storage and ageing inventory
• Allocate account-level expenses
• Compare month-over-month contribution
• Prepare assortment actions

30-Day SKU Profitability Implementation Plan

Days 1-7: Data Collection

• Create the SKU master
• Collect order reports
• Collect settlement reports
• Collect advertising reports
• Collect return and inventory reports
• Collect current fee and fulfilment terms

Days 8-14: Cost Mapping

• Update product cost
• Build packaging profiles
• Map weight and dimensions
• Classify settlement transactions
• Separate taxes and statutory deductions
• Define advertising allocation

Days 15-21: Profit Model

• Calculate net revenue
• Calculate delivered contribution
• Calculate return-adjusted contribution
• Calculate break-even price
• Calculate break-even ACOS
• Compare fulfilment channels

Days 22-30: Actions and Controls

• Identify revenue traps
• Pause unprofitable promotions
• Correct package data
• Reprice selected SKUs
• Update advertising targets
• Update replenishment priorities
• Create weekly and monthly dashboards

SKU Profitability Audit Checklist

• Every variant has a unique SKU mapping
• Product cost is current
• Packaging cost is complete
• Actual and volumetric weight are recorded
• Current marketplace fees are applied
• Seller-funded discounts are included
• Advertising is allocated at SKU level
• Returns and cancellations are included
• Claims are recorded only when received or conservatively expected
• Tax on fees is separated
• TCS and TDS are separated from operating fees
• Settlement is reconciled to bank
• Fee rules are versioned by effective date
• Contribution and net profit are reported separately
• Negative-profit SKUs have an action owner

How DigiCommerce Supports Marketplace Profitability

DigiCommerce helps marketplace sellers, brands, manufacturers, exporters, and retailers build practical SKU-level profitability systems.

• Order and settlement reconciliation
• Marketplace fee mapping
• SKU cost-master preparation
• Return and RTO cost analysis
• Advertising profitability analysis
• Break-even price calculation
• Break-even ACOS and TACOS planning
• Fulfilment-channel comparison
• Multi-marketplace profit dashboards
• Inventory and assortment decisions
• Settlement variance tracking
• Monthly profitability reporting

Related DigiCommerce resources include online marketplace solutions, ecommerce service provider guidance, ecommerce sales growth strategies, and ecommerce listing services.

Frequently Asked Questions

1. What is SKU-level profitability?

It is the calculation of revenue, fees, costs, returns, advertising, and contribution profit for each individual sellable SKU or variant.

2. Why is marketplace settlement not the same as profit?

Settlement does not automatically account for product cost, packaging, advertising, internal fulfilment, fixed overhead, and every cross-period adjustment.

3. Which marketplace fees should be included?

Include the current applicable commission, fixed fee, logistics, fulfilment, storage, return, service, promotion, and fee-tax components shown in the seller portal and settlement reports.

4. Should TCS and TDS be treated as marketplace fees?

They should be tracked separately because their accounting and tax treatment can differ from operating fees. Confirm treatment with a qualified professional.

5. How should advertising be allocated?

Use SKU-attributed spend where available. Otherwise, use a documented allocation rule based on sales, clicks, orders, or another relevant activity.

6. What is break-even ACOS?

It is the maximum advertising cost percentage that consumes the available pre-advertising contribution without creating a loss.

7. How should returns be included?

Calculate return probability and average return loss, including reverse logistics, damaged stock, packaging loss, fees, and recoverable credits.

8. Should variants be analysed separately?

Yes. Different sizes, colours, pack quantities, and models can have different costs, prices, conversion, and return rates.

9. How often should SKU profitability be updated?

High-volume sellers should monitor exceptions daily, review SKU results weekly, and complete a formal monthly profitability close.

10. What should be done with a high-sales loss-making SKU?

Review price, category, fee band, shipping, package dimensions, ads, discounts, return reasons, product cost, and fulfilment channel before deciding whether to repair or discontinue it.

11. Can one profitability model work for all marketplaces?

The core structure can be shared, but fee rules, settlement fields, fulfilment costs, payment timing, and reports must be mapped separately for each marketplace.

12. Can DigiCommerce build a SKU profitability dashboard?

Yes. DigiCommerce can combine orders, settlements, fees, advertising, returns, product costs, and inventory into marketplace and SKU-level profitability reports.

Conclusion

SKU-level profitability analysis converts marketplace data into actionable commercial decisions. Sellers should not rely only on gross sales, ROAS, or bank payouts. Every SKU should be evaluated after marketplace fees, fulfilment, advertising, product cost, packaging, returns, cancellations, claims, and other variable expenses.

The strongest model uses current rate cards, transaction-level settlement data, accurate SKU mapping, return-adjusted contribution, and regular bank reconciliation. It should guide pricing, promotions, advertising, replenishment, fulfilment, and assortment decisions.

For SKU-level marketplace profitability, settlement reconciliation, fee audits, break-even pricing, advertising targets, and multi-marketplace dashboards, connect with DigiCommerce Solutions.