Amazon Seller Partner Migration Guide
Upgrading to 4.0.0
Stream GET_FBA_STORAGE_FEE_CHARGES_DATA now has updated schema, which matches Amazon Seller Partner docs.
Users will need to refresh the source schemas and reset these streams after upgrading.
Refresh affected schemas and reset data
- Select Connections in the main navbar.
- Select the connection(s) affected by the update.
- Select the Replication tab.
- Select Refresh source schema.
- Select OK.
Any detected schema changes will be listed for your review.
- Select Save changes at the bottom of the page.
- Ensure the Reset affected streams option is checked.
Depending on destination type you may not be prompted to reset your data.
- 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 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:
| Stream | Affected fields | Format change |
|---|---|---|
GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL | estimated-arrival-date | string YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_LEDGER_DETAIL_VIEW_DATA | Date and Time | string YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_MERCHANTS_LISTINGS_FYP_REPORT | Status Change Date | string MMM D[,] YYYY -> date-time YYYY-MM-DD |
GET_STRANDED_INVENTORY_UI_DATA | Date-to-take-auto-removal | string YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE | settlement-start-date, settlement-end-date, deposit-date, posted-date | string YYYY-MM-DDTHH:mm:ssZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_MERCHANT_LISTINGS_ALL_DATA | open-date | string YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_MERCHANT_LISTINGS_DATA | open-date | string YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_MERCHANT_LISTINGS_INACTIVE_DATA | open-date | string YYYY-MM-DD HH:mm:ss ZZZ -> date-time YYYY-MM-DDTHH:mm:ssZ |
GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT | open-date | string 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
- Select Connections in the main navbar.
- Select the connection(s) affected by the update.
- Select the Replication tab.
- Select Refresh source schema.
- Select OK.
Any detected schema changes will be listed for your review.
- Select Save changes at the bottom of the page.
- Ensure the Reset affected streams option is checked.
Depending on destination type you may not be prompted to reset your data.
- 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_REPORTGET_BRAND_ANALYTICS_SEARCH_TERMS_REPORTGET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORTGET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORTGET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORTGET_SALES_AND_TRAFFIC_REPORTGET_VENDOR_SALES_REPORTGET_VENDOR_INVENTORY_REPORT
Customers, who have the following streams, will have to disable them:
GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATAGET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATAGET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATAGET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATAGET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA