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-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)
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.
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)
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.
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)
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.
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)
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-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)
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-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)
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-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.
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-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
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-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
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-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
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.
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
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.
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.
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-id
order-item-id
purchase-date
sku
product-name
quantity-purchased
payment-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.
AmazonOrderID
OrderDate
PaymentType
Item
AmazonOrderItemCode
SKU
Title
Quantity
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-id
order-item-id
purchase-date
sku
product-name
quantity-purchased
payment-type
Updated 4 months ago