Versions Compared

Old Version 1

changes.mady.by.user Brian Au

Saved on

compared with

New Version 2

changes.mady.by.user Brian Au

Saved on

Key

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

...

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

...

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

...