- Availability
- Airbyte Cloud Airbyte OSS airbyte_lib
- Support Level
- Community
- Latest Version
- 2.5.0
Amazon Seller Partner
This page contains the setup guide and reference information for the Amazon Seller Partner source connector.
Prerequisites
- Amazon Seller Partner account
For Airbyte Cloud:
- AWS Environment
- AWS Region
- Granted OAuth access
For Airbyte Open Source:
- AWS Environment
- AWS Region
- LWA Client Id
- LWA Client Secret
- Refresh Token
Setup Guide
Step 1: Set up Amazon Seller Partner
Airbyte Open Source setup steps
- Register Amazon Seller Partner application. The application must be published as Amazon does not allow external parties such as Airbyte to access draft applications.
Step 2: Set up the source connector in Airbyte
For Airbyte Cloud:
- Log into your Airbyte Cloud account.
- Click Sources and then click + New source.
- On the Set up the source page, select Amazon Seller Partner from the Source type dropdown.
- Enter a name for the Amazon Seller Partner connector.
- Click
Authenticate your account
. - Log in and Authorize to your Amazon Seller Partner account.
- For Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. This field is optional - if not provided, the date 2 years ago from today will be used.
- For End Date, enter the date in YYYY-MM-DD format. Any data after this date will not be replicated. This field is optional - if not provided, today's date will be used.
- You can specify report options for each stream using Report Options section. Available options can be found in corresponding category here.
- Click
Set up source
.
For Airbyte Open Source:
- Using developer application from Step 1, generate refresh token.
- Go to local Airbyte page.
- On the Set up the source page, select Amazon Seller Partner from the Source type dropdown.
- Enter a name for the Amazon Seller Partner connector.
- For Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. This field is optional - if not provided, the date 2 years ago from today will be used.
- For End Date, enter the date in YYYY-MM-DD format. Any data after this date will not be replicated. This field is optional - if not provided, today's date will be used.
- You can specify report options for each stream using Report Options section. Available options can be found in corresponding category here.
- Click
Set up source
.
Supported sync modes
The Amazon Seller Partner source connector supports the following sync modes:
- Full Refresh
- Incremental
Supported streams
- Active Listings Report (GET_MERCHANT_LISTINGS_DATA)
- All Listings Report (GET_MERCHANT_LISTINGS_ALL_DATA)
- Amazon Search Terms Report (GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT) (only available in OSS)
- Brand Analytics Alternate Purchase Report (GET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORT) (only available in OSS)
- Brand Analytics Item Comparison Report (GET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORT) (only available in OSS)
- Repeat Purchase (GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT) (only available in OSS)
- Browse Tree Report (GET_XML_BROWSE_TREE_DATA)
- Canceled Listings Report (GET_MERCHANT_CANCELLED_LISTINGS_DATA)
- FBA Amazon Fulfilled Inventory Report (GET_AFN_INVENTORY_DATA) (incremental)
- FBA Amazon Fulfilled Shipments Report (GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL)
- FBA Fee Preview Report (GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA)
- FBA Manage Inventory (GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA)
- FBA Manage Inventory Health Report (GET_FBA_INVENTORY_PLANNING_DATA)
- FBA Multi-Country Inventory Report (GET_AFN_INVENTORY_DATA_BY_COUNTRY) (incremental)
- FBA Promotions Report (GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA)
- FBA Reimbursements Report (GET_FBA_REIMBURSEMENTS_DATA)
- FBA Removal Order Detail Report (GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA)
- FBA Removal Shipment Detail Report (GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA)
- FBA Replacements Report (GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA)
- FBA Returns Report (GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA)
- FBA Storage Fees Report (GET_FBA_STORAGE_FEE_CHARGES_DATA)
- FBA Stranded Inventory Report (GET_STRANDED_INVENTORY_UI_DATA)
- Financial Events
- Financial Event Groups
- Flat File Archived Orders Report (GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE)
- Flat File Feedback Report (GET_SELLER_FEEDBACK_DATA)
- Flat File Orders By Last Update Report (GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL) (incremental)
- Flat File Orders By Order Date Report (GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL)
- Flat File Returns Report by Return Date (GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE)
- Flat File Settlement Report (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE)
- Inactive Listings Report (GET_MERCHANT_LISTINGS_INACTIVE_DATA)
- Inventory Ledger Report - Detailed View (GET_LEDGER_DETAIL_VIEW_DATA)
- Inventory Ledger Report - Summary View (GET_LEDGER_SUMMARY_VIEW_DATA)
- Inventory Report (GET_FLAT_FILE_OPEN_LISTINGS_DATA)
- Market Basket Analysis Report (GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT) (only available in OSS)
- Net Pure Product Margin Report (GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT)
- Open Listings Report (GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT)
- Orders (incremental)
- Order Items (incremental)
- Rapid Retail Analytics Inventory Report (GET_VENDOR_REAL_TIME_INVENTORY_REPORT)
- Restock Inventory Report (GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT)
- Sales and Traffic Business Report (GET_SALES_AND_TRAFFIC_REPORT)
- Scheduled XML Order Report (Shipping) (GET_ORDER_REPORT_DATA_SHIPPING)
- Subscribe and Save Forecast Report (GET_FBA_SNS_FORECAST_DATA)
- Subscribe and Save Performance Report (GET_FBA_SNS_PERFORMANCE_DATA)
- Suppressed Listings Report (GET_MERCHANTS_LISTINGS_FYP_REPORT)
- Unshipped Orders Report (GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING)
- Vendor Direct Fulfillment Shipping
- Vendor Inventory Report (GET_VENDOR_INVENTORY_REPORT)
- Vendor Sales Report (GET_VENDOR_SALES_REPORT)
- Vendor Traffic Report (GET_VENDOR_TRAFFIC_REPORT)
- XML Orders By Order Date Report (GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL)
Report options
Make sure to configure the required parameters in the report options setting for the reports configured.
For GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL
and GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE
streams maximum value for period_in_days
30 days and 60 days.
So, for any value that exceeds the limit, the period_in_days
will be automatically reduced to the limit for the stream.