Orders Overview
Monitor, filter, and analyze every Amazon order across all marketplaces. View order details, fulfillment insights, country breakdowns, B2B metrics, and export data for accounting or further analysis.
Difficulty: 🟢 Beginner · Reading time: ~10 min
Open this page in your dashboard: Go to Orders Overview →
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.
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.
🎥 Video Walkthrough
Video tutorial coming soon. A full guided walkthrough of this feature will be available here shortly.
🗂️ Page Structure
The Orders page is organized into these key sections:
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
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
B2B Orders
Percentage and count of business-to-business orders
B2C Orders
Percentage and count of standard consumer orders
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.
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
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:
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.
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.
Orders Table
The main orders table displays one row per order with the following columns:
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.
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.
What the Breakdown Shows
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
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:
Click the tag filter button next to the search bar
A dropdown appears showing all available tags grouped by category
Select one or more tags to filter the table
Active tag filters appear as colored chips above the table
Click the X on any chip to remove that filter
Use Clear All at the bottom of the dropdown to reset
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.
Product Comparison
The Ordered Products view supports a Compare feature:
Select two or more products using the comparison selector
A comparison modal opens showing side-by-side metrics
Compare revenue, profit, margin, ROI, and units sold
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
Navigate to Dashboard > Orders.
Set the date range to Last 30 Days.
Click the Margin % column header to sort descending (highest margin first).
Review the top 10 orders: these are your most profitable transactions.
Open the Breakdown Panel to see what makes these orders profitable.
Switch to the Ordered Products tab to see the same data aggregated by product.
Sort by Profit descending to identify your top profit-generating products.
📤 Step-by-Step: Exporting Order Data
Set your desired date range and marketplace filters.
Apply any additional status filters as needed.
Click the Export button (file export icon) in the filter bar.
The system generates a CSV file containing all orders matching your current filters.
The file downloads automatically to your browser's default download location.
Export files contain all columns visible in the table, including financial data. Handle exported files securely, especially if they contain COGS or profit information.
🎯 Real-World Scenario: Investigating High Refund Rates
Situation: You notice your refund count has increased by 40% this month.
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
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
Daily check: Review today's orders each morning to catch anomalies early (wrong prices, unexpected cancellations).
Weekly analysis: Use the 7-day view to identify trends in order volume, refund rates, and margin shifts.
Use filters aggressively: Combine date range + marketplace + status to answer specific questions.
Use tags: Tag products by supplier, category, season, or margin tier for segmented analysis.
Export regularly: Download monthly order data for your accountant or for offline analysis.
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?
Ordered ProductsOrders AnalyticsLast updated