Daily product-level details on completed customer orders, including purchase price, quantity, tracking, and shipping information. The following report types are included:
GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA
GET_AFN_INVENTORY_DATA
This results in a collection of datasets in a destination:
sp_fba_afn_inventory
sp_fba_customer_shipment_sales
sp_fba_fulfilled_shipments
Amazon Fulfillment connector leverages the Amazon Reporting API for the above report types. This API provides preset, Amazon-defined FBA business reports. See Amazon's docs for more details on the various report types below.
Frequency
While the FBA Fulfillment reports are considered near-real time, API limits precluded requesting more frequently than daily. Also, the data in these reports are not "settled" quickly, meaning that while Amazon may provide a report, the data in it is not complete (see Lookbacks)
Lookbacks
Trailing fulfillment records may appear later for a prior reporting period. For example, on 8/1, a request is made for the fulfillment report. The data is returned. However, on 8/3, if a request is made for 8/1 again, additional fulfillment records will be updated at Amazon for the 8/1 date. As a result, we use a -1, -2, and -7 look back to care for this behavior.