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