Order Reports
Order Reports
Flat File Orders By Order Date Report
Table name: sellercentral_ordersbydate_report
Seller Central Console Report: All Order Reports (Help)
For details on data availability and refresh schedule, please click here.
account_id
Integer
account_name
String
seller_id
String
amazon_order_id
String
merchant_order_id
String
purchase_date
Date Time
last_updated_date
Date Time
order_status
String
fulfillment_channel
String
sales_channel
String
order_channel
String
url
String
ship_service_level
String
product_name
String
sku
String
asin
String
item_status
String
quantity
Integer
currency
String
item_price
Numeric
item_tax
Numeric
shipping_price
Numeric
shipping_tax
Numeric
gift_wrap_price
Numeric
gift_wrap_tax
Numeric
item_promotion_discount
Numeric
ship_promotion_discount
Numeric
ship_city
String
ship_state
String
ship_postal_code
String
ship_country
String
promotion_ids
String
purchase_order_number
String
price_designation
String
report
Integer
is_business_order
Boolean
buyer_company_name
String
is_replacement_order
Boolean
is_exchange_order
Boolean
original_order_id
String
Flat File Orders By Last Update Report
Table name: sellercentral_ordersbylastupdate_report
Seller Central Console Report: Updated Orders (Help)
For details on data availability and refresh schedule, please click here.
account_id
Integer
account_name
String
currency_code
String
amazon_order_id
String
merchant_order_id
String
purchase_date
Timestamp
last_updated_date
Timestamp
order_status
String
fulfillment_channel
String
sales_channel
String
order_channel
String
ship_service_level
String
product_name
String
sku
String
asin
String
number_of_items
Integer
item_status
String
quantity
Integer
currency
String
item_price
Numeric
item_tax
Numeric
shipping_price
Numeric
shipping_tax
Numeric
gift_wrap_price
Numeric
gift_wrap_tax
Numeric
item_promotion_discount
Numeric
ship_promotion_discount
Numeric
ship_city
String
ship_state
String
ship_postal_code
String
ship_country
String
promotion_ids
String
is_business_order
Boolean
purchase_order_number
String
price_designation
String
buyer_company_name
String
license_state
String
license_expiration_date
Timestamp
download_date
Date
Last updated