How to Track Amazon Sales by SKU (and Why You Should)

Why per-SKU tracking matters

Account-level metrics are misleading. Your account might show $40,000 in monthly revenue and a healthy overall margin, but that number hides the reality: 3 products are generating all your profit, 2 are breaking even, and 2 are actively losing money. Without per-SKU tracking, you can't see which products to scale, fix, or cut.

This problem gets worse as your catalog grows. A 10-SKU business can be managed with mental math. A 50-SKU business needs systematic tracking. At 100+ SKUs, per-SKU profitability analysis isn't optional; it's the difference between growing profitably and growing yourself into a cash flow problem.

The most dangerous scenario is a "revenue winner, margin loser." A product doing $15,000/month in revenue looks great in your top-line numbers, but if PPC costs eat 25% of revenue and the return rate is 12%, the per-unit margin might be negative. You're paying Amazon for the privilege of selling that product. Only per-SKU tracking reveals this.

Metrics to track per SKU

For each SKU in your catalog, track these metrics monthly (weekly for your top 10 products):

• Revenue: Gross sales for the SKU. The starting point for all calculations.
• Units sold: Volume matters. High revenue on low volume means premium pricing (good). High volume on low revenue means commodity pricing (higher risk).
• COGS per unit: Your landed product cost including manufacturing, shipping to Amazon, prep, and labeling.
• Amazon fees per unit: Referral fee (typically 15%), FBA fulfillment fee, and monthly storage fees. These vary by product size and weight.
• PPC spend: Advertising cost attributed to this SKU. The most variable cost and often the one that turns profitable products into losers.
• Return rate and refund cost: Returns cost double: you lose the sale and pay for return processing. A 10% return rate on a low-margin product can destroy profitability.
• True net margin: Revenue minus all costs above. This is the number that actually matters. See our guide on calculating true profit margin.
• Per-SKU ACoS: How much advertising costs relative to that product's ad revenue. Compare this to your break-even ACoS for each product.

Finding hidden losses

Per-SKU analysis consistently reveals surprises. Here are the most common hidden loss patterns:

The PPC drain. A product with healthy organic sales and a 25% margin looks profitable until you account for PPC. If you're spending $800/month on ads for a product that generates $3,000 in revenue, your PPC alone takes 27% of revenue. Add Amazon fees and COGS, and you might be underwater. The fix: optimize PPC efficiency using AI-powered optimization or reduce spend if the product can sustain organic sales.

The return rate killer. Products with return rates above 10% are margin destroyers. Each return costs you the sale, the FBA return processing fee, and often the product can't be resold. A $30 product with a 15% return rate loses roughly $4.50 per unit sold in return-related costs. Track return rates per SKU and investigate spikes immediately. See our guide on reducing return rates.

The storage fee creep. Slow-moving inventory accumulates storage fees that don't show up in your per-unit economics until they've eaten your margin. Products with inventory turnover below 4x per year are at risk, especially with Amazon's aged inventory surcharges.

The promotional giveaway. Coupons and promotions reduce your effective revenue per unit. A $5 coupon on a $30 product drops your revenue by 17%. If you're also running PPC to the coupon listing, the combined discount plus ad cost might leave you with single-digit margins.

Portfolio decisions from SKU data

Once you have per-SKU profitability data, you can make informed portfolio decisions instead of guessing:

Scale winners. Products with margins above 25% and healthy sales velocity deserve more investment: increased PPC budget, listing optimization, variation expansion, and international expansion.

Fix breakeven products. Products between 5-15% margin might be fixable. Common fixes: optimize PPC to reduce ad spend, improve listing to increase conversion rate (more sales on the same ad spend), negotiate lower COGS with your supplier, or reduce returns by addressing product quality issues.

Cut losers. Products with negative margins and no clear path to profitability should be discontinued. Every month you keep a money-losing product in your catalog, you're subsidizing it with profits from your winners. Liquidate remaining inventory and reallocate that capital and attention to products that actually make money.

Price adjustments. Per-SKU data might reveal that a small price increase (even $1-2) would significantly improve margins without meaningfully impacting conversion rate. Test it. The Business Report will show if conversion rate drops after the price change.

Automating SKU-level tracking

Building per-SKU P&L reports manually means downloading multiple reports (Business Reports, PPC reports, settlement reports, return reports), combining them in a spreadsheet, and calculating margins. This takes 2-3 hours per week for a 30-SKU catalog.

Automated tracking pulls all data sources via the SP-API, calculates per-SKU profitability daily, and delivers the analysis on your schedule. You review the results instead of building the reports.

• Automatic per-SKU P&L calculation including all costs (fees, PPC, returns, promotions)
• Margin alerts when any SKU drops below your threshold
• Trend analysis showing which SKUs are improving or declining
• Weekly or monthly reports delivered to Slack, email, or Google Sheets

The ROI on automated SKU tracking is usually immediate. Just identifying and fixing (or cutting) one money-losing product typically pays for the automation several times over.