The Amazon Sales connector reflects a logical grouping of reports Amazon groups under "Sales Reporting" in the Seller Central UI.
The Amazon Sales Connector offers information on both FBA and seller-fulfilled orders, including order status, fulfillment, sales channel information, and product details. The following report types are included:
GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA
GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA
GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE
GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA
GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL*
GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL*
*Note: Given the shared context (order tracking reports) and schema for ORDER_DATE_GENERAL
and LAST_UPDATE_GENERAL
are combined into a common "Orders Report" table.
Per Amazon, ORDER_DATE_GENERAL
and LAST_UPDATE_GENERAL
are available in North America (NA) and Europe (EU). These reports return all orders, regardless of fulfillment channel or shipment status. These reports are intended for order tracking and do not include customer-identifying information. For self-fulfilled orders, item price is not shown for orders in a "pending" state.
Amazon Sales leverage the Amazon Reporting API for the report types listed above. This API provides preset, Amazon-defined FBA business reports. For more details on the various report types detailed below, see Amazon's docs.
Understanding Limits To Sales Reports
There are limits to how often Amazon will generate FBA reports. These limits depend on whether an FBA report is a near-real-time report or a daily report. The reports listed above are provided at a DAILY interval as defined and made available by Amazon.
Per Amazon, the following are notes on the above report types:
Daily FBA reports are generated by Amazon no more than once every four hours. This means that after a daily FBA report is generated following your report request, a four-hour waiting period must pass before Amazon will generate an updated version of that report. If you have multiple tools making the same report request within this time period, Amazon will cancel requests.
Order tracking reports are available in North America (NA) and Europe (EU). For all sellers. These reports return all orders, regardless of fulfillment channel or shipment status. These reports are intended for order tracking, not to drive a seller's fulfillment process, as the reports do not include customer-identifying information, and scheduling is not supported. Also note that for self-fulfilled orders, item price is not shown for orders in a "pending" state.
For real-time reports, see Amazon Fulfillment Real-Time or Amazon Orders API.