Amazon MWS
Amazon MWS ETL connector for data replication
- 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 [email protected] for any guidance with the setup and optimization.
- 1.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.
- 2.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.
- 3.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.
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 |
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
AmazonMWS_Reports.xlsx
26KB
Binary
Amazon Reports - Description
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
- 1.Signin to Daton
- 2.Select AmazonMWS from the list of Integrations
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide Merchant/Seller ID, MWS Auth Token and Marketplaces listed in. You can get your details from MWS Auth Token
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.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
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.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
Name | Target Datatype |
FinancialEventGroupId | STRING |
ProcessingStatus | STRING |
FundTransferStatus | STRING |
OriginalTotal | RECORD |
ConvertedTotal | RECORD |
FundTransferDate | DATETIME |
TraceId | STRING |
AccountTail | STRING |
BeginningBalance | RECORD |
FinancialEventGroupStart | DATETIME |
FinancialEventGroupEnd | DATETIME |
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
Name | Target Datatype |
ShipmentEventList | RECORD |
RefundEventList | RECORD |
GuaranteeClaimEventList | RECORD |
ChargebackEventList | RECORD |
PayWithAmazonEventList | RECORD |
ServiceProviderCreditEventList | RECORD |
RetrochargeEventList | RECORD |
RentalTransactionEventList | RECORD |
PerformanceBondRefundEventList | RECORD |
ProductAdsPaymentEventList | RECORD |
ServiceFeeEventList | RECORD |
SellerDealPaymentEventList | RECORD |
DebtRecoveryEventList | RECORD |
LoanServicingEventList | RECORD |
AdjustmentEventList | RECORD |
SAFETReimbursementEventList | RECORD |
SellerReviewEnrollmentPaymentEventList | RECORD |
FBALiquidationEventList | RECORD |
CouponPaymentEventList | RECORD |
ImagingServicesFeeEventList | RECORD |
NetworkComminglingTransactionEventList | RECORD |
AffordabilityExpenseEventList | RECORD |
AffordabilityExpenseReversalEventList | RECORD |
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
Name | Target Datatype |
ListMarketplaces | RECORD |
ListParticipations | RECORD |
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
Name | Target Datatype |
AmazonOrderId | STRING |
SellerOrderId | STRING |
PurchaseDate | DATETIME |
LastUpdateDate | DATETIME |
OrderStatus | STRING |
FulfillmentChannel | STRING |
SalesChannel | STRING |
OrderChannel | STRING |
ShipServiceLevel | STRING |
ShippingAddress | RECORD |
OrderTotal | RECORD |
NumberOfItemsShipped | INTEGER |
NumberOfItemsUnshipped | INTEGER |
PaymentExecutionDetail | RECORD |
PaymentMethod | STRING |
PaymentMethodDetails | RECORD |
IsReplacementOrder | BOOLEAN |
ReplacedOrderId | STRING |
MarketplaceId | STRING |
BuyerEmail | STRING |
BuyerName | STRING |
BuyerCounty | STRING |
BuyerTaxInfo | RECORD |
ShipmentServiceLevelCategory | STRING |
ShippedByAmazonTFM | BOOLEAN |
TFMShipmentStatus | STRING |
EasyShipShipmentStatus | STRING |
OrderType | STRING |
EarliestShipDate | DATETIME |
LatestShipDate | DATETIME |
EarliestDeliveryDate | DATETIME |
LatestDeliveryDate | DATETIME |
IsBusinessOrder | BOOLEAN |
PurchaseOrderNumber | STRING |
IsPrime | BOOLEAN |
IsPremiumOrder | BOOLEAN |
PromiseResponseDueDate | DATETIME |
IsEstimatedShipDateSet | BOOLEAN |
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
Name | Target Datatype |
InventoryRecommendations | RECORD |
SelectionRecommendations | RECORD |
PricingRecommendations | RECORD |
FulfillmentRecommendations | RECORD |
ListingQualityRecommendations | RECORD |
GlobalSellingRecommendations | RECORD |
AdvertisingRecommendations | RECORD |
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
Name | Target Datatype |
FeedSubmissionId | STRING |
FeedType | STRING |
SubmittedDate | STRING |
FeedProcessingStatus | STRING |
StartedProcessingDate | DATETIME |
CompletedProcessingDate | DATETIME |
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
Name | Target Datatype |
InventoryRecommendations | RECORD |
SelectionRecommendations | RECORD |
PricingRecommendations | RECORD |
FulfillmentRecommendations | RECORD |
ListingQualityRecommendations | RECORD |
GlobalSellingRecommendations | RECORD |
AdvertisingRecommendations | RECORD |
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
Name | Target Datatype |
SellerSKU | STRING |
FNSKU | STRING |
ASIN | STRING |
Condition | STRING |
TotalSupplyQuantity | INTEGER |
InStockSupplyQuantity | INTEGER |
EarliestAvailability | RECORD |
SupplyDetail | RECORD |
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
Name | Target Datatype |
SellerFulfillmentOrderId | STRING |
MarketplaceId | STRING |
DisplayableOrderId | STRING |
DisplayableOrderDateTime | DATETIME |
DisplayableOrderComment | STRING |
ShippingSpeedCategory | STRING |
DeliveryWindow | RECORD |
DestinationAddress | RECORD |
FulfillmentAction | STRING |
FulfillmentPolicy | STRING |
FulfillmentMethod | STRING |
CODSettings | RECORD |
ReceivedDateTime | DATETIME |
StatusUpdatedDateTime | DATETIME |
FulfillmentOrderStatus | STRING |
NotificationEmailList | RECORD |
ListRegisteredDestinations
Purpose: This API returns the list of all current destinations.
Replication: Full Based Replication
Replication Key: N/A
Fields
Name | Target Datatype |
DeliveryChannel | STRING |
AttributeList | RECORD |
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
Name | Target Datatype |
DeliveryChannel | STRING |
AttributeList | RECORD |
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
Name | Target Datatype |
AmazonOrderId | STRING |
ASIN | STRING |
SellerSKU | STRING |
OrderItemId | STRING |
Title | STRING |
QuantityOrdered | INTEGER |
QuantityShipped | INTEGER |
ProductInfo | RECORD |
PointsGranted | RECORD |
ItemPrice | RECORD |
ShippingPrice | RECORD |
GiftWrapPrice | RECORD |
ItemTax | RECORD |
GiftWrapPrice | RECORD |
ShippingTax | RECORD |
GiftWrapTax | RECORD |
ShippingDiscount | RECORD |
ShippingDiscountTax | RECORD |
PromotionDiscount | RECORD |
PromotionDiscountTax | RECORD |
PromotionIds | RECORD |
CODFee | RECORD |
CODFeeDiscount | RECORD |
IsGift | BOOLEAN |
GiftMessageText | STRING |
GiftWrapLevel | STRING |
InvoiceData | RECORD |
ConditionNote | STRING |
ConditionId | STRING |
ConditionSubtypeId | STRING |
ScheduledDeliveryStartDate | STRING |
ScheduledDeliveryEndDate | STRING |
PriceDesignation | STRING |
BuyerCustomizedInfo | RECORD |
TaxCollection | RECORD |
SerialNumberRequired | BOOLEAN |
IsTransparency | BOOLEAN |
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
Name | Target Datatype |
Identifiers | RECORD |
SalesRankings | RECORD |
AttributeSets | RECORD |
Relationships | RECORD |
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
Name | Target Datatype |
Identifiers | RECORD |
SalesRankings | RECORD |
AttributeSets | RECORD |
Relationships | RECORD |
CompetitivePricing | RECORD |
LowestOfferListings | RECORD |
Offers | RECORD |
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.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name | Target Datatype |
sku | STRING |
asin | STRING |
price | NUMERIC |
quantity | NUMERIC |
Business_Price | NUMERIC |
Quantity_Price_Type | NUMERIC |
Quantity_Lower_Bound_1 | NUMERIC |
Quantity_Price_1 | NUMERIC |
Quantity_Lower_Bound_2 | NUMERIC |
Quantity_Price_2 | NUMERIC |
Quantity_Lower_Bound_3 | NUMERIC |
Quantity_Price_3 | NUMERIC |
Quantity_Lower_Bound_4 | NUMERIC |
Quantity_Price_4 | NUMERIC |
Quantity_Lower_Bound_5 | NUMERIC |
Quantity_Price_5 | NUMERIC |
standard_price_point | NUMERIC |
ProductTaxCode | STRING |
AllListingsReport
Purpose: The api detailed all listings report.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name | Target Datatype |
item_name | STRING |
item_description | STRING |
listing_id | STRING |
seller_sku | STRING |
price | NUMERIC |
quantity | NUMERIC |
open_date | STRING |
image_url | STRING |
item_is_marketplace | BOOLEAN |
product_id_type | STRING |
zshop_shipping_fee | NUMERIC |
item_note | STRING |
item_condition | STRING |
zshop_category1 | STRING |
zshop_browse_path | STRING |
zshop_storefront_feature | STRING |
asin1 | STRING |
asin2 | STRING |
asin3 | STRING |
will_ship_internationally | BOOLEAN |
expedited_shipping | BOOLEAN |
zshop_boldface | BOOLEAN |
product_id | STRING |
bid_for_featured_placement | STRING |
add_delete | STRING |
pending_quantity | STRING |
fulfillment_channel | STRING |
optional_payment_type_exclusion | STRING |
merchant_shipping_group | STRING |
status | STRING |
maximum_retail_price | STRING |
scheduled_delivery_sku_set | STRING |
standard_price_point | NUMERIC |
ProductTaxCode | STRING |
minimum_seller_allowed_price | NUMERIC |
maximum_seller_allowed_price | NUMERIC |
OpenListingsReport
Purpose: The api detailed open listings report.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name | Target Datatype |
item_name | STRING |
item_description | STRING |
listing_id | STRING |
seller_sku | STRING |
price | NUMERIC |
quantity | NUMERIC |
open_date | STRING |