Intro
Amazon Vendor Partner Connector programmatically access the data on reports. Applications using Selling Partner API can increase selling efficiency, reduce labor requirements, and improve response time to customers, helping sellers grow their businesses. Vendor Partner API builds on the functionality of Amazon Vendor Partner Connector but provides features to improve usability and security for developers and the sellers they work with. This guide documents the Amazon Vendor Partner Connector. You connect to your Amazon Vendor Partner account in the Data Center. This topic discusses the fields and menus that are specific to the Amazon Selling Partner connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in a DataSet Using a Data Connector.Best Practices
- For most reports, be conservative on date ranges. Only pull the data you need.
- Be prepared for some reports to take hours to complete; this is a limitation of the Amazon API.
- Be advised that years-old data takes much longer to retrieve.
Prerequisites
To connect to your Amazon Vendor Partner account and create a DataSet, you must have the following:| Parameter Name | Where to find it |
| Username | Credentials used to log into Seller Central |
| Password | Credentials used to log into Seller Central |
Connecting to Your Amazon Vendor Partner Account
This section enumerates the options in the Credentials and Details panes on the Amazon Selling Partner Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.Credentials Pane
The Domo Amazon Selling Partner Connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click Connect (or select Add Account if you have existing Amazon Vendor Partner accounts in Domo) to open the Amazon Vendor Partner OAuth screen where you can enter your Amazon Vendor Partner username and password. Once you have entered valid Amazon Vendor Partner credentials, you can use the same account any time you go to create a new Amazon Selling Partner DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about the accounts tab, see Managing User Accounts for Connectors.Note: If you are already logged into Amazon Vendor Partner when you connect in Domo, you are authenticated automatically when you click Add account. If you want to connect to an account that is different from the one you are logged into, you must first log out of amazon Vendor Partner.
Details Pane
This pane contains a primary Report menu, along with various other fields which may or may not appear depending on the report type you select.Menu | Description | ||||
|---|---|---|---|---|---|
Report | Select the Amazon Selling Partner report you want to run. The following reports are available:
|
Other Panes
A hybrid Selling Partner API application is an application that can make calls to both Selling Partner API and Amazon Marketplace Web Service (Amazon MWS). Use a hybrid application when your solution requires functionality from both services. When a seller authorizes your hybrid Selling Partner API application, they are (1) authorizing your Amazon MWS developer ID to make calls to Amazon MWS on their behalf, and (2) authorizing the application to make calls to Selling Partner API on their behalf.FAQ
My Amazon store sells in multiple marketplaces across the world. How do I get all of my orders, inventory and other important Amazon MWS data?
My Amazon store sells in multiple marketplaces across the world. How do I get all of my orders, inventory and other important Amazon MWS data?
You will need to create an account for each marketplace. We recommend naming the accounts with the marketplace location: for example, ‘United States’ or ‘Italy’. Once you have created the needed accounts, create connector datasets using each account to receive the data that matters to you. If you would like to join the data, use Domo’s Magic ETL or Dataflow tools to bring the different marketplaces together.
How should I configure the Orders or Order Items report?
How should I configure the Orders or Order Items report?
Due to API limitations, the connector can only be set up with Append mode. Select the desired start date for your historic backfill, and use a relative end date with a value of ‘yesterday’ or ‘1’. Set the connector to only run once per day. The connector will get the most current day’s data, then start getting backfill data from the most recent data to older, one day at a time. The connector will run up to 24 hours, and then will remember where it left off in the historical backfill. The next day, when the connector runs again, it will get the most current day’s data appended to it first, then pick up where it left off with the historical backfill. This pattern will continue until the connector has received all data for the historical backfill. Once all the backfill is completed, it will continue to append the most current days data, one day at a time. If the connector doesn’t run or is unsuccessful during a run, it is designed to receive the data it missed in both the current and historical backfill.
Can Domo schedule Amazon Vendor Reports on my behalf?
Can Domo schedule Amazon Vendor Reports on my behalf?
No. The connector is not able to schedule Amazon MWS Reports on your behalf in the Amazon Vendor API. The connector will deliver all reports in the discovery dropdown for your convenience, but you may receive a “Report not generated” error if the report is not generated. The error message will contain the name of the report in the Amazon Vendor account that needs to be generated before the connector can run successfully. Generate the report and add it to the report scheduler in your Amazon Vendor dashboard and try again. The connector report ‘Reports - Schedule List’ lists all scheduled reports.
How frequently should I run the connector schedule?
How frequently should I run the connector schedule?
The connector should only run once per day.
Troubleshooting
- Make sure your authentication remains valid.
- Review the configuration to make sure that all required items have been selected.
- Review the Connector history for error messages.
- In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the Connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the timeframe that you are trying to pull.