Release Notes

February 2025

For new connectors created after 9th February, 2025, we have added a new field, Historical sync time frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connector, you can edit the connection details and set the time frame value. For more information, see our Amazon Selling Partner documentation.

We apply the historical sync limit to the following tables only:

• APPROVAL_SUPPORT_DATA_ELEMENT
• FINANCIAL_ADHOC_DISBURSEMENT_EVENT
• FINANCIAL_AFFORDABILITY_EXPENSE_EVENT
• FINANCIAL_CAPACITY_RESERVATION_BILLING_EVENT
• FINANCIAL_CHARGE_COMPONENT
• FINANCIAL_CHARGE_INSTRUMENT
• FINANCIAL_CHARGE_REFUND_EVENT
• FINANCIAL_COUPON_PAYMENT_EVENT
• FINANCIAL_DEBT_RECOVERY_EVENT
• FINANCIAL_DEBT_RECOVERY_ITEM
• FINANCIAL_FAILED_ADHOC_DISBURSEMENT_EVENT
• FINANCIAL_FBA_LIQUIDATION_EVENT
• FINANCIAL_FEE_COMPONENT
• FINANCIAL_IMAGING_SERVICES_FEE_EVENT
• FINANCIAL_PAY_WITH_AMAZON_EVENT
• FINANCIAL_PRODUCT_ADS_PAYMENT_EVENT
• FINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENT
• FINANCIAL_REMOVAL_SHIPMENT_EVENT
• FINANCIAL_REMOVAL_SHIPMENT_ITEM
• FINANCIAL_REMOVAL_SHIPMENT_ITEM_ADJUSTMENT
• FINANCIAL_RENTAL_TRANSACTION
• FINANCIAL_RETRO_CHARGE_EVENT
• FINANCIAL_SAFET_REIMBURSEMENT_EVENT
• FINANCIAL_SAFET_REIMBURSEMENT_ITEM
• FINANCIAL_SELLER_DEAL_PAYMENT_EVENT
• FINANCIAL_SELLER_REVIEW_ENROLLMENT_PAYMENT_EVENT
• FINANCIAL_SERVICE_FEE_EVENT
• FINANCIAL_SHIPMENT_DIRECT_PAYMENT
• FINANCIAL_SHIPMENT_EVENT
• FINANCIAL_SHIPMENT_EVENT_ITEM
• FINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTION
• FINANCIAL_SOLUTION_PROVIDER_CREDIT_EVENT
• FINANCIAL_TAX_WITHHOLDING_EVENT
• FINANCIAL_TDS_REIMBURSEMENT_EVENT
• FINANCIAL_TRIAL_SHIPMENT_EVENT
• FINANCIAL_VALUE_ADDED_SERVICE_CHARGE_EVENT
• MARKET_BASKET_ANALYSIS_REPORT_DAILY
• MARKET_BASKET_ANALYSIS_REPORT_MONTHLY
• MARKET_BASKET_ANALYSIS_REPORT_QUARTERLY
• MARKETPLACE_TAX_CLASSIFICATION
• NET_PURE_PRODUCT_MARGIN_REPORT_DAILY
• NET_PURE_PRODUCT_MARGIN_REPORT_MONTHLY
• NET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLY
• NETWORK_COMMINGLING_TRANSACTION_EVENT
• ORDER
• ORDER_ITEMS
• ORDERS_ITEM_PROMOTION_ID
• ORDER_ITEM_SERIAL_NUMBER
• ORDER_REGULATED_INFO
• PAYMENT_EXECUTION_DETAIL_ITEM
• PAYMENT_METHOD_DETAIL_ITEM
• RAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_HOURLY
• RAPID_RETAIL_ANALYTICS_SALES_REPORT_HOURLY
• RAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_HOURLY
• REGULATED_INFORMATION_FIELD
• REPEAT_PURCHASE_REPORT_MONTHLY
• REPEAT_PURCHASE_REPORT_QUARTERLY
• SALES_AND_TRAFFIC_BUSINESS_REPORT_DAILY
• SALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLY
• SEARCH_TERMS_REPORT_DAILY
• SEARCH_TERMS_REPORT_MONTHLY
• SEARCH_TERMS_REPORT_QUARTERLY
• VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_DAILY
• VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLY
• VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLY
• VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_DAILY
• VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLY
• VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLY
• VENDOR_INVENTORY_SOURCING_FRESH_REPORT_DAILY
• VENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLY
• VENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLY
• VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_DAILY
• VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLY
• VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLY
• VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_DAILY
• VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLY
• VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLY
• VENDOR_SALES_MANUFACTURING_FRESH_REPORT_DAILY
• VENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLY
• VENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLY
• VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_DAILY
• VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLY
• VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLY
• VENDOR_SALES_SOURCING_BUSINESS_REPORT_DAILY
• VENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLY
• VENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLY
• VENDOR_SALES_SOURCING_FRESH_REPORT_DAILY
• VENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLY
• VENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLY
• VENDOR_SALES_SOURCING_RETAIL_REPORT_DAILY
• VENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLY
• VENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLY
• VENDOR_TRAFFIC_REPORT_DAILY
• VENDOR_TRAFFIC_REPORT_MONTHLY
• VENDOR_TRAFFIC_REPORT_QUARTERLY

