Pricing Reports

Pricing Reports - For Sellers

This section documents the Amazon SP-API pricing reports integrated into Intentwise, including the available report types, supported data fields, and download frequency. These reports provide product-level pricing information such as current listing prices, competitive prices, and featured offer details across supported marketplaces.

Competitive Pricing Master

Table name: amazon_source_data.sellercentral_competitive_pricing_master

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
asin	String
seller_sku	String
status	String
download_date	Date

Competitive Pricing Offers

Table name: amazon_source_data.sellercentral_competitive_pricing_offers

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
offer_type	String
buying_price_landed_amount	Numeric
buying_price_landed_currency	String
buying_price_listing_amount	Numeric
buying_price_listing_currency	String
buying_price_shipping_amount	Numeric
buying_price_shipping_currency	String
buying_price_points_number	Integer
buying_price_points_monetary_amount	Numeric
buying_price_points_monetary_currency	String
regular_price_amount	Numeric
regular_price_currency	String
business_price_amount	Numeric
business_price_currency	String
fulfillment_channel	String
item_condition	String
item_sub_condition	String
seller_sku	String
quantity_tier	Integer
quantity_discount_type	String
qdp_listing_price_amount	Numeric
qdp_listing_price_currency	String
download_date	Date

Competitive Pricing Identifiers

Table name: amazon_source_data.sellercentral_competitive_pricing_identifiers

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
marketplace_id	String
marketplace_asin	String
sku_marketplace_id	String
sku_seller_id	String
sku_seller_sku	String
download_date	Date

Competitive Pricing Attribute Sets

Table name: amazon_source_data.competitive_pricing_attribute_sets

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
attribute_data	String
download_date	Date

Competitive Pricing Relationships

Table name: amazon_source_data.sellercentral_competitive_pricing_relationships

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
relationship_data	String
download_date	Date

Competitive Pricing Competitive Prices

Table name: amazon_source_data.sellercentral_competitive_pricing_competitive_prices

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
competitive_price_id	String
landed_price_amount	Numeric
landed_price_currency	String
listing_price_amount	Numeric
listing_price_currency	String
shipping_amount	Numeric
shipping_currency	String
points_number	Integer
points_monetary_value_amount	Numeric
points_monetary_value_currency	String
condition_type	String
subcondition_type	String
offer_type	String
quantity_tier	Integer
quantity_discount_type	String
seller_id	String
belongs_to_requester	Boolean
listing_count	Integer
download_date	Date

Competitive Pricing Sales Rankings

Table name: amazon_source_data.sellercentral_competitive_pricing_sales_rankings

Note - To join with master table use the column master_id

Column Name	Data type	Description
account_name	String
account_id	Integer
master_id	Integer
product_category_id	String
rank	Integer
download_date	Date