Orders Dashboard


Overview

This article is focused on giving you an idea of all orders placed in the system with a focus on statuses such as Order Status (Cancelled, Processed, Pending), Ship Status, Profit Status (Actual or Estimated). The Profit column data displayed is based on the Profit Status which shows either actual or estimated profit. The Profit Status is based on a combination of Payment and Ship Status.
In contrast to the Sales reports, which deal with shipped orders only, the Orders reports include both unshipped and shipped orders.


Orders Dashboard

To access Orders Dashboard, go to Reports > Orders > Orders Dashboard.

Orders dashboard

The dashboard can be filtered by date range, and by Company, Company Groups, and Channel. You can also filter by Ship date or Order date. The filter options control the data display on all sections of the dashboard. To use the filter options:

  1. Go to Reports > Orders > Orders Dashboard > Click on Custom Filter in the top right corner.
  2. Choose your filters > Click Reload.Orders report

On the Orders dashboard you can configure the following panels:

Panel Name

Description

Grand Total Orders & Total Profit

Shows profit per day, with total orders and total profit noted at the top. The percentage in the green or red box at the top right of the chart compares profit and loss from the selected date range to the prior identical period, e.g. – past 7 days compared to the prior 7 days. Click on the box to open a sub-dashboard that compares the profit  – total and per day – for the selected date range.

1 Day – Orders By Channel

The number of orders grouped by channel and visualized in the pie chart over the date range specified
Daily Orders Total daily average orders revenue for selected date range (Total Revenue / No. of Orders). The percentages indicate an increase or decrease in orders revenue from the previous period of similar range. For example, if orders are calculated for 7 days, it will compare to the prior 7-day period. Click the percentage box to open a sub-dashboard that compares daily average sales.
No. of Orders Daily average number of orders in date range (No. of Orders / No. of Days). The percentages indicates an increase or decrease in No. of Orders from the previous period of similar range. For example, if No. of Orders are calculated for 7 days, it will compare to the prior 7-day period. Click the percentage box to see a sub-dashboard that compares daily No. of Orders.
Typical Order The average revenue generated by an order in selected date range (Daily Average Sale / Daily Average No. of Orders). The percentages indicate an increase or decrease in sales revenue from the previous period of similar range. For example, if sales are calculated for 7 days, it will compare to the prior 7-day period. Click the percentage to open a itemized daily sales chart.
Top 5 Products by $ Shows the top five products that generated the most revenue based on sales in the selected date range
Top 5 Products by Unit Count Shows the top five products with the most sales based on sales in the selected date range.

Orders Reports

Find a brief description of Sellercloud’s Orders reports.

Orders report

  1. Orders Summary by Date Range – This report displays orders within a selected date range summarized by Channel or Company.
  2. Orders Detail by Date Range – This report shows details of each order within a selected date range.
For answers to general questions about using Sellercloud’s Financial Reporting Suite, see the Reports FAQs.

Orders reports are structured like other Sellercloud reports, but differ in that they include unshipped and shipped orders, and use the Order Date for date selection results.

The Order Details by Date Range report lets you filter for pending Amazon orders by choosing the Order Status “Pending” filter.

In contrast, Sales reports are akin to Profit reports and deal only with shipped orders, using the Ship Date as the primary date selector. (Unshipped orders may not be filled, which could result in cancellation and thus, no profit.)

Example: If you receive orders over the weekend, your Sales report will not show how many orders you received on Sunday, a non-shipping day. Rather, it will show them on the day they ship. By comparison, your Orders report will show orders on the the day they were ordered (Order Date).

For answers to general questions about using Sellercloud’s Financial Reporting Suite, see the Reports FAQs.

Was this article helpful?