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

In this FAQ we explain the meaning of each of the columns you'll find in the FULL report. To find out more about how to use the “Basic” 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!).

 

Name of the shop where the order was placed.

Order identifier.

Date the order was placed by the customer.

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

Invoice number associated with the order.

Date of invoice generation associated with the order.

Delivery slip number associated with the order.

Order delivery date.

Payment method used when the customer places an order.

Carrier chosen for order delivery.

Total amount of the order, including VAT.

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.

Total amount of shipping costs, excluding VAT.

Total VAT collected on shipping costs.

Total amount of discounts applied using promo code(s).

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

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

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 collected on wrapping costs.

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 (eco-participation) on the products concerned is also added to this sum, excluding VAT (HT).

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 (eco-participation) is also added to this sum for the products concerned.

Sum of the amounts corresponding to the eco-tax, for the products concerned, excluding VAT (excl. VAT). As a reminder, this sum is already included in Total products excl. VAT. This column is useful for your eco-tax declaration forms.

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.

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|

 

Sum of the cost prices of the products included in the order. 

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

 

 

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.

 

 

It's a percentage. It is the proportion of gross profits in relation to the total selling price of products.

 

 

It's a percentage. It is the proportion of net profits in relation to the total amount of the sale.

 

 

E-mail of the customer who placed the order.

Birthday of the customer who placed the order.

Last name of the customer who placed the order.

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

First name of the customer who placed the order.

Account creation date of the customer who placed the order.

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

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

Last name indicated in the invoice address.

First name indicated in the invoice address.

Order invoice address.

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

Postal code indicated in the invoice address.

City indicated in the invoice address.

Country indicated in the invoice address.

Phone number indicated in the invoice address.

Other FAQs in this category