Order Reports

📘

Note

Order reports are retained for 30 days. You can generate the reports again if you do not download them within 30 days.

Order reports

The date range you specify for an order report indicates when orders become eligible for fulfillment (no longer in a pending state), not when you create them. Order reports only support orders that are less than two years old.

The reports are canceled if no eligible data is found.

📘

Order reports support for the JP, AU, and SG marketplaces

Order reports support orders from 2016 onward for the JP, AU, and SG marketplaces.

Order reports can have up to a 30-minute delay, as the fulfillable date of an order is usually 30 minutes after the order has been created.

Unshipped Orders Report

reportType value: GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING

Role: Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN

Requested/scheduled: Requested or scheduled

Report output type: Tab-delimited flat file

Contains only orders that are not confirmed as shipped.

This report covers a 38-day lookback period.

This report accepts the following reportOptions values:

• ShowSalesChannel - A Boolean value that indicates whether an additional column is added to the report that shows the sales channel. Default: false. Example: "reportOptions":{"ShowSalesChannel":"true"}

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• payments-date
• reporting-date
• promise-date
• days-past-promise
• buyer-email
• buyer-phone-number
• sku
• product-name
• quantity-purchased
• quantity-shipped
• quantity-to-ship
• ship-service-level
• recipient-name
• ship-address-1
• ship-address-2
• ship-address-3
• ship-city
• ship-state
• ship-postal-code
• ship-country
• is-business-order
• purchase-order-number
• price-designation
• is-prime

---

Scheduled XML Order Report (Invoicing)

reportType value: GET_ORDER_REPORT_DATA_INVOICING

Role: Tax Invoicing (Restricted)

Order Fulfillment Channel: MFN

Availability: Seller Central sellers

Marketplace availability: EU

Requested/scheduled: Scheduled

Report output type: XML

This report can be used to generate tax invoices in the EU region.

The report includes all new orders since the last report. For new reports, it contains order reports from the past 38 days.

You can only schedule one GET_ORDER_REPORT_DATA_INVOICING or GET_FLAT_FILE_ORDER_REPORT_DATA_INVOICING report at a time. If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

Select to expand list of report attributes.

• AmazonOrderID
• AmazonSessionID
• OrderDate
• OrderPostedDate
• BillingData
  • BuyerEmailAddress
  • BuyerName
  • BuyerPhoneNumber
• FulfillmentData
  • FulfillmentMethod
  • FulfillmentServiceLevel
  • Address
    • Name
    • AddressFieldOne
    • City
    • PostalCode
    • CountryCode
    • PhoneNumber
• IsBusinessOrder
• IsPrime
• IsIba
• Item
  • AmazonOrderItemCode
  • SKU
  • Title
  • Quantity
  • ProductTaxCode
  • ItemPrice
    • Type
    • Amount
    • currency
  • ItemFees
    • Type
    • Amount
    • currency

---

Scheduled XML Order Report (Tax)

reportType value: GET_ORDER_REPORT_DATA_TAX

Role: Tax Remittance (Restricted)

Order Fulfillment Channel: MFN

Availability: Seller Central sellers

Marketplace availability: NA

Requested/scheduled: Scheduled

Report output type: XML

This report is for calculating and remitting taxes in the NA region.

The report includes all new orders since the last report. For new reports, it contains order reports from the past 38 days.

You can only schedule one GET_ORDER_REPORT_DATA_TAX or GET_FLAT_FILE_ORDER_REPORT_DATA_TAX report at a time. If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

Select to expand list of report attributes.

• AmazonOrderID
• AmazonSessionID
• OrderDate
• OrderPostedDate
• BillingData
  • BuyerEmailAddress
• FulfillmentData
  • FulfillmentMethod
  • FulfillmentServiceLevel
  • Address
    • AddressFieldOne
    • City
    • PostalCode
    • CountryCode
    • PhoneNumber
• IsBusinessOrder
• IsPrime
• IsIba
• Item
  • AmazonOrderItemCode
  • SKU
  • Title
  • Quantity
  • ProductTaxCode
  • ItemPrice
    • Type
    • Amount
    • currency
  • ItemFees
    • Type
    • Amount
    • currency

---

Scheduled XML Order Report (Shipping)

reportType value: GET_ORDER_REPORT_DATA_SHIPPING

Order Fulfillment Channel: MFN

Role: Direct to Consumer Shipping (Restricted)

Availability: Seller Central sellers

Requested/scheduled: Scheduled

Report output type: XML

This report is for shipping seller fulfilled orders to customers.

The report includes all new orders since the last report. For new reports, it contains order reports from the past 38 days.

You can only schedule one GET_ORDER_REPORT_DATA_SHIPPING or GET_FLAT_FILE_ORDER_REPORT_DATA_SHIPPING report at a time. If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

Select to expand list of report attributes.

• AmazonOrderID
• AmazonSessionID
• OrderDate
• OrderPostedDate
• BillingData
  • BuyerEmailAddress
  • BuyerName
  • BuyerPhoneNumber
