{"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. Warning: 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 trade policy.\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."}