Schema Information for Amazon Selling Partner
Schema Information for Amazon Selling Partner
In this article, we will look at the schema information of the supported APIs and tables for Amazon Selling Partner.
Find the links to other articles related to Amazon Selling Partner Below:
- Essential Attributes and Supported Tables for Amazon Selling Partner
- Setup Instructions for Amazon Selling Partner
-
Release Notes and Updates for Amazon Selling Partner
All Report Types and Tables
This section helps you with detailed data categorization in Amazon Selling Partner, providing in-depth information for efficient navigation and analysis. Explore individual table schemas for a comprehensive understanding of underlying data structures.
Schema Details
The schema of each table offered by Daton is given according to the report type in the sheet, Amazon Selling Partner API Schemas
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.
To explore the list of Amazon Selling Partner APIs currently offered by Daton with detailed schema information see, Amazon Selling Partner APIs/Tables
Categorization of Tables in Selling Partner
Click on each of the categories to expand.
Daily Reports
The list of Daily Report Tables available for Amazon Selling Partner in Daton is as follows:
FlatFileV2SettlementReport |
PromotionsPerformanceReport |
SalesAndTrafficReportByChildASIN |
SalesAndTrafficReportByParentASIN (deprecated) |
SalesAndTrafficReportByDate |
FBAReservedInventoryReport |
FBAPromotionsReport |
FBAReturnsReport |
FBARemovalOrderDetailReport |
FBADailyInventoryHistoryReport (deprecated) |
FBAReceivedInventoryReport (deprecated) |
FBAInventoryEventDetailReport (deprecated) |
FBAInventoryAdjustmentsReport (deprecated) |
FBAReplacementsReport |
FBAInboundPerformanceReport |
FBAReimbursementsReport |
FBARemovalShipmentDetailReport |
Snapshot Reports
The list of Snapshot Report Tables available for Amazon Selling Partner in Daton is as follows:
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 |
To know more about each table, see Snapshot Reports- Amazon Selling Partner.
Monthly Reports
The list of Monthly Report Tables available for Amazon Selling Partner in Daton is as follows:
VATTransactionsReport (EU only) |
FBAStorageFeesReport |
FBAMonthlyInventoryHistoryReport (deprecated) |
Raw Data Tables
The list of Raw Data Tables available for Amazon Selling Partner in Daton is as follows:
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 |
Real Time Reports
The list of Real-Time Report Tables available for Amazon Selling Partner in Daton is as follows:
InventoryLedgerDetailedReport |
InventoryLedgerSummaryReport |
FBAFlatFileOrdersByLastUpdateReport |
FlatFileReturnsReportbyReturnDate |
FlatFileFeedbackReport |
FBAAmazonFulfilledShipmentsReport |
FBACustomerShipmentSalesReport |
EasyShipPickedUpReport (India only) |
EasyShipWaitingforPickUpReport (India only) |
FlatFileAllOrdersReportbyLastUpdate |