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

Columns in the Customers report.

Counts and amounts relate to orders selected by the filters, rather than necessarily the customer’s lifetime history.

Customer ID

Identifier of the customer.

Customer group ID (Default group)

Default customer group identifier associated with the customer.

Last name

Customer last name.

First name

Customer first name.

E-mail (Email)

Customer e-mail.

Customer account creation date (Customer registration date)

Account creation date of the customer.

Customer account updating date (Customer update date)

Date of the last modification made to the account of the customer.

Birthday date (Birthday)

Customer birthday date.

Company

Information from a billing address among the customer’s selected orders. The grouping does not guarantee the first order’s address or the customer account’s current address.

Address (Address 1)

Information from a billing address among the customer’s selected orders. The grouping does not guarantee the first order’s address or the customer account’s current address.

Address supplement (Address 2)

Supplement to invoice address (see "Address" column), if entered by customer.

Postcode

Postal code of invoice address (see "Address" column).

City

City of invoice address (see "Address" column).

Country

Country of invoice address (see "Address" column).

Phone

Telephone number entered in invoice address (see "Address" column).

Number of orders placed (Number of orders)

Number of distinct selected orders for this customer after the report filters are applied.

Number of products ordered (Number of products)

Sum of product quantities in this customer’s selected orders after the report filters are applied.

Average cart incl. VAT (Average cart)

Average of selected order totals including tax, excluding shipping: (sum of paid totals including tax − sum of shipping including tax) ÷ number of distinct orders. It depends on the report filters and is not necessarily the average over the customer’s entire history.

Products ordered

A "View products" link takes you directly to the customer's file to see the products he/she has ordered.

Product total excl. VAT (Product total no tax)

Sum of the prices of the products ordered by the customer, excluding VAT. If a specific price was applied at the time of ordering, it is taken into account. The eco-tax on the products concerned is also taken into account in this sum, excluding VAT.

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.

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.

Gross profits (Product gross profit)

These are the profits generated by a customer, before discounts (voucher codes) are taken into account:

Net profits (Product net profit)

These are the profits generated by a customer, including discounts (voucher codes).

Note: Wrapping costs are not included in "customer" net profits.

Gross margin (Product gross margin)

It's a percentage. This is the ratio of gross profits to total product amount:

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.