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.
📊 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.
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.
COG missing? Profit numbers lie. If a product has no Cost of Goods entered on the Products page, the Net Profit column will overstate reality (it only subtracts Amazon's fees). Visit Products → bulk upload COGS (Cost of Goods Sold) → return here for accurate numbers.
🔬 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.
❓ 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 Reports page in the sidebar to schedule or download an Ordered Products export with the same columns and filters.
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