# Orders Overview
{% hint style="info" %}
**Difficulty:** ๐ข Beginner ยท **Reading time:** \~10 min
{% endhint %}
{% hint style="success" icon="rocket" %}
**Open this page in your dashboard:** [**Go to Orders Overview โ**](https://dashboard.sellermagnet.com/dashboard/orders)
{% endhint %}
The **Orders Overview** page gives you complete visibility into every order and ordered product across all your connected Amazon marketplaces. It combines the Orders table with advanced filtering, an insights panel, and a detailed breakdown side panel, everything you need to manage and analyze your order flow.
{% hint style="info" %}
This page covers both the **Orders** view (`Dashboard > Orders`) and the **Ordered Products** view (`Dashboard > Ordered Products`). They share the same filtering and breakdown capabilities but present data at different granularity levels.
{% endhint %}
***
## ๐ฅ Video Walkthrough
{% hint style="info" %}
**Video tutorial coming soon.** A full guided walkthrough of this feature will be available here shortly.
{% endhint %}
***
## ๐๏ธ Page Structure
The Orders page is organized into these key sections:
| Section | Purpose |
| -------------------------- | ----------------------------------------------------------------------------------------- |
| **Insights Panel** | Three cards showing fulfillment split, B2B metrics, and country distribution |
| **Filter Bar** | Date range, marketplace, search, status filters, and tag filters |
| **Orders Table** | Paginated table with sortable columns for every order |
| **Breakdown Panel** | Slide-out financial decomposition (toggle via the breakdown button) |
| **Ordered Products Table** | Product-level aggregation with per-SKU (Stock Keeping Unit) metrics, tags, and comparison |
***
## Order Insights Panel
At the top of the page, three insight cards provide a quick visual summary of your orders:
### Fulfillment Split Card
| Metric | Description |
| ------- | ------------------------------------------------------ |
| **FBA** | Percentage and count of orders fulfilled by Amazon |
| **FBM** | Percentage and count of orders fulfilled by the seller |
A horizontal bar chart visually represents the FBA/FBM ratio.
### B2B Breakdown Card
| Metric | Description |
| -------------- | --------------------------------------------------- |
| **B2B Orders** | Percentage and count of business-to-business orders |
| **B2C Orders** | Percentage and count of standard consumer orders |
{% hint style="success" icon="rocket" %}
**Pro Tip:** If B2B orders represent a significant share (>15%) of your volume, consider enabling Amazon Business pricing and quantity discounts to attract more corporate buyers.
{% endhint %}
### Country Distribution Card
Shows a scrollable list of countries with:
* Country flag
* Country name
* Percentage bar
* Order count
This helps you identify which marketplaces or regions drive the most volume.
***
## ๐ Filter Bar
The filter bar provides multiple ways to narrow down your order view:
### Date Range Selector
| Option | Period |
| -------------- | ----------------------------------------------- |
| Today | Current calendar day |
| Yesterday | Previous calendar day |
| Last 7 Days | Rolling 7-day window |
| Last 30 Days | Rolling 30-day window |
| This Month | 1st of current month to today |
| This Year | January 1st to today |
| Last 6 Months | Rolling 6-month window |
| Last 12 Months | Rolling 12-month window |
| Last Year | Full previous calendar year |
| Custom | Opens date picker for arbitrary start/end dates |
### Marketplace Selector
Filter orders by a specific Amazon marketplace or view all marketplaces combined.
### Search
Type any of the following to instantly filter the table:
* Product name or title
* ASIN (Amazon Standard Identification Number)
* SKU
* Order ID
### Status Filter (Filter Icon)
Click the **filter icon** button to open a dropdown with status-based filters:
| Filter Group | Options |
| ---------------- | -------------------------------------- |
| **Order Status** | Shipped, Pending, Cancelled, Unshipped |
| **Fulfillment** | FBA, FBM |
| **Financial** | Profitable, Unprofitable |
Active filters are indicated by a red badge on the filter icon button. Use the **Clear** button at the bottom of the dropdown to reset all filters.
{% hint style="warning" %}
Multiple filters are combined with AND logic. For example, selecting "FBA" and "Shipped" shows only FBA orders that have been shipped. Be mindful that overly narrow filters may return zero results.
{% endhint %}
***
## Orders Table
The main orders table displays one row per order with the following columns:
| Column | Description | Sortable |
| ----------------------------- | --------------------------------------------- | -------- |
| **Product** | Product image, title, ASIN, and SKU | Yes |
| **Fulfillment** | FBA or FBM badge | Yes |
| **Date** | Order purchase date and time | Yes |
| **Status** | Current order status (Shipped, Pending, etc.) | Yes |
| **Qty** | Quantity of units ordered | Yes |
| **Unit Price** | Per-unit selling price | Yes |
| **Amazon Fees** | Total Amazon fees (referral, FBA, etc.) | Yes |
| **Refunded** | Refund amount if applicable | Yes |
| **COGS (Cost of Goods Sold)** | Cost of Goods Sold from batch data | Yes |
| **Total** | Net revenue after all deductions | Yes |
| **Profit** | Calculated profit | Yes |
| **Margin %** | Profit margin as a percentage | Yes |
| **ROI %** | Return on investment as a percentage | Yes |
### Sorting
Click any column header to sort. Click again to reverse the sort direction. A sort arrow indicator shows the current sort column and direction.
### Pagination
The table supports pagination with configurable page sizes. Navigation controls appear at the bottom of the table.
***
## Breakdown Panel
The Breakdown Panel is a slide-out side panel that provides a detailed financial decomposition.
### How to Open It
Click the **pie chart icon** (breakdown button) in the table header to toggle the panel open/closed.
{% hint style="info" %}
The Breakdown Panel is hidden by default on screens narrower than 1400px to preserve table readability. On smaller screens, use the product click interaction to view individual breakdowns.
{% endhint %}
### What the Breakdown Shows
| Section | Details |
| --------------- | ------------------------------------------------- |
| **Revenue** | Gross sales, item price, shipping price |
| **Amazon Fees** | Referral fee, FBA fee, variable closing fee, etc. |
| **Promotions** | Discounts, coupons, and promotional deductions |
| **COGS** | Cost of goods from batch data |
| **Expenses** | Allocated general expenses per order |
| **Net Profit** | Final profit after all deductions |
You can view the breakdown for:
* **A specific order** by clicking on a row in the table
* **All orders** in the current filtered view (aggregated breakdown)
***
## Ordered Products View
The Ordered Products page (`Dashboard > Ordered Products`) presents data aggregated at the product level rather than the order level.
### Table Columns
| Column | Description |
| --------------- | ----------------------------------------------- |
| **Product** | Product image, title, ASIN, SKU (sticky column) |
| **Units Sold** | Total quantity sold in the selected period |
| **Revenue** | Total gross revenue from this product |
| **Amazon Fees** | Total fees charged for this product |
| **COGS** | Total cost of goods sold |
| **Profit** | Total net profit |
| **Margin %** | Average profit margin |
| **ROI %** | Average return on investment |
| **Tags** | Product tags/categories assigned by the user |
### Tag Filtering
The Ordered Products view includes a **tag filter** system:
1. Click the **tag filter button** next to the search bar
2. A dropdown appears showing all available tags grouped by category
3. Select one or more tags to filter the table
4. Active tag filters appear as colored chips above the table
5. Click the **X** on any chip to remove that filter
6. Use **Clear All** at the bottom of the dropdown to reset
{% hint style="success" icon="rocket" %}
**Pro Tip:** Use tags to create product categories like "Private Label," "Wholesale," or "Q4 Seasonal" to quickly segment your analysis. Tags are managed in the Products Management section.
{% endhint %}
### Product Comparison
The Ordered Products view supports a **Compare** feature:
1. Select two or more products using the comparison selector
2. A comparison modal opens showing side-by-side metrics
3. Compare revenue, profit, margin, ROI, and units sold
4. Useful for A/B testing product variations or evaluating sourcing decisions
### Inline Breakdown Rows
Click on any product row to expand an inline **breakdown card** showing the detailed financial decomposition for that specific product, including:
* Revenue breakdown
* Fee breakdown by type
* COGS and expense allocation
* Net profit calculation
***
## ๐ฃ Step-by-Step: Finding Your Most Profitable Orders
1. Navigate to **Dashboard > Orders**.
2. Set the date range to **Last 30 Days**.
3. Click the **Margin %** column header to sort descending (highest margin first).
4. Review the top 10 orders: these are your most profitable transactions.
5. Open the **Breakdown Panel** to see what makes these orders profitable.
6. Switch to the **Ordered Products** tab to see the same data aggregated by product.
7. Sort by **Profit** descending to identify your top profit-generating products.
***
## ๐ค Step-by-Step: Exporting Order Data
1. Set your desired **date range** and **marketplace** filters.
2. Apply any additional **status filters** as needed.
3. Click the **Export** button (file export icon) in the filter bar.
4. The system generates a CSV file containing all orders matching your current filters.
5. The file downloads automatically to your browser's default download location.
{% hint style="warning" %}
Export files contain all columns visible in the table, including financial data. Handle exported files securely, especially if they contain COGS or profit information.
{% endhint %}
***
## ๐ฏ Real-World Scenario: Investigating High Refund Rates
**Situation:** You notice your refund count has increased by 40% this month.
| Step | Action | What to Look For |
| ---- | ----------------------------------------------------------------- | ----------------------------------------------- |
| 1 | Set date range to **This Month** | Overall refund count in the insights panel |
| 2 | Click the filter icon and select **Refunded** status | Only refunded orders visible |
| 3 | Sort by **Date** descending | Check if refunds cluster around a specific date |
| 4 | Sort by **Product** to group | Identify if one product drives most refunds |
| 5 | Switch to **Ordered Products** and sort by units sold vs. refunds | Calculate per-product refund rate |
| 6 | Check **Country Distribution** in insights | See if refunds come from a specific region |
**Before:** "Refunds are up 40%, I do not know why." **After:** "Product X (ASIN B08XXXXX) has a 22% refund rate from Amazon.co.uk due to size issues reported in 8 of 12 returns."
***
โ ๏ธ Common Mistakes to Avoid
| Mistake | Impact | Better Approach |
| --------------------------- | ---------------------------------------------------- | ---------------------------------------------------------- |
| Not using date filters | Viewing all-time data is slow and hard to analyze | Always set a relevant date range |
| Ignoring the Insights Panel | Missing fulfillment and geographic trends | Check the three insight cards before diving into the table |
| Sorting only by revenue | High-revenue products may have low margins | Sort by Margin % or ROI % for profitability insights |
| Not using tags on products | Cannot segment or categorize product analysis | Create and assign tags for all product lines |
| Forgetting to update COGS | Profit, margin, and ROI columns show inaccurate data | Update batches whenever you receive new inventory |
\## โ
Best Practices
1. **Daily check:** Review today's orders each morning to catch anomalies early (wrong prices, unexpected cancellations).
2. **Weekly analysis:** Use the 7-day view to identify trends in order volume, refund rates, and margin shifts.
3. **Use filters aggressively:** Combine date range + marketplace + status to answer specific questions.
4. **Use tags:** Tag products by supplier, category, season, or margin tier for segmented analysis.
5. **Export regularly:** Download monthly order data for your accountant or for offline analysis.
6. **Compare products:** Use the comparison feature to evaluate product performance side by side.
***
## โ FAQ
How quickly do new orders appear in the table?
Orders typically appear within 15-30 minutes of being placed on Amazon. The exact timing depends on Amazon's SP-API (Selling Partner API) data propagation.
Can I filter orders by multiple statuses at once?
Yes. Open the filter dropdown and select multiple status options. They are combined with OR logic within the same filter group (e.g., "Shipped OR Pending") and AND logic across groups (e.g., "FBA AND Shipped").
Why do some orders show EUR 0.00 for COGS?
This means no product batch has been created for that product. Navigate to Products Management and add a batch with your purchase price to see accurate COGS and profit calculations.
Can I search by Amazon Order ID?
Yes. Paste the full Amazon Order ID into the search bar and it will filter to that specific order.
How does the Country Distribution work for multi-marketplace sellers?
The country distribution shows the actual shipping destination country, not the marketplace. An order on Amazon.de shipping to Austria will appear under "AT" in the country distribution.
What is the difference between the Orders tab and the Ordered Products tab?
The **Orders** tab shows one row per order transaction. The **Ordered Products** tab aggregates data by product SKU/ASIN, showing totals for units sold, revenue, and profit per product across all orders.
Can I customize which columns are visible in the table?
The table displays all standard columns. You can resize columns by dragging the column borders in the Ordered Products table. Column visibility customization is on the product roadmap.
***
## โก๏ธ What's Next?
{% content-ref url="/pages/0edov7P7zB9nAFkgZ1WO" %}
[Ordered Products](/dashboard-and-analytics/dashboard-overview/ordered-products.md)
{% endcontent-ref %}
{% content-ref url="/pages/nXtCVcpldqI1cfeA606R" %}
[Orders Analytics](/dashboard-and-analytics/dashboard-overview/orders-analytics.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/orders-overview.md?ask=
```
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.