What Nobody Tells You About Your Best Seller
Table of Contents
- Why Best-Selling Products Hide Losses
- Most sellers track these costs at the account level, not the product level. That is where the hiding happens.
- What It Costs You When You Do Not Audit Per Product
- How to Run a Real Product Profitability Analysis
- Running This Audit Across Multiple Client Accounts
- Start With the Product You Trust Most
- Get Your Questions Answered (FAQ)
Your best-selling product gets the most orders, the most reviews, and the most attention. It feels like the backbone of your business. But what if it is actually draining your profit?
This happens more often than sellers expect. A product sells 500 units a month and looks healthy on the revenue line. Then you subtract referral fees, FBA fulfillment fees, storage fees, advertising spend, returns, and reimbursements Amazon or Walmart never processed. The number left over is not what you assumed.
The problem is not that these fees exist. The problem is that most sellers never see them broken down per product, per order, at the level where the math actually matters. They look at total revenue and total costs, and the real story stays buried.
This article walks through why this happens, what it costs you in margins and missed decisions, and how to run a real product audit that shows the full picture — across Amazon, Walmart, or both.
Why Best-Selling Products Hide Losses
High sales volume masks low margins because total revenue still looks large.
A product selling $25,000 a month in revenue feels profitable. But if your real margin on that product is 3% after all marketplace fees, you are keeping $750 — and spending hours of ad budget, inventory planning, and customer service to earn it. A slower-selling product with a 22% margin might be making you more money with less effort.
The gap between “revenue” and “profit” gets wider as fees stack up. Here is what most sellers miss when they look at a best-seller:
| Fee type | Visible in Seller Central summary? | Impact on best-sellers |
|---|---|---|
| Referral fee (8–45%) | Yes, but aggregated | Higher-priced items pay more per unit |
| FBA fulfillment fee | Yes, but not per-SKU by default | Oversize or heavy items cost 2–3× more |
| Monthly storage fee | Buried in payments report | Slow turns on a best-seller during Q4 spike fees |
| Long-term storage surcharge | Separate report | Hits any unsold inventory after 271 days |
| Advertising spend (PPC) | In advertising console, not P&L | Best-sellers often get the most ad spend |
| Return processing fee | Buried in returns report | High-return categories eat margin silently |
| Unprocessed reimbursements | Not visible until you file a claim | Lost/damaged inventory you never claimed back |
On Amazon, referral fees alone range from 8% to 45% depending on the category (source: Amazon 2026 fee schedule). On Walmart, referral fees follow a similar category-based structure, typically ranging from 6% to 20% (source: Walmart referral fee schedule). These are just the starting point. FBA pick-and-pack, monthly storage, long-term storage surcharges, return processing fees, and advertising costs pile on top.
Most sellers track these costs at the account level, not the product level. That is where the hiding happens.
When you only look at totals, a best-seller with thin margins gets averaged in with everything else. It never triggers a red flag, because the account-level number looks fine.
What It Costs You When You Do Not Audit Per Product
A product’s sales figures don’t always tell the full story. Once you account for every expense, a product that appears profitable may leave you with very little. Here’s what a per-product profitability breakdown can reveal.
Despite generating $17,994 in monthly revenue, this product delivers an estimated profit of $2,908.80, representing a margin of 16.2%. This calculation accounts for product costs, marketplace fees, advertising spend, storage and estimated return-related costs. Actual profitability may vary depending on refunds, inventory adjustments and other expenses.
How to Run a Real Product Profitability Analysis
Fixing this starts with seeing the actual numbers. There are three parts to a proper product profitability analysis.
Pull Per-Product P&L for Every SKU
Start by getting a profit-and-loss breakdown at the product level, not the account level. This means every fee — referral, fulfillment, storage, advertising, returns — attributed to each individual SKU.
In KwickMetrics, the P&L dashboard breaks this down automatically for every Amazon and Walmart account. You can see profit by product, by day, by marketplace — without building a spreadsheet. Each fee line is pulled from your actual seller account data, not estimated.
Once you can see profit per SKU, sort by margin percentage instead of revenue. The products at the bottom of that list are the ones hiding losses.
Ask Your Data the Questions Spreadsheets Cannot Answer
A P&L table shows you the numbers. But the real audit happens when you start asking questions the table was not designed for. Questions like: “Which of my products had the biggest margin drop in the last 90 days?” or “What is my real profit per unit on my top 5 sellers after ad spend?”
This is where talking to your data directly changes the process. KwickMetrics connects to Claude and ChatGPT through a protocol called MCP — Model Context Protocol. It lets you ask your live marketplace data a question in plain English, and get an answer pulled from your actual numbers. Not a template. Not a pre-built report. Your data, answering your question, in real time. It is free on every KwickMetrics plan.
Instead of exporting CSVs and building pivot tables, you type: “Show me every product where ad spend is more than 30% of revenue this month.” You get the answer in seconds, from your real data. That is the difference between running reports and actually understanding your business.
Set Margin Thresholds and Review Monthly
Once you have visibility, build a routine around it. Set a minimum margin threshold — say, 10% net — and flag every product that falls below it. Review monthly. For each flagged product, decide: raise the price, cut ad spend, renegotiate the supplier cost, or discontinue.
The fix is not always dramatic. Sometimes a 5% price increase or a $2 reduction in per-unit cost turns a break-even product into a real contributor. But you cannot make that call if you do not have the per-product numbers in front of you.
Running This Audit Across Multiple Client Accounts
For agencies managing 10, 30, or 100 seller accounts, the hidden-profit problem multiplies. Each client has their own fee structure, their own ad spend patterns, and their own products that may be quietly losing money.
Running a manual product profitability analysis across even 10 accounts takes days. You are logging into each account, exporting data, rebuilding the same calculations, and hoping nothing changed between exports. That is time you are not spending on strategy, optimization, or client retention.
With KwickMetrics, every client account — Amazon and Walmart — connects under one login with no per-account fees. The P&L dashboard applies to each account individually, so you can audit product margins across your entire portfolio without switching tools or rebuilding spreadsheets.
The MCP connection works across all accounts too. An agency manager can ask: “Which client accounts have products with margins below 5% this month?” and get a cross-account answer from live data. That is the kind of visibility that turns a reactive agency into one that catches problems before the client does.
When you can show a client that their best-selling product is actually their least profitable — and you found it before they did — that is how you keep accounts.
Start With the Product You Trust Most
Your best-selling product deserves the most scrutiny, not the least. High sales volume can hide thin margins, overlooked fees, misallocated ad spend, and time spent managing products that barely break even.
Start by getting a clear picture of your profit at the product level. Account for every cost, review your margins regularly, and identify the products that need attention. Whether you sell on Amazon, Walmart, or both, the goal is the same: understand what you actually earn, not just what you sell.
But analysing the numbers is only the first step. The real advantage comes from being able to explore your marketplace data whenever a question comes up.
That’s where KwickMetrics MCP makes things easier. Connect your KwickMetrics data to Claude or ChatGPT and ask questions in plain English. Find products with declining margins, investigate rising ad spend, or compare profitability across marketplaces without manually exporting reports.
Instead of waiting for your next spreadsheet review to uncover a problem, you can ask your data and get the insights you need to make better decisions.
Want to understand what’s really driving your product profitability? Explore KwickMetrics MCP and turn your marketplace data into answers you can act on.
See what your real profit looks like after every fee.
Get Your Questions Answered (FAQ)
Subtract all product-related costs from your revenue, including product cost, referral fees, FBA fees, storage, advertising spend, returns, and other expenses.
Calculate this for each SKU to understand your actual profit. KwickMetrics P&L dashboard automatically breaks down these costs. With KwickMetrics MCP, you can go a step further and ask Claude or ChatGPT questions about your profitability data, such as which products have the lowest margins.
Yes. High sales volume doesn't guarantee profitability. Referral fees, fulfilment costs, advertising spend, and returns can quickly eat into margins.
With KwickMetrics MCP, you can ask questions like "Which of my best-selling products generate the lowest profit?" and identify products that need attention.
MCP (Model Context Protocol) allows AI assistants like Claude and ChatGPT to connect with external data sources. KwickMetrics MCP connects your marketplace data to these AI assistants, letting you ask questions in plain English and get insights from your actual seller data without manually exporting reports.
The principle is the same: subtract all associated costs from product revenue. However, referral and fulfilment fees differ between Amazon and Walmart.
KwickMetrics supports P&L analysis for both marketplaces. With KwickMetrics MCP, you can also explore your Walmart data through Claude or ChatGPT and ask questions about product margins, costs, and profitability trends.
