Skip to main content

Amazon Seller Partner

This page guides you through the process of setting up the Amazon Seller Partner source connector.

Prerequisites

  • AWS Environment
  • AWS Region
  • AWS Access Key
  • AWS Secret Key
  • Role ARN
  • LWA Client ID (LWA App ID)**
  • LWA Client Secret**
  • Refresh token**
  • Replication Start Date

**not required for Airbyte Cloud

Step 1: Set up Amazon Seller Partner

  1. Register Amazon Seller Partner application.
    • The application must be published as Amazon does not allow external parties such as Airbyte to access draft applications.
  2. Create IAM user.

Step 2: Set up the source connector in Airbyte

For Airbyte Cloud:

  1. Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select Amazon Seller Partner from the Source type dropdown and enter a name for this connector.
  4. Click Authenticate your account.
  5. Log in and Authorize to your Amazon Seller Partner account.
  6. Paste all other data to required fields using your IAM user.
  7. Click Set up source.

For Airbyte Open Source:

  1. Using developer application from Step 1, generate refresh token.
  2. Go to local Airbyte page.
  3. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  4. 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.
  5. Paste all data to required fields using your IAM user and developer account.
  6. 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:

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 TypeAirbyte Type
stringstring
int, float, numbernumber
datedate
datetimedatetime
arrayarray
objectobject

Changelog

VersionDatePull RequestSubject
1.6.02023-08-18#32259mark "aws_secret_key" and "aws_access_key" as required in specification; update schema for stream Orders
1.5.12023-08-18#29255role_arn is optional on UI but not really on the backend blocking connector set up using oauth
1.5.02023-08-08#29054Add new stream OrderItems
1.4.12023-07-25#27050Fix - non vendor accounts connector create/check issue
1.4.02023-07-21#27110Add GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING and GET_ORDER_REPORT_DATA_SHIPPING streams
1.3.02023-06-09#27110Removed app_id from InputConfiguration, refactored spec
1.2.02023-05-23#22503Enabled stream attribute customization from Source configuration
1.1.02023-04-21#23605Add FBA Reimbursement Report stream
1.0.12023-03-15#24098Add Belgium Marketplace
1.0.02023-03-13#23980Make 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.332023-03-01#23606Implement reportOptions for all missing reports and refactor
0.2.322022-02-21#23300Make AWS Access Key, AWS Secret Access and Role ARN optional
0.2.312022-01-10#16430Implement slicing for report streams
0.2.302022-12-28#20896Validate connections without orders data
0.2.292022-11-18#19581Use user provided end date for GET_SALES_AND_TRAFFIC_REPORT
0.2.282022-10-20#18283Added multiple (22) report types
0.2.262022-09-24#16629Report API version to 2021-06-30, added multiple (5) report types
0.2.252022-07-27#15063Add Restock Inventory Report
0.2.242022-07-12#14625Add FBA Storage Fees Report
0.2.232022-06-08#13604Add new streams: Fullfiments returns and Settlement reports
0.2.222022-06-15#13633Fix - handle start date for financial stream
0.2.212022-06-01#13364Add financial streams
0.2.202022-05-30#13059Add replication end date to config
0.2.192022-05-24#13119Add OAuth2.0 support
0.2.182022-05-06#12663Add GET_XML_BROWSE_TREE_DATA report
0.2.172022-05-19#12946Add throttling exception managing in Orders streams
0.2.162022-05-04#12523allow to use IAM user arn or IAM role
0.2.152022-01-25#9789Add stream FbaReplacementsReports
0.2.142022-01-19#9621Add GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL report
0.2.132022-01-18#9581Change createdSince parameter to dataStartTime
0.2.122022-01-05#9312Add all remaining brand analytics report streams
0.2.112022-01-05#9115Fix reading only 100 orders
0.2.102021-12-31#9236Fix NoAuth deprecation warning
0.2.92021-12-30#9212Normalize GET_SELLER_FEEDBACK_DATA header field names
0.2.82021-12-22#8810Fix GET_SELLER_FEEDBACK_DATA Date cursor field format
0.2.72021-12-21#9002Extract REPORTS_MAX_WAIT_SECONDS to configurable parameter
0.2.62021-12-10#8179Add GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT report
0.2.52021-12-06#8425Update title, description fields in spec
0.2.42021-11-08#8021Added GET_SELLER_FEEDBACK_DATA report with incremental sync capability
0.2.32021-11-08#7828Remove datetime format from all streams
0.2.22021-11-08#7752Change check_connection function to use stream Orders
0.2.12021-09-17#5248Added extra stream support. Updated reports streams logics
0.2.02021-08-06#4863Rebuild source with airbyte-cdk
0.1.32021-06-23#4288Bugfix failing connection check
0.1.22021-06-15#4108Fixed: Sync fails with timeout when create report is CANCELLED`