How to Track Per-SKU Profitability: A 2026 Guide

Table of Contents

• Why SKU Profitability Tracking Fails (and the Fix)
• Step 1: Pull the Sales and Order Data You Already Have
  • Settlement Reports and Marketplace Data
• Step 2: The Profit per SKU Calculation (With Examples)
  • A Worked Cost Allocation Example
  • How to Allocate Shared Costs Without Distorting the Picture
• Step 3: SKU Contribution Margin vs Gross Margin
• Step 4: Build a Product-Level Profitability Dashboard
  • Reconciliation and Data Accuracy
• Step 5: Use SKU Rationalization to Act on the Numbers
• Common Mistakes That Distort SKU Profitability
• Conclusion: Review Cadence and Next Steps
• Frequently Asked Questions

Last Updated: October 5, 2026

Why SKU Profitability Tracking Fails (and the Fix)

Most multi-channel sellers can tell you their total revenue. Very few can tell you which products actually make money. Learning how to track per-sku profitability fixes that blind spot, and it starts with accepting an uncomfortable truth: your best-selling item is often not your most profitable one.

We've spent 15 years inside warehouse and e-commerce operations, and the pattern repeats. A seller pushes a hero product hard, then discovers after a full quarter that shipping surcharges and ad spend ate the margin. The fix is not a new platform. It is a repeatable process that turns raw order data into profit per SKU.

Here is the workflow we walk clients through, step by step.

Step 1: Pull the Sales and Order Data You Already Have

Start with the data you already own. You do not need new software to begin tracking SKU-level profitability. Export three things from your store and your channels:

• Order line items with SKU, quantity, and selling price
• Discounts and refunds applied to each order
• Shipping charges collected versus shipping paid

Combine these into one sheet. Every row should represent a single SKU on a single order.

Settlement Reports and Marketplace Data

Marketplace settlement reports are where the real numbers live. A settlement report shows what a channel actually paid you after fees, refunds, and adjustments. Pull these monthly and match them against your order exports. If the two do not reconcile, your profit math will be wrong before you even start.

Amazon's settlement report documentation for sellers explains how fees and adjustments appear in these files. The same logic applies to any channel that issues a payout statement.

Step 2: The Profit per SKU Calculation (With Examples)

The profit per SKU calculation is simple in concept: revenue minus every cost tied to that SKU. The hard part is assigning costs correctly, and that is where most sellers quietly get it wrong. Before you build anything, separate the two numbers you actually need.

Contribution profit is what a SKU leaves behind after variable costs, the costs that only exist because you sold that unit. Fully loaded profit subtracts shared overhead on top: software subscriptions, warehouse rent, salaried labor, insurance, and any other cost that exists whether or not the SKU sells. Contribution profit tells you whether a product is worth keeping. Fully loaded profit tells you whether the whole business is healthy. Mixing them is the single most common source of bad assortment calls.

Use these two formulas:

Contribution profit per unit = Selling price − COGS − outbound shipping − fulfillment fees − marketplace fees − payment processing − allocated ad spend − returns cost

Fully loaded profit per unit = Contribution profit per unit − allocated overhead per unit

Here is the cost list to gather for each SKU, and where each number actually comes from:

• COGS (landed): supplier invoice plus inbound freight, duties, and any inspection cost, divided by units received. Do not use the supplier's quoted unit price alone.
• Outbound shipping: the actual label cost per unit, not the flat rate you charged the customer. If you offer free shipping, this is a real cost with no offsetting revenue line.
• Fulfillment: pick, pack, and per-unit handling fees. For third-party logistics, pull these from the monthly invoice; for self-fulfillment, estimate labor minutes per unit times your loaded hourly rate.
• Marketplace fees: referral percentage plus any category-specific fee. These change by category and by price band, so verify the current rate rather than reusing last year's number.
• Payment processing: typically a percentage plus a fixed per-transaction fee. The fixed portion hurts low-priced SKUs disproportionately.
• Ad spend: allocated per unit sold, not per campaign. See the allocation method below.
• Returns: refund value plus return shipping plus any restocking or disposal cost, spread across all units sold, not just the returned ones.

A Worked Cost Allocation Example

Suppose a SKU sells for $40 and moves 100 units in a month. Here is how the numbers come together:

• COGS landed: $12 per unit → $1,200
• Outbound shipping: $5 per unit → $500
• Fulfillment: $2 per unit → $200
• Marketplace referral and payment processing: $6 per unit → $600
• Ad spend for the month on this SKU: $400 total → $4 per unit
• Returns: 5 units returned, $40 refund each plus $5 return shipping → $225 total, or $2.25 per unit across all 100 units

Contribution profit per unit = $40 − $12 − $5 − $2 − $6 − $4 − $2.25 = $8.75. Contribution margin = $8.75 ÷ $40 = 21.9%.

Now allocate overhead. If monthly overhead across the business is $3,000 and this SKU represents 20% of total units sold, its share is $600, or $6 per unit. Fully loaded profit per unit = $8.75 − $6 = $2.75, a fully loaded margin of 6.9%. That is the number that tells you whether the SKU is actually carrying its weight.

How to Allocate Shared Costs Without Distorting the Picture

Shared costs, ads, storage, labor, overhead, must be spread across units, or your margin will look better than it is. Three allocation bases cover most situations:

1. By units sold, simplest, works well for ad spend and per-unit fulfillment labor.
2. By revenue share, better for overhead when your SKUs have very different price points.
3. By cubic volume or storage days, the right base for warehouse and long-term holding costs, since a bulky slow-mover consumes more space than a small fast-mover at the same revenue.

Pick one base per cost category and apply it consistently. Changing the base month to month makes trend analysis meaningless.

Step 3: SKU Contribution Margin vs Gross Margin

Gross margin and SKU contribution margin answer different questions. Gross margin tells you how a product performs before overhead. Contribution margin tells you what is left to cover fixed costs and profit after variable costs.

Book a Discovery Call →

SKU contribution margin is the revenue a product leaves behind after all variable costs, expressed as a percentage of its selling price.

For most assortment decisions, contribution margin is the number to watch. A product with a strong gross margin can still have a weak contribution margin once shipping and fees hit.

Step 4: Build a Product-Level Profitability Dashboard

A product-level profitability dashboard turns your spreadsheet into a weekly habit. You do not need an expensive tool. A clean sheet with one row per SKU and columns for revenue, each cost, and final profit will outperform a fancy system nobody updates.

Build it in this order:

1. One row per SKU
2. Columns for revenue, COGS, shipping, fees, and ad spend
3. A calculated profit column
4. A margin percentage column
5. A weekly refresh date

Reconciliation and Data Accuracy

Reconciliation and data accuracy decide whether your dashboard is useful or misleading. Match your dashboard totals to your settlement reports every month. If they differ, find out why before you act on any number.

• Check for missing refunds
• Confirm fee rates have not changed
• Verify unit counts match your order exports

Shopify's guide to understanding profit and margin reports walks through how platform-reported profit can drift from your own math.

Step 5: Use SKU Rationalization to Act on the Numbers

SKU rationalization is the practice of cutting or fixing products that drag down profit. Numbers only help if you act on them.

Sort your dashboard by profit per SKU, then apply simple rules:

• High revenue, low margin: raise price or cut costs
• Low revenue, high margin: promote it more
• Low revenue, low margin: consider discontinuing

Our systems flag bundling opportunities and weak SKUs weekly, so the decision is made for you rather than waiting on a quarterly review. Because we build around your existing stack, there is no rip-and-replace and no lost history.

Common Mistakes That Distort SKU Profitability

Several errors quietly wreck your profit tracking. Watch for these:

• Ignoring returns when calculating margin
• Allocating all ad spend to your best seller
• Using list price instead of actual selling price
• Forgetting storage and long-term holding fees
• Mixing marketplace and direct-channel data in one column

Each one inflates profit and leads to bad assortment calls. Fix them once, and your dashboard stays trustworthy.

Conclusion: Review Cadence and Next Steps

Tracking profit per SKU is not a one-time project. Set a weekly review, reconcile monthly, and act on the flags your data raises. Most sellers who do this find margin hiding in the products they almost cut.

Scale Partners AI builds production-ready systems that plug into your current software and deliver weekly "fix this" recommendations, from real-time per-SKU profit visibility to simplified multi-channel inventory management. No slide decks, no rip-and-replace.

Book a Discovery Call with Scale Partners AI and start seeing true profit per SKU this month.