> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/pricing-reports.md).

# 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

<table><thead><tr><th width="191.33331298828125">Column Name</th><th width="167.77783203125">Data type</th><th width="208">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>asin</td><td>String</td><td></td></tr><tr><td>seller_sku</td><td>String</td><td></td></tr><tr><td>status</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Offers**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_competitive\_pricing\_offers

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="241">Column Name</th><th width="158">Data type</th><th width="181.3333740234375">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>offer_type</td><td>String</td><td></td></tr><tr><td>buying_price_landed_amount</td><td>Numeric</td><td></td></tr><tr><td>buying_price_landed_currency</td><td>String</td><td></td></tr><tr><td>buying_price_listing_amount</td><td>Numeric</td><td></td></tr><tr><td>buying_price_listing_currency</td><td>String</td><td></td></tr><tr><td>buying_price_shipping_amount</td><td>Numeric</td><td></td></tr><tr><td>buying_price_shipping_currency</td><td>String</td><td></td></tr><tr><td>buying_price_points_number</td><td>Integer</td><td></td></tr><tr><td>buying_price_points_monetary_amount</td><td>Numeric</td><td></td></tr><tr><td>buying_price_points_monetary_currency</td><td>String</td><td></td></tr><tr><td>regular_price_amount</td><td>Numeric</td><td></td></tr><tr><td>regular_price_currency</td><td>String</td><td></td></tr><tr><td>business_price_amount</td><td>Numeric</td><td></td></tr><tr><td>business_price_currency</td><td>String</td><td></td></tr><tr><td>fulfillment_channel</td><td>String</td><td></td></tr><tr><td>item_condition</td><td>String</td><td></td></tr><tr><td>item_sub_condition</td><td>String</td><td></td></tr><tr><td>seller_sku</td><td>String</td><td></td></tr><tr><td>quantity_tier</td><td>Integer</td><td></td></tr><tr><td>quantity_discount_type</td><td>String</td><td></td></tr><tr><td>qdp_listing_price_amount</td><td>Numeric</td><td></td></tr><tr><td>qdp_listing_price_currency</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Identifiers**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_competitive\_pricing\_identifiers

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="173.55560302734375">Column Name</th><th width="127.99993896484375">Data type</th><th width="265.7777099609375">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>marketplace_id</td><td>String</td><td></td></tr><tr><td>marketplace_asin</td><td>String</td><td></td></tr><tr><td>sku_marketplace_id</td><td>String</td><td></td></tr><tr><td>sku_seller_id</td><td>String</td><td></td></tr><tr><td>sku_seller_sku</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Attribute Sets**

Table name: **amazon\_source\_data.**&#x63;ompetitive\_pricing\_attribute\_sets

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="198.4444580078125">Column Name</th><th width="129.7777099609375">Data type</th><th width="244.4444580078125">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>attribute_data</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Relationships**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_competitive\_pricing\_relationships

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="163.888916015625">Column Name</th><th width="181.33331298828125">Data type</th><th width="226.666748046875">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>relationship_data</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Competitive Prices**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_competitive\_pricing\_competitive\_prices

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="213.11114501953125">Column Name</th><th width="129.7777099609375">Data type</th><th width="231.1112060546875">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>competitive_price_id</td><td>String</td><td></td></tr><tr><td>landed_price_amount</td><td>Numeric</td><td></td></tr><tr><td>landed_price_currency</td><td>String</td><td></td></tr><tr><td>listing_price_amount</td><td>Numeric</td><td></td></tr><tr><td>listing_price_currency</td><td>String</td><td></td></tr><tr><td>shipping_amount</td><td>Numeric</td><td></td></tr><tr><td>shipping_currency</td><td>String</td><td></td></tr><tr><td>points_number</td><td>Integer</td><td></td></tr><tr><td>points_monetary_value_amount</td><td>Numeric</td><td></td></tr><tr><td>points_monetary_value_currency</td><td>String</td><td></td></tr><tr><td>condition_type</td><td>String</td><td></td></tr><tr><td>subcondition_type</td><td>String</td><td></td></tr><tr><td>offer_type</td><td>String</td><td></td></tr><tr><td>quantity_tier</td><td>Integer</td><td></td></tr><tr><td>quantity_discount_type</td><td>String</td><td></td></tr><tr><td>seller_id</td><td>String</td><td></td></tr><tr><td>belongs_to_requester</td><td>Boolean</td><td></td></tr><tr><td>listing_count</td><td>Integer</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

### **Competitive Pricing Sales Rankings**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_competitive\_pricing\_sales\_rankings

**Note** - To join with master table use the column master\_id

<table><thead><tr><th width="195.77777099609375">Column Name</th><th width="144">Data type</th><th width="216">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>master_id</td><td>Integer</td><td></td></tr><tr><td>product_category_id</td><td>String</td><td></td></tr><tr><td>rank</td><td>Integer</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>