All Report Types and Tables

Schema

The schema of each table offered by Daton is given according to the report type in the sheet linked below.

46KB

Amazon SP-API Tables Schema .xlsx

Linked spreadsheet with schema of each table

Table Details

The details of each table Daton offers are divided amongst Seller Reports and Raw API tables. Seller Reports are tables fetched via the Reports API in Amazon's SP API. Raw Data Tables refer to tables offered by Daton that are from all APIs other than the Reports API in Amazon's SP API.

36KB

Amazon Selling Partner Tables.xlsx

Details including SP-API endpoint/Report Types, history and latency used to fetch data for each table

Report Types

Daily Reports

FlatFileV2SettlementReport
PromotionsPerformanceReport
SalesAndTrafficReportByChildASIN
SalesAndTrafficReportByParentASIN (deprecated)
SalesAndTrafficReportByDate
FBAReservedInventoryReport
FBAPromotionsReport
FBAReturnsReport
FBARemovalOrderDetailReport
FBADailyInventoryHistoryReport (deprecated)
FBAReceivedInventoryReport (deprecated)
FBAInventoryEventDetailReport (deprecated)
FBAInventoryAdjustmentsReport (deprecated)
FBAReplacementsReport
FBAInboundPerformanceReport
FBAReimbursementsReport
FBARemovalShipmentDetailReport

Snapshot Reports

PanEuropeanEligibilityFBAASINs
SuppressedListingsReport
ListingQualityandSuppressedListingReport
FBAMultiCountryInventoryReport
FBAManageInventoryHealthReport
InventoryReport
AllListingsReport
OpenListingsReport
CanceledListingsReport
ActiveListingsReport
InactiveListingsReport
FBAAmazonFulfilledInventoryReport
FBAManageInventory
FBAManageInventoryArchived (deprecated)
FBARestockInventoryReport
FBAStrandedInventoryReport
FBARecommendedRemovalReport
FBASmallAndLightInventoryReport
FeePreviewReport
ReferralFeePreviewReport
ReferralFeeDiscountsReport
AccountHealthSellerPerformanceReport
ProductOpportunitiesNotYetOnAmazon
ProductOpportunitiesRecommended

Real Time Reports

InventoryLedgerDetailedReport
InventoryLedgerSummaryReport
FBAFlatFileOrdersByLastUpdateReport
FlatFileReturnsReportbyReturnDate
FlatFileFeedbackReport
FBAAmazonFulfilledShipmentsReport
FBACustomerShipmentSalesReport
EasyShipPickedUpReport (India only)
EasyShipWaitingforPickUpReport (India only)
FlatFileAllOrdersReportbyLastUpdate

Monthly Reports

VATTransactionsReport (EU only)
FBAStorageFeesReport
FBAMonthlyInventoryHistoryReport (deprecated)

Raw Data Tables

ListAllFulfillmentOrders
OrderMetricsHourly
OrderMetricsDaily
CatalogCategoriesForASIN
CatalogCategoriesForSKU
GetCompetitivePricingForSKU
GetCompetitivePricingForASIN
InboundShipments
InboundShipmentsItems
InboundShipmentsTransportDetails
FBAInventorySummary
ListOrder
ListOrderItems
ListFinancialEvents
ListFinancialEventsGroups
ListFinancialEventsByGroupId
ListingsItemsSummary
ListingsItemsIssues
CatalogItems
CatalogItemsVariations
CatalogItemsSalesRank
CatalogItemsSummary
ListingsRestrictions
ListingOffers
PricingForASIN