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. 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. 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. 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. 1.
    Signin to Daton
  2. 2.
    Select AmazonMWS from the list of Integrations
  3. 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. 4.
    Provide Merchant/Seller ID, MWS Auth Token and Marketplaces listed in. You can get your details from MWS Auth Token
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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
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
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
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
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
ship_address_2
STRING

FlatFileOrdersByLastUpdateReport

Purpose: The api detailed all orders updated in the specified period.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
amazon_order_id
STRING
merchant_order_id
STRING
purchase_date
STRING
last_updated_date
DATETIME
order_status
STRING
fulfillment_channel
STRING
sales_channel
STRING
order_channel
STRING
url
STRING
ship_service_level
STRING
product_name
STRING
sku
STRING
asin
STRING
item_status
STRING
quantity
NUMERIC
currency
STRING
item_price
NUMERIC
item_tax
NUMERIC
shipping_price
NUMERIC
FlatFileReturnsReportbyReturnDate
Purpose: The api detailed returns information, including return request date.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
Order_ID
STRING
Order_date
STRING
Return_request_date
STRING
Return_request_status
STRING
Amazon_RMA_ID
STRING
Merchant_RMA_ID
STRING
Label_type
STRING
Label_cost
STRING
Currency_code
STRING
Return_carrier
STRING
Tracking_ID
INTEGER
Label_to_be_paid_by
STRING
A_to_z_claim
STRING
Is_prime
STRING
ASIN
STRING
Merchant_SKU
STRING
Item_name
STRING
Return_quantity
INTEGER
Returnreason
STRING
ReferralFeePreviewReport
Purpose: The api detailed open listings as well as the price and estimated referral fees for each SKU.
Replication: Key Based Replication
Replication Key: StartDate
Fields
Name
Target Datatype
seller_sku
STRING
asin
STRING
item_name
STRING
price
STRING
estimated_referral_fee_per_item
NUMERIC
ActiveListingsReport
Purpose: The api detailed active 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
STRING
product_id_type
STRING
zshop_shipping_fee
NUMERIC
item_note
STRING
item_condition
NUMERIC
zshop_category1
STRING
zshop_browse_path
STRING
zshop_storefront_feature
STRING
asin1
STRING
asin2
STRING
asin3
STRING
InactiveListingsReport
Purpose: The api detailed inactive 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
STRING
product_id_type
STRING
zshop_shipping_fee
NUMERIC
item_note
STRING
item_condition
NUMERIC
zshop_category1
STRING
zshop_browse_path
STRING
zshop_storefront_feature
STRING
asin1
STRING
asin2
STRING
asin3
STRING