Order Reports
Order Reports for the Selling Partner Reports API.
Order reports
The date range that you specify when requesting an order report indicates when the orders became eligible for fulfillment (no longer in a pending state), not when the orders were created. Order reports only support orders that are less than two years old.
Order reports support for the JP, AU, and SG marketplaces
Order reports support orders from 2016 and after 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
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING
Role: Direct to Consumer Shipping (Restricted)
Requested/scheduled: This report can be requested or scheduled.
Report output type: Tab-delimited flat file
Contains only orders that are not confirmed as shipped.
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-idorder-item-idpurchase-datepayments-datereporting-datepromise-datedays-past-promisebuyer-emailbuyer-phone-numberskuproduct-namequantity-purchasedquantity-shippedquantity-to-shipship-service-levelrecipient-nameship-address-1ship-address-2ship-address-3ship-cityship-stateship-postal-codeship-countryis-business-orderpurchase-order-numberprice-designationis-prime
Scheduled XML Order Report (Invoicing)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_ORDER_REPORT_DATA_INVOICING
Role: Tax Invoicing (Restricted)
Availability: Seller Central sellers
Marketplace availability: EU
Requested/scheduled: This report can only be scheduled.
Report output type: XML
This report can be used to generate tax invoices in the EU region.
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 will be canceled.
Select to expand list of report attributes.
AmazonOrderIDAmazonSessionIDOrderDateOrderPostedDateBillingDataBuyerEmailAddressBuyerNameBuyerPhoneNumber
FulfillmentDataFulfillmentMethodFulfillmentServiceLevelAddressNameAddressFieldOneCityPostalCodeCountryCodePhoneNumber
IsBusinessOrderIsPrimeIsIbaItemAmazonOrderItemCodeSKUTitleQuantityProductTaxCodeItemPriceTypeAmountcurrency
ItemFeesTypeAmountcurrency
Scheduled XML Order Report (Tax)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_ORDER_REPORT_DATA_TAX
Role: Tax Remittance (Restricted)
Availability: Seller Central sellers
Marketplace availability: NA
Requested/scheduled: This report can only be scheduled.
Report output type: XML
This report is for calculating and remitting taxes in the NA region.
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 will be canceled.
Select to expand list of report attributes.
AmazonOrderIDAmazonSessionIDOrderDateOrderPostedDateBillingDataBuyerEmailAddress
FulfillmentDataFulfillmentMethodFulfillmentServiceLevelAddressAddressFieldOneCityPostalCodeCountryCodePhoneNumber
IsBusinessOrderIsPrimeIsIbaItemAmazonOrderItemCodeSKUTitleQuantityProductTaxCodeItemPriceTypeAmountcurrency
ItemFeesTypeAmountcurrency
Scheduled XML Order Report (Shipping)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_ORDER_REPORT_DATA_SHIPPING
Role: Direct to Consumer Shipping (Restricted)
Availability: Seller Central sellers
Requested/scheduled: This report can only be scheduled.
Report output type: XML
This report is for shipping seller fulfilled orders to customers.
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 will be canceled.
Select to expand list of report attributes.
AmazonOrderIDAmazonSessionIDOrderDateOrderPostedDateBillingDataBuyerEmailAddressBuyerNameBuyerPhoneNumber
FulfillmentDataFulfillmentMethodFulfillmentServiceLevelAddressNameAddressFieldOneCityPostalCodeCountryCodePhoneNumber
IsBusinessOrderIsPrimeIsIbaItemAmazonOrderItemCodeSKUTitleQuantityProductTaxCodeItemPriceTypeAmountcurrency
ItemFeesTypeAmountcurrency
Requested or Scheduled Flat File Order Report (Invoicing)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_INVOICING
Role: Tax Invoicing (Restricted)
Availability: Seller Central sellers
Marketplace availability: EU
Requested/scheduled: This report can be 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 will be 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-idorder-item-idpurchase-datepayments-datebuyer-emailbuyer-namebuyer-phone-numberskuproduct-namequantity-purchasedcurrencyitem-priceitem-taxshipping-priceshipping-taxship-service-levelrecipient-nameship-address-1ship-address-2ship-address-3ship-cityship-stateship-postal-codeship-countryship-phone-numberitem-promotion-discountitem-promotion-idship-promotion-discountship-promotion-iddelivery-start-datedelivery-end-datedelivery-time-zonedelivery-Instructionssales-channel
Requested or Scheduled Flat File Order Report (Shipping)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_SHIPPING
Role: Direct to Consumer Shipping (Restricted)
Availability: Seller Central sellers
Requested/scheduled: This report can be 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 will be 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-idorder-item-idpurchase-datepayments-datebuyer-namebuyer-emailbuyer-phone-numberskuproduct-namequantity-purchasedcurrencyitem-priceitem-taxshipping-priceshipping-taxship-service-levelrecipient-nameship-address-1ship-address-2ship-address-3ship-cityship-stateship-postal-codeship-countryship-phone-numberdelivery-start-datedelivery-end-datedelivery-time-zonedelivery-Instructionsearliest-ship-datelatest-ship-dateearliest-delivery-datelatest-delivery-dateis-business-orderpurchase-order-numberprice-designation
Requested or Scheduled Flat File Order Report (Tax)
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_ORDER_REPORT_DATA_TAX
Role: Tax Remittance (Restricted)
Availability: Seller Central sellers
Marketplace availability: NA
Requested/scheduled: This report can be 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 will be 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-idorder-item-idpurchase-datepayments-datebuyer-emailbuyer-phone-numberskuproduct-namequantity-purchasedcurrencyitem-priceitem-taxshipping-priceshipping-taxship-service-levelship-address-1ship-address-2ship-address-3ship-cityship-stateship-postal-codeship-countryship-phone-numberdelivery-start-datedelivery-end-datedelivery-time-zonedelivery-Instructionssales-channelis-business-orderpurchase-order-numberprice-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.
Flat File Orders By Last Update Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
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)
Availability: Sellers
Requested/scheduled: This report can only be 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-idmerchant-order-idpurchase-datelast-updated-dateorder-statusfulfillment-channelsales-channelorder-channelship-service-levelproduct-nameskuasinitem-statusquantitycurrencyitem-priceitem-taxshipping-priceshipping-taxgift-wrap-pricegift-wrap-taxitem-promotion-discountship-promotion-discountship-cityship-stateship-postal-codeship-countrypromotion-idsis-business-orderpurchase-order-numberprice-designation
Flat File Orders By Order Date Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
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)
Availability: Sellers
Requested/scheduled: This report can only be 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-idmerchant-order-idpurchase-datelast-updated-dateorder-statusfulfillment-channelsales-channelorder-channelship-service-levelproduct-nameskuasinitem-statusquantitycurrencyitem-priceitem-taxshipping-priceshipping-taxgift-wrap-pricegift-wrap-taxitem-promotion-discountship-promotion-discountship-cityship-stateship-postal-codeship-countrypromotion-idscpfis-business-orderpurchase-order-numberprice-designation
Flat File Archived Orders Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE
Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)
Availability: Sellers
Requested/scheduled: This report can only be 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-idmerchant-order-idpurchase-datelast-updated-dateorder-statusfulfillment-channelsales-channelorder-channelurlship-service-levelproduct-nameskuasinitem-statusquantitycurrencyitem-priceitem-taxshipping-priceshipping-taxgift-wrap-pricegift-wrap-taxitem-promotion-discountship-promotion-discountship-countryship-promotion-idpromotion-idsis-business-orderpurchase-order-numberprice-designationcustomized-urlcustomized-pageis-heavy-or-bulkyis-replacement-order
XML Orders By Last Update Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL
Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)
Availability: Sellers
Requested/scheduled: This report can only be requested.
Report output type: XML
Contains all orders updated in the specified period.
Select to expand list of report attributes.
AmazonOrderIDMerchantOrderIDPurchaseDateLastUpdatedDateOrderStatusSalesChannelFulfillmentDataFulfillmentChannelShipServiceLevelAddressCityStatePostalCodeCountry
IsBusinessOrderOrderItemAmazonOrderItemCodeASINSKUItemStatusProductNameQuantity
XML Orders By Order Date Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL
Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)
Availability: Sellers
Requested/scheduled: This report can only be requested.
Report output type: XML
Contains all orders that were placed in the specified period.
Select to expand list of report attributes.
AmazonOrderIDMerchantOrderIDPurchaseDateLastUpdatedDateOrderStatusSalesChannelFulfillmentDataFulfillmentChannelShipServiceLevelAddressCityStatePostalCodeCountry
IsBusinessOrderOrderItemAmazonOrderItemCodeASINSKUItemStatusProductNameQuantityItemPriceTypeAmountcurrency
Promotion
Pending order reports
These pending order reports are only available in the Japan marketplace.
Flat File Pending Orders Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_FLAT_FILE_PENDING_ORDERS_DATA
Role: Inventory and Order Tracking
Availability: Sellers
Requested/scheduled: This report can be requested or scheduled.
Report output type: Tab-delimited flat file
Contains all pending orders.
Select to expand list of report attributes.
order-idorder-item-idpurchase-dateskuproduct-namequantity-purchasedpayment-type
XML Pending Orders Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_PENDING_ORDERS_DATA
Requested/scheduled: This report can be requested or scheduled.
Report output type: XML
Contains all pending orders. Can only be scheduled using Amazon MWS.
Select to expand list of report attributes.
AmazonOrderIDOrderDatePaymentTypeItemAmazonOrderItemCodeSKUTitleQuantity
Converged Flat File Pending Orders Report
Note
Reports generated from this report type will be retained for 30 days. If the generated report is not downloaded within 30 days, you can generate the report again.
reportType value: GET_CONVERGED_FLAT_FILE_PENDING_ORDERS_DATA
Role: Product Listing
Availability: Marketplace sellers
Requested/scheduled: This report can be requested or scheduled.
Report output type: Flat file
Contains all pending orders.
Select to expand list of report attributes.
order-idorder-item-idpurchase-dateskuproduct-namequantity-purchasedpayment-type
Updated about 1 month ago