January 2025

We have resolved an issue that caused the LISTED_ITEM_ISSUE, LISTED_ITEM_OFFERS, and ITEM_FULFILLMENT_AVAILABILITY tables to not sync correctly.

September 2024

We have fixed a bug where we didn’t sync a few records of the VENDOR_RETAIL_PROCUREMENT_ORDER and VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM tables.

We have added the following new tables to support the Catalog module for Amazon vendor accounts:

• CATALOG
• ITEM_CLASSIFICATION_SALES_RANK
• ITEM_CONTRIBUTOR
• ITEM_DIMENSION
• ITEM_DISPLAY_GROUP_SALES_RANK
• ITEM_IDENTIFIER
• ITEM_IMAGE
• ITEM_PRODUCT_TYPE
• ITEM_RELATIONSHIP
• ITEM_SUMMARY
• ITEM_VARIATION_THEME
• ITEM_VENDOR_DETAILS

We have made the following schema changes for all Amazon Selling Partner connectors:

• We have changed the primary key of the VENDOR_RETAIL_PROCUREMENT_SHIPMENT table and its child tables. The new composite key is a combination of the vendor_shipment_identifier and transaction_date columns. If any of the two columns are NULL, we will skip these tables to avoid sync failures.
• We have changed the primary key of the CONTAINER_PACKED_ITEM table. The new composite key is a combination of the index, container_sequence_number, container_type, transaction_date, and vendor_shipment_identifier columns to avoid data integrity issues.
• We have changed the primary key of the SHIPMENT_STATUS_DETAIL table. The new composite key is a combination of the index, transaction_date, and shipment_status columns.
• We will skip the records of the VENDOR_SHIPPING_ORDER if any of the columns purchase_order_date or purchase_order_number is null.

August 2024

We have fixed a bug whereby a few fields were being synced under an incorrect names in the item_offer_summary table. You need to trigger a resync to backfill the records with the correct column names.

June 2024

To ensure data accuracy, we now sync the past two days' worth of SALES_AND_TRAFFIC_BUSINESS_REPORT_DAILY reports. Previously, we synced one day's worth of these reports due to source side limitations. It may take up to two days to reflect for the destination to reflect correct data. Learn more in our Amazon Selling Partner reports documentation.

March 2024

Our Amazon Selling Partner connector is now generally available. Read our Amazon Selling Partner documentation.

February 2024

We have changed the primary key of the ITEM_OFFER_DETAIL table. The new composite primary key is a combination of the asin, sub_condition, and index columns.

October 2023

We now support the Reports API. To sync data from these reports, go to the Schema tab of your Fivetran dashboard and select your report tables. If you are unable to select the report tables, re-authorize the connector. To learn more, see our Reports document.

September 2023

The Amazon Selling Partner connector now supports priority-first sync for the FINANCE module. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Amazon Selling Partner's priority-first syncs fetch the most recent 7 days' worth of data from the FINANCE module. To learn more, see our priority-first sync documentation.

We have added two new tables, FINANCIAL_SHIPMENT_EVENT_ITEM and FINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTION.

We have added a new column, event_type, to the FINANCIAL_AFFORDABILITY_EXPENSE_EVENT and FINANCIAL_SHIPMENT_EVENT tables.

We have added a new column, inventory_summary_id, to the FBA_INVENTORY_RESEARCHING_QUANTITY_ENTRY table.

We have added the following new columns to the FINANCIAL_CHARGE_COMPONENT table:

• charge_kind
• linked_to
• linked_to_id

We have added the following new columns to the FINANCIAL_FEE_COMPONENT table:

• fee_kind
• linked_to
• linked_to_id

We have added a new primary key column, _fivetran_id, to the FBA_INVENTORY_SUMMARY and FINANCIAL_SAFET_REIMBURSEMENT_ITEM tables.

We have deprecated the financial_event_id and financial_event_type columns in the FINANCIAL_CHARGE_COMPONENT and FINANCIAL_FEE_COMPONENT tables.

We are gradually rolling out these changes to all existing connectors.

We have deprecated the ORDER_ITEM_APPROVAL_STATUS and ORDER_ITEM_APPROVAL_TYPE tables because the Orders API v0 has deprecated the ItemApprovalTypes and ItemApprovalStatus attributes.

July 2023

The Amazon Selling Partner connector now supports priority-first sync for the ORDERS table. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. To learn more, see our priority-first sync documentation.

June 2023

Amazon Selling Partner is a leading ecommerce platform. Read our Amazon Selling Partner connector documentation.