Introduction: Gross Revenue Is Not Your Profit

One number that almost every ecommerce seller knows is their gross revenue — the total amount customers paid for their products. It is the headline figure that feels most tangible, most like success.

But gross revenue is one of the least useful numbers in your business for making decisions. It tells you how much was ordered, not how much you earned. The real story of your ecommerce business lives in your order-level profitability — the margin on each individual transaction after every relevant cost has been accounted for.

This guide explains how to calculate true order-level profitability, why it transforms your decision-making, and how to build the data infrastructure to produce this intelligence systematically.

The Anatomy of an Ecommerce Order: Where Your Money Actually Goes

For a typical marketplace order, here are all the cost elements that reduce your gross sale before you arrive at a net margin:

**1. Cost of Goods Sold (COGS)**
The direct cost of the product itself — your purchase price from your supplier, including import duties or manufacturing costs if you are producing the item.

**2. Marketplace Commission / Referral Fee**
Every marketplace charges a percentage of the selling price as a commission. On Amazon India, this ranges from 3% to 17% depending on the category. On Flipkart, rates are similar. On Meesho, structural commissions apply differently across categories.

**3. Closing Fee / Fixed Fee**
Many marketplaces charge a fixed closing fee per order in addition to the commission. This is particularly common on Flipkart and can represent a significant cost on lower-priced products.

**4. FBA / Fulfilment Fee (for FBA sellers)**
If you use Fulfilled By Amazon, your per-unit shipping and handling fee from Amazon covers pick, pack, and delivery. These fees vary based on product size and weight.

**5. Shipping Cost (for self-fulfilled orders)**
If you self-fulfil, the actual logistics cost is a direct expense on each order. This varies by courier, route, and package weight.

**6. Return Handling Cost**
When a customer returns a product, you incur reverse logistics cost, possible re-packaging cost, and potential write-off if the product cannot be resold.

**7. Advertising Cost (order-attributed)**
If your order was generated through a sponsored listing or ad campaign, the advertising cost per order should be allocated to that order's margin calculation.

**8. Packaging Materials**
Product-level packaging cost is often overlooked but can be material — particularly for fragile or premium products.

Understanding which of these apply to each order, and at what amount, is the foundation of order-level profitability analysis.

Why Most Sellers Do Not Know Their True Product Margins

There is a simple reason why product-level profitability is rarely tracked correctly: the data lives in too many different places.

Your COGS is in your purchase records. Your marketplace fees are in your settlement reports. Your logistics costs are in your courier invoices. Your advertising spend is in your campaign dashboards. Your return costs are in your operations data.

Combining all of these into a per-order, per-SKU profitability view requires either extensive manual work in spreadsheets or a purpose-built system that can ingest and consolidate data from all these sources.

Without this consolidated view, sellers typically make product and pricing decisions based on one of two incomplete heuristics:
- **Gross margin on COGS only** (ignoring all marketplace and logistics costs)
- **Settlement amount minus COGS** (which is better, but still ignores product-level allocation of advertising and returns)

Both approaches consistently overstate profitability and lead to decisions to scale products that are actually unprofitable at the total cost level.

The Contribution Margin Framework

The most useful metric for ecommerce order-level profitability is the **Contribution Margin** — the amount a product contributes to covering your fixed costs and profit after all variable direct costs are deducted.

**Contribution Margin = Selling Price – Variable Costs**

Variable costs at the order level include:
- COGS
- Marketplace commission
- Closing / fixed fees
- Fulfilment or logistics cost
- Return probability-adjusted cost (based on your historical return rate for that SKU)
- Advertising cost per order (derived from your ACoS)

**Example:**
- Selling price: ₹850
- COGS: ₹(320)
- Referral fee (8%): ₹(68)
- Closing fee: ₹(30)
- FBA fulfilment: ₹(55)
- Advertising allocation (12% of revenue): ₹(102)
- Return cost provision (15% return rate × ₹200 reverse logistics): ₹(30)
- **Contribution Margin: ₹245 (28.8%)**

This 28.8% contribution margin is the number that actually matters. If your COGS is ₹320 and you are selling at ₹850, it appears you have a 62% gross margin. But the real return after all costs is 28.8% — and that is before any of your fixed overhead costs.

Step-by-Step: Building an Order-Level Profitability Report

**Step 1: Define your data sources.**
Identify where each cost component lives. COGS in your purchase ledger, fees in settlement reports, logistics in courier data, and advertising in platform campaign reports.

**Step 2: Create a master order table.**
Build a table with one row per order (or per SKU line within an order) that brings all revenue and cost components into a single row. Each column represents a cost element.

**Step 3: Allocate advertising costs.**
This is often the most challenging step. You have a total advertising spend for the period but need to allocate it at the order level. Common approaches include:
- Allocate proportionally by attributed orders from your ad reports
- Apply a fixed-cost-per-click approximation by SKU
- Use ACoS (Advertising Cost of Sales) as a percentage of revenue per SKU

**Step 4: Provision for returns.**
For high-volume analysis, rather than waiting for actual returns, provision for them using your historical return rate per SKU. This gives you a forward-looking margin view.

**Step 5: Calculate contribution margin per order.**
Apply the formula and sort SKUs by contribution margin percentage. Your most profitable SKUs will immediately become visible. Your loss-making SKUs will surface too — often for the first time.

**Step 6: Generate actionable insights.**
Use the ranked profitability view to make decisions: which SKUs to scale, which to re-price, which to exit.

Common Insights Generated by Order-Level Profitability Analysis

Sellers who implement this analysis consistently report the same categories of insight:

**Low-priced SKUs often have negative margins.** When closing fees and fulfilment fees are fixed amounts, they represent a proportionally higher cost on cheaper products. A ₹200 product with a ₹30 closing fee has a 15% cost component from closing fee alone.

**High-return products destroy margins silently.** A product with a 30% return rate can have its contribution margin reduced by 40–50% compared to a non-returned equivalent, even if the gross sale price looks identical.

**Advertising can make profitable products unprofitable.** If your ACoS is 25% on a product with only a 22% contribution margin before advertising, that product is not generating positive returns on its advertising investment.

**Category fee differences create SKU-level arbitrage.** A product that qualifies for a lower-fee category is inherently more profitable than an identical product in a higher-fee category.

How MaruTally Generates Order-Level Profitability Intelligence

MaruTally was built specifically to solve the order-level profitability data problem for ecommerce sellers.

The platform:
- **Imports settlement data** from Amazon, Flipkart, Meesho, and other platforms and maps each fee category to the correct cost dimension
- **Links COGS data** from your purchase records to the relevant SKU, so gross margin is calculated at the order level rather than the aggregate level
- **Allocates advertising spend** from platform campaign reports proportionally to the orders each ad dollar generated
- **Applies return provisions** based on your historical return rates per SKU
- **Produces a ranked profitability view** that shows contribution margin by SKU, by marketplace, and by time period

This intelligence is available in real time, not as a quarterly exercise, enabling sellers to make faster and better-informed decisions about where to invest their inventory capital.

Conclusion: Know Your Winners Before You Scale Them

The most expensive mistake in ecommerce is scaling a product that is actually unprofitable. Without order-level profitability data, this mistake happens routinely — sellers see high revenue and strong order volume, increase their inventory investment, and only discover the margin problem when the business is carrying significant stock of a money-losing product.

Order-level profitability analysis is not a luxury for large businesses. It is essential intelligence for any seller who wants to make confident decisions about which products to grow.

Start by identifying your top 20 SKUs by revenue. Run the contribution margin calculation for each. The results may surprise you — and they will definitely inform your next moves.

Calculating Order-Level Profitability in E-commerce