Skip to main content

Amazon Sales Connector

Amazon Selling Partner API data integration for Sales Reports

Openbridge Support avatar
Written by Openbridge Support
Updated over 6 months ago

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

  • sp_fba_sns_performance (Subscribe and Save Performance)

  • sp_fba_sns_forecast (Subscribe and Save Forecast)

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.

Did this answer your question?