Automate Amazon Selling Partner (SP-API) Data via ELT

Dave Swendeman

April 11, 2023

With Daasity, extract and load SP-API data (both Amazon Seller Central data and Amazon Vendor Central data) into your data warehouse.

We’ll provide a quick overview of some endpoints we pull from, but you can read our full documentation here:

SP-API Extraction for Seller Central

Daasity calls the following endpoints to maximize the amount of data merchants can get from Amazon:

Order API

Report API

We have ERDs available in our documentation for each of the following endpoints:

FBA Sales
FBA Inventory
FBA Customer Concessions
FBA Removals
Inventory
Order Tracking
Performance
Returns
Seller Retail Analytics
Settlement Report

SP-API Extraction for Vendor Central

On the Vendor Central Side, we extract the following reports on a daily or weekly basis:

Vendor Sales Report (extracts at day level, checks daily for report)
Vendor Traffic Report (extracts at the day level, checks daily for report)
Vendor Inventory Report (extracts at the week level, checks daily for report)

Here is Daasity’s Vendor Central ERD:

Keep Reading

For more about Daasity and how we can help you build a single source of truth around your Amazon data, check out one of our most popular articles, on extracting Amazon Seller Central data.

Dave Swendeman

Dave loves words, wordplay, and he has the audaasity to use a pun in his bio. Dave runs content at Daasity, and he works to make sure that as many people as possible understand how a data-driven business is a better business. Outside of work, he can be found studying languages, lifting things up and putting them down, and tending to his citrus trees.