What do the columns in the "Products" report correspond to?

Name of the shop where the order was placed.

Identifier of the product or product combination (if you choose to display details by combination).

Reference of the product or product combination (if you decide to display details by combination).

Name of the product or product combination (if you decide to display details by combination).

Note: if it's a product with combinations, but you don't display the details by combination, the column will display the default combination name.

Supplier reference of the product or product combination (if you decide to display details by combination). If several suppliers are associated with the product or product combination, the reference associated with the default supplier will be displayed.

Product default supplier name.

EAN code of the product or product combination (if you decide to display details by combination). If the EAN code is not filled in at combination level, the EAN code indicated in the "Details" tab of the general product will be displayed (if available).

UPC code of the product or product combination (if you decide to display details by combination). If the UPC code is not filled in at combination level, the UPC code indicated in the "Details" tab of the general product will be displayed (if available).

Quantity of this product (or product combination) sold over the selected period.

where:

Qtity_init is the quantity sold at the initial price

Qtity_{spe 1} is the quantity sold at the specific price 1

Qtity_{spe n} is the quantity sold at the specific price n

Average price of the product (product combination) over the selected period. This average takes into account specific product prices, if any, for certain orders placed during the period.

where:

Qtity_init is the quantity sold at the initial price

Price_init is the product's initial price (i.e. without any specific price applied), excluding VAT.

Qtity_{spe 1} is the quantity sold at the specific price 1

Price _{spe 1} is the specific price 1 excluding VAT = product's initial price excl. VAT - discount 1 excl. VAT (defined by a specific price rule)

Qtity_{spe n} is the quantity sold at the specific price n

Price_{spe n} is the specific price n excluding VAT = product's initial price excl. VAT - discount n excl. VAT (defined by a specific price rule)

Example :

For example, if product A with a initial price of €10 excl. VAT has been sold 3 times over the selected period, including once with a specific price of €7 excl. tax, then the average unit price will be €9:

Moreover, knowing that:

The sum: Qtity_init x Price_init + Qtity_{spe 1} x Price_{spe 1} + Qtité_{spé n} x Prix_{spé n} is the Product total excl. VAT (see relevant section) and that the sum: Qtity_init + Qtity_{spe 1} + ... + Qtity_{spe n} is the Total quantity sold (see relevant section), we can also say that:

VAT rate associated with the product (in percent).

Total amount of discounts applied using voucher code(s) (cart rules).

Please note: this column only calculates discounts resulting from voucher codes (cart rules). Discounts due to specific prices are not taken into account here.

Total VAT associated with the total amount of discounts (cart rules), and which will therefore not be collected and paid to the government.

Total amount of the product (or product combination if you decide to display details by combination), over the selected period, excluding VAT.

If a specific price was applied when the order was placed, it is taken into account. In this sum we also take the eco-tax into account, if the product is concerned, excluding VAT.

or:

This is Product total excl. VAT (see previous section) minus the sum of discount amounts (voucher codes), i.e. the absolute value of Discount total excl. VAT (see relevant section):

Please note: when we talk about discounts here, we're talking about discounts resulting from voucher codes (cart rules). Discounts due to specific prices have already been taken into account in the Product total excl. VAT.

Sum of VAT collected on the product or product combination (if you decide to display details by combination):

Note: Total product excl. VAT includes specific prices (see previous section). It also includes the total amount of eco-tax if the product (or the product combination if you decide to display the detail by combination) is concerned, excluding VAT. In other words, the Total VAT on products includes the Total VAT on eco-tax, if any.

Sum of the amounts corresponding to the eco-tax, if the product (or the product combination if you decide to display the detail by combination) is concerned, excluding VAT. As a reminder, this total is already included in the Product total excl. VAT. This column is useful for your eco-tax declaration forms.

Sum of VAT collected on eco-taxes, if the product (or product combination if you decide to display details by combination) is concerned. As a reminder, this total VAT on eco-taxes is already included in the Total VAT on products. This column is useful for your VAT and eco-tax declaration forms.

Total VAT is Total VAT on products minus the sum of VAT on discounts (voucher codes), i.e. the absolute value of Total VAT on discounts (see relevant section):

Total cost of the product over the period concerned, taking into account the quantity sold :

Notes:

• The module allows you to decide whether you want to consider the cost price of the product as it was at the time the order was placed, or whether you want to take the current value of the product's cost price. By default, the cost price is recorded at the time the order is placed, and this is used for the various calculations. If you prefer to use the current cost price, go to the module configuration and uncheck the corresponding option.
  
  
• Moreover, when the module retrieves the cost price value, it first looks at the level of the (default) supplier associated with the product (or product combination). If the cost price has been entered at this level, this value will be taken into account; otherwise, the module will look for the cost price value entered in the product's "Pricing" tab.

These are the profits on the product, before taking into account discounts (voucher codes):

These are the profits on the product, taking into account discounts (voucher codes). Unlike net profits calculated on an order (as in the basic and full reports), net profits on a product do not take wrapping costs into account.

It's a percentage. It is the proportion of gross profits on the product in relation to the total amount of the product:

It's a percentage. It is the proportion of net profits on the product in relation to the "net" amount of the sale of the product (i.e. after taking into account "voucher code” discounts):

Name of product manufacturer (or brand).

Product default category name.

This column shows how much the sale of the product (or product combination, if you decide to display details by combination) represents of the total amount of products sold over the selected period:

We add up the % of total sales for each product as we go down the column.

Example:

We export a "product" report and we position ourselves on the "Firewood" product. If we add up the percentage of total sales for the first 3 products, we find a cumulative percentage of total sales of 69,11%, which means that the first 3 products alone account for 69,11% of total sales for the selected period:

This column shows the proportion of gross profits generated by the product (or product combination, if you decide to display details by combination) in relation to total gross profits generated over the selected period:

We add up the % of total gross profits for each product as we go down the column.

Example:

We export a "product" report and we position ourselves on the "Firewood" product. If we add up the percentage of total gross profits for the first 3 products, we find a cumulative percentage of total gross profits of 72,82%, which means that the first 3 products alone account for 72,82% of gross profits for the selected period:

This column shows the proportion of net profits generated by the product (or product combination, if you decide to display details by combination) in relation to total net profits generated over the selected period:

We add up the % of total net profits for each product as we go down the column.

Example:

We export a "product" report and we position ourselves on the "Firewood" product. If we add up the percentage of total net profits for the first 3 products, we find a cumulative percentage of total net profits of 73%, which means that the first 3 products alone account for 73% of net profits for the selected period: