What do the columns in the "Customers" report correspond to?
In this FAQ we explain the meaning of each of the columns you'll find in the CUSTOMERS report. To find out more about how to use the "Customers" report, go to this FAQ (the video is a bit old, so the column labels have changed a bit, but the principle remains the same!).
Identifier of the customer.
Default customer group identifier associated with the customer.
Customer last name.
Customer first name.
Customer e-mail.
Customer account creation date
Account creation date of the customer.
Customer account updating date
Date of the last modification made to the account of the customer.
Customer birthday date.
Value of the “Company” field if filled in the invoice address for the first order.
Customer address (invoice address used for first order).
Supplement to invoice address (see "Address" column), if entered by customer.
Postal code of invoice address (see "Address" column).
City of invoice address (see "Address" column).
Country of invoice address (see "Address" column).
Telephone number entered in invoice address (see "Address" column).
Date of the first order placed by the customer and validated (the order status indicates that the order is considered validated).
Date of most recent order placed (and validated).
Number of orders placed by the customer (validated or not).
Number of products ordered by the customer (whether the order has been validated or not).
Average customer cart, incl. VAT. This is the average amount paid by the customer (excluding shipping costs) for all orders placed. Please note that all values here include VAT:
A "View products" link takes you directly to the customer's file to see the products he/she has ordered.
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.
Sum of the cost prices of the products ordered by the customer.
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.
Discount total excl. VAT (negative value)
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.
These are the profits generated by a customer, before discounts (voucher codes) are taken into account:
These are the profits generated by a customer, including discounts (voucher codes).
Note: Wrapping costs are not included in "customer" net profits.
It's a percentage. This is the ratio of gross profits to total product amount:
It's a percentage. It is the ratio of net profits to the "net" amount of product sales (i.e. after taking into account "voucher code” discounts):
Note: Wrapping costs are not included in "customer" net profits.
Other FAQs in this category
- How to use the "Customers" report?
- How to use the "Products" and "Categories" reports?
- How to use the "VAT", "Profits and margins" and "Credit notes" reports?
- What do the columns in the "VAT on products" report correspond to?
- How to export the collected amounts by VAT rate?
- What do the columns in the "VAT" report correspond to?
- What do the columns in the "Profits and margins" report correspond to?
- What do the columns in the "Product credit notes by VAT rate" report correspond to?
- What do the columns in the "Shipping credit notes" report correspond to?
- What do the columns in the "Credit notes" report correspond to?
- How to use the "Sales by country" report?
- What do the columns in the "Sales by country" report correspond to?
- How to use the "Brands" and "Suppliers" reports?
- What do the columns in the "Suppliers" report correspond to?
- What do the columns in the "Brands" report correspond to?
- What do the columns in the "Categories" report correspond to?
- What do the columns in the "Products" report correspond to?
- How to use the "Full" and "Basic" reports?
- What do the columns in the "Basic" report correspond to?
- What do the columns in the "Full" report correspond to?