Coefficient's Amazon Seller Central connector helps transform your spreadsheet or workbook into a dynamic, automated hub for your e-commerce operations. Eliminate the need to manually log into Amazon Seller Central to download separate, rigid flat files and get live data directly on Google Sheets or Excel. 🦾
Connecting to Amazon Seller Central
Import from Amazon Seller Central
Schedule your Import, Snapshots, and Add Automations
Connecting to Amazon Seller Central
When you begin an Amazon Seller Central import for the first time, you will need to go through a few steps to connect to Amazon Seller Central as a data source with Coefficient.
|
1. Open the Coefficient Sidebar and click Menu. |
2. Select “Connected Sources”. |
3. Select “Add Connection” at the bottom and then “Connect” to Amazon Seller Central. |
|
4. Enter the required credentials to authorize the connection to Amazon Seller Central. |
ℹ️ Note: You need an Amazon Selling Partner API (SP-API) application to be able to add this connection. Here's how to get your credentials:
|
5. Enter the required details, click "Connect", and you’re ready to create an import. 🎉 |
Import from Amazon Seller Central
|
1. Open the Coefficient Sidebar and click on the “Import from…” button. |
2. Select “Amazon Seller Central” from the list. |
3. Under the Request tab, select the Object/Report you'd like to import the data from in the Import Preview window. (e.g, Get Order Metrics)
4. Once the object is selected, filter the import by adjusting the Headers & Parameters. Click "Preview" to view the data being pulled based on the modifications made.
ℹ️ Note: Parameters with a red asterisk(*), in this case the "CreatedAfter" parameter, are required fields and need to be filled to proceed with the import. You can also add optional parameters, such as the pre-added parameters under the "Show All" drop-down.
ℹ️ Note: "+Add" allows you to add other parameters using a Key and a Value, but is dependent on the availability of the Amazon Seller Central API documentation.
5. Under the Response tab, select the fields that you would like to be added to the import. You can also reduce the results imported to your spreadsheet/workbook by adding a row limit. Click on "Import" on the top-right of the preview window once satisfied with the modifications.
6. Congratulations on your first Amazon Seller Central import in Coefficient! 🎉
Schedule your Import, Snapshots, and Add Automations
Once you have pulled your data into spreadsheets using Coefficient, you can set up the following: