Page Comparison

...

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

...

Date used:

You can select either Order Item Created or Order Item Updated

By default, the setting would be Order Created

...

Columns that are shown by default

SKU	SKU of the product
Product Name	Name of the product
Revenue (excl. Tax)	The total revenue excluding the tax of the products in that Brand/Attribute Set/Attribute/Category/Product 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 Brand/Attribute Set/Attribute/Category/Product during the selected report period. The currency will follow the Base Currency of the magento site. Revenue (excl. Tax) = Total Invoiced - Total Refunded
COGS	The COGS of the Product -COSG recorded when invoiced but if the product got refunded, it will deduct = *Magento cost(qty invoiced - qty refunded)** The currency will follow the Base Currency of the magento site.
Profit	The profit of theProduct Value= Revenue (excl. Tax) - COGS The currency will follow the Base Currency of the magento site.
Margin (%)	The profit margin of the Product Value= Profit / Revenue (excl. Tax)
Refunded	The refunded amount of that Product The currency will follow the Base Currency of the magento site.
% Total Revenue	Value = Revenue (excl. Tax) of each product/ Revenue (excl. Tax) of all product

Columns that are hidden by default

Qty Sold	The total qty sold of that Product Value= Qty Invoiced - Qty Refunded This column will be hidden by default
Average Selling Price	The Average Selling Price of that Product Value= Revenue (excl. Tax)/Qty Sold The currency will follow the Base Currency of the magento site. This column will be hidden by default
Qty Refunded	The units of the Product that are refunded The column will be hidden by default
Invoiced	The Invoiced amount for the Product The currency will follow the Base Currency of the magento site. The column will be hidden by default
Discount	The discount amount for the Product The currency will follow the Base Currency of the magento site. The column will be hidden by default
Tax	The total tax for the Product during the selected report period. 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 Product Name, Revenue (excl. Tax) (From-To), Refunded (From-To), Average Selling Price (From-To)

...

Versions Compared