Essential Attributes and Raw Tables of Amazon MWS

Learn about the necessary characteristics and fundamental data structures of Amazon MWS, providing valuable insights into the essential components and underlying tables of the platform.

Need help with something?

Talk to data expert

Essential Attributes

The following table shows some of the essential connector attributes and their details:

Features Details
Release Status Released
Source API Version  
Table Selection Yes
Column Selection Yes
Edit Integration Yes
Replication Type Selection No
Authentication Parameters MerchantID or SellerID
MWS Auth Token
Marketplace
Replication Type Full Replication
Key Based Incremental
Replication Key Date
Suggested Replication Frequency 4 hrs

General guidelines for configuring Amazon MWS on Daton

  • Create separate integration for ListOrder and ListOrderItems tables. These two are the largest and slower APIs.
  • Create separate integration for the rest of the Raw tables. 
  • Create separate integrations for reports. It is advised to limit to 20 reports per integration. If you are on the starter or above subscription plan, you can create multiple integrations per connector without any increase in monthly billing. 
  • Suggested frequency for raw tables - 1hr
  • Suggested frequency for daily reports - 4 hrs (Note that even if we set the frequency to 4 hrs, data would be fetched only twice per day)
  • Suggested frequency for monthly reports - 24 hrs
  • Suggested frequency for real-time reports - 1 hr
  • Reach out to support@sarasanalytics.com for any guidance with the setup and optimization.

Supported Raw Tables

Data from raw tables can be used to build custom reports.  

Suggested replication frequency - 2 hrs

  • ListFinancialEventGroups
  • ListFinancialEvents
  • ListMarketplaceParticipations
  • ListOrder
  • GetFeedSubmissionList
  • ListRecommendations
  • ListInventorySupply
  • ListAllFulfillmentOrders
  • ListRegisteredDestinations
  • ListSubscriptions
  • ListOrderItems
  • GetMatchingProduct
  • GetCompetitivePricingForSKU

Amazon Reports

Amazon MWS Reports