# 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></tbody></table>

***

## 📊 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.</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>

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

***

## 🔬 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 %}

***

## ❓ 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 **Reports** page in the sidebar to schedule or download an Ordered Products export with the same columns and filters.

</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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sellermagnet.com/dashboard-and-analytics/dashboard-overview/ordered-products.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.