rpt_orders
Seller reports (SP-API) · GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL|GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL · Every hour, on the hour
How fresh is it?
Hourly
Every hour, on the hour
| Family | Seller reports (SP-API) |
|---|---|
| Report type | GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL|GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL |
| Grain | region |
| Sync | incremental |
| Business date | purchase_date |
Columns (68)
| Column | Type | Key |
|---|---|---|
id | INTEGER | |
store_id | VARCHAR(36) | 🔑 key |
report_date | DATE | |
amazon_order_id | VARCHAR(50) | 🔑 key |
merchant_order_id | VARCHAR(50) | |
purchase_date | TIMESTAMP WITH TIME ZONE | |
last_updated_date | TIMESTAMP WITH TIME ZONE | |
order_status | VARCHAR(50) | |
fulfillment_channel | VARCHAR(20) | |
sales_channel | VARCHAR(100) | |
order_channel | VARCHAR(100) | |
ship_service_level | VARCHAR(50) | |
product_name | TEXT | |
sku | VARCHAR(200) | 🔑 key |
asin | VARCHAR(20) | |
item_status | VARCHAR(50) | |
ship_city | VARCHAR(100) | |
ship_state | VARCHAR(100) | |
ship_postal_code | VARCHAR(20) | |
ship_country | VARCHAR(10) | |
quantity | INTEGER | |
currency | VARCHAR(10) | |
item_price | NUMERIC(12, 2) | |
item_tax | NUMERIC(12, 2) | |
shipping_price | NUMERIC(12, 2) | |
shipping_tax | NUMERIC(12, 2) | |
gift_wrap_price | NUMERIC(12, 2) | |
gift_wrap_tax | NUMERIC(12, 2) | |
item_promotion_discount | NUMERIC(12, 2) | |
ship_promotion_discount | NUMERIC(12, 2) | |
promotion_ids | TEXT | |
is_business_order | VARCHAR(10) | |
number_of_items | INTEGER | |
price_designation | VARCHAR(50) | |
buyer_company_name | VARCHAR(200) | |
purchase_order_number | VARCHAR(100) | |
buyer_tax_registration_country | VARCHAR(10) | |
buyer_tax_registration_type | VARCHAR(50) | |
tax_collection_model | VARCHAR(50) | |
tax_collection_responsible_party | VARCHAR(50) | |
is_exchange_order | VARCHAR(10) | |
is_replacement_order | VARCHAR(10) | |
is_transparency | VARCHAR(10) | |
payment_method_details | TEXT | |
item_amazon_funded_promotion | VARCHAR(10) | |
amazon_programs | TEXT | |
fulfilled_by | VARCHAR(50) | |
is_iba | VARCHAR(10) | |
is_buyer_requested_cancellation | VARCHAR(10) | |
buyer_requested_cancel_reason | VARCHAR(255) | |
signature_confirmation_recommended | VARCHAR(10) | |
order_item_id | VARCHAR(50) | 🔑 key |
is_prime | VARCHAR(10) | |
is_amazon_invoiced | VARCHAR(10) | |
vat_exclusive_item_price | NUMERIC(12, 2) | |
vat_exclusive_shipping_price | NUMERIC(12, 2) | |
vat_exclusive_giftwrap_price | NUMERIC(12, 2) | |
item_total | NUMERIC(12, 2) | |
amount_paid_by_buyer | NUMERIC(12, 2) | |
original_order_id | VARCHAR(50) | |
ioss_number | VARCHAR(50) | |
address_type | VARCHAR(50) | |
is_heavy_or_bulky | VARCHAR(10) | |
license_expiration_date | DATE | |
license_state | VARCHAR(50) | |
order_kind | VARCHAR(10) | |
marketplace | VARCHAR(10) | |
extra | JSON |
Query it
In an AI client (MCP)
{
"name": "query_report_data",
"arguments": {
"store": "myStore-US",
"tables": [
"rpt_orders"
],
"columns": [
"rpt_orders.amazon_order_id",
"rpt_orders.sku",
"rpt_orders.order_item_id"
],
"order_by": [
{
"column": "rpt_orders.purchase_date",
"dir": "desc"
}
],
"limit": 100
}
}From code (Tool API)
curl -X POST https://api.sellersheetai.com/api/v1/tools/query_report_data \
-H "Authorization: Bearer $SELLERSHEET_API_KEY" \
-H "Content-Type: application/json" \
-d '{"store":"myStore-US","tables":["rpt_orders"],"columns":["rpt_orders.amazon_order_id","rpt_orders.sku","rpt_orders.order_item_id"],"order_by":[{"column":"rpt_orders.purchase_date","dir":"desc"}],"limit":100}'Early access — the Tool API is open on request, contact us.