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

Columns in the Full report.

Shop name

Name of the shop where the order was placed.

Order ID

Order identifier.

Order date

Date the order was placed by the customer.

Order update date

Date of last modification to order (e.g. change in order status).

Invoice number

Invoice number associated with the order.

Invoice date

Date of invoice generation associated with the order.

Delivery slip number (Delivery number)

Delivery slip number associated with the order.

Delivery date

Order delivery date.

Order state

Latest status in the order history at extraction time. It is not the historical status on the invoice date.

Payment method

Payment method used when the customer places an order.

Carrier

Carrier chosen for order delivery.

Order total incl. VAT (Total paid)

Total amount of the order, including VAT.

Order amount already paid incl. VAT (Total paid real)

Depending on the payment method used, you may not have received full payment for your order. This column shows the amount that has normally already been paid to you.

Shipping cost total excl. VAT (Total shipping)

Total amount of shipping costs, excluding VAT.

Total VAT on shipping costs (Total shipping tax)

Total VAT collected on shipping costs.

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.

Wrapping cost total excl. VAT (Total wrapping no tax)

If you have activated the function enabling you to offer gift wrapping to your customers, this column shows the total amount of the wrapping costs, excluding VAT.

Total VAT on wrapping costs (Wrapping tax amount)

Total VAT collected on wrapping costs.

Product total excl. VAT (Total products no tax)

Sum of the prices of the products included in the order, excluding VAT. If a specific price is applied, it is taken into account. The eco-tax on the products concerned is also taken into account in this sum, excluding VAT.

Total VAT on products (Total product tax)

Sum of VAT collected on products. VAT is calculated on the specific price of the product if a specific price rule was in effect at the time the order was placed. VAT on eco-tax is also added to this sum for the products concerned.

Ecotax total excl. VAT (Ecotax no tax)

Sum of the amounts corresponding to the eco-tax, for the products concerned, excluding VAT. As a reminder, this sum is already included in Total products 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-tax amounts, for the products 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 (Total tax)

Sum of all VATs.

Please note: as the VAT on eco-taxes is already included in the Total VAT on products, the amount in the "Total VAT on eco-taxes" column is not added:

Total VAT = Total VAT on products + Total VAT on shipping costs + Total VAT on wrapping costs - |Total VAT on discounts|

Total of product cost prices (Total cost)

Sum of quantities multiplied by purchase costs recorded in order lines.

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

Gross profits (Gross profit)

These are profits before discounts (voucher codes) are taken into account:

Net profits (Net profit)

These are the profits received once the total amount of the sale has been taken into account. We therefore take into account discounts (voucher codes) and wrapping costs in addition to the product price:

Gross margin

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

Net margin

An indicator of order profitability, expressed as a percentage. It complements the amount shown in the Net profits column.

E-mail (Email)

E-mail of the customer who placed the order.

Birthday date (Birthday)

Birthday of the customer who placed the order.

First name

First name of the customer who placed the order.

Last name

Last name of the customer who placed the order.

Customer group ID (Default group)

ID of the default customer group of the customer who placed the order.

Customer account creation date (Customer registration date)

Account creation date of the customer who placed the order.

Customer account updating date (Customer update date)

Date of the last modification made to the account of the customer who placed the order.

Company

Value of the "Company" field if entered by the customer in the invoice address.

Last name (invoicing) (Address last name)

Last name indicated in the invoice address.

First name (invoicing) (Address first name)

First name indicated in the invoice address.

Address (Address 1)

Order invoice address.

Address supplement (Address 2)

Supplement to the order invoice address (if provided by the customer).

Postcode

Postal code indicated in the invoice address.

City

City indicated in the invoice address.

Country

Country indicated in the invoice address.

Phone

Phone number indicated in the invoice address.

Configuration and filters · Choose a report.