Sales Orders

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
  • Units
  • Revenue
  • Est. net profit
  • Sales Overview with Comparison
  • Sales order list
  • Order Details
  • Net Profit Split Up

Total orders

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.

Total orders info

Shipped orders

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.

Shipped orders info

Pending orders

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.

Pending orders info

Units

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.

Units info

Revenue

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.

Revenue Info

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.

Est. net profit info

tip

Mini graph in the info cards are displayed based on the given period filter.

For example,
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.

Chart

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.

For Example,
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

Filters

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.

tip

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.

Filters

Sales order list

These are the list of columns that can be included in the sales order report table.

Column NameDescriptionExample
Order IDAmazon defined unique ID for the order113-9517201-4212232
PurchasedThe purchased date of the order02 Jun 2020
StatusThe status of the orderPossible values would be Pending, Shipped, Cancelled, Shipping and Unshipped.
UnitsTotal number of units in the order1
RevenueThe approximate sales amount generated from the order. It is indicated in the currency defined in the profile.$100
CategoriesCategory path configured in the Category TreeElectronics -> Mobiles -> Accessories
ProductsProduct ordered by the buyerMobile Back case
SKUA merchant-defined unique ID for a product orderedKC013AA01
ASINAmazon defined unique ID for a product orderedB000WON1Z0
Shipped Country Name of the country where the order is shippedUnited States (US)
Shipped StateName of the state where the order is shippedIdaho
Shipped CityName of the city where the order is shippedHenryetta
Buyer emailPseudo(randomized) email ID of the buyer who made the order186tjv5@marketplace.amazon.com
Seller IDSeller defined unique ID for the order113-9517201-4212232
Business orderStatus that represents whether the order is made by a verified amazon business buyerTrue or false
Fulfillment channelThe fulfillment channel name of the orderAFN or MFN
Sales channelThe sales channel name through which the order was placed amazon.com, amazon.ca, amazon.com.mx or non-amazon
Shipped ItemsNumber of items that are delivered to the buyer1
UnShipped ItemsNumber of items that are yet to be delivered to the buyer3
Payment methodMethod of payment for ordersPossible values would be “CashOnDelivery”, “CreditCard”, ”Standard”, “Invoice”

List

Last updated on