The sales order report provides you the key metrics and detailed behaviour of the sales at the selected marketplaces and period.
Here is the list what you can get from the sales order report,
- Total orders
- Shipped orders
- Pending orders
- Est. net profit
- Sales Overview with Comparison
- Sales order list
- Order Details
- Net Profit Split Up
It shows the total count of shipped and pending orders. This info card has a mini graph that represents the data of the total orders at a particular point throughout the selected period.
It shows the total count of the orders which are processed and delivered to the buyer (i.e. Orders with shipped status). This info card has a mini graph that represents the data of the shipped orders at a particular point throughout the selected period.
It shows the total count of the orders which are yet to be processed and delivered to the buyer (i.e. orders with pending status). This info card has a mini graph that represents the data of the pending orders at a particular point throughout the selected period.
Unlike total and shipped orders percentage values, pending orders should be less than the previous period to indicate a positive value.
It shows the total count of units sold from the total orders. This info card has a mini graph that represents the data of the total units sold at a particular point throughout the selected period.
It shows the approximate total sales amount generated from all the sold units. This info card has a mini graph that represents the data of the total revenue generated at a particular point throughout the selected period. The revenue will be shown in the currency which is selected in the company profile.
Est. net profit
It shows the total estimated net profit by reducing the amazon fees and taxes from the Revenue.
I.e: Estimated net Profit = Revenue - Cost
Here, Cost = Amazon fees + Promotions + COP + Expenses
This info card has a mini graph that represents the data of the estimated net profit at a particular point throughout the selected period.
Mini graph in the info cards are displayed based on the given period filter.
If data is viewed with the “Last 7 days” filter, then the mini graph shows 7 points (1 point for each day).
If data is viewed with “Today / Yesterday” filter, then the mini graph shows 24 points (1 point for each hour).
Sales Overview with Comparison
Sales Overview with Comparison is the simple line chart that displays sales trends metrics like units and revenue of the selected marketplaces and period with a previous period comparison.
You can view, either unit or revenue at a time. You can switch among Orders, Units and Revenue from options provided at the top right corner of the chart. On hover over the bars in the charts, you can get its detailed numbers in the current and previous periods.
You can group the data in the chart by Hour, by Day, by Week, and by Month. The grouping options are available based on the selected period in the top left corner of the trends comparison chart.
This Month filter, you will have Group by Day and Group by Week options
This Year filter, you will have Group by Week and Group by Month options
You can filter data in the info cards, trends comparison chart, and list with the help of a wide variety of default filters. The number of filters is varies based on the report you are looking at currently.
For sales orders report, we have, Units, Revenue, Estimated net profit, Tag, Marketplace order ID, Payment method, Fulfillment channel, Status, Order Type, SKU, Buyer Email and Countries filters. You can apply any combination of filters to get fine-grained data.
After you apply the filters, click the Save button at the top right of the filter modal for future use. So that you can apply saved complex filters in 2 clicks whenever you need it in the future.
Sales order list
These are the list of columns that can be included in the sales order report table.
|Order ID||Amazon defined unique ID for the order||113-9517201-4212232|
|Purchased||The purchased date of the order||02 Jun 2020|
|Status||The status of the order||Possible values would be Pending, Shipped, Cancelled, Shipping and Unshipped.|
|Units||Total number of units in the order||1|
|Revenue||The approximate sales amount generated from the order. It is indicated in the currency defined in the profile.||$100|
|Categories||Category path configured in the Category Tree||Electronics -> Mobiles -> Accessories|
|Products||Product ordered by the buyer||Mobile Back case|
|SKU||A merchant-defined unique ID for a product ordered||KC013AA01|
|ASIN||Amazon defined unique ID for a product ordered||B000WON1Z0|
|Shipped Country||Name of the country where the order is shipped||United States (US)|
|Shipped State||Name of the state where the order is shipped||Idaho|
|Shipped City||Name of the city where the order is shipped||Henryetta|
|Buyer email||Pseudo(randomized) email ID of the buyer who made the email@example.com|
|Seller ID||Seller defined unique ID for the order||113-9517201-4212232|
|Business order||Status that represents whether the order is made by a verified amazon business buyer||True or false|
|Fulfillment channel||The fulfillment channel name of the order||AFN or MFN|
|Sales channel||The sales channel name through which the order was placed||amazon.com, amazon.ca, amazon.com.mx or non-amazon|
|Shipped Items||Number of items that are delivered to the buyer||1|
|UnShipped Items||Number of items that are yet to be delivered to the buyer||3|
|Payment method||Method of payment for orders||Possible values would be “CashOnDelivery”, “CreditCard”, ”Standard”, “Invoice”|