Versions Compared

Old Version 1

changes.mady.by.user Brian Au

Saved on

compared with

New Version Current

changes.mady.by.user Brian Au

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 (This setting only shows when your system has installed POS package)

There are three options: All, Website, POS that you can select to show the report based on the selected channel

...

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

  • Location by (This setting only shows when your system has installed POS package)

Include 2 options: Billing Address, Shipping Address. You can select to show the data based on Billing Address or Shipping Address

  • Data detail

    image-20240327-105957.pngImage Removedimage-20240919-040123.pngImage Added

    In 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

Country

  • The name of the country (full name)

Number of Orders

  • The number of orders from this country during the selected report period.

Number of Customer

  • The number of customers from this country during the selected report period.

Subtotal

  • The total subtotal of all orders during in this country during the selected report period.

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

Tax

  • The total tax of all orders during in this country during the selected report period.

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

Shipping

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

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

Discount

  • The total Discounts of all orders in this country during the selected report period.

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

Grand Total

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

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

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

Average Order Value

  • The average order value the during the selected report period.

  • Value = Total / Number of Orders

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

Refunded

  • The total Refunded amount of all orders in this country 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 of this country during the selected report period.

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

  • Revenue (incl. Tax) = Total Paid - Total Refunded - Tax - Shipping.

Average Order Value

  • The Average Order Value of all orders of this country 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

Qty Refunded

  • The qty of items that has been refunded of all orders of this country 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 of this country during the selected report period.

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

  • Revenue (incl. Tax) = Total Paid - Total Refunded - Shipping.

  • This column is hidden by default.

% Total Revenue

  • Value = Revenue (excl. Tax) of this country / Total Revenue (excl. Tax) of all countries * 100%.

  • This column is hidden by default.

COGS

  • The total cost recorded in the invoice of all orders of this country 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 of this country 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

.

% Total Profit

Value = Profit of this country / Profit of all countries * 100%

  • .

  • This column is hidden by default.

    • Margin (%)

    • The Margin of all orders of this country 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 Country, Subtotal, Tax, Shipping, Grand Total, Refunded

    III/ Chart

    image-20240327-110413.pngImage Removed

    In this chart, you can compare the data of each metric in the Report by selecting the value through the Select Metrics dropdown including (SubtotalTax, Shipping, Discount, Grand Total, Average Order Value, Refunded ).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.

    image-20240709-034236.pngImage Addedimage-20240709-034332.pngImage Added