Release Notes
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 thevendor_shipment_identifier
andtransaction_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 theindex
,container_sequence_number
,container_type
,transaction_date
, andvendor_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 theindex
,transaction_date
, andshipment_status
columns. - We will skip the records of the
VENDOR_SHIPPING_ORDER
if any of the columnspurchase_order_date
orpurchase_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.