Skip to main content

Amazon Seller Partner Migration Guide

Upgrading to 3.0.0

Streams GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL and GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL now have updated schemas.

The following streams now have date-time formatted fields:

StreamAffected fieldsFormat change
GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERALestimated-arrival-datestring YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_LEDGER_DETAIL_VIEW_DATADate and Timestring YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_MERCHANTS_LISTINGS_FYP_REPORTStatus Change Datestring MMM D[,] YYYY -> date-time YYYY-MM-DD
GET_STRANDED_INVENTORY_UI_DATADate-to-take-auto-removalstring YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILEsettlement-start-date, settlement-end-date, deposit-date, posted-datestring YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_MERCHANT_LISTINGS_ALL_DATAopen-datestring YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_MERCHANT_LISTINGS_DATAopen-datestring YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_MERCHANT_LISTINGS_INACTIVE_DATAopen-datestring YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ
GET_MERCHANT_LISTINGS_DATA_BACK_COMPATopen-datestring YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ

Users will need to refresh the source schemas and reset these streams after upgrading.

Refresh affected schemas and reset data

  1. Select Connections in the main navbar.
    1. Select the connection(s) affected by the update.
  2. Select the Replication tab.
    1. Select Refresh source schema.
    2. Select OK.
Any detected schema changes will be listed for your review.
  1. Select Save changes at the bottom of the page.
    1. Ensure the Reset affected streams option is checked.
Depending on destination type you may not be prompted to reset your data.
  1. Select Save connection.
This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

Upgrading to 2.0.0

This change removes Brand Analytics and permanently removes deprecated FBA reports (from Airbyte Cloud). Customers who have those streams must refresh their schema OR disable the following streams:

  • GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT
  • GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT
  • GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT
  • GET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORT
  • GET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORT
  • GET_SALES_AND_TRAFFIC_REPORT
  • GET_VENDOR_SALES_REPORT
  • GET_VENDOR_INVENTORY_REPORT

Customers, who have the following streams, will have to disable them:

  • GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA
  • GET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATA
  • GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA
  • GET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATA
  • GET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA