Query sales orders
query_sales_ordersReturns one store's sales orders with all order items in descending purchase time. Uses a UTC start-inclusive, end-exclusive window of at most 31 days. Excludes canceled, non-Amazon and replacement orders. SKU and promotion filters select whole orders. The time window always filters purchasedAt (order purchase time), never refund or return event time. REFUND means the order currently has a refund flag in the latest synchronized data; it does not necessarily mean a full refund or a physical return. An order purchased in July and refunded in September matches a July purchase window with REFUND, but not a September purchase window. Historical results may change after later refunds are synchronized. This endpoint cannot answer which refunds or returns occurred during a period. Amounts may be estimated; amounts after promotion are not settlement proceeds. Missing prices or order currency produce null amounts. Use this endpoint for individual orders and their items; use Sales reports for aggregated sales metrics and Profit reports for profit, refunds and costs. Order amount sums are not guaranteed to reconcile with report sales or netSales. Returns no total count. Offset pagination is not a snapshot; deduplicate by storeId and orderId when collecting changing data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skus | No | Exact seller SKUs, at most 100. Any matching item selects the whole order; all order items are returned. | |
| endAt | Yes | Exclusive purchase time in UTC yyyy-MM-dd'T'HH:mm:ss'Z' format. Must be after startAt and at most 31 days later. Applies to purchasedAt even when statuses includes REFUND; not a refund or return time boundary. | |
| limit | No | Maximum number of items to return. Defaults to 100 and cannot exceed 100. | |
| offset | No | Zero-based pagination offset. | |
| startAt | Yes | Inclusive purchase time in UTC yyyy-MM-dd'T'HH:mm:ss'Z' format, for example 2024-04-05T23:30:00Z. Whole seconds only. Applies to purchasedAt even when statuses includes REFUND; not a refund or return time boundary. | |
| storeId | Yes | Store ID from the Stores API, formatted as sellerId:marketplaceId. | |
| orderIds | No | Exact order IDs, at most 100. The purchase time window still applies. | |
| statuses | No | Optional business statuses: PENDING, UNSHIPPED, SHIPPED, REFUND. Leave empty for all visible statuses. UNSHIPPED applies to merchant fulfillment. The time window always filters purchasedAt (order purchase time), never refund or return event time. REFUND means the order currently has a refund flag in the latest synchronized data; it does not necessarily mean a full refund or a physical return. An order purchased in July and refunded in September matches a July purchase window with REFUND, but not a September purchase window. Historical results may change after later refunds are synchronized. This endpoint cannot answer which refunds or returns occurred during a period. | |
| fulfillmentChannel | No | Optional fulfillment channel: AFN (Amazon) or MFN (merchant). Leave empty to include both. | |
| hasPromotionDiscount | No | Optional true or false. True selects orders with any nonzero recorded item promotion discount; false selects orders without such items. This does not indicate promotion campaign membership. SKU and discount filters are evaluated independently across all items in an order. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||