Ordered Products
Per-product sales performance for every product you've sold, units, refunds, COG, fees, net profit, and margin. The fastest way to spot your best earners and your hidden money-losers.
Difficulty: 🟡 Intermediate · Reading time: ~7 min
Open this page in your dashboard: Go to Ordered Products →
📋 Overview
The Ordered Products page aggregates every order in your selected date range into a per-product view. Where the Orders Overview shows individual transactions, this page shows you the bigger picture: how each SKU (Stock Keeping Unit) is actually performing, units sold, refund rate, fees, and the all-important net profit and margin columns.
Use this page to: Identify your top revenue earners, spot low-margin products eating into profit, find products with abnormally high refund rates, and make data-driven keep/kill decisions.
Per-product, not per-order. A single product that sold 412 units across 380 orders appears as one row. Click the row to see a per-product breakdown over time, charts, and a comparison view.
🎯 The Filter Bar
Five controls let you slice the data exactly the way you need it:
🛒 Marketplace
Show data for one specific Amazon marketplace, or "All marketplaces" combined.
📅 Date range
Quick pills: TD Today, YD Yesterday, L7D Last 7 days, L30D Last 30 days (default), MTD Month-to-date, YTD Year-to-date, L6M Last 6 months, L12M Last 12 months, LY Last year, or Custom for a date picker.
🔍 Search
Filter by product name, SKU, or ASIN (Amazon Standard Identification Number). Live as you type.
🏷️ Tags
Multi-select by Product Tag (Bestsellers, Brand A, Slow Movers, etc.). Active tags appear as colored chips above the search bar.
🔄 Compare
Opens the Compare Products modal, pick 2-5 products to see them side by side with charts.
📈 Compare pill
A "Trends" toggle in the filter bar that turns period comparison on for the whole table. See below.
📈 Period-Compare Pill
Separate from the multi-product Compare modal above, the filter bar carries a small compare pill, a Trends toggle with a "vs Previous Period" selector next to it. Flip the toggle on (it turns green) and every row in the table gains a trend indicator that measures the current date range against the previous comparable period, so you can see at a glance which products are moving up or down without opening any modal. The pill's config menu lets you choose what to compare against (a previous time period, or another marketplace). It compares the entire table at once, whereas the Compare modal is for benchmarking a handful of hand-picked SKUs side by side.
📊 The 13-Column Table
This is the heart of the page. Every column is sortable (click the header).
Product
Image + text
Product image, name, and SKU. Sticky-left so you can always see which row you're reading. Includes a Copy ASIN button (see below).
Units Sold
Integer
Total units shipped in the date range (excluding refunded units).
Refunds
Integer
Number of units refunded in the date range.
COG
€
Cost of Goods per unit (from your Products page). If empty here, profit will be wrong.
Avg Net Sale Price
€
Average price you actually received per unit (after promo discounts, before fees).
Net Sales Volume
€
Total revenue collected (Units × Avg Net Price). Your top-line number.
Net Sales Refunded
€
Revenue paid back to customers as refunds (shown in red as a negative).
Refund Rate (Units)
%
Refunds ÷ Units. A bar visualizes the rate (green < 5%, red >= 5%).
Refund Rate (Revenue)
%
Refunded revenue ÷ Net Sales Volume. Often differs from unit rate when refunded items are higher- or lower-priced than average.
Shipping
€
Total shipping costs paid (FBM) or charged (FBA inbound).
Fees
€
Total Amazon fees: referral, FBA fulfillment, storage, and other deductions.
Net Profit
€
The big one. Net Sales - Refunds - Shipping - Fees - (COG × Units). Green = positive, red = negative.
Margin
%
Net Profit ÷ Net Sales Volume. Your healthy-business early-warning system.
Details
Action
Opens the per-product breakdown modal with charts, daily volume, and a comparison view.
Which column should I sort by?
Not sure where to start? Sort by the column that answers your question:
My best earners
Net Profit
Descending (highest first)
My worst margins
Margin
Ascending (lowest first)
Products with quality issues
Refund Rate (Units)
Descending (highest first)
COG missing? Profit numbers lie. If a product has no Cost of Goods entered, the Net Profit column will overstate reality (it only subtracts Amazon's fees). The quickest fix is right here: click the blue COG missing badge on that product's row to open the batch entry and record your cost. You can also manage costs in bulk on the Products page. Once a cost is set, return here for accurate numbers.
📋 Copy ASIN
The Product column includes a small Copy ASIN button (tooltip: Copy ASIN to clipboard). Click it to copy the product's ASIN straight to your clipboard, the button briefly turns into a green checkmark to confirm. This is handy for pasting an ASIN into Seller Central, a competitor lookup, or a supplier message without leaving the page.
📤 Export
The Ordered Products table has its own export menu offering two formats:
CSV
Universal plain-text format for accounting tools, other software, or automation.
Excel
Native .xlsx workbook that opens straight into Microsoft Excel.
The export respects your current marketplace, date range, search, and tag filters. It is the same unified CSV/Excel control used across the dashboard.
🔬 Product Details Modal
Click any row (or the Details icon) to open the per-product detail view:
⚖️ Compare Products
The Compare button (top-right of the filter bar, or inside any product detail) opens a side-by-side view for up to 5 products:
Charts grid: Units, Revenue, Profit, and Margin lines overlaid for every selected product
Comparison table: KPI rows so you can scan totals quickly
Tag filter: narrow comparison candidates to one tag group (e.g. compare all "Bestsellers")
Empty state: friendly icon + message until you've selected at least 2 products
When to use Compare: A/B-style decisions like "should I keep the cheap variant or the premium variant?", "which two SKUs are cannibalizing each other?", or "is my new launch outperforming the old one yet?".
💡 Pro Tips
Sort by Margin ascending to find your worst-performing products. Anything below 15% margin needs investigation, usually it's a fee structure problem or a missing COG entry.
Sort by Refund Rate (Units) descending to find quality issues. A product above 8% refund rate is hurting your account health and your margins simultaneously, fix the listing or kill the SKU.
Use the L12M range monthly for an annual product audit. Identify which 20% of your SKUs generate 80% of profit (Pareto), then double down on them with PPC and Inventory Planner.
🎯 Real-World Scenario: A Best-Seller Quietly Losing Ground
Situation: One of your core SKUs feels fine, it still sells every day, but your overall profit is down and you cannot pin the cause. Use this page to isolate it in a few clicks.
1
Set the Date range to L30D, then note the numbers, and switch to the prior month with Custom
Month-over-month movement per product
2
Search the product name or SKU to isolate the single row
One clean row to read
3
Read Units Sold, Net Sales Volume, and Net Profit for each period
Where the drop actually lands
4
Sort by Refund Rate (Units) descending
Whether returns are eating the units
5
Check the Margin column against last month
A shrinking margin points at fees or COG, not just volume
6
Click Details to open the per-product breakdown and read the daily chart
The exact day the trend turned
Before (last month): 412 Units Sold, €8,240 Net Sales Volume, €1,690 Net Profit, 20.5% Margin, 3.1% Refund Rate (Units).
After (this month, L30D): 358 Units Sold, €7,160 Net Sales Volume, €760 Net Profit, 10.6% Margin, 7.8% Refund Rate (Units).
Reading it: Units fell only 13%, but Net Profit nearly halved. The Margin column collapsed from 20.5% to 10.6% while the Refund Rate (Units) more than doubled to 7.8%. The problem is not demand, it is returns and their knock-on Fees. The Details daily breakdown shows the refunds clustering after a mid-month price promotion. Action: review the listing and promo that triggered the returns, confirm the COG on the row is current, and re-check the Margin next week before deciding to keep or kill the SKU.
⚠️ Common Mistakes to Avoid
Click to expand the mistakes table
Sorting only by Net Sales Volume
A high top-line number can hide a thin or negative Margin, you end up celebrating a product that loses money on every unit.
Leaving COG blank
Net Profit and Margin only subtract Amazon's fees, so both columns overstate reality and every keep/kill decision is built on a false number.
Ignoring the gap between Refund Rate (Units) and Refund Rate (Revenue)
When the two diverge, your high-priced variant is often the one being returned, reading only the unit rate masks the real revenue damage.
Judging a product on the default L30D window alone
A slow-moving SKU with seasonal or FBA storage costs looks fine short-term, only a L12M view reveals the true annual picture.
Reading Net Profit without checking Fees and Shipping
Rising fulfillment or referral costs can quietly erode profit even when Units and revenue hold steady.
Comparing products by eye across scattered rows
Guesswork invites the wrong conclusion, the Compare modal overlays them on the same axis so the difference is unambiguous.
✅ Best Practices
Lead with Net Profit and Margin, not revenue. Sort by Net Profit descending to find true earners, then sort Margin ascending to expose the ones quietly losing money.
Fix every COG-missing badge first. Before you trust any profit read, click the blue COG missing badge on affected rows so Net Profit and Margin reflect reality.
Read both refund columns together. Compare Refund Rate (Units) against Refund Rate (Revenue), the gap tells you whether your expensive variants are the ones coming back.
Match the date range to the question. Use
L30Dfor recent trends,MTDfor the current month in progress, andL12Mmonthly for a full annual Pareto audit.Use Details before deciding. Open the per-product modal to read the daily chart and confirm exactly when a trend turned, rather than acting on a single aggregate number.
Export with your filters set. The CSV/Excel export respects your active marketplace, date range, search, and tag filters, so slice the table first, then hand a clean file to your accountant.
❓ FAQ
Why don't I see all my products in the list?
Only products that had at least one order in the selected date range appear here. To see all products in your catalog (including never-sold ones), visit Products in the sidebar.
Why is my Net Profit negative on a product I'm "selling well"?
Most common cause: missing or wrong COG. Second most common: high refund rate combined with restocking fees. Third: FBA storage fees silently eating into low-velocity items. Click the row to see the daily breakdown, that usually reveals the cause.
How accurate is Net Sales Volume?
Very. SellerMagnet pulls from Amazon's Settlement Reports, which are the same numbers Amazon uses to pay you. The page reconciles to within €0.01 of your settlements after the relevant period closes.
Can I export this table to CSV/Excel?
Yes. Use the export menu on this page (file-export icon) and choose CSV or Excel. The export uses your current filters. For scheduled or recurring exports, the Reports page in the sidebar offers additional options.
Why do the Refund Rate (Units) and Refund Rate (Revenue) columns differ?
Because refunded items are not always priced at the average. If your high-priced variant has a higher refund rate than your low-priced variant, the revenue rate will be HIGHER than the units rate. Use both numbers, the gap between them is itself diagnostic.
Is the data live?
Settlement-grade data lags Amazon's reporting by a few hours. Order-level data (Today, Yesterday) is typically updated within minutes via the Orders API. The page header shows a counter and a refresh button to pull the latest snapshot.
➡️ What's Next?
Orders AnalyticsRefunded OrdersLast updated