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
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
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
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
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
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
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
account_name
String
account_id
Integer
master_id
Integer
product_category_id
String
rank
Integer
download_date
Date
Last updated
Was this helpful?