EndPoint Orders: Read Orders
Name
ListOrders
Description
The ListOrders operation returns a list of orders created or updated during a time frame that you specify. You define that time frame using the CreatedAfter parameter or the LastUpdatedAfter parameter. You must use one of these parameters, but not both. You can also apply a range of filtering criteria to narrow the list of orders that is returned. The ListOrders operation includes order information for each order returned, including AmazonOrderId, OrderStatus, FulfillmentChannel, and LastUpdateDate.
[Read more]
Parameters
| Parameter |
Label |
Required |
Options |
Description |
| CreatedAfter |
CreatedAfter |
NO |
|
A UTC date used for selecting orders created after (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error.
|
| CreatedBefore |
CreatedBefore |
NO |
|
A UTC date used for selecting orders created before (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z)
|
| LastUpdatedAfter |
LastUpdatedAfter |
NO |
|
A UTC date used for selecting orders that were last updated after (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified.
|
| LastUpdatedBefore |
LastUpdatedBefore |
NO |
|
A UTC date used for selecting orders that were last updated before (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z)
|
| OrderStatus |
OrderStatus |
NO |
| Option |
Value |
| Pending |
Pending |
| Unshipped |
Unshipped |
| PartiallyShipped |
PartiallyShipped |
| PendingAvailability |
PendingAvailability |
| Shipped |
Shipped |
| Canceled |
Canceled |
| Unfulfillable |
Unfulfillable |
|
A list of OrderStatus values. Used to select orders with a current status that matches one of the status values that you specify.
|
| FulfillmentChannel |
FulfillmentChannel |
NO |
| Option |
Value |
| Fulfilled by Amazon |
AFN |
| Fulfilled by the seller |
MFN |
|
A list that indicates how an order was fulfilled.
|
| PaymentMethod |
PaymentMethod |
NO |
| Option |
Value |
| Cash on delivery |
COD |
| Convenience store payment |
CVS |
| Any payment method other than COD or CVS |
Other |
|
A list of PaymentMethod values. Used to select orders paid for with the payment methods that you specify.
|
| BuyerEmail |
BuyerEmail |
NO |
|
The e-mail address of a buyer. Used to select only the orders that contain the specified e-mail address. If BuyerEmail is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and SellerOrderId cannot be specified.
|
| SellerOrderId |
SellerOrderId |
NO |
|
An order identifier that is specified by the seller. Not an Amazon order identifier. Used to select only the orders that match a seller-specified order identifier. If SellerOrderId is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and BuyerEmail cannot be specified.
|
| EasyShipShipmentStatus |
EasyShipShipmentStatus |
NO |
| Option |
Value |
| PendingPickUp# Amazon has not yet picked up the package from the seller |
PendingPickUp |
| LabelCanceled# The seller canceled the pickup |
LabelCanceled |
| PickedUp# Amazon has picked up the package from the seller |
PickedUp |
| OutForDelivery# The package is out for delivery |
OutForDelivery |
| Damaged# The package was damaged by the carrier |
Damaged |
| Delivered# Package has been delivered to the buyer. |
Delivered |
| RejectedByBuyer# Package has been rejected by the buyer. |
RejectedByBuyer |
| Undeliverable# The package cannot be delivered. |
Undeliverable |
| ReturnedToSeller# The package was not delivered to the customer and was returned to the seller. |
ReturnedToSeller |
| ReturningToSeller# The package was not delivered to the customer and is being returned to the seller. |
ReturningToSeller |
| Lost# Package was lost by the carrier. |
Lost |
|
A list of EasyShipShipmentStatus values. Used to select Easy Ship orders with current statuses that match the status values that you specify. If EasyShipShipmentStatus is specified, only Amazon Easy Ship orders are returned.This parameter is valid only in the India marketplace.
|
| Version |
Version |
NO |
|
|
| MarketplaceIdList |
MarketplaceIdList |
YES |
| Option |
Value |
| US |
ATVPDKIKX0DER |
| Brazil |
A2Q3Y263D00KWC |
| Canada |
A2EUQ1WTGCTBG2 |
| Mexico |
A1AM78C64UM0Y8 |
| United Arab Emirates (U.A.E.) |
A2VIGQ35RCS4UG |
| Germany |
A1PA6795UKMFR9 |
| Egypt |
ARBP9OOSHTCHU |
| Spain |
A1RKKUPIHCS9HS |
| France |
A13V1IB3VIYZZH |
| UK |
A1F83G8C2ARO7P |
| India |
A21TJRUUN4KGV |
| Italy |
APJ6JRA9NG5V4 |
| Netherlands |
A1805IZSGTT6HS |
| Saudi Arabia |
A17E79C6D8DWNP |
| Turkey |
A33AVAJ2PDY3EV |
| Singapore |
A19VAU5U5O7RUS |
| Australia |
A39IBJ37TRP1C6 |
| Japan |
A1VC38T7YXB528 |
|
|
Output Columns
| Name |
DataType |
Length |
Raw |
Description |
| AmazonOrderId |
DT_WSTR |
76 |
False |
|
| OrderTotal_Amount |
DT_NUMERIC |
0 |
False |
|
| OrderTotal_CurrencyCode |
DT_WSTR |
255 |
False |
|
| BuyerName |
DT_WSTR |
255 |
False |
|
| OrderStatus |
DT_WSTR |
32 |
False |
|
| OrderType |
DT_WSTR |
52 |
False |
|
| PurchaseDate |
DT_DBTIMESTAMP |
0 |
False |
|
| LatestShipDate |
DT_DBTIMESTAMP |
0 |
False |
|
| PaymentMethod |
DT_WSTR |
20 |
False |
|
| ShippingAddress_City |
DT_WSTR |
255 |
False |
|
| ShippingAddress_PostalCode |
DT_WSTR |
40 |
False |
|
| ShippingAddress_isAddressSharingConfidential |
DT_WSTR |
20 |
False |
|
| ShippingAddress_StateOrRegion |
DT_WSTR |
255 |
False |
|
| ShippingAddress_CountryCode |
DT_WSTR |
255 |
False |
|
| ShippingAddress_Name |
DT_WSTR |
255 |
False |
|
| ShippingAddress_AddressLine1 |
DT_WSTR |
255 |
False |
|
| ShippingAddress_AddressLine2 |
DT_WSTR |
255 |
False |
|
| ShippingAddress_County |
DT_WSTR |
255 |
False |
|
| LastUpdateDate |
DT_DBTIMESTAMP |
0 |
False |
|
| IsReplacementOrder |
DT_WSTR |
20 |
False |
|
| NumberOfItemsShipped |
DT_I4 |
0 |
False |
|
| ShipServiceLevel |
DT_WSTR |
36 |
False |
|
| SalesChannel |
DT_WSTR |
40 |
False |
|
| IsBusinessOrder |
DT_WSTR |
20 |
False |
|
| NumberOfItemsUnshipped |
DT_I4 |
0 |
False |
|
| PaymentMethodDetails_PaymentMethodDetail |
DT_WSTR |
32 |
False |
|
| IsGlobalExpressEnabled |
DT_WSTR |
20 |
False |
|
| IsSoldByAB |
DT_WSTR |
20 |
False |
|
| IsPremiumOrder |
DT_WSTR |
20 |
False |
|
| EarliestShipDate |
DT_DBTIMESTAMP |
0 |
False |
|
| MarketplaceId |
DT_WSTR |
52 |
False |
|
| FulfillmentChannel |
DT_WSTR |
12 |
False |
|
| IsPrime |
DT_WSTR |
20 |
False |
|
| SellerOrderId |
DT_WSTR |
76 |
False |
|
| ShipmentServiceLevelCategory |
DT_WSTR |
36 |
False |
|
| BuyerEmail |
DT_WSTR |
255 |
False |
|
Input Columns
| Name |
DataType |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