• FulfillmentData
  • FulfillmentMethod
  • FulfillmentServiceLevel
  • Address
    • Name
    • AddressFieldOne
    • City
    • PostalCode
    • CountryCode
    • PhoneNumber
• IsBusinessOrder
• IsPrime
• IsIba
• Item
  • AmazonOrderItemCode
  • SKU
  • Title
  • Quantity
  • ProductTaxCode
  • ItemPrice
    • Type
    • Amount
    • currency
  • ItemFees
    • Type
    • Amount
    • currency

---

Requested or Scheduled Flat File Order Report (Invoicing)

reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_INVOICING

Role: Tax Invoicing (Restricted)

Order Fulfillment Channel: MFN

Availability: Seller Central sellers

Marketplace availability: EU

Requested/scheduled: Requested or scheduled

Report output type: Tab-delimited flat file

This report can be used to generate tax invoices in the EU region.

This report shows orders from the previous 60 days.

Seller Central sellers can only schedule one GET_ORDER_REPORT_DATA_INVOICING or GET_FLAT_FILE_ORDER_REPORT_DATA_INVOICING report at a time.

If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

📘

Note:

The format of this report will differ slightly depending on whether it is scheduled or requested.

This report accepts the following reportOptions values:

• ShowSalesChannel - A Boolean value that indicates whether an additional column is added to the report that shows the sales channel. Default: false. Example: "reportOptions":{"ShowSalesChannel":"true"}

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• payments-date
• buyer-email
• buyer-name
• buyer-phone-number
• sku
• product-name
• quantity-purchased
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• ship-service-level
• recipient-name
• ship-address-1
• ship-address-2
• ship-address-3
• ship-city
• ship-state
• ship-postal-code
• ship-country
• ship-phone-number
• item-promotion-discount
• item-promotion-id
• ship-promotion-discount
• ship-promotion-id
• delivery-start-date
• delivery-end-date
• delivery-time-zone
• delivery-Instructions
• sales-channel

---

Requested or Scheduled Flat File Order Report (Shipping)

reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_SHIPPING

Role: Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN

Availability: Seller Central sellers

Requested/scheduled: Requested or scheduled

Report output type: Tab-delimited flat file

Contains orders from the previous 60 days. This report can be used to ship Amazon orders.

Seller Central sellers can only schedule one GET_ORDER_REPORT_DATA_SHIPPING or GET_FLAT_FILE_ORDER_REPORT_DATA_SHIPPING report at a time.

If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

📘

Note:

The format of this report will differ slightly depending on whether it is scheduled or requested.

This report accepts the following reportOptions values:

• ShowSalesChannel - A Boolean value that indicates whether an additional column is added to the report that shows the sales channel. Default: false. Example: "reportOptions":{"ShowSalesChannel":"true"}
  

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• payments-date
• buyer-name
• buyer-email
• buyer-phone-number
• sku
• product-name
• quantity-purchased
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• ship-service-level
• recipient-name
• ship-address-1
• ship-address-2
• ship-address-3
• ship-city
• ship-state
• ship-postal-code
• ship-country
• ship-phone-number
• delivery-start-date
• delivery-end-date
• delivery-time-zone
• delivery-Instructions
• earliest-ship-date
• latest-ship-date
• earliest-delivery-date
• latest-delivery-date
• is-business-order
• purchase-order-number
• price-designation

---

Requested or Scheduled Flat File Order Report (Tax)

reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_TAX

Role: Tax Remittance (Restricted)

Order Fulfillment Channel: MFN

Availability: Seller Central sellers

Marketplace availability: NA

Requested/scheduled: Requested or scheduled

Report output type: Tab-delimited flat file

Contains orders from the previous 60 days for NA region only.

Seller Central sellers can only schedule one GET_ORDER_REPORT_DATA_TAX or GET_FLAT_FILE_ORDER_REPORT_DATA_TAX report at a time.

If you have one of these reports scheduled and you schedule a new report, the existing report is canceled.

📘

Note:

The format of this report will differ slightly depending on whether it is scheduled or requested.

This report accepts the following reportOptions values:

• ShowSalesChannel - A Boolean value that indicates whether an additional column is added to the report that shows the sales channel. Default: false. Example: "reportOptions":{"ShowSalesChannel":"true"}

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• payments-date
• buyer-email
• buyer-phone-number
• sku
• product-name
• quantity-purchased
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• ship-service-level
• ship-address-1
• ship-address-2
• ship-address-3
• ship-city
• ship-state
• ship-postal-code
• ship-country
• ship-phone-number
• delivery-start-date
• delivery-end-date
• delivery-time-zone
• delivery-Instructions
• sales-channel
• is-business-order
• purchase-order-number
• price-designation

---

Order tracking reports

The Order tracking reports are available in all regions and for all sellers. The reports return all orders, regardless of fulfillment channel or shipment status. The reports are intended for order tracking, not to drive a seller's fulfillment process, as they do not include customer-identifying information and scheduling is not supported. Also note that for self-fulfilled orders, item price is not shown for orders in a pending state.

The date range for these reports is limited to 30 days. However, you can select any start date.

Flat File Orders By Last Update Report

reportType value: GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

Role: Product Listing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN and FBA

