top of page

How to Run a SKU Profitability Audit to Prune Unprofitable ASINs

Writer: Irene Silvano
Irene Silvano
Nov 9
6 min read

A SKU profitability audit calculates true profit margin per ASIN by subtracting Amazon fees, FBA costs, advertising spend, and overhead from net revenue. Sellers should pull 90 days of business report data, calculate contribution margin for every SKU, flag ASINs below a set margin threshold, and discontinue or renegotiate products that drain cash flow without driving strategic value.

Most Amazon sellers know their top-line revenue down to the dollar. Far fewer know which ASINs are actually making them money once fees, ads, returns, and storage costs are factored in. That gap is dangerous. A catalog can look healthy on a sales dashboard while a third of its SKUs quietly bleed cash every month.

Running a SKU profitability audit closes that gap. It forces a seller to look past revenue and into contribution margin, the number that actually determines whether a product deserves shelf space, ad dollars, and warehouse slots. For FBA sellers juggling dozens or hundreds of ASINs, this audit is the difference between a catalog that compounds profit and one that just stays busy.

This guide walks through exactly how to run that audit, which Amazon reports to pull, how to calculate true profitability per SKU, and how to decide which ASINs to prune, fix, or double down on.

Why does every Amazon seller need a SKU profitability audit?

Revenue growth hides margin erosion. An ASIN can generate $50,000 a month and still lose money once FBA fees, long-term storage charges, PPC spend, and return rates are netted out. According to Amazon's own fee structure, referral fees alone range from 8% to 15% depending on category, and that's before fulfillment fees, which scale with size and weight tiers.

Stack advertising costs on top of that. Many sellers run ACoS (Advertising Cost of Sale) north of 20% just to maintain page-one visibility in competitive categories. When referral fees, FBA fees, and ad spend combine, a product that looks profitable on paper can land at breakeven or negative contribution margin.

A profitability audit surfaces these losses before they compound. It also reveals high-friction ASINs, products that consume disproportionate time on customer service, returns processing, or inventory management relative to the profit they generate.

How do you calculate true profit margin per Amazon SKU?

True SKU profitability goes well beyond the "Net Proceeds" figure shown in Seller Central. The full calculation looks like this:

Net Revenue (unit price minus returns and refunds) minus Amazon referral fee minus FBA fulfillment fee (or FBM shipping cost) minus Storage fees (monthly and long-term, if applicable) minus Advertising spend allocated to that ASIN minus Cost of goods sold (COGS) minus any other overhead (packaging, prep, labeling, returns processing) equals Contribution margin per unit

Multiply contribution margin per unit by monthly units sold to get total contribution margin per SKU. This number, not revenue, should guide every catalog decision.

What is contribution margin and why does it matter more than revenue?

Contribution margin measures how much profit a single SKU generates after variable costs are removed, before fixed overhead like warehousing contracts or salaries is allocated. It answers a specific question: does this product cover its own costs and contribute cash toward the business?

A seller should treat contribution margin as the primary filter for every catalog decision. Choose to keep a SKU if its contribution margin is positive and improving over time. Choose to prune or renegotiate a SKU if contribution margin is flat, negative, or declining despite stable or growing sales volume.

Which Amazon business reports should you use for SKU analysis?

Four reports inside Seller Central provide the raw data needed for an accurate audit:

  1. Business Report (Detail Page Sales and Traffic by Child Item): Provides unit sales, sessions, conversion rate, and revenue per ASIN.

  2. Fulfilled Shipments Report: Breaks down FBA fees, shipping costs, and fulfillment details per order.

  3. Advertising Campaign Reports: Shows ad spend, clicks, and attributed sales per ASIN, which is essential for calculating true ACoS at the SKU level.

  4. Storage Fees Report: Flags inventory sitting too long in FBA warehouses, which triggers long-term storage surcharges that quietly erode margin.

Pull 90 days of data at minimum. A 30-day window can be skewed by seasonality, promotions, or stockouts. Ninety days smooths out those anomalies and gives a more reliable margin picture.

How do you build a SKU profitability audit checklist?

A structured checklist keeps the audit consistent across every ASIN in the catalog:

  • Export unit sales and revenue for each SKU from the Business Report

  • Calculate referral and FBA fees using Amazon's fee schedule or the Revenue Calculator.

  • Pull ad spend per ASIN from Advertising Console reports

  • Add COGS and landed cost (manufacturing, freight, duties)

  • Factor in return rate and refund costs by category

  • Calculate contribution margin per unit and in total.

  • Rank all SKUs by contribution margin, lowest to highest.

  • Flag any SKU below your minimum margin threshold (commonly 10-15%, depending on category and overhead structure)

  • Review high-friction indicators: return rate above category average, frequent customer service tickets, or chargebacks.

This checklist should be run quarterly at minimum. Fee structures, ad costs, and competitive pricing shift often enough that a stale audit can mask new margin problems.

How do you identify low-margin, high-friction ASINs that drain cash flow?

Low margin and high friction often travel together, but not always. A seller needs to separate the two to prioritize action correctly.

Low-margin ASINs show thin or negative contribution margin despite steady sales volume. These are products where fees, ad spend, or COGS have crept up faster than price increases, or where a competitive category has forced the price down.

High-friction ASINs consume disproportionate operational resources: elevated return rates, frequent size or quality complaints, complex bundling requirements, or inventory that's prone to damage in transit. A product can carry acceptable margin and still be high-friction if it demands constant customer service attention or manual intervention.

Choose to prune a SKU immediately if it scores low on both margin and friction. Choose to investigate further if a SKU is low-margin but low-friction. A small price adjustment or fee renegotiation might restore profitability without discontinuing the product.

When should you discontinue an Amazon product or ASIN?

Three conditions typically justify discontinuing a SKU:

  1. Contribution margin has been negative for two or more consecutive quarters, with no clear path to profitability through pricing or cost adjustments.

  2. The ASIN requires disproportionate advertising spend to maintain visibility, pushing true ACoS above sustainable levels for that category.

  3. Operational friction outweighs strategic value. Some SKUs are kept deliberately as loss leaders or catalog completers. If a product has no such strategic role and still loses money, it's a clear candidate for discontinuation.

Discontinuing a SKU doesn't always mean removing it instantly. Sellers can wind down inventory gradually, redirect ad spend to higher-margin ASINs, and reallocate warehouse space before fully retiring the listing.

How do you prioritize high-margin ASINs after pruning the catalog?

Once low performers are identified, the next step is reallocating resources toward the SKUs that already prove profitable. Increase advertising budget on ASINs with the strongest contribution margin, since every incremental ad dollar there returns more profit than the same dollar spent on a low-margin product. Negotiate better freight or supplier terms on high-volume, high-margin SKUs to widen margin further. Use freed-up warehouse space and cash flow from pruned ASINs to expand inventory on proven winners, rather than spreading resources evenly across the entire catalog.

This prioritization transforms the audit from a defensive exercise into a growth strategy. Pruning isn't just about cutting losses. It's about redirecting capital toward the products already generating the best returns.

Turning the audit into an ongoing habit

A SKU profitability audit isn't a one-time cleanup project. Amazon's fee structures change, competitors adjust pricing, and ad costs fluctuate across seasons. A catalog that's healthy in Q1 can develop margin problems by Q3 if nobody's watching.

Build the audit into a recurring quarterly process. Set a clear contribution margin threshold for the catalog, track performance against it every cycle, and treat any SKU that falls below the line as a flag for immediate review, not a problem to revisit next quarter. The sellers who protect their margins best are the ones who treat profitability tracking as routine as checking inventory levels.

Frequently Asked Questions

How often should I run a SKU profitability audit? Quarterly is the recommended minimum. Fee changes, seasonal ad cost shifts, and competitive pricing pressure can erode margin faster than most sellers expect, so a quarterly cadence catches problems before they compound.

What contribution margin threshold should I use to flag unprofitable ASINs? Most sellers use a 10-15% minimum contribution margin threshold, though the right number depends on category, overhead structure, and growth stage. Lower-margin categories like consumables may require a lower threshold than premium or branded products.

Can I recover a low-margin ASIN instead of discontinuing it? Yes. Options include renegotiating supplier costs, adjusting price, improving packaging to reduce return rates, or shifting fulfillment method. Discontinuation should be the last step after these levers have been tested.

What's the difference between contribution margin and net profit? Contribution margin accounts for variable costs tied directly to a SKU, such as COGS, Amazon fees, and ad spend. Net profit also subtracts fixed overhead like software subscriptions, salaries, and warehousing contracts, giving a full picture of business-level profitability.

Do I need special software to run this audit, or can I use Amazon's native reports? Amazon's native Business Reports, Fulfilled Shipments Report, and Advertising Reports provide enough raw data to run a manual audit in a spreadsheet. Profitability software can automate the calculation and flag low-margin SKUs faster, which becomes more valuable as catalog size grows beyond 50-100 ASINs.

 
 
 

Comments


bottom of page