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

Columns in the Products report.

Shop name

Name of the shop where the order was placed.

Product ID

The parent product ID. Combination detail separates rows, but this column does not become a combination ID.

Product reference

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

Product name

Name from the order line. Enable combination detail to separate combinations; without that detail, do not assume the name is the current default combination’s name.

Supplier reference

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.

Supplier name

Product default supplier name.

UPC code (UPC)

Product or combination UPC according to the requested detail. Check catalogue codes; an empty combination value does not guarantee fallback to the parent product code.

Total quantity sold (Product total quantity)

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 unit price excl. VAT (Product unit price)

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 (Product tax rate)

VAT rate associated with the product (in percent).

Discount total excl. VAT (negative value) (Total discounts no tax)

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 on discounts (negative value) (Discounts tax amount)

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

Product total excl. VAT (Product total no tax)

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:

Total VAT on products (Total product tax)

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.

Ecotax total excl. VAT (Ecotax no tax)

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.

Total VAT on ecotax (Ecotax tax amount)

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 of product cost prices (Product total costs)

Sum of quantities multiplied by costs stored in the module’s tables. Importing those costs depends on available data and settings.

To choose the purchase costs used in the calculations, see the guide to purchase costs for orders placed before installation.

Gross profits (Product gross profit)

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

Gross margin (Product gross margin)

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

Net profits (Product net profit)

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.

Net margin (Product net margin)

Net profits are expressed as a percentage of product revenue excluding tax, before cart-rule discounts: (product total excluding tax − cost − absolute discounts excluding tax) ÷ product total excluding tax × 100.

Manufacturer name

Name of product manufacturer (or brand).

Category name (Category)

The product’s current default category. Other associated categories are not used for this grouping. See the category filter.

% of total sales (Percent total sales)

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:

Cumulative % of total sales (Total sales cumulative)

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:

% of total gross profits (Percent total gross profits)

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:

Cumulative % of total gross profits (Total gross profits cumulative)

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:

% of total net profits (Percent total net profits)

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:

Cumulative % of total net profits (Total net profits cumulative)

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:

Configuration and filters · Choose a report.