Page Comparison

Name of the first column

• Value= Brand/Category

Revenue (excl. Tax)

• The total revenue excluding the tax of the products in that Brand/Category

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

Qty Sold

• The total qty sold of that Brand/Category

• Value= Qty Invoiced - Qty Refunded

Average Selling Price

• The Average Selling Price of that Brand/Category

• Value= Revenue (excl. Tax)/Qty Sold

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

% Total Revenue

• Value = Revenue (excl. Tax) of each Brand or Catefory/ Revenue (excl. Tax) of all Brands or Categories

COGS

• The COGS of the Brand/Category

• COSG recorded when invoiced but if the product got refunded, it will deduct = Magento cost*(qty invoiced - qty refunded) of all the items belonging to the Brand/Category

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

Profit

• The profit of the Brand/Category

• Value= Revenue (excl. Tax) - COGS

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

Margin (%)

• The profit margin of the Brand/Category

• Value= Profit / Revenue (excl. Tax).

Refunded

• The refunded amount of that Brand/Category

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

Revenue (incl. Tax)

• The total revenue including the tax of the products in thatBrand/Category during the selected report period.

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

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

• The column will be hidden by default for all reports

Qty Invoiced

• The units of the Brand/Category that are invoiced

• The column will be hidden by default for all reports

Qty Refunded

• The units of the Brand/Category that are refunded

• The column will be hidden by default for all reports

Top Selling Product

• Three products that have the highest Revenue (excl. Tax)

• The product will be sorted by the Revenue (excl. Tax) (Highest to Lowest)

• On this field, the product will display like this:

+ For simple product: Show the name of that product
+ For custom option product: Show the product name of the simple priduct
+ For bundle ship together, bundle ship seperately, configurable product, and grouped product: Show name of the child products

• The column will be hidden by default for all reports

Invoiced

• The Invoiced amount for the Brand/Category

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

• The column will be hidden by default for all reports

Discount

• The total Discounts of all products for the Brand/Category during the selected report period.

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

• This column is hidden by default.

Tax

• The total tax for the Brand/Category during the selected report period.

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

• This column is hidden by default.