Release Notes
October 2025
We have added the MARKETPLACE_PARTICIPATION table.
We are gradually rolling out this change to all connections.
We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We’re updating the sync frequency to once a day for the following reports in the Amazon Selling Partner connector.
CUSTOMER_SHIPMENT_SALES_REPORTFULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_REPORTLONG_TERM_STORAGE_FEE_CHARGES_REPORTMARKET_BASKET_ANALYSIS_REPORT_MONTHLYMARKET_BASKET_ANALYSIS_REPORT_QUARTERLYNET_PURE_PRODUCT_MARGIN_REPORT_MONTHLYNET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLYORDERS_REPORTREIMBURSEMENTS_REPORTREPEAT_PURCHASE_REPORT_MONTHLYREPEAT_PURCHASE_REPORT_QUARTERLYSALES_AND_TRAFFIC_BUSINESS_CHILD_ASIN_REPORT_MONTHLYSALES_AND_TRAFFIC_BUSINESS_PARENT_ASIN_REPORT_MONTHLYSALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLYSALES_AND_TRAFFIC_BUSINESS_SKU_REPORT_MONTHLYSEARCH_TERMS_REPORT_MONTHLYSEARCH_TERMS_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_FRESH_ASIN_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_FRESH_ASIN_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_ASIN_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_ASIN_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_FRESH_ASIN_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_FRESH_ASIN_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_RETAIL_ASIN_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_RETAIL_ASIN_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_BUSINESS_ASIN_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_BUSINESS_ASIN_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_FRESH_ASIN_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_FRESH_ASIN_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_RETAIL_ASIN_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_RETAIL_ASIN_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_SOURCING_BUSINESS_ASIN_REPORT_MONTHLYVENDOR_SALES_SOURCING_BUSINESS_ASIN_REPORT_QUARTERLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_SOURCING_FRESH_ASIN_REPORT_MONTHLYVENDOR_SALES_SOURCING_FRESH_ASIN_REPORT_QUARTERLYVENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLYVENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_SALES_SOURCING_RETAIL_ASIN_REPORT_MONTHLYVENDOR_SALES_SOURCING_RETAIL_ASIN_REPORT_QUARTERLYVENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_TRAFFIC_REPORT_MONTHLYVENDOR_TRAFFIC_REPORT_QUARTERLY
September 2025
We have made the following improvements to the connection setup form:
- Merchant ID/Vendor Code no longer displays when the Vendor Account toggle is active.
- We have renamed the Merchant ID/Vendor Code field to Merchant ID, which is a read-only field and updates automatically from the URL after OAuth authorization.
We are gradually rolling out these changes to all the connections.
We have updated the Quickstart packages for the following connectors:
- Amazon Selling Partner to version 0.2.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
- Qualtrics to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
- QuickBooks to version 0.21.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
- Recharge to version 1.1.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 20, 2025.
- Reddit Ads to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 12, 2025.
- SAP ERP on HANA to version 0.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
- Shopify to version 0.22.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
- Zendesk Support to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
We now capture deletes for ITEM_RELATIONSHIP table in CATALOG module using _fivetran_deleted column. This boolean column flags rows marked as deleted.
We are gradually rolling out this change to all existing connections.
July 2025
We have added new tables facilitating vendor sales & inventory reports to have asin granularity. The following tables have been added and are available in multiple granularity (DAILY, MONTHLY, QUARTERLY):
VENDOR_SALES_SOURCING_RETAIL_ASIN_REPORT_*VENDOR_SALES_SOURCING_BUSINESS_ASIN_REPORT_*VENDOR_SALES_SOURCING_FRESH_ASIN_REPORT_*VENDOR_INVENTORY_MANUFACTURING_FRESH_ASIN_REPORT_*VENDOR_INVENTORY_MANUFACTURING_RETAIL_ASIN_REPORT_*VENDOR_INVENTORY_SOURCING_FRESH_ASIN_REPORT_*VENDOR_INVENTORY_SOURCING_RETAIL_ASIN_REPORT_*VENDOR_SALES_MANUFACTURING_FRESH_ASIN_REPORT_*VENDOR_SALES_MANUFACTURING_BUSINESS_ASIN_REPORT_*VENDOR_SALES_MANUFACTURING_RETAIL_ASIN_REPORT_*
We will gradually rolling out this change to all connections.
We have added the following tables to store Sales and Traffic Business Report data at ASIN granularity, with daily and monthly aggregations:
SALES_AND_TRAFFIC_BUSINESS_PARENT_ASIN_REPORT_*SALES_AND_TRAFFIC_BUSINESS_CHILD_ASIN_REPORT_*SALES_AND_TRAFFIC_BUSINESS_SKU_REPORT_*
We are gradually rolling out this change to all existing connections.
June 2025
We have removed the following tables from the schema dashboard, as they were never part of the connector’s data sync:
ADDITIONAL_SELLER_INPUTSAMAZON_PREP_FEES_DETAILASIN_INBOUND_GUIDANCEAVAILABLE_DELIVERY_EXPERIENCE_OPTIONAVAILABLE_SHIPPING_SERVICE_OPTIONINBOUND_SHIPMENT_INFOINBOUND_SHIPMENT_ITEMINBOUND_SHIPMENT_ITEM_PREP_DETAILITEM_CONTRIBUTORMERCHANT_FULFILLMENT_SHIPMENTMERCHANT_FULFILLMENT_SHIPMENT_ITEMNON_PARTNERED_LTL_DATA_OUTPUTNON_PARTNERED_SMALL_PARCEL_PACKAGE_OUTPUTPARTNERED_LTL_DATA_OUTPUTPARTNERED_LTL_DATA_OUTPUT_PALLETPARTNERED_SMALL_PARCELPARTNERED_SMALL_PARCEL_PACKAGE_OUTPUTPREORDER_INFO_RESULTPREP_INSTRUCTIONSKU_INBOUND_GUIDANCETAX_REGISTRATION_DETAILS_FOR_RETAIL_SHIPPINGTRANSPORT_CONTENT
This update does not affect any data sync behavior.
May 2025
We have removed the following tables:
VENDOR_DIRECT_FULFILLMENT_CUSTOMER_INVOICEVENDOR_DIRECT_FULFILLMENT_ORDERVENDOR_DIRECT_FULFILLMENT_ORDER_ITEMVENDOR_DIRECT_FULFILLMENT_SHIPPING_LABELVENDOR_DIRECT_FULFILLMENT_SHIPPING_LABEL_DATAVENDOR_DIRECT_FULFILLMENT_TAX_DETAIL
April 2025
We have fixed a bug where we didn't accurately sync the ITEM_VENDOR_DETAIL table.
We have added the following new reports to provide details about sales and payment:
CUSTOMER_SHIPMENT_SALES_REPORTFEE_PREVIEW_REPORTFULFILLED_SHIPMENTS_DATA_GENERAL_REPORTFULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_REPORTLONG_TERM_STORAGE_FEE_CHARGES_REPORTORDERS_REPORTREIMBURSEMENTS_REPORT
We are gradually rolling out this change to all existing connections.
We now provide an option to fetch the ORDER_REGULATED_INFO child table data as a configurable child table, allowing you to exclude it when you do not have the necessary permissions to access its data.
February 2025
We have added a new Quickstart package for the Amazon Selling Partner connector.
We have updated the Quickstart packages for the following connectors:
- Ad Reporting data model connectors to version 0.5.0
- Amplitude to version 0.6.0
- Apple App Store to version 0.5.0
- App reporting data model connectors to version 0.5.0
- Asana to version 0.8.3
- HubSpot to version 0.21.0
- Sage Intacct to version 0.6.0
- Shopify to version 0.17.0
- Snapchat Ads to version 0.8.0
- Stripe to version 0.16.1
- Zuora to version 0.3.2
For new connections created after 9th February, 2025, we have added a new drop-down menu, Historical sync time frame, to the connection setup form. This drop-down menu allows you to specify whether you want to sync all historical data or only data from a specific time range during historical syncs. The default value is Sync data from selected date. If you choose to sync data from a specific time range, we also provide a new field, Historic Sync Backwards Limit, that allows you to specify that range. 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_ELEMENTFINANCIAL_ADHOC_DISBURSEMENT_EVENTFINANCIAL_AFFORDABILITY_EXPENSE_EVENTFINANCIAL_CAPACITY_RESERVATION_BILLING_EVENTFINANCIAL_CHARGE_COMPONENTFINANCIAL_CHARGE_INSTRUMENTFINANCIAL_CHARGE_REFUND_EVENTFINANCIAL_COUPON_PAYMENT_EVENTFINANCIAL_DEBT_RECOVERY_EVENTFINANCIAL_DEBT_RECOVERY_ITEMFINANCIAL_FAILED_ADHOC_DISBURSEMENT_EVENTFINANCIAL_FBA_LIQUIDATION_EVENTFINANCIAL_FEE_COMPONENTFINANCIAL_IMAGING_SERVICES_FEE_EVENTFINANCIAL_PAY_WITH_AMAZON_EVENTFINANCIAL_PRODUCT_ADS_PAYMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_ITEMFINANCIAL_REMOVAL_SHIPMENT_ITEM_ADJUSTMENTFINANCIAL_RENTAL_TRANSACTIONFINANCIAL_RETRO_CHARGE_EVENTFINANCIAL_SAFET_REIMBURSEMENT_EVENTFINANCIAL_SAFET_REIMBURSEMENT_ITEMFINANCIAL_SELLER_DEAL_PAYMENT_EVENTFINANCIAL_SELLER_REVIEW_ENROLLMENT_PAYMENT_EVENTFINANCIAL_SERVICE_FEE_EVENTFINANCIAL_SHIPMENT_DIRECT_PAYMENTFINANCIAL_SHIPMENT_EVENTFINANCIAL_SHIPMENT_EVENT_ITEMFINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTIONFINANCIAL_SOLUTION_PROVIDER_CREDIT_EVENTFINANCIAL_TAX_WITHHOLDING_EVENTFINANCIAL_TDS_REIMBURSEMENT_EVENTFINANCIAL_TRIAL_SHIPMENT_EVENTFINANCIAL_VALUE_ADDED_SERVICE_CHARGE_EVENTMARKET_BASKET_ANALYSIS_REPORT_DAILYMARKET_BASKET_ANALYSIS_REPORT_MONTHLYMARKET_BASKET_ANALYSIS_REPORT_QUARTERLYMARKETPLACE_TAX_CLASSIFICATIONNET_PURE_PRODUCT_MARGIN_REPORT_DAILYNET_PURE_PRODUCT_MARGIN_REPORT_MONTHLYNET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLYNETWORK_COMMINGLING_TRANSACTION_EVENTORDERORDER_ITEMSORDERS_ITEM_PROMOTION_IDORDER_ITEM_SERIAL_NUMBERORDER_REGULATED_INFOPAYMENT_EXECUTION_DETAIL_ITEMPAYMENT_METHOD_DETAIL_ITEMRAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_HOURLYRAPID_RETAIL_ANALYTICS_SALES_REPORT_HOURLYRAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_HOURLYREGULATED_INFORMATION_FIELDREPEAT_PURCHASE_REPORT_MONTHLYREPEAT_PURCHASE_REPORT_QUARTERLYSALES_AND_TRAFFIC_BUSINESS_REPORT_DAILYSALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLYSEARCH_TERMS_REPORT_DAILYSEARCH_TERMS_REPORT_MONTHLYSEARCH_TERMS_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_DAILYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_DAILYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_DAILYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_DAILYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_DAILYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_DAILYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_DAILYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_DAILYVENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_SOURCING_FRESH_REPORT_DAILYVENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLYVENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_SALES_SOURCING_RETAIL_REPORT_DAILYVENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_TRAFFIC_REPORT_DAILYVENDOR_TRAFFIC_REPORT_MONTHLYVENDOR_TRAFFIC_REPORT_QUARTERLY
We have released pre-built, dbt Core-compatible data models for our Amazon Selling Partner connector. Find the model in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
January 2025
We have resolved an issue that caused the following tables to not sync correctly:
LISTED_ITEM_ISSUELISTED_ITEM_OFFERSITEM_FULFILLMENT_AVAILABILITY
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:
CATALOGITEM_CLASSIFICATION_SALES_RANKITEM_CONTRIBUTORITEM_DIMENSIONITEM_DISPLAY_GROUP_SALES_RANKITEM_IDENTIFIERITEM_IMAGEITEM_PRODUCT_TYPEITEM_RELATIONSHIPITEM_SUMMARYITEM_VARIATION_THEMEITEM_VENDOR_DETAILS
We have made the following schema changes for all Amazon Selling Partner connections:
- We have changed the primary key of the
VENDOR_RETAIL_PROCUREMENT_SHIPMENTtable and its child tables. The new composite key is a combination of thevendor_shipment_identifierandtransaction_datecolumns. 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_ITEMtable to avoid data integrity issues. The new composite key is a combination of theindex,container_sequence_number,container_type,transaction_date, andvendor_shipment_identifiercolumns. - We have changed the primary key of the
SHIPMENT_STATUS_DETAILtable. The new composite key is a combination of theindex,transaction_date, andshipment_statuscolumns. - We now skip the records of the
VENDOR_SHIPPING_ORDERtable if either thepurchase_order_dateor thepurchase_order_numbercolumn is null.
August 2024
We have fixed a bug where we synced a few columns under incorrect names in the ITEM_OFFER_SUMMARY table. You must trigger a connection re-sync 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_kindlinked_tolinked_to_id
We have added the following new columns to the FINANCIAL_FEE_COMPONENT table:
fee_kindlinked_tolinked_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 connections.
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.