Amazon MWS
Amazon MWS ETL connector for data replication

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 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.

Known Issues

    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.

Snapshot

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

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

AmazonMWS_Reports.xlsx
26KB
Binary
Amazon Reports - Description

Amazon MWS Merchant Token

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

Integrate AmazonMWS with Daton

    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

Workflow

    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

AmazonMWS Data

ListFinancialEventGroups
Purpose: This API is used to get the list of all varients in the catelog.
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
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.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
ListMarketplaces
RECORD
ListParticipations
RECORD

ListOrders

Purpose: This API returns the list of all orders created or updated.
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.
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.
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.
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
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.
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.
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 .
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 .
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.
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
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
Business_Price
NUMERIC
Quantity_Price_Type
STRING
Quantity_Lower_Bound_1
NUMERIC
Quantity_Price_1
NUMERIC
scheduled_delivery_sku_set
STRING
merchant_shipping_group
NUMERIC
ProductTaxCode
STRING
CanceledListingsReport
Purpose: The api detailed canceled 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
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
add_delete
STRING
optional_payment_type_exclusion
STRING
Business_Price
NUMERIC
Quantity_Price_Type
STRING
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
standard_price_point
NUMERIC
merchant_shipping_group
STRING
ProductTaxCode
STRING
SoldListingsReport
Purpose: The api detailed sold listings report that contains items sold on Amazon's retail website.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
item_name
STRING
listing_id
STRING
sku
STRING
price
NUMERIC
shipping_fee
NUMERIC
purchase_date
STRING
buyer_email
STRING
buyer_nick_name
STRING
date_listed
STRING
item_is_marketplace
BOOLEAN
quantity
NUMERIC
ListingQualityandSuppressedListingReport
Purpose: The api detailed listing quality and suppressed listing report that contains your listing information that is incomplete or incorrect..
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
sku
STRING
product_name
STRING
asin
STRING
field_name
STRING
alert_type
STRING
current_value
NUMERIC
last_updated
STRING
explanation
STRING
GlobalExpansionOpportunitiesReport
Purpose: The api detailed products that a seller lists which have a high sales potential in other Amazon marketplaces
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
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.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
order_id
STRING
order_item_id
STRING
purchase_date
STRING
payments_date
DATETIME
reporting_date
DATETIME
promise_date
DATETIME
days_past_promise
INTEGER
buyer_email
STRING
buyer_name
STRING
buyer_phone_number
STRING
sku
STRING
product_name
STRING
quantity_purchased
NUMERIC
quantity_shipped
NUMERIC
quantity_to_ship
NUMERIC
ship_service_level
STRING
recipient_name
STRING
ship_address_1
STRING
ship_address_2
STRING
ship_address_3
STRING
ship_city
STRING
ship_state
STRING
ship_postal_code
STRING
ship_country
STRING
payment_method
STRING
cod_collectible_amount
NUMERIC
already_paid
BOOLEAN
payment_method_fee
NUMERIC
is_business_order
BOOLEAN
purchase_order_number
STRING
price_designation
STRING
fulfilled_by
STRING
shipment_status
STRING
OrderReport
Purpose: The api detailed orders report.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
payments_status
STRING
order_id
STRING
order_item_id
STRING
payments_date
DATETIME
payments_transaction_id
STRING
item_name
STRING
listing_id
STRING
sku
STRING
price
NUMERIC
shipping_fee
NUMERIC
quantity_purchased
NUMERIC
total_price
NUMERIC
purchase_date
STRING
batch_id
STRING
buyer_email
STRING
buyer_name
STRING
recipient_name
STRING
ship_address_1
STRING