Schema and Tables

The reporting service provides reports that you can use to track, measure ad performance, and adjust settings to optimize your budget or campaign.

This section details the following entities:

• Schema

• Tables

  • Seller Reports

  • Raw Data Tables

Schema

The schema contains the field name and datatype of all columns in the tables offered by Daton:

• Real-Time Reports

• Daily Reports

• Monthly Report

• Raw Data Tables

• Snapshot Reports

Click here to view the Amazon SP API- Tables Schema

Tables

The details of each table offered by Daton is given divided amongst Seller Reports and Raw API tables.

Seller Reports are tables that are fetched via the Reports API in Amazon's SP API.

Raw Data Tables are offered by Daton that are from all APIs other than the Reports API in Amazon's SP API.

Seller Reports

The following representation contains the Name, Enum, and Location of all the Reports offered by Daton. They also specify the locations of the marketplaces that are being served. Here, we have categorized them as:

• FBA Reports

• Inventory Reports

• Business Reports

• Subscribe and Save Reports

• Brand Analytics Reports

• Other Reports

FBA Reports

Report Name	Enum	Location in SC
FBAAmazonFulfilledShipmentsReport For FBA Sellers only - Europe (EU), Japan, and North America (NA)	GET_AMAZON_FULFILLED_SHIPMENTS_DATA	Reports->Fulfillment->Sales->Amazon Fulfilled Shipments
FBACustomerShipmentSalesReport For FBA Sellers only - Europe (EU), Japan, and North America (NA)	GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA	Reports->Fulfillment->Sales->Customer Shipment Sales
FBAPromotionsReport FBA sellers only - North America (NA)	GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA	Reports->Fulfillment->Sales->Promotions
FBAAmazonFulfilledInventoryReport For FBA Sellers only	GET_AFN_INVENTORY_DATA	Reports->Fulfillment->Inventory->Amazon Fulfilled Inventory
FBAMonthlyInventoryHistoryReport For FBA sellers only	GET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA	Reports->Fulfillment->Inventory->Monthly Inventory History
FBAInventoryEventDetailReport For FBA sellers only	GET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATA	Reports->Fulfillment->Inventory->Inventory Event Detail
FBAInboundPerformanceReport For FBA sellers only	GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA	Reports->Fulfillment->Inventory->Inbound Performance
FBAReservedInventoryReport For FBA sellers only	GET_RESERVED_INVENTORY_DATA	Reports->Fulfillment->Inventory->Reserved Inventory
FBAStorageFeesReport For FBA Sellers only	GET_FBA_STORAGE_FEE_CHARGES_DATA	Reports->Fulfillment->Payments->Monthly Storage Fees
FBAReplacementsReport For FBA sellers only - US only	GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA	Reports->Fulfillment->Customer Concessions->Replacements
FBAInventoryHealthReport For FBA sellers only - This report is not available in the Mexico and Australia marketplaces.	GET_FBA_FULFILLMENT_INVENTORY_HEALTH_DATA	Reports->Fulfillment->Inventory->Inventory Health
FBAManageInventory For FBA sellers only	GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA	Reports->Fulfillment->Inventory->Manage FBA Inventory
FBAManageInventoryArchived For FBA sellers only - All regions except Mexico	GET_FBA_MYI_ALL_INVENTORY_DATA	Reports->Fulfillment->Inventory->Manage FBA Inventory Archived
FBARestockInventoryReport FBA Sellers only - Formerly US Marketplace only. Now enabled for all marketplaces	GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT	Reports->Fulfillment->Inventory->Restock Inventory
FBAStrandedInventoryReport FBA Sellers only - US, India, and Japan	GET_STRANDED_INVENTORY_UI_DATA	Reports->Fulfillment->Inventory->Stranded Inventory
FBAInventoryAgeReport For FBA sellers only - US, India, and Japan marketplaces.	GET_FBA_INVENTORY_AGED_DATA	Reports->Fulfillment->Inventory->Inventory Age
FBADailyInventoryHistoryReport For FBA sellers only - For all Regions	GET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATA	Reports->Fulfillment->Inventory->Daily Inventory History
FBAReceivedInventoryReport For FBA sellers only	GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA	Reports->Fulfillment->Inventory->Received Inventory
FBAInventoryAdjustmentsReport For FBA sellers only.	GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA	Reports->Fulfillment->Inventory->Inventory Adjustments
FeePreviewReport FBA Sellers only - EU and NA	GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA	Reports->Fulfillment->Payments->Fee Preview
FBARecommendedRemovalReport For FBA sellers only	GET_FBA_RECOMMENDED_REMOVAL_DATA	Reports->Fulfillment->Removals->Recommended Removal
FBAReimbursementsReport For FBA sellers only	GET_FBA_REIMBURSEMENTS_DATA	Reports->Fulfillment->Payments->Reimbursements
FBAReturnsReport For FBA sellers only	GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA	Reports->Fulfillment->Customer Concessions->FBA Customer returns
FBASmallandLightInventoryReport FBA Sellers only - US, UK, Germany, and Japan	GET_FBA_UNO_INVENTORY_DATA	Reports->Fulfillment->Inventory->Small & Light Inventory
FBARemovalOrderDetailReport FBA Sellers only	GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA	Reports->Fulfillment->Removals->Removal Order Detail
FBARemovalShipmentDetailReport FBA Sellers only	GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA	Reports->Fulfillment->Removals->Removal Shipment Detail
InventoryLedgerSummaryReport All Sellers	GET_LEDGER_SUMMARY_VIEW_DATA	Reports->Fulfillment->Inventory->InventoryLedger
InventoryLedgerSummaryReportByFulfillmentCentre All Sellers	GET_LEDGER_SUMMARY_VIEW_DATA	Reports->Fulfillment->Inventory->InventoryLedger
InventoryLedgerDetailedReport All Sellers	GET_LEDGER_DETAIL_VIEW_DATA	Reports->Fulfillment->Inventory->InventoryLedger
FBAManageInventoryHealthReport All Sellers	GET_FBA_INVENTORY_PLANNING_DA	ports->Fulfillment->Inventory->FBA Inventory

