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 [e-mail] 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

26KB

AmazonMWS_Reports.xlsx

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.

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

ListOrders

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/subscriptions/Subscriptions_ListRegisteredDestinations.html

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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
ship_city	STRING
ship_state	STRING
ship_zip	STRING
ship_country	STRING
special_comments	STRING
upc	STRING
ship_method	STRING
VAT	STRING
fulfilled_by	STRING

FlatFileOrdersByLastUpdateReport

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

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
shipping_tax	NUMERIC
gift_wrap_price	NUMERIC
gift_wrap_tax	NUMERIC
item_promotion_discount	NUMERIC
ship_promotion_discount	NUMERIC
ship_city	STRING
ship_state	STRING
ship_postal_code	STRING
ship_country	STRING
promotion_ids	STRING
is_business_order	BOOLEAN
purchase_order_number	STRING
price_designation	STRING
fulfilled_by	STRING
is_sold_by_ab	BOOLEAN

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

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
In_policy	STRING
Return_type	STRING
Resolution	STRING
Invoice_number	STRING
Return_delivery_date	STRING
Order_amount	NUMERIC
Order_quantity	INTEGER
SafeT_action_reason	STRING
SafeT_claim_id	STRING
SafeT_claim_state	STRING
SafeT_claim_creation_time	NUMERIC
SafeT_claim_reimbursement_amount	NUMERIC
Refunded_amount	NUMERIC
Category	STRING

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

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.

Source API Documentation http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports

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
will_ship_internationally	BOOLEAN
expedited_shipping	BOOLEAN
zshop_boldface	STRING
product_id	STRING
bid_for_featured_placement	STRING
add_delete	STRING
pending_quantity	NUMERIC
fulfillment_channel	STRING
Business_Price	NUMERIC
Quantity_Price_Type	STRING
Quantity_Lower_Bound_1	STRING
Quantity_Price_1	NUMERIC
Quantity_Lower_Bound_2	STRING
Quantity_Price_2	NUMERIC
Quantity_Lower_Bound_3	STRING
Quantity_Price_3	NUMERIC
Quantity_Lower_Bound_4	STRING
Quantity_Price_4	NUMERIC
Quantity_Lower_Bound_5	STRING
Quantity_Price_5	NUMERIC
optional_payment_type_exclusion	STRING
merchant_shipping_group	STRING

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

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
will_ship_internationally	BOOLEAN
expedited_shipping	BOOLEAN
zshop_boldface	STRING
product_id	STRING
bid_for_featured_placement	STRING
add_delete	STRING
pending_quantity	NUMERIC
fulfillment_channel	STRING
optional_payment_type_exclusion	STRING
merchant_shipping_group	STRING