Amazon Selling Partner
Amazon Seller Partner ETL for data replication
Amazon Selling Partner is the new replacement for the to-be-deprecated Amazon MWS API, offering better reporting and organization of data.

How to make an Amazon Selling Partner Integration in Daton?

  1. 1.
    Log in to Daton. If you don't have previous credentials, sign up for Daton.
  2. 2.
    Assuming you have configured your destination, search "Amazon Selling Partner" in the search bar and click configure on the integration that appears. If not, configure your data warehouse first. Daton supports several data destinations.
  3. 3.
    Provide Integration Name, Replication Frequency, History, and Marketplace. Integration name would be used while creating tables on the warehouse and cannot be changed later. See general guidelines if you are unsure of which option to pick.
  4. 4.
    Click the 'Authenticate' button. You will be taken to Amazon's Seller Central login page to authorize Daton to access data from Amazon's SP-API. Allow Daton to access the scopes and authorize the Daton app.
  5. 5.
    If you prefer to not use the primary account, you will need to give access to a set of permissions on Amazon in order to authorize Daton. Contact [email protected] to learn more.
  6. 6.
    After authentication, you will be prompted to choose from the list of available tables. Select the required tables and columns.
  7. 7.
    Submit the integration. You can now view the tables being created in your data destination by the name given to your integration.

What happens next?

  1. 1.
    Click on your integration in the 'Sources' page to see the status of each table.
  2. 2.
    Click on a table to see its status. The jobs would be in pending state initially and then will be moved to Active state once data starts flowing into the destination.
  3. 3.
    Job status can be viewed at any time. You can also edit the integration to change frequency and history.

General guidelines for configuring Amazon Selling Partner Connector on Daton

  • Select frequency as 1 hour. This will ensure fastest replication of historical data.
  • Historical data replication happens in batches and it will take a few jobs for the data to be replicated up until current day
  • Select the duration of history based on availability of data, i.e. for the period the business has been active.
  • Reach out to [email protected] for any guidance with the setup and optimization.

Known Issues

  1. 1.
    Some of the APIs such as fba-inventory-api are not available for all marketplaces. Refer to each report category for detailed list of availability.
  2. 2.
    Authentication while creating integrations on Daton must be done using the primary seller account only.
  3. 3.
    Transaction (Payments) reports are not available through APIs. Reach out to our support for alternatives.
  4. 4.
    There are limited Vendor Central APIs presently and we have not published a public connector for this. Reach out to our support for alternatives.