Sales by Time-frame

Owned by Brian Au
Last updated: Nov 14, 2024
5 min read

I/ Overview

  1. As a store manager, if you want to check which time your store has good performance at selling, this report is for you.

  2. To access the Sale by Time-frame report: Omni-channel Reports > Report Dashboard > All reports > Sales reports > Sales by Time-frame or Omni-channel Reports > Sales → Sales by Time-frame

The Sales by Time-frame Report page is displayed with the default view as below:

image-20240327-093412.png

  1. Report details

On the main page, you can select metrics of the orders you would like to see in the report, based on the information you would like to see, including:

  • Time range

You can set the time range in which you want to see all the orders (From a date To another specific one)

  • Data Used

Date used:

You can select either Order Created or Order Updated

By default, the setting would be Order Created

+ Order Created: Show report based on the date the order is created

+ Order Updated: Show report based on the date the order was last updated

  • Sales Channel

There are three options: All, Website, POS that you can select to show the report based on the selected channel. By default, the setting would be All

  • Location (This setting only shows when the Sales Channel is POS)

Include all the available locations where you use POS. You can select the location to show the data based on the selected location.

  • Report by

There are 2 options: Hour, Weekday that you can select to show the data based on hour or weekday.

  • Data detail

 

image-20240327-095253.png
Sales by Hour

On this report, there will be 2 types of columns: columns that are shown by default and columns that are hidden by default when you access the report

Columns that are shown by default

Hour

  • The hour:

+ 0:00 - 0:59
+ 1:00 - 1:59
+ 2:00 - 2:59
...
+ 23:00 - 23:59

  • Ex: the 0:00 - 0:59 row will show data for orders from 0:00 to 0:59.

  • Shown when Report by = "Hour".

Weekday

  • The day in week (Sunday -> Monday -> Tuesday -> Wednesday -> Thursday -> Friday). The data in this column will be sorted by the order above.

  • Shown when Report by = "Weekday".

Number of Orders

  • The number of orders that was sold in this hour / this weekday during the selected report period.

Grand Total

  • The total Grand Total of all orders in this hour / this weekday during the selected report period.

  • Grand Total = Subtotal + Tax - Discount + Shipping.

  • The currency will follow the Base Currency of the magento site.

Invoiced

  • The total Invoiced amount of all orders in this hour / this weekday the during the selected report period.

  • The currency will follow the Base Currency of the magento site.

Refunded

  • The total Refunded amount of all orders in this hour / this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

Revenue (excl. Tax)

  • The total revenue excluding the tax of all orders during in this hour/this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Revenue (excl. Tax) = (Total Invoiced - Invoiced Tax- Invoiced Shipping) - (Total Refunded - Tax Refunded- Shipping Refunded)

Average Order Value

  • The Average Order Value of all o\rders in this hour/this weekday during the selected report period.

  • Average Order Value = Revenue (excl. Tax) / Number of Orders.

  • The currency will follow the

Base Currency of the magento site.

Columns that are hidden by default

Subtotal

  • The total subtotal of all orders during in this hour / this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

% Subtotal

  • Value = Subtotal of this hour/this weekday / Total Subtotal of all hours/weekdays * 100%.

  • This column is hidden by default.

Tax

  • The total tax of all orders during in this hour / this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Shipping

  • The total Shipping fee of all orders in this hour / this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Discount

  • The total Discounts of all orders in this hour / this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

% Grand Total

  • Value = Grand total of this hour/this weekday / Total Grand Total of all hours/weekdays * 100%.

  • This column is hidden by default.

Qty Invoiced

  • The qty of items that has been invoiced of all orders in this hour/this weekday during the selected report period.

  • Note: For bundle item, calculate by its child products.

  • This column is hidden by default.

Qty Refunded

  • The qty of items that has been refunded of all orders in this hour/this weekday during the selected report period.

  • Note: For bundle item, calculate by its child products.

  • This column is hidden by default.

Revenue (incl. Tax)

  • The total revenue including the tax of all orders during in this hour/this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Revenue (incl. Tax) = Total Invoiced - Total Refunded.

  • This column is hidden by default.

% Total Revenue

  • Value = Revenue (excl. Tax) of this hour/this weekday / Total Revenue (excl. Tax) of all hours/weekdays * 100%.

  • This column is hidden by default.

COGS

  • The total cost recorded in the invoice of all orders in this hour/this weekday during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • COGS = Total Cost recorded when invoiced - (Total Cost recorded when invoiced / Unit Invoiced * Qty Refunded). Note: The calculation is for each product in each order.

  • This column is hidden by default.

Profit

  • The Profit of all orders in this hour/this weekday during the selected report period.

  • Profit = Revenue (excl. Tax) - COGS.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Margin (%)

  • The Margin of all orders in this hour/this weekday during the selected report period.

  • Margin (%) = Profit / Revenue (excl. Tax) * 100%.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

II/ Filter Report Data

On this report, you can filter by the Grand Total and Revenue (excl. Tax)

III/ Chart

In this chart, you can compare the data of each metric in the Report by selecting the value through the Select Metrics dropdown including (Number of Orders, Subtotal, Grand Total, Invoiced, Refunded, Revenue (incl. Tax), Revenue (excl. Tax), Average Order Value, COGS, Profit, Margin (%), Tax, Shipping (excl. Tax), Discount, % Subtotal, % Grand Total, Qty Invoiced, % Total Revenue, Qty Refunded).

For the metrics that display the contribution of the data over the total, they will be shown by the pie chart, and the rest is shown by bar chart.