Inventory Reports

Report Name in Daton	Enum	Location in SC
ReferralFeePreviewReport For Seller Central Only	GET_REFERRAL_FEE_PREVIEW_REPORT	Inventory->Inventory Reports->Referral Fee Preview Report
ReferralFeeDiscountsReport For Amazon Business Sellers Only - US, UK, Germany, India, and Japan	FEE_DISCOUNTS_REPORT	Inventory->Inventory Reports->Referral Fee Discounts Report
AllListingsReport For Seller Central Only - Canada, US,Europe, and India	GET_MERCHANT_LISTINGS_ALL_DATA	Inventory->Inventory Reports->All Listing Report
ActiveListingsReport For Seller Central Only	GET_MERCHANT_LISTINGS_DATA	Inventory->Inventory Reports->Active Listing Report
InactiveListingsReport For Seller Central Only	GET_MERCHANT_LISTINGS_INACTIVE_DATA	Inventory->Inventory Reports->Inactive Listings report
OpenListingsReport For Seller Central Only - Canada, US, UK, and India	GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT	Inventory->Inventory Reports->Open Listings Report
CanceledListingsReport For Seller Central Only - Canada, US, UK, and India	GET_MERCHANT_CANCELLED_LISTINGS_DATA	Inventory->Inventory Reports->Canceled Listings Report
ListingQualityAndSuppressedListingReport For Seller Central Only	GET_MERCHANT_LISTINGS_DEFECT_DATA	Inventory->Inventory Reports->Listing Quality and Suppressed Listings Report
SoldListingsReport For Seller Central Only - Canada, US, UK, and India	GET_CONVERGED_FLAT_FILE_SOLD_LISTINGS_DATA	Inventory->Inventory Reports->Sold Listings Report
InventoryReport	GET_FLAT_FILE_OPEN_LISTINGS_DATA	Reports->Inventory Reports->Inventory Report
SuppressedListingsReport	GET_MERCHANTS_LISTINGS_FYP_REPORT
PanEuropeanEligibilityFBAASINs This report is only available to FBA sellers in the Spain, UK, France, Germany, and Italy marketplaces.	GET_PAN_EU_OFFER_STATUS	Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: FBA ASINs
PanEuropeanEligibilitySelfFulfilledASINs This report is only available in the Spain, UK, France, Germany, and Italy marketplaces.	GET_MFN_PAN_EU_OFFER_STATUS	Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: Self-fulfilled ASINs

