Page Comparison

Name of the first column

• Value= Attribute Value/Attribute Set

Revenue (excl. Tax)

• The total revenue excluding the tax of the products in that Attribute Value/Attribute Set during the selected report period.

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

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

Revenue (incl. Tax)

• The total revenue including the tax of the products in that Attribute Value/Attribute Set during the selected report period.

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

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

Qty Sold

• The total qty sold of that Attribute Value/Attribute Set

• Value= Qty Invoiced - Qty Refunded

Average Selling Price

• The Average Selling Price of that Attribute Value/Attribute Set

• 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 Attribute or Attribute Set/ Revenue (excl. Tax) of all Attributes or Attribute Sets

COGS

• The COGS of the Attribute Value/Attribute Set

• 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 Attribute Value/Attribute Set

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

Profit

• The profit of the Attribute Value/Attribute Set

• Value= Revenue (excl. Tax) - COGS

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

Margin (%)

• The profit margin of the Attribute Value/Attribute Set

• Value= Profit / Revenue (excl. Tax)

Refunded

• The refunded amount of that Attribute Set/Attribute Value

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

Qty Refunded

• The units of the Attribute Value/Attribute Set 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:

• The column will be hidden by default for all reports

Refunded

• The refunded amount of that Attribute Set/Attribute Value

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

Invoiced

• The Invoiced amount for all items for the Attribute Set/Attribute Value

• 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 items for the Attribute Set/Attribute Value
  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 of all items for the Attribute Set/Attribute Value during the selected report period.

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

• This column is hidden by default.