# Amazon MWS ### 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 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 {% file src="" %} Amazon Reports - Description {% endfile %} ### ## Amazon MWS Merchant Token Please grant access to our Developer Id by following the steps outlined in this document: ## 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](https://docs.sarasanalytics.com/faqs/source-api-keys/amazon-mws-merchant-token-and-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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 |