- Availability
- Airbyte Cloud Airbyte OSS
- Support Level
- Community
- Latest Version
- 2.0.2
Amazon Seller Partner
This page guides you through the process of setting up the Amazon Seller Partner source connector.
Prerequisites
- Amazon Selling Partner account
For Airbyte Cloud:
- AWS Environment
- AWS Region
- Granted OAuth access
For Airbyte Open Source:
- AWS Environment
- AWS Region
- Replication Start Date
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.
- In the left navigation bar, click Sources. In the top-right corner, click + new source.
- On the source setup page, select Amazon Seller Partner from the Source type dropdown and enter a name for this connector.
- Click
Authenticate your account
. - Log in and Authorize to your Amazon Seller Partner account.
- Paste all other data to required fields.
- Click
Set up source
.
For Airbyte Open Source:
- Using developer application from Step 1, generate refresh token.
- Go to local Airbyte page.
- In the left navigation bar, click Sources. In the top-right corner, click + new source.
- On the Set up the source page, enter the name for the Amazon Seller Partner connector and select Amazon Seller Partner from the Source type dropdown.
- Paste all data to required fields.
- Click
Set up source
.
Supported sync modes
The Amazon Seller Partner source connector supports the following sync modes:
- Full Refresh
- Incremental
Performance considerations
Information about rate limits you may find here.
Supported streams
This source is capable of syncing the following tables and their data:
- Manage FBA Inventory Reports
- Removal FBA Order Details Reports
- FBA Shipments Reports
- FBA Replacements Reports
- FBA Storage Fees Report
- Restock Inventory Reports
- Flat File Actionable Order Data Shipping
- Flat File Open Listings Reports
- Flat File Orders Reports
- Flat File Orders Reports By Last Update (incremental)
- Amazon-Fulfilled Shipments Report
- Merchant Listings Reports
- Vendor Direct Fulfillment Shipping
- Vendor Inventory Health Reports
- Orders (incremental)
- Orders Items (incremental)
- Seller Feedback Report (incremental)
- Brand Analytics Alternate Purchase Report (only available in OSS)
- Brand Analytics Item Comparison Report (only available in OSS)
- Brand Analytics Market Basket Report (only available in OSS)
- Brand Analytics Repeat Purchase Report (only available in OSS)
- Brand Analytics Search Terms Report (only available in OSS)
- Browse tree report
- Financial Event Groups
- Financial Events
- FBA Fee Preview Report
- FBA Promotions Report
- FBA Manage Inventory
- Subscribe and Save Forecast Report
- Subscribe and Save Performance Report
- Flat File Archived Orders Report
- Flat File Returns Report by Return Date
- Canceled Listings Report
- Active Listings Report
- Open Listings Report
- Suppressed Listings Report
- Inactive Listings Report
- FBA Stranded Inventory Report
- XML Orders By Order Date Report
- Inventory Ledger Report - Detailed View
- FBA Manage Inventory Health Report
- Inventory Ledger Report - Summary View
- FBA Reimbursements Report
- Order Data Shipping Report
- Sales and Traffic Business Report (only available in OSS)
- Vendor Sales Report (only available in OSS)
- Vendor Inventory Report (only available in OSS)
- FBA Amazon Fulfilled Inventory Report (incremental)
- FBA Multi-Country Inventory Report (incremental)
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.
Data type mapping
Integration Type | Airbyte Type |
---|---|
string | string |
int , float , number | number |
date | date |
datetime | datetime |
array | array |
object | object |
Changelog
Version | Date | Pull Request | Subject |
---|---|---|---|
2.4.0 | 2023-11-23 | #32738 | Add GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT , GET_VENDOR_REAL_TIME_INVENTORY_REPORT , and GET_VENDOR_TRAFFIC_REPORT streams |
2.3.0 | 2023-11-22 | #32541 | Make GET_AFN_INVENTORY_DATA , GET_AFN_INVENTORY_DATA_BY_COUNTRY , and GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE streams incremental |
2.2.0 | 2023-11-21 | #32639 | Make start date optional, if start date is not provided, date 2 years ago from today will be used |
2.1.1 | 2023-11-21 | #32560 | Silently exit sync if the retry attempts were unsuccessful |
2.1.0 | 2023-11-21 | #32591 | Add new fields to GET_LEDGER_DETAIL_VIEW_DATA, GET_FBA_INVENTORY_PLANNING_DATA and Orders schemas |
2.0.2 | 2023-11-17 | #32462 | Remove Max time option from specification; set default waiting time for reports to 1 hour |
2.0.1 | 2023-11-16 | #32550 | Fix the OAuth flow |
2.0.0 | 2023-11-23 | #32355 | Remove Brand Analytics from Airbyte Cloud, permanently remove deprecated FBA reports |
1.6.2 | 2023-11-14 | #32508 | Do not use AWS signature as it is no longer required by the Amazon API |
1.6.1 | 2023-11-13 | #32457 | Fix report decompression |
1.6.0 | 2023-11-09 | #32259 | mark "aws_secret_key" and "aws_access_key" as required in specification; update schema for stream Orders |
1.5.1 | 2023-08-18 | #29255 | role_arn is optional on UI but not really on the backend blocking connector set up using oauth |
1.5.0 | 2023-08-08 | #29054 | Add new stream OrderItems |
1.4.1 | 2023-07-25 | #27050 | Fix - non vendor accounts connector create/check issue |
1.4.0 | 2023-07-21 | #27110 | Add GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING and GET_ORDER_REPORT_DATA_SHIPPING streams |
1.3.0 | 2023-06-09 | #27110 | Removed app_id from InputConfiguration , refactored spec |
1.2.0 | 2023-05-23 | #22503 | Enabled stream attribute customization from Source configuration |
1.1.0 | 2023-04-21 | #23605 | Add FBA Reimbursement Report stream |
1.0.1 | 2023-03-15 | #24098 | Add Belgium Marketplace |
1.0.0 | 2023-03-13 | #23980 | Make app_id required. Increase end_date gap up to 5 minutes from now for Finance streams. Fix connection check failure when trying to connect to Amazon Vendor Central accounts |
0.2.33 | 2023-03-01 | #23606 | Implement reportOptions for all missing reports and refactor |
0.2.32 | 2022-02-21 | #23300 | Make AWS Access Key, AWS Secret Access and Role ARN optional |
0.2.31 | 2022-01-10 | #16430 | Implement slicing for report streams |
0.2.30 | 2022-12-28 | #20896 | Validate connections without orders data |
0.2.29 | 2022-11-18 | #19581 | Use user provided end date for GET_SALES_AND_TRAFFIC_REPORT |
0.2.28 | 2022-10-20 | #18283 | Added multiple (22) report types |
0.2.26 | 2022-09-24 | #16629 | Report API version to 2021-06-30, added multiple (5) report types |
0.2.25 | 2022-07-27 | #15063 | Add Restock Inventory Report |
0.2.24 | 2022-07-12 | #14625 | Add FBA Storage Fees Report |
0.2.23 | 2022-06-08 | #13604 | Add new streams: Fullfiments returns and Settlement reports |
0.2.22 | 2022-06-15 | #13633 | Fix - handle start date for financial stream |
0.2.21 | 2022-06-01 | #13364 | Add financial streams |
0.2.20 | 2022-05-30 | #13059 | Add replication end date to config |
0.2.19 | 2022-05-24 | #13119 | Add OAuth2.0 support |
0.2.18 | 2022-05-06 | #12663 | Add GET_XML_BROWSE_TREE_DATA report |
0.2.17 | 2022-05-19 | #12946 | Add throttling exception managing in Orders streams |
0.2.16 | 2022-05-04 | #12523 | allow to use IAM user arn or IAM role |
0.2.15 | 2022-01-25 | #9789 | Add stream FbaReplacementsReports |
0.2.14 | 2022-01-19 | #9621 | Add GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL report |
0.2.13 | 2022-01-18 | #9581 | Change createdSince parameter to dataStartTime |
0.2.12 | 2022-01-05 | #9312 | Add all remaining brand analytics report streams |
0.2.11 | 2022-01-05 | #9115 | Fix reading only 100 orders |
0.2.10 | 2021-12-31 | #9236 | Fix NoAuth deprecation warning |
0.2.9 | 2021-12-30 | #9212 | Normalize GET_SELLER_FEEDBACK_DATA header field names |
0.2.8 | 2021-12-22 | #8810 | Fix GET_SELLER_FEEDBACK_DATA Date cursor field format |
0.2.7 | 2021-12-21 | #9002 | Extract REPORTS_MAX_WAIT_SECONDS to configurable parameter |
0.2.6 | 2021-12-10 | #8179 | Add GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT report |
0.2.5 | 2021-12-06 | #8425 | Update title, description fields in spec |
0.2.4 | 2021-11-08 | #8021 | Added GET_SELLER_FEEDBACK_DATA report with incremental sync capability |
0.2.3 | 2021-11-08 | #7828 | Remove datetime format from all streams |
0.2.2 | 2021-11-08 | #7752 | Change check_connection function to use stream Orders |
0.2.1 | 2021-09-17 | #5248 | Added extra stream support. Updated reports streams logics |
0.2.0 | 2021-08-06 | #4863 | Rebuild source with airbyte-cdk |
0.1.3 | 2021-06-23 | #4288 | Bugfix failing connection check |
0.1.2 | 2021-06-15 | #4108 | Fixed: Sync fails with timeout when create report is CANCELLED` |