Business Reports

Report Name	Enum	Location in SC
ReferralFeePreviewReport For Seller Central Only	GET_REFERRAL_FEE_PREVIEW_REPORT	Inventory->Inventory Reports->Referral Fee Preview Report
ReferralFeeDiscountsReport For Amazon Business Sellers Only - US, UK, Germany, India, and Japan	FEE_DISCOUNTS_REPORT	Inventory->Inventory Reports->Referral Fee Discounts Report
AllListingsReport For Seller Central Only - Canada, US,Europe, and India	GET_MERCHANT_LISTINGS_ALL_DATA	Inventory->Inventory Reports->All Listing Report
ActiveListingsReport For Seller Central Only	GET_MERCHANT_LISTINGS_DATA	Inventory->Inventory Reports->Active Listing Report
InactiveListingsReport For Seller Central Only	GET_MERCHANT_LISTINGS_INACTIVE_DATA	Inventory->Inventory Reports->Inactive Listings report
OpenListingsReport For Seller Central Only - Canada, US, UK, and India	GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT	Inventory->Inventory Reports->Open Listings Report
CanceledListingsReport For Seller Central Only - Canada, US, UK, and India	GET_MERCHANT_CANCELLED_LISTINGS_DATA	Inventory->Inventory Reports->Canceled Listings Report
ListingQualityAndSuppressedListingReport For Seller Central Only	GET_MERCHANT_LISTINGS_DEFECT_DATA	Inventory->Inventory Reports->Listing Quality and Suppressed Listings Report
SoldListingsReport For Seller Central Only - Canada, US, UK, and India	GET_CONVERGED_FLAT_FILE_SOLD_LISTINGS_DATA	Inventory->Inventory Reports->Sold Listings Report
InventoryReport	GET_FLAT_FILE_OPEN_LISTINGS_DATA	Reports->Inventory Reports->Inventory Report
SuppressedListingsReport	GET_MERCHANTS_LISTINGS_FYP_REPORT
PanEuropeanEligibilityFBAASINs For FBA sellers in the Spain, UK, France, Germany, and Italy marketplaces.	GET_PAN_EU_OFFER_STATUS	Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: FBA ASINs
PanEuropeanEligibilitySelfFulfilledASINs For the Spain, UK, France, Germany, and Italy marketplaces.	GET_MFN_PAN_EU_OFFER_STATUS	Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: Self-fulfilled ASINs

Subscribe and Save Reports

Report Name	Enum
SubscribeAndSaveForecastReport	GET_FBA_SNS_FORECAST_DATA
SubscribeAndSavePerformanceReport	GET_FBA_SNS_PERFORMANCE_DATA

Brand Analytics reports

All of these reports are available for all Sellers in all the regions and to access it, user must be registered on Amazon Brand Registry.

Report Name	Enum	Location in SC
BrandAnalyticsMarketBasketReport	GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT	Brands->Brand Analytics->Consumer Behaviour Dashboards->Market Basket Analysis
BrandAnalyticsSearchTermsReport	GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT	Brands->Brand Analytics->Consumer Behaviour Dashboards->Amazon Search Terms Report
RepeatPurchaseReport	GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT	Brands->Brand Analytics->Consumer Behaviour Dashboards->Repeat Purchase Behaviour
AlternatePurchaseReport	GET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORT	Brands->Brand Analytics->Consumer Behaviour Dashboards->Item Comparison and Alternate Purchase Behaviour
ItemComparisonReport	GET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORT	Brands->Brand Analytics->Consumer Behaviour Dashboards->Item Comparison and Alternate Purchase Behaviour

Other Reports