Availability: Sellers

Requested/scheduled: Requested

Report output type: Tab-delimited flat file

Contains all orders updated in the specified period.

Select to expand list of report attributes.

• amazon-order-id
• merchant-order-id
• purchase-date
• last-updated-date
• order-status
• fulfillment-channel
• sales-channel
• order-channel
• ship-service-level
• product-name
• sku
• asin
• item-status
• quantity
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• gift-wrap-price
• gift-wrap-tax
• item-promotion-discount
• ship-promotion-discount
• ship-city
• ship-state
• ship-postal-code
• ship-country
• promotion-ids
• is-business-order
• purchase-order-number
• price-designation

---

Flat File Orders By Order Date Report

reportType value: GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN and FBA

Availability: Sellers

Requested/scheduled: Requested

Report output type: Tab-delimited flat file

Contains all orders that were placed in the specified period.

Select to expand list of report attributes.

• amazon-order-id
• merchant-order-id
• purchase-date
• last-updated-date
• order-status
• fulfillment-channel
• sales-channel
• order-channel
• ship-service-level
• product-name
• sku
• asin
• item-status
• quantity
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• gift-wrap-price
• gift-wrap-tax
• item-promotion-discount
• ship-promotion-discount
• ship-city
• ship-state
• ship-postal-code
• ship-country
• promotion-ids
• cpf
• is-business-order
• purchase-order-number
• price-designation

---

Flat File Archived Orders Report

reportType value: GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN and FBA

Availability: Sellers

Requested/scheduled: Requested

Report output type: Tab-delimited flat file

Contains all archived orders that were placed in the specified period.

Select to expand list of report attributes.

• amazon-order-id
• merchant-order-id
• purchase-date
• last-updated-date
• order-status
• fulfillment-channel
• sales-channel
• order-channel
• url
• ship-service-level
• product-name
• sku
• asin
• item-status
• quantity
• currency
• item-price
• item-tax
• shipping-price
• shipping-tax
• gift-wrap-price
• gift-wrap-tax
• item-promotion-discount
• ship-promotion-discount
• ship-country
• ship-promotion-id
• promotion-ids
• is-business-order
• purchase-order-number
• price-designation
• customized-url
• customized-page
• is-heavy-or-bulky
• is-replacement-order

---

XML Orders By Last Update Report

reportType value: GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN and FBA

Availability: Sellers

Requested/scheduled: Requested

Report output type: XML

Contains all orders updated in the specified period.

Select to expand list of report attributes.

• AmazonOrderID
• MerchantOrderID
• PurchaseDate
• LastUpdatedDate
• OrderStatus
• SalesChannel
• FulfillmentData
  • FulfillmentChannel
  • ShipServiceLevel
  • Address
    • City
    • State
    • PostalCode
    • Country
• IsBusinessOrder
• OrderItem
  • AmazonOrderItemCode
  • ASIN
  • SKU
  • ItemStatus
  • ProductName
  • Quantity

---

XML Orders By Order Date Report

reportType value: GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Order Fulfillment Channel: MFN and FBA

Availability: Sellers

Requested/scheduled: Requested

Report output type: XML

Contains all orders that were placed in the specified period.

Select to expand list of report attributes.

• AmazonOrderID
• MerchantOrderID
• PurchaseDate
• LastUpdatedDate
• OrderStatus
• SalesChannel
• FulfillmentData
  • FulfillmentChannel
  • ShipServiceLevel
  • Address
    • City
    • State
    • PostalCode
    • Country
• IsBusinessOrder
• OrderItem
  • AmazonOrderItemCode
  • ASIN
  • SKU
  • ItemStatus
  • ProductName
  • Quantity
  • ItemPrice
    • Type
    • Amount
    • currency
  • Promotion

---

Pending order reports

These pending order reports are only available in the Japan marketplace.

This report covers a 38-day lookback period.

Flat File Pending Orders Report

reportType value: GET_FLAT_FILE_PENDING_ORDERS_DATA

Role: Inventory and Order Tracking

Order Fulfillment Channel: MFN

Availability: Sellers

Requested/scheduled: Requested or scheduled

Report output type: Tab-delimited flat file

Contains all pending orders.

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• sku
• product-name
• quantity-purchased
• payment-type

---

XML Pending Orders Report

Order Fulfillment Channel: MFN

reportType value: GET_PENDING_ORDERS_DATA

Requested/scheduled: Scheduled

Report output type: XML

Contains all pending orders.

Select to expand list of report attributes.

• AmazonOrderID
• OrderDate
• PaymentType
• Item
  • AmazonOrderItemCode
  • SKU
  • Title
  • Quantity

---

Converged Flat File Pending Orders Report

reportType value: GET_CONVERGED_FLAT_FILE_PENDING_ORDERS_DATA

Role: Product Listing

Order Fulfillment Channel: MFN

Availability: Marketplace sellers

Requested/scheduled: Requested or scheduled

Report output type: Flat file

Contains all pending orders.

Select to expand list of report attributes.

• order-id
• order-item-id
• purchase-date
• sku
• product-name
• quantity-purchased
• payment-type