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

Insight

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.

May interest you