{"section":"tutorials","requestedLocale":"en","requestedSlug":"order-report","locale":"en","slug":"order-report","path":"docs/en/tutorials/orders/all-orders/order-report.md","branch":"main","content":"When you export an order report on the [All Orders](/en/docs/tutorials/all-orders) page, the system generates a report in `.csv` format containing details about the orders placed in your store.\n\nEach row in the spreadsheet refers to a [SKU](/en/docs/tutorials/what-is-an-sku). For example, if an order contains 3 SKUs, it will be listed in 3 rows of the report, each dedicated to data of one SKU.\n\n> ℹ️ The order report link is available for download for six hours.\n\nEach column corresponds to specific information, as described below.\n\n- **Origin**: indicates if the order comes from a [marketplace or fulfillment](/en/docs/tutorials/marketplace-strategies-at-vtex).\n- **Order**: the order ID, which appears on the order attributes page, in the Orders management module.\n- **Sequence**: numeric sequence of the order transaction.\n- **Creation Date**: date and time when the customer placed the order.\n- **Client Name**: first name of the customer who placed the order.\n- **Client Last Name**: the surname of the customer who placed the order.\n- **Client Document**: Taxpayer Registration Number of the customer who placed the order.\n- **Email**: email of the customer who placed the order.\n- **Phone**: phone number of the customer who placed the order.\n- **UF**: state, province or region of the customer who placed the order.\n- **City**: city of the customer who placed the order.\n- **Address Identification**: delivery address ID.\n- **Address Type**: type of delivery address (residential or pickup).\n- **Receiver Name**: name of the person who will receive the order.\n- **Street**: delivery address street name.\n- **Number**: delivery address number.\n- **Complement**: additional info about the delivery address.\n- **Neighborhood**: delivery address neighborhood.\n- **Reference**: reference for the delivery address.\n- **Postal Code:** ZIP code of the delivery address.\n- **SLA Type**: type of delivery (regular, store pickup, fast delivery).\n- **Courier**: carrier responsible for the delivery.\n- **Estimate Delivery Date**: the date the order is expected to be delivered.\n- **Delivery Deadline**: total time to deliver the order to the customer in business days (5bd = 5 business days).\n- **Status**: order status when the spreadsheet was exported.\n- **Last Change Date**: last date and time when the order status changed.\n- **UtmMedium**: utm_medium of the order, if any.\n- **UtmSource**: utm_source of the order, if any.\n- **UtmCampaign**: utm_campaign of the order, if any.\n- **Coupon**: order coupon ID, if any.\n- **Payment System Name**: payment method used for the purchase.\n- **Installments**: number of installments in which the order was paid.\n- **Payment Value**: the order price paid by the customer, with discounts and promotions applied.\n- **Quantity_SKU**: number of items of the same SKU.\n- **ID_SKU**: SKU ID.\n- **Category Ids Sku**: IDs of the categories in which the SKU is included. This information is organized according to the department/category/subcategory tree. For example, if the value is /1000003/1000016/, it means that the SKU is included in the category 1000016, which is part of the department 1000003.\n- **Reference Code**: the SKU reference code.\n- **SKU Name**: name of the SKU as it appears in the catalog.\n- **SKU Value**: the price added for the SKU.\n- **SKU Selling Price**: price at which the SKU was actually sold, with discounts and promotions applied.\n- **SKU Total Price**: total value of the SKU in the order, considering all items of the SKU.\n- **SKU Path**: URL where the SKU is stored in the VTEX system.\n- **Item Attachments**: attachments to the SKU.\n- **List Id**: ID of the list that the SKU is in, if any.\n- **List Type Name**: name of the list type that the SKU is in, if any.\n- **Service (Price / Selling Price)**: service linked to the SKU in the order, if any.\n- **Shipping List Price**: shipping cost per SKU.\n- **Shipping Value**: shipping cost per SKU actually applied to the order.\n- **Total Value**: total price of the order. \n        > ⚠️ It refers to the total price of the order, not the SKU price. If there are other SKUs in the same order, their prices are also considered in that total.\n- **Discounts Totals:** total amount of discounts applied to the order.\n- **Discounts Names**: promotions applied to the order.\n- **Call Center Email**: email of the telesales operator who placed the order, if applicable.\n- **Call Center Code**: ID of the telesales operator who placed the order, if applicable.\n- **Tracking Number**: unique code assigned to the order package, which allows you to track it.\n- **Host**: host who received the order, configured in License Manager.\n- **GiftRegistry ID**: Gift card ID of the order, if any.\n- **Seller Name**: name of the seller of the order.\n- **Status TimeLine**: timeline that displays the order statuses, from the order creation to the moment of exporting the spreadsheet.\n- **Note**: note included in the order by the customer, if any.\n- **UtmiPart**: the UTM utmi_pc for tracking the website's internal traffic. For example, to track the origin of a given click on a banner in the store.\n- **UtmiCampaign**: the UTM utmi_cp for tracking the website's internal traffic. For example, to track the origin of a given click on a banner in the store.\n- **UtmiPage**: the UTM utmi_p for tracking the website's internal traffic. For example, to track the origin of a given click on a banner in the store.\n- **Seller Order Id**: the order ID on the seller, in case the sale was made through a marketplace.\n- **Acquirer**: acquirer involved in the transaction.\n- **Authorization Id**: authorization ID.\n- **TID**: [transaction ID](/en/docs/tutorials/how-do-i-find-the-order-nsu-and-tid) of the order.\n- **NSU:** order's [unique number sequence](/en/docs/tutorials/how-do-i-find-the-order-nsu-and-tid)\n- **Card First Digits**: the first six digits of the card used to make the purchase.\n- **Card Last Digits**: the last four digits of the card used to make the purchase.\n- **Payment Approved By**: email of the person that approved the payment (applicable when the approval was made manually).\n- **Cancelled By**: email of the user who requested the order cancellation.\n- **Cancellation Reason**: corresponds to the `cancelReason` field in the [Orders API](https://developers.vtex.com/docs/api-reference/orders-api#post-/api/oms/pvt/orders/-orderId-/cancel). This column contains only null values. Please refer to the **Cancellation Data** column for more information about the cancellation.\n- **Gift Card Name**: name of the gift card applied to the order, if any.\n- **Gift Card Caption**: description of the gift card, if any.\n- **Authorized Date**: date and time when the order transaction was authorized.\n- **Corporate Name**: legal business name, in case the order was placed by a company.\n- **Corporate Document**: company registration number, in case the order was placed by a company.\n- **TransactionId**: transaction ID.\n- **PaymentId**: payment ID.\n- **SalesChannel**: ID of the applicable sales channel.\n- **marketingTags**: field that can be used by the store system to track different marketing-related activities. The VTEX recurrence system populates this field with the vtexrecurrence value.\n- **Delivered**: indicates if the order has already been delivered (true) or not (false). This applies to stores that send this information to the VTEX system.\n- **SKU RewardValue**: points for that SKU in the store's reward program.\n- **Is Marketplace certified:** indicates if the order was placed through a certified marketplace (true) or not (false).\n- **Is checked in:** indicates if the order was placed in a physical store through VTEX Sales App (true) or not (false).\n- **Currency Code:** the three-letter ISO code assigned to the currency in which the sale was made (for example, BRL or USD).\n- **Taxes:** the sum of the values defined as Tax and CustomTax, the taxes applied to the SKU. If those values do not exist, the column will be empty.\n- **Invoice Numbers:** the order's invoice number.\n- **Country:** country in which the order was placed.\n- **Input Invoices Numbers:** number of an invoice of Output type, which means that it refers to a purchase.\n- **Output Invoices Numbers:** number of an invoice of Input type, which means that it refers to a return.\n- **Status raw value (temporary):** the raw status value of an order. For example, the status of an order can be displayed on the interface as `Handling` while in this field it would be `handling`.\n- **Cancellation Data**: the reason given by the end-customer for canceling the order, as shown in the `Reason` field of the `cancellationData` object in the [Orders API](https://developers.vtex.com/docs/api-reference/orders-api#post-/api/oms/pvt/orders/-orderId-/cancel). If the user does not fill in this field when canceling the order, this column will be empty in the report."}