Amazon MWS
Amazon MWS ETL connector for data replication
Last updated
Amazon MWS ETL connector for data replication
Last updated
Create separate integration for ListOrder and ListOrderItems tables. These two are the largest and slower APIs.
Create separate integration for rest of the Raw tables.
Create separate integrations for reports. It is advised to limit to 20 reports per integration. If you are on starter or above subscription plan, you can create multiple integrations per connector without any increate 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.
Cancelled reports - Report requests can get cancelled if there is any parallel process using the same requests or when users manually request for these reports from console. Daton will try again in subsequent jobs in case of cancelled or failed report requests and there will not be any loss of data.
Changes in fields and datatypes - We have observed that there could be changes by Amazon in the report field names. While we are trying to make the migration process as seamless as possible, it may be required to reload the reports if any names or datatypes change.
Presently, daily reports will be processed 2 times in a day to account for failure reports. We will optimize this further in our upcoming releases and try to process only one successful job.
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
Please grant access to our Developer Id by following the steps outlined in this document: https://docs.sarasanalytics.com/faqs/source-api-keys/amazon-mws-merchant-token-and-auth-token
Signin to Daton
Select AmazonMWS from the list of Integrations
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide Merchant/Seller ID, MWS Auth Token and Marketplaces listed in. You can get your details from MWS Auth Token
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
ListFinancialEventGroups
Purpose: This API is used to get the list of all varients in the catelog.
Source API Documentation http://docs.developer.amazonservices.com/en_US/finances/Finances_ListFinancialEventGroups.html
Replication: Key Based Replication
Replication Key: financialEventGroupStartedAfter
Fields
ListFinancialEvents
Purpose: This API is used to get the list of all Financial events for an order
Source API Documentation http://docs.developer.amazonservices.com/en_US/finances/Finances_ListFinancialEvents.html
Replication: Key Based Replication
Replication Key: withPostedAfter
Fields
ListMarketplaceParticipations
Purpose: This API is used to get the list of marketplaces that the seller submitting the request and list of participations that include seller.
Source API Documentation http://docs.developer.amazonservices.com/en_US/sellers/Sellers_ListMarketplaceParticipations.html
Replication: Full Replication
Replication Key: NA
Fields
Purpose: This API returns the list of all orders created or updated.
Source API Documentation http://docs.developer.amazonservices.com/en_US/orders-2013-09-01/Orders_ListOrders.html
Replication: Key Based Replication
Replication Key: createdAfter
Fields
GetFeedSubmissionList
Purpose: This API returns the list of all active recommendations or for all categories.
Source API Documentation http://docs.developer.amazonservices.com/en_US/feeds/Feeds_GetFeedSubmissionList.html
Replication: Key Based Replication
Replication Key: withSubmittedToDate
Fields
GetFeedSubmissionList
Purpose: This API returns the list of all all feed submissions.
Source API Documentation http://docs.developer.amazonservices.com/en_US/feeds/Feeds_GetFeedSubmissionList.html
Replication: Key Based Replication
Replication Key: withSubmittedToDate
Fields
ListRecommendations
Purpose: This API returns the list of active recommendations for all categories for a specific marketplace.
Source API Documentation http://docs.developer.amazonservices.com/en_US/recommendations/Recommendations_ListRecommendations.html
Replication: Full Based Replication
Replication Key: N/A
Fields
ListInventorySupply
Purpose: This API returns the list of active recommendations for all information about the availability of a seller's inventory
Source API Documentation http://docs.developer.amazonservices.com/en_US/fba_inventory/FBAInventory_ListInventorySupply.html
Replication: Full Based Replication
Replication Key: N/A
Fields
ListAllFulfillmentOrders
Purpose: This API returns the list of fulfillment orders fulfilled.
Source API Documentation http://docs.developer.amazonservices.com/en_US/fba_outbound/FBAOutbound_ListAllFulfillmentOrders.html
Replication: Key Based Replication
Replication Key: QueryStartDateTime
Fields
ListRegisteredDestinations
Purpose: This API returns the list of all current destinations.
Source API Documentation http://docs.developer.amazonservices.com/en_US/subscriptions/Subscriptions_ListRegisteredDestinations.html
Replication: Full Based Replication
Replication Key: N/A
Fields
ListSubscriptions
Purpose: This API returns the list of all current subscriptions.
Source API Documentation http://docs.developer.amazonservices.com/en_US/subscriptions/Subscriptions_ListSubscriptions.html
Replication: Full Based Replication
Replication Key: N/A
Fields
ListOrderItems
Purpose: This API returns the order items based on the AmazonOrderId .
Source API Documentation http://docs.developer.amazonservices.com/en_US/orders-2013-09-01/Orders_ListOrderItems.html
Replication: Key Based Replication
Replication Key: createdAfter
Fields
GetMatchingProduct
Purpose: This API returns list of products and their attributes, based on a list of ASIN values .
Source API Documentation http://docs.developer.amazonservices.com/en_US/products/Products_GetMatchingProduct.html
Replication: Key Based Replication
Replication Key: QueryStartDateTime
Fields
GetCompetitivePricingForSKU
Purpose: This API returns current competitive price of a product, based on SellerSKU.
Source API Documentation http://docs.developer.amazonservices.com/en_US/products/Products_GetCompetitivePricingForSKU.html
Replication: Key Based Replication
Replication Key: QueryStartDateTime
Fields
InventoryReport
Purpose: The api detailed all open listings report that contains a summary of the seller's product listings with the price and quantity for each SKU.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
AllListingsReport
Purpose: The api detailed all listings report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
OpenListingsReport
Purpose: The api detailed open listings report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
CanceledListingsReport
Purpose: The api detailed canceled listings report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
SoldListingsReport
Purpose: The api detailed sold listings report that contains items sold on Amazon's retail website.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
ListingQualityandSuppressedListingReport
Purpose: The api detailed listing quality and suppressed listing report that contains your listing information that is incomplete or incorrect..
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
GlobalExpansionOpportunitiesReport
Purpose: The api detailed products that a seller lists which have a high sales potential in other Amazon marketplaces
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
sku / STRING product_id | STRING product_id_type | STRING item_name | STRING price | NUMERIC minimum_seller_allowed_price | NUMERIC maximum_seller_allowed_price | NUMERIC item_condition | STRING quantity | NUMERIC status | STRING marketplace | STRING
UnshippedOrdersReport
Purpose: The api detailed orders that are not confirmed as shipped.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
OrderReport
Purpose: The api detailed orders report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
Purpose: The api detailed all orders updated in the specified period.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
FlatFileReturnsReportbyReturnDate
Purpose: The api detailed returns information, including return request date.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
ReferralFeePreviewReport
Purpose: The api detailed open listings as well as the price and estimated referral fees for each SKU.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
ActiveListingsReport
Purpose: The api detailed active listings report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields
InactiveListingsReport
Purpose: The api detailed inactive listings report.
Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
Replication: Key Based Replication
Replication Key: StartDate
Fields