how-to
How to Calculate Per SKU Profitability (2026 Guide)
Table of Contents
- Why Per SKU Profitability Is Your True North Metric
- The SKU Profitability Formula: Gross Margin vs. Net Profit
- Calculating Landed Cost Per SKU: A Step-by-Step Walkthrough
- Ecommerce Inventory Cost Allocation: Handling Indirect Expenses
- Common Mistakes That Skew Your Margin Analysis
- Using SKU Rationalization to Act on Your Profitability Data
- Conclusion: Building a Repeatable Profitability Review
- Frequently Asked Questions
Last Updated: September 6, 2026
Why Per SKU Profitability Is Your True North Metric
Most ecommerce operators track revenue, gross margin, and maybe inventory turnover. Fewer track profitability at the individual product level. That gap hides real problems: best-selling SKUs that lose money after fees and freight, slow movers quietly consuming storage capacity, and a catalog where 20% of items generate all the profit while the rest drag it down.
Per SKU profitability is the practice of calculating net profit for each individual product variation, accounting for every cost from procurement through delivery. It answers a question aggregate P&L statements cannot: which specific products actually make you money?
At Scale Partners AI, we've spent 15 years inside logistics and ecommerce operations. The operators who scale successfully share one habit: they review profitability at the SKU level weekly, not quarterly. This guide walks through the exact formula, the cost allocation steps most teams skip, and how to act on the data once you have it.
The SKU Profitability Formula: Gross Margin vs. Net Profit
The distinction between gross margin and net profit is where most margin analysis goes wrong. Gross margin subtracts only the cost of goods sold (COGS) from revenue. Net profit subtracts everything: COGS, freight, fulfillment, storage, advertising, referral fees, and a fair share of overhead.
The SKU profitability formula starts simply:
Net Profit per SKU = Net Revenue - COGS - Landed Costs - Allocated Indirect Costs
Net revenue accounts for returns, discounts, and promotions. Landed costs include freight, duties, and insurance. Indirect costs are the tricky part, covered in detail below.
Calculating Contribution Margin for a Single SKU
Contribution margin is the most practical intermediate metric. It measures what a SKU contributes toward fixed costs after covering its variable costs. The formula is:
Contribution Margin = Net Revenue - Variable Costs (COGS + Freight + Fulfillment + Referral Fees + PPC Ad Spend)
Contribution margin matters because it separates SKUs that are structurally profitable from those that only look profitable on paper. A SKU with a healthy gross margin can still have a thin or negative contribution margin once variable costs stack up.
Calculating Landed Cost Per SKU: A Step-by-Step Walkthrough
Landed cost is the total cost to get a product to your warehouse door, ready for sale. Getting this wrong cascades through every downstream calculation. The steps below establish an accurate baseline for true margin analysis.
Step 1: Sum Direct Product Costs (COGS)
Start with the invoice price you pay the supplier per unit. Include any per-unit manufacturing or procurement costs. If you buy in batches, divide the total batch cost by the number of usable units, accounting for expected damage or defect rates during transit.
Step 2: Add Freight, Duties, and Insurance
Freight costs are rarely uniform across your catalog. Heavier or larger items consume more container space and cost more to ship. Allocate freight based on weight or cubic volume, not evenly across units. Add customs duties and cargo insurance premiums to the per-unit figure.
Step 3: Include Storage and Fulfillment Fees
Storage fees accrue daily based on cubic footage occupied. Fulfillment fees apply per unit when orders ship. Both belong in landed cost if you want an accurate picture of what a SKU truly costs to carry and deliver. Many operators stop after Step 2, which understates true cost and inflates apparent profitability.
Ecommerce Inventory Cost Allocation: Handling Indirect Expenses
Indirect costs are expenses that support the entire operation but cannot be traced to a single unit. Rent, warehouse salaries, software subscriptions, and utilities fall into this category. Ignoring them means your per SKU profitability figures reflect only direct costs, not the full cost of running the business. However, the most common and costly error isn't ignoring these costs, it's allocating them as if every sales channel were identical.
The Multi-Channel Allocation Problem
Most ecommerce operators sell the same SKU on their own website (DTC), on Amazon, and possibly on Walmart or eBay. Each channel has a different cost structure that must be reflected in your allocation. A SKU sold on your own site might have a 2.9% payment processing fee. The same SKU on Amazon incurs a referral fee (typically 8-15% for most categories), a variable closing fee, and a fulfillment fee if you use FBA. On Walmart Marketplace, the referral fee is often lower, but you might be responsible for shipping costs.
Allocating indirect costs evenly across these channels will produce a single, misleading profitability number. Instead, you must build a channel-aware allocation model. For example, if your warehouse staff picks and packs orders for your DTC site but Amazon's FBA handles its own fulfillment, then your warehouse labor costs should be allocated only to the DTC portion of that SKU's sales. Similarly, customer service costs for marketplace orders are often handled by the marketplace itself, so those costs should not be burdened onto that channel's units.
A Practical Allocation Framework
- Identify Channel-Specific Variable Costs: Start with the direct, per-unit costs that vary by channel. This includes payment processing fees, marketplace referral fees, fulfillment fees, and shipping costs. These are not indirect costs; they are direct variable costs that must be subtracted before you even begin allocating overhead.
- Allocate Shared Overhead by Activity: For costs like rent, utilities, and software, use an activity-based approach. If a SKU sells 60% of its volume on your DTC site (which you fulfill yourself) and 40% on Amazon (which uses FBA), then allocate 60% of its warehouse storage and picking labor costs to the DTC channel. The 40% sold via FBA should not carry those warehouse costs.
- Use a Blended Cost of Capital: When calculating the carrying cost of inventory (the cost of capital tied up in stock), use a blended rate that reflects your entire operation, not just one channel. This ensures that a slow-moving SKU on your DTC site is penalized for tying up cash, even if it sells quickly on a marketplace.
Handling Channel-Specific Return Rates
Return rates are not uniform across channels. Customers who buy on a marketplace like Amazon have different return behaviors than those who buy on your branded DTC site. A SKU might have a 5% return rate on your site but a 15% return rate on Amazon, often due to the ease of the return process. This variance must be factored into your channel-level allocation. The cost of processing a return, inbound shipping, inspection, restocking, and potential disposal, should be attributed to the channel that generated the return. This level of detail is what separates a functional profitability model from a strategic one.
By building a channel-aware allocation model, you move beyond a simple average and gain the ability to answer questions like, "Should we stop selling this SKU on Amazon but keep it on our DTC site?" or "Is our higher DTC margin enough to justify the higher marketing spend?" This is the unique strategic value that a robust per-SKU profitability calculation provides.
Common Mistakes That Skew Your Margin Analysis
Several recurring errors distort SKU profitability calculations. Recognizing them prevents costly misjudgments.
First, many teams use average freight rates across all SKUs. Heavy or bulky items then appear more profitable than they are. Second, storage fees are frequently excluded entirely, particularly for slow-moving inventory that accrues months of carrying costs. Third, overhead is either ignored completely or spread evenly across all units, which penalizes high-volume, low-margin SKUs and flatters low-volume, high-margin ones.
Fourth, return rates are rarely tracked at the SKU level. Fifth, PPC ad spend gets grouped into a marketing bucket rather than attributed to the products it promotes. Sixth, many calculations use gross margin when they should use net profit, creating a misleading view of SKU performance.
| Common Mistake | The Fix | Impact on Accuracy |
|---|---|---|
| Using average freight rates | Allocate by weight or volume | Prevents bulky items from looking profitable |
| Ignoring storage fees | Track cubic footage and days of inventory | Surfaces slow movers eating profit |
| Spreading overhead evenly | Allocate by space or labor hours | Fairly reflects true cost per SKU |
| Treating returns as corporate cost | Attribute return rate per SKU | Reveals high-return product costs |
| Using gross margin instead of net profit | Subtract all variable and allocated costs | Reflects actual cash contribution |
Using SKU Rationalization to Act on Your Profitability Data
Calculating per SKU profitability only matters if you act on the results. SKU rationalization is the process of reviewing your catalog and deciding what to keep, improve, promote, or discontinue based on profitability data.
Begin by segmenting SKUs into profitability tiers. High-margin, high-velocity products deserve marketing investment and reliable stock levels. High-margin, low-velocity items may be worth keeping for assortment but warrant reduced storage allocation. Low-margin, high-velocity products need cost review: renegotiate supplier pricing, optimize freight, or adjust pricing strategy. Low-margin, low-velocity SKUs are prime candidates for liquidation or discontinuation.
Inventory velocity matters alongside profitability. A moderately profitable SKU that turns over quickly may outperform a high-margin SKU that sits in storage for six months, accruing fees and tying up capital. Days of inventory is a critical companion metric to net profit.
Conclusion: Building a Repeatable Profitability Review
Per SKU profitability is the metric that separates operators who guess from operators who know. The calculation requires discipline: accurate landed costs, honest allocation of indirect expenses, and SKU-level tracking of returns and advertising. But the payoff is a catalog where every product earns its place, and where capital flows toward the items that genuinely drive net profit.
The challenge is consistency. Manual spreadsheet calculations become outdated the moment freight rates, storage fees, or return patterns shift. This is where Scale Partners AI delivers value. Our custom AI systems integrate with your existing software stack, eliminating manual workarounds and providing real-time visibility into true per-SKU profit. Built by operators with 15 years of experience, we deliver weekly recommendations you can implement, not slide decks. IRS guidance on inventory valuation methods provides a useful framework for the accounting side, and the ecommerce accounting guide from the AICPA covers treatment of landed costs. For marketplace sellers, the FTC's guidance on advertising and fees clarifies referral fee disclosure expectations.
Get started with Scale Partners AI and turn your SKU data into a repeatable profitability review that drives margin improvement every week.
Frequently Asked Questions
What is SKU profitability?
SKU profitability is the net profit a specific product variation generates after accounting for all direct and indirect costs. You calculate it by subtracting the fully allocated landed cost, variable selling expenses, and a share of fixed overhead from the product's revenue. Unlike gross margin, per SKU profitability includes costs like storage fees, PPC ad spend, and return rates, giving you the true margin each product contributes to your business.
What is the formula for calculating SKU productivity?
SKU productivity typically measures revenue or profit against the space or capital invested, while the SKU profitability formula focuses on net profit per unit. The core calculation is: Selling Price minus (Landed Cost plus Variable Selling Costs plus Allocated Fixed Costs) equals Net SKU Profit. Divide that by the selling price and multiply by 100 to get your net profit margin percentage for that specific SKU.
What costs should be included when calculating per SKU profitability?
Include your cost of goods sold (COGS), freight and duties, storage fees, and fulfillment costs for a base landed cost. You also need variable costs like marketplace referral fees, PPC ad spend, and return rate losses. Finally, allocate a portion of fixed costs such as warehouse rent and salaries to each SKU. Missing any of these categories inflates your apparent profit and leads to poor inventory decisions.
How does SKU rationalization impact overall business health?
SKU rationalization uses profitability data to identify and prune underperforming products, often revealing that a small percentage of SKUs generate most of your net profit. Removing low-margin SKUs frees up warehouse space and working capital, reduces complexity in forecasting, and lets you focus marketing spend on high-velocity items. This process directly improves inventory turnover and operational efficiency across your entire catalog.