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 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.
The following is a collection of tables and views that will be resident in your target destination;
sp_fba_fulfilled_shipments
sp_fba_removal_order_detail
sp_fba_removal_shipment_detail
sp_fba_replacements
sp_fba_returns
sp_fba_stranded_inventory
sp_orders_report
sp_returns
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 leverages 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.