Schema Information of Amazon MWS
Discover the schema information of Amazon MWS, essential for understanding and utilizing the platform effectively.
Schema Information of Amazon MWS
Discover the schema information of Amazon MWS, essential for understanding and utilizing the platform effectively.
Tables/APIs
The following is the list of tables or APIs associated with the connector:
ListFinancialEventGroups
Purpose: This API is used to get the list of all variants in the catalog.
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 |
| 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 |
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 |
| 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 |
| merchant_shipping_group | NUMERIC |
| 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 |
