October 04, 2021 08:20

Amazon Seller Central Integration

In this article, we’ll integrate an Amazon Seller Central data source with Y42.

The Amazon Selling Partner API provides metadata and insights for Amazon sellers. The Amazon Selling Partner API (SP-API) is the next generation suite for Amazon's Selling Partners and is an evolution of Amazon Marketplace Web Service (Amazon MWS) APIs, which have been offering sellers programmatic access to critical Amazon features.

Overview

Authentication: OAuth

Settings: Historical Date selection, Account selection

Schema type: Fixed

Update Type: Full import and incremental

Authentication

OAuth doesn’t share password data but instead uses authorization tokens to prove an identity between you and the service provider. OAuth is an authentication protocol that allows you to approve one application interacting with another on your behalf without giving away your password. For instance, when you tell Facebook that it’s OK for another application or website to access your profile. To sum up, you only need to have an existing account to authorize the access. Scroll down to the setup guide for a step by step guidance.

Import Settings

By default, the historical date will be set to one year ago. Refer to your own datasource to decide from which exact date you would want to retrieve data.

Account pre-requisites

You will need an active Amazon Seller Central account is required, along with the relevant credentials, with permission to access data from accounts and marketplaces you'd like to sync.

Schema

This integration returns fixed schemas from the API. See the SP-API Documentation to see a list of all references, and for more information, such as use case guides. Please contact help@y42.com to request additional tables or reports.

Table	Description	Limitation
Orders	Orders created or updated.
Order buyer info	Buyer information for all orders.
Order address	Shipping address for all orders.
Order items	Detailed order item information for each order.	Orders in PENDING status do not have financial information until verified by Amazon (reference).
Order items buyer info	Buyer information for all order items of an order.
Inventory
Transaction report (payment report)	All transaction events.	Transaction (payment) reports have to be generated before they can be integrated. Please follow this guide to generate a transaction report.
Settlement (flat) reports	Tab-delimited flat file settlement report.
FBA shipment fulfillment

Limitations

Due to Amazon's limitation on reporting financial information for orders in pending status, you will see discrepancies between your Amazon Seller Central sales reports and Y42 generated Amazon sales reports. It can take up to 21 days for orders to leave the pending status upon verification by Amazon.

Updating your data

You have the option of scheduling imports or Incremental Imports by the month, weeks, days, and even by the hour. With the incremental import, you will only add the new rows to that table, while a full import will actually re-import the entire table completely.

Incremental imports significantly increase the import speed, we import your table incrementally based on the last imported state e.g. id - If the table does not have a state, a full import will be triggered - This is done automatically.

We recommend therefore to schedule an incremental import regularly, but also schedule a full import with a certain frequency -- this is because only the full import will guarantee that old rows that have been updated on the data source will also get updated on your Y42 integration destination.

Amazon Seller Central Setup Guide:

Note: In order to connect Amazon Seller Central with Y42, you will need to have an Amazon SC Account.

On Integrate, click on "Add..." to search for Amazon Seller Central and select it.
Name your integration.
Select the Marketplace location and click Authorize to log into your Amazon Seller account.
Login with your existing account and follow the Auth and Verification process.
Select your Merchant account and Marketplace.
After authentication, you are good to go and start importing your tables.
Choose from which point onwards in time to import your data and Select Amazon Seller Central Account.
Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?

0 out of 0 found this helpful