> For the complete documentation index, see [llms.txt](https://docs.sellermagnet.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sellermagnet.com/dashboard-and-analytics/dashboard-overview/ordered-products.md).

# Ordered Products

{% hint style="info" %}
**Difficulty:** 🟡 Intermediate · **Reading time:** \~7 min
{% endhint %}

{% hint style="success" icon="rocket" %}
**Open this page in your dashboard:** [**Go to Ordered Products →**](https://dashboard.sellermagnet.com/dashboard/ordered-products)
{% endhint %}

![Ordered Products - Per-product sales performance dashboard](/files/9KVMF7gKx21FI7Hk2DST)

## 📋 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.

{% hint style="success" %}
**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.
{% endhint %}

{% hint style="info" %}
**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.
{% endhint %}

***

## 🎯 The Filter Bar

Five controls let you slice the data exactly the way you need it:

<table><thead><tr><th width="180">Filter</th><th>What it does</th></tr></thead><tbody><tr><td><strong>🛒 Marketplace</strong></td><td>Show data for one specific Amazon marketplace, or "All marketplaces" combined.</td></tr><tr><td><strong>📅 Date range</strong></td><td>Quick pills: <code>TD</code> Today, <code>YD</code> Yesterday, <code>L7D</code> Last 7 days, <strong><code>L30D</code> Last 30 days (default)</strong>, <code>MTD</code> Month-to-date, <code>YTD</code> Year-to-date, <code>L6M</code> Last 6 months, <code>L12M</code> Last 12 months, <code>LY</code> Last year, or <code>Custom</code> for a date picker.</td></tr><tr><td><strong>🔍 Search</strong></td><td>Filter by product name, SKU, or ASIN (Amazon Standard Identification Number). Live as you type.</td></tr><tr><td><strong>🏷️ Tags</strong></td><td>Multi-select by Product Tag (Bestsellers, Brand A, Slow Movers, etc.). Active tags appear as colored chips above the search bar.</td></tr><tr><td><strong>🔄 Compare</strong></td><td>Opens the Compare Products modal, pick 2-5 products to see them side by side with charts.</td></tr><tr><td><strong>📈 Compare pill</strong></td><td>A "Trends" toggle in the filter bar that turns period comparison on for the <em>whole table</em>. See below.</td></tr></tbody></table>

### 📈 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).

<table><thead><tr><th width="180">Column</th><th width="110">Type</th><th>What it shows</th></tr></thead><tbody><tr><td><strong>Product</strong></td><td>Image + text</td><td>Product image, name, and SKU. Sticky-left so you can always see which row you're reading. Includes a <strong>Copy ASIN</strong> button (see below).</td></tr><tr><td><strong>Units Sold</strong></td><td>Integer</td><td>Total units shipped in the date range (excluding refunded units).</td></tr><tr><td><strong>Refunds</strong></td><td>Integer</td><td>Number of units refunded in the date range.</td></tr><tr><td><strong>COG</strong></td><td>€</td><td>Cost of Goods per unit (from your Products page). If empty here, profit will be wrong.</td></tr><tr><td><strong>Avg Net Sale Price</strong></td><td>€</td><td>Average price you actually received per unit (after promo discounts, before fees).</td></tr><tr><td><strong>Net Sales Volume</strong></td><td>€</td><td>Total revenue collected (Units × Avg Net Price). Your top-line number.</td></tr><tr><td><strong>Net Sales Refunded</strong></td><td>€</td><td>Revenue paid back to customers as refunds (shown in red as a negative).</td></tr><tr><td><strong>Refund Rate (Units)</strong></td><td>%</td><td>Refunds ÷ Units. A bar visualizes the rate (green &#x3C; 5%, red >= 5%).</td></tr><tr><td><strong>Refund Rate (Revenue)</strong></td><td>%</td><td>Refunded revenue ÷ Net Sales Volume. Often differs from unit rate when refunded items are higher- or lower-priced than average.</td></tr><tr><td><strong>Shipping</strong></td><td>€</td><td>Total shipping costs paid (FBM) or charged (FBA inbound).</td></tr><tr><td><strong>Fees</strong></td><td>€</td><td>Total Amazon fees: referral, FBA fulfillment, storage, and other deductions.</td></tr><tr><td><strong>Net Profit</strong></td><td>€</td><td><strong>The big one.</strong> <code>Net Sales - Refunds - Shipping - Fees - (COG × Units)</code>. Green = positive, red = negative.</td></tr><tr><td><strong>Margin</strong></td><td>%</td><td>Net Profit ÷ Net Sales Volume. Your healthy-business early-warning system.</td></tr><tr><td><strong>Details</strong></td><td>Action</td><td>Opens the per-product breakdown modal with charts, daily volume, and a comparison view.</td></tr></tbody></table>

### Which column should I sort by?

Not sure where to start? Sort by the column that answers your question:

| I want to find...            | Sort this column        | Direction                  |
| ---------------------------- | ----------------------- | -------------------------- |
| 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) |

{% hint style="warning" %}
**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.
{% endhint %}

### 📋 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:

| Format    | When to use it                                                                   |
| --------- | -------------------------------------------------------------------------------- |
| **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:

{% stepper %}
{% step %}

### Summary cards

A 3-card row at the top showing key totals for that single product over the chosen date range: **Total Units**, **Net Profit**, and **Margin**.
{% endstep %}

{% step %}

### Performance chart

A 500px-tall chart plotting Units, Revenue, and Profit over time so you can spot trends, seasonal spikes, and post-promo dips summary view.
{% endstep %}

{% step %}

### Daily breakdown table

Day-by-day numbers below the chart for granular auditing, useful when investigating a specific bad day.
{% endstep %}

{% step %}

### Compare button

Opens the Compare Products modal pre-filled with this product. Add up to 4 more SKUs to benchmark side-by-side.
{% endstep %}
{% endstepper %}

***

## ⚖️ 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

{% hint style="info" %}
**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?".
{% endhint %}

***

## 💡 Pro Tips

{% hint style="success" %}
**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.
{% endhint %}

{% hint style="success" %}
**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.
{% endhint %}

{% hint style="success" %}
**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.
{% endhint %}

***

## 🎯 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.

| Step | Action                                                                                               | What to Look For                                          |
| ---- | ---------------------------------------------------------------------------------------------------- | --------------------------------------------------------- |
| 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

<details>

<summary><strong>Click to expand the mistakes table</strong></summary>

| Mistake                                                                        | Why It Hurts                                                                                                                                          |
| ------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| 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.                        |

</details>

***

## ✅ Best Practices

1. **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.
2. **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.
3. **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.
4. **Match the date range to the question.** Use `L30D` for recent trends, `MTD` for the current month in progress, and `L12M` monthly for a full annual Pareto audit.
5. **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.
6. **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

<details>

<summary><strong>Why don't I see all my products in the list?</strong></summary>

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.

</details>

<details>

<summary><strong>Why is my Net Profit negative on a product I'm "selling well"?</strong></summary>

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.

</details>

<details>

<summary><strong>How accurate is Net Sales Volume?</strong></summary>

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.

</details>

<details>

<summary><strong>Can I export this table to CSV/Excel?</strong></summary>

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.

</details>

<details>

<summary><strong>Why do the Refund Rate (Units) and Refund Rate (Revenue) columns differ?</strong></summary>

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.

</details>

<details>

<summary><strong>Is the data live?</strong></summary>

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.

</details>

***

## ➡️ What's Next?

{% content-ref url="/pages/nXtCVcpldqI1cfeA606R" %}
[Orders Analytics](/dashboard-and-analytics/dashboard-overview/orders-analytics.md)
{% endcontent-ref %}

{% content-ref url="/pages/QUfddxcjTGMwmLVQVH0o" %}
[Refunded Orders](/dashboard-and-analytics/dashboard-overview/refunded-orders.md)
{% endcontent-ref %}