Report Name	Enum	Location in SC
FlatFileReturnsReportByReturnDate	GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE	Reports->Returns
FlatFileFeedbackReport	GET_SELLER_FEEDBACK_DATA	Performance->Feedback
EasyShipPickedUpReport India Only	GET_EASYSHIP_PICKEDUP	Orders->Order Reports->EasyShip Orders
EasyShipWaitingforPickUpReport India Only	GET_EASYSHIP_WAITING_FOR_PICKUP	Orders->Order Reports->EasyShip Orders
FBAFlatFileOrdersByLastUpdateReport	GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE	Reports->Fulfillment->Sales->All Orders (Select Last Update Date from options)
ManageInventoryHealth For Seller Central Only	GET_FLAT_FILE_ORDERS_DATA	Orders->Order Reports->New Orders
FlatFileV2SettlementReport	GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2	Reports->Payments->All Statements
FlatFileAllOrdersReportbyLastUpdate	GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE	Reports->FulfilledByAmazon->Sales->All Orders
ProductOpportunitiesRecommended US, UK, France, Spain, Italy, India, Japan, Germany	GET_B2B_PRODUCT_OPPORTUNITIES_RECOMMENDED_FOR_YOU	B2B->Product Opportunities->Recommended For You
ProductOpportunitiesNotYetOnAmazon US, UK, France, Spain, Italy, India, Japan, Germany	GET_B2B_PRODUCT_OPPORTUNITIES_NOT_YET_ON_AMAZON	B2B->Product Opportunities->Products Not Yet On Amazon
AccountHealthSellerPerformanceReport	GET_V2_SELLER_PERFORMANCE_REPORT	Performance->Account Health->Reports->Performance Over Time
PromotionsPerformanceReport For Sellers registered on Amazon Brand Registry and with Selling Partner, Insights Selling Partner API role	GET_PROMOTION_PERFORMANCE_REPORT	Seller Central -> Advertising -> Deals
VATTransactionsReport Germany, Spain, Italy, France, and UK	GET_VAT_TRANSACTION_DATA	Reports->Fullfillment->Tax->Amazon VAT Transactions Report
GSTMerchantTaxReportB2B India Only	GET_GST_MTR_B2B_CUSTOM	Reports->Tax Documents Library->Merchant Tax Reports->B2B
GSTMerchantTaxReportB2C India Only	GET_GST_MTR_B2C_CUSTOM	Reports->Tax Documents Library->Merchant Tax Reports->B2B

Click here for a detailed view of the Amazon SP - Seller Reports

Raw Data Tables

Table Name in Selling Partner	Endpoint	API Filters and Parameters
CatalogItems (This table cannot be added when any one of listed tables are added: CatalogItemsVariations, CatalogItemsSalesRank, CatalogItemsSummary)	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#getcatalogitem	List of ASINs IncludedData - attributes, dimensions, identifiers, images, productTypes, relationships, salesRanks, summaries
CatalogItemsSummary	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#getcatalogitem	List of ASINs IncludedData - Summaries
CatalogItemsVariations	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#getcatalogitem	List of ASINs IncludedData - Variations
CatalogItemsSalesRank	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#getcatalogitem	List of ASINs IncludedData - SalesRank
CatalogCategoriesForASIN	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v0-reference#listcatalogcategories	List of ASINs
CatalogCategoriesForSKU	https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v0-reference#listcatalogcategories	List of SKUs
ListingsRestrictions	https://github.com/amzn/selling-partner-api-docs/blob/main/references/listings-restrictions-api/listingsRestrictions_2021-08-01.md#getlistingsrestrictions	List of ASINs
FBAInventorySummary	https://github.com/amzn/selling-partner-api-docs/blob/main/references/fba-inventory-api/fbaInventory.md#getinventorysummaries	details - true granularityType - Iterate Marketplaces granularityId - Iterate Marketplaces marketplaceIds - Iterate Marketplaces
ListFinancialEvents	https://github.com/amzn/selling-partner-api-docs/blob/main/references/finances-api/financesV0.md#listfinancialevents	None
ListFinancialEventsByGroupId	https://developer-docs.amazon.com/sp-api/docs/finances-api-reference#listfinancialeventsbygroupid	FinancialEventsGroupId - from ListFinancialEventGroups
ListFinancialEventGroups	https://github.com/amzn/selling-partner-api-docs/blob/main/references/finances-api/financesV0.md#listfinancialeventgroups	None
InboundShipments	https://github.com/amzn/selling-partner-api-docs/blob/main/references/fulfillment-inbound-api/fulfillmentInboundV0.md#getshipments	QueryType - DATE_RANGE, Next Token LastUpdatedAfter
InboundShipmentItems	https://github.com/amzn/selling-partner-api-docs/blob/main/references/fulfillment-inbound-api/fulfillmentInboundV0.md#getshipmentitems	QueryType - DATE_RANGE, Next Token LastUpdatedAfter
InboundShipmentsTransportDetails	https://developer-docs.amazon.com/sp-api/docs/fulfillment-inbound-api-v0-reference#gettransportdetails	QueryType - DATE_RANGE, Next Token LastUpdatedAfter
ListOrder	https://github.com/amzn/selling-partner-api-docs/blob/main/references/orders-api/ordersV0.md#getorders	OrderStatuses - All Enums FulfillmentChannels - All Enums PaymentMethods - All Enums Check whether defaults give all statuses and channels.
ListOrderItems	https://github.com/amzn/selling-partner-api-docs/blob/main/references/orders-api/ordersV0.md#getorderitems
GetCompetitivePricingForSKU	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getcompetitivepricing	SKUs - List ItemType - SKU CustomerType
GetCompetitivePricingForASIN	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getcompetitivepricing	ASIN - List ItemType - ASIN CustomerType
PricingForASIN	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getpricing	OfferType - Both B2B and B2C ItemType - SKU, List of ASINs
OrderMetricsDaily	https://developer-docs.amazon.com/sp-api/docs/sales-api-v1-reference#getordermetrics	granularity - Day
OrderMetricsHourly	https://developer-docs.amazon.com/sp-api/docs/sales-api-v1-reference#getordermetrics	granularity - Hour
GetMarketplaceParticipations	https://github.com/amzn/selling-partner-api-docs/blob/main/references/sellers-api/sellers.md#getmarketplaceparticipations
ListingsItemsSummary	https://developer-docs.amazon.com/sp-api/docs/listings-items-api-v2021-08-01-reference#getlistingsitem	IncludedData - Summaries
ListingsItemsIssues	https://developer-docs.amazon.com/sp-api/docs/listings-items-api-v2021-08-01-reference#getlistingsitem	IncludedData - Issues
ListingsRestrictions	https://developer-docs.amazon.com/sp-api/docs/listings-restrictions-api-v2021-08-01-reference#getlistingsrestrictions
ListingOffers	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getlistingoffers	ItemCondition - All CustomerType - All
ListingOffersForASIN	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getitemoffers	ItemCondition - All CustomerType - All
APLusContentDocument	https://developer-docs.amazon.com/sp-api/docs/selling-partner-api-for-a-content-management#getcontentdocument	marketplaceIds, includedDataSet = CONTENT, contentReferenceKey
ListAllFulfillmentOrders	https://github.com/amzn/selling-partner-api-docs/blob/main/references/fulfillment-outbound-api/fulfillmentOutbound_2020-07-01.md#listallfulfillmentorders	None
FeeEstimateForSKU	https://github.com/amzn/selling-partner-api-docs/blob/main/references/product-fees-api/productFeesV0.md#getmyfeesestimateforsku	SellerInputIdentifier - skus
FeeEstimateForASIN	https://github.com/amzn/selling-partner-api-docs/blob/main/references/product-fees-api/productFeesV0.md#getmyfeesestimateforsku	SellerInputIdentifier - asins
PricingForSKU	https://developer-docs.amazon.com/sp-api/docs/product-pricing-api-v0-reference#getpricing	OfferType - Both B2B and B2C ItemType - SKU, List of SKUs

Contact us

Main Menu

Setup Manual