Returns the order items information for a specified order search criterial (All orders by Create/Update date, status etc)
Parameter |
Label |
Required |
Options |
Description |
CreatedAfter |
CreatedAfter |
NO |
Option |
Value |
2023-12-31 |
2023-12-31 |
2023-12-31T00:00:00 |
2023-12-31T00:00:00 |
now |
now |
now-24h |
now-24h |
today |
today |
yesterday |
yesterday |
yearstart-10y |
yearstart-10y |
monthstart |
monthstart |
monthend |
monthend |
yearstart |
yearstart |
yearend |
yearend |
weekstart |
weekstart |
weekend |
weekend |
yearstart-1y |
yearstart-1y |
yearend-1y |
yearend-1y |
monthstart-1d |
monthstart-1d |
monthend+1d |
monthend+1d |
monthend+1d-1y |
monthend+1d-1y |
|
A UTC date used for selecting orders created after (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
|
CreatedBefore |
CreatedBefore |
NO |
Option |
Value |
2023-12-31 |
2023-12-31 |
2023-12-31T00:00:00 |
2023-12-31T00:00:00 |
now |
now |
now-24h |
now-24h |
today |
today |
yesterday |
yesterday |
yearstart-10y |
yearstart-10y |
monthstart |
monthstart |
monthend |
monthend |
yearstart |
yearstart |
yearend |
yearend |
weekstart |
weekstart |
weekend |
weekend |
yearstart-1y |
yearstart-1y |
yearend-1y |
yearend-1y |
monthstart-1d |
monthstart-1d |
monthend+1d |
monthend+1d |
monthend+1d-1y |
monthend+1d-1y |
|
A UTC date used for selecting orders created before (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
|
LastUpdatedAfter |
LastUpdatedAfter |
NO |
Option |
Value |
2023-12-31 |
2023-12-31 |
2023-12-31T00:00:00 |
2023-12-31T00:00:00 |
now |
now |
now-24h |
now-24h |
today |
today |
yesterday |
yesterday |
yearstart-10y |
yearstart-10y |
monthstart |
monthstart |
monthend |
monthend |
yearstart |
yearstart |
yearend |
yearend |
weekstart |
weekstart |
weekend |
weekend |
yearstart-1y |
yearstart-1y |
yearend-1y |
yearend-1y |
monthstart-1d |
monthstart-1d |
monthend+1d |
monthend+1d |
monthend+1d-1y |
monthend+1d-1y |
|
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. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
|
LastUpdatedBefore |
LastUpdatedBefore |
NO |
Option |
Value |
2023-12-31 |
2023-12-31 |
2023-12-31T00:00:00 |
2023-12-31T00:00:00 |
now |
now |
now-24h |
now-24h |
today |
today |
yesterday |
yesterday |
yearstart-10y |
yearstart-10y |
monthstart |
monthstart |
monthend |
monthend |
yearstart |
yearstart |
yearend |
yearend |
weekstart |
weekstart |
weekend |
weekend |
yearstart-1y |
yearstart-1y |
yearend-1y |
yearend-1y |
monthstart-1d |
monthstart-1d |
monthend+1d |
monthend+1d |
monthend+1d-1y |
monthend+1d-1y |
|
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. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
|
OrderStatuses |
OrderStatuses |
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.
|
MarketplaceIds |
MarketplaceIds |
YES |
Option |
Value |
United States of America |
ATVPDKIKX0DER |
Brazil |
A2Q3Y263D00KWC |
Canada |
A2EUQ1WTGCTBG2 |
Mexico |
A1AM78C64UM0Y8 |
Spain |
A1RKKUPIHCS9HS |
United Kingdom |
A1F83G8C2ARO7P |
France |
A13V1IB3VIYZZH |
Belgium |
AMEN7PMS3EDWL |
Netherlands |
A1805IZSGTT6HS |
Germany |
A1PA6795UKMFR9 |
Italy |
APJ6JRA9NG5V4 |
Sweden |
A2NODRKZP88ZB9 |
South Africa |
AE08WJ6YKNBMC |
Poland |
A1C3SOZRARQ6R3 |
Egypt |
ARBP9OOSHTCHU |
Turkey |
A33AVAJ2PDY3EV |
Saudi Arabia |
A17E79C6D8DWNP |
United Arab Emirates (U.A.E.) |
A2VIGQ35RCS4UG |
India |
A21TJRUUN4KGV |
Singapore |
A19VAU5U5O7RUS |
Australia |
A39IBJ37TRP1C6 |
Japan |
A1VC38T7YXB528 |
|
|
FulfillmentChannels |
FulfillmentChannels |
NO |
Option |
Value |
Fulfilled by Amazon |
AFN |
Fulfilled by the seller |
MFN |
|
A list that indicates how an order was fulfilled.
|
PaymentMethods |
PaymentMethods |
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.
|
MaxResultsPerPage |
MaxResultsPerPage |
NO |
|
A number that indicates the maximum number of orders that can be returned per page. Value must be 1 - 100. Default 100.
|
EasyShipShipmentStatuses |
EasyShipShipmentStatuses |
NO |
Option |
Value |
PendingSchedule |
PendingSchedule |
PendingPickUp |
PendingPickUp |
PendingDropOff |
PendingDropOff |
LabelCanceled |
LabelCanceled |
PickedUp |
PickedUp |
DroppedOff |
DroppedOff |
AtOriginFC |
AtOriginFC |
AtDestinationFC |
AtDestinationFC |
Delivered |
Delivered |
RejectedByBuyer |
RejectedByBuyer |
Undeliverable |
Undeliverable |
ReturningToSeller |
ReturningToSeller |
ReturnedToSeller |
ReturnedToSeller |
Lost |
Lost |
OutForDelivery |
OutForDelivery |
Damaged |
Damaged |
|
A list of EasyShipShipmentStatus values. Used to select Easy Ship orders with statuses that match the specified values. If EasyShipShipmentStatus is specified, only Amazon Easy Ship orders are returned. Possible values: - PendingSchedule (The package is awaiting the schedule for pick-up.) - PendingPickUp (Amazon has not yet picked up the package from the seller.) - PendingDropOff (The seller will deliver the package to the carrier.) - LabelCanceled (The seller canceled the pickup.) - PickedUp (Amazon has picked up the package from the seller.) - DroppedOff (The package is delivered to the carrier by the seller.) - AtOriginFC (The packaged is at the origin fulfillment center.) - AtDestinationFC (The package is at the destination fulfillment center.) - Delivered (The package has been delivered.) - RejectedByBuyer (The package has been rejected by the buyer.) - Undeliverable (The package cannot be delivered.) - ReturningToSeller (The package was not delivered and is being returned to the seller.) - ReturnedToSeller (The package was not delivered and was returned to the seller.) - Lost (The package is lost.) - OutForDelivery (The package is out for delivery.) - Damaged (The package was damaged by the carrier.)
|
ElectronicInvoiceStatuses |
ElectronicInvoiceStatuses |
NO |
Option |
Value |
NotRequired |
NotRequired |
NotFound |
NotFound |
Processing |
Processing |
Errored |
Errored |
Accepted |
Accepted |
|
A list of ElectronicInvoiceStatus values. Used to select orders with electronic invoice statuses that match the specified values. Possible values: - NotRequired (Electronic invoice submission is not required for this order.) - NotFound (The electronic invoice was not submitted for this order.) - Processing (The electronic invoice is being processed for this order.) - Errored (The last submitted electronic invoice was rejected for this order.) - Accepted (The last submitted electronic invoice was submitted and accepted.)
|
AmazonOrderIds |
AmazonOrderIds |
NO |
|
Comma separated list of AmazonOrderId values. An AmazonOrderId is an Amazon-defined order identifier, in 3-7-7 format. Max count : 50
|
ActualFulfillmentSupplySourceId |
ActualFulfillmentSupplySourceId |
NO |
|
Denotes the recommended sourceId where the order should be fulfilled from.
|
IsISPU |
IsISPU |
NO |
|
When true, this order is marked to be picked up from a store rather than delivered.
|
StoreChainStoreId |
StoreChainStoreId |
NO |
|
The store chain store identifier. Linked to a specific store in a store chain.
|