# Notification Reports ## Change Notification Reports - For Sellers You can use notification type values to subscribe to Selling Partner API notifications. Determine which notifications you want to receive to choose notification type values. ### **Offer Change Event Report** Table name: **amazon\_source\_data.**sellercentral\_offer\_change\_event\_report Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/notification-type-values#Summary_AnyOfferChanged) | Column Name | Data type | Description | | ----------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_name | String | Display Name | | account\_id | Integer | Intentwise Account ID | | country\_code | String | Country Code | | currency\_code | String | Currency Code | | mws\_seller\_id | String | Selling Partner ID | | event\_id | String | Event ID | | marketplace\_id | String | Marketplace ID | | asin | String | The ASIN for the item that had an offer change. | | item\_condition | String | The condition of the item that had an offer change. | | time\_of\_offer\_change | DateTime | The update time for the offer that caused this notification | | offer\_change\_type | String | The type of offer that changed and triggered this notification. | | suggested\_list\_price | Numeric | The list price of the item as suggested by the manufacturer | | competitive\_price\_threshold | Numeric | This price is based on competitive prices from other retailers (excluding other Amazon Sellers). Your offer may be ineligible for the Buy Box if your price + shipping is greater than this competitive price. | | is\_latest\_offer | Boolean | Indicates whether the offer is latest for seller and asin combination | | account\_timezone | String | Account Specific Timezone | | publish\_time | DateTime | Publish Time | | created\_date | Date | Date of when the listings item was created | | created\_date\_timestamp | DateTime | Timestamp of when the listings item was created | ### **Offer Change Event Details Report** Table name: **amazon\_source\_data.**sellercentral\_offer\_event\_details\_report Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/notification-type-values#Summary_AnyOfferChanged) | Column Name | Data type | Description | | ---------------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | account\_name | String | Display Name | | account\_id | Integer | Intentwise Account ID | | country\_code | String | Country Code | | currency\_code | String | Currency Code | | mws\_seller\_id | String | Selling Partner ID | | offer\_id | String | Offer ID | | event\_id | String | Event ID | | sub\_condition | String | The subcondition of the item. For example: New, Mint, Very Good, Good, Acceptable, Poor, Club, Ocode, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other | | listing\_price | Numeric | The price of the item. | | shipping\_price | Numeric | The shipping cost. | | shipping\_minimum\_hours | Integer | The minimum time, in hours, that the item will likely be shipped after the order has been placed. | | shipping\_maximum\_hours | Integer | The maximum time, in hours, that the item will likely be shipped after the order has been placed. | | shipping\_availability\_type | String | Indicates whether the item is available for shipping now, or on a known or an unknown date in the future. | | shipping\_available\_date | DateTime | The date when the item will be available for shipping. Only displayed for items that are not currently available for shipping. | | ships\_from\_country | String | The country from where the item is shipped. | | ships\_from\_state | String | The state from where the item is shipped. | | ships\_domestically | Boolean | Indicates whether the item ships domestically. | | is\_fulfilled\_by\_amazon | Boolean | Indicates whether the offer is fulfilled by Amazon. | | is\_buybox\_winner | Boolean | Indicates whether the offer is currently in the Buy Box. | | is\_lowest\_price | Boolean | Indicates whether the offer has lowest price. | | is\_featured\_merchant | Boolean | Indicates whether the seller of the item is eligible to win the Buy Box | | is\_offer\_prime | Boolean | Indicates whether the offer is an Amazon Prime offer. | | is\_offer\_national\_prime | Boolean | Indicates whether the offer is an Amazon Prime offer throughout the entire marketplace where it is listed. | | account\_timezone | String | Account Specific Timezone | | publish\_time | DateTime | Publish Time | | created\_date | Date | Date of when the listings item was created | | created\_date\_timestamp | DateTime | Timestamp of when the listings item was created | ### Account Status Change **Report** For the **ACCOUNT\_STATUS\_CHANGED** notification type, the SP API currently provides only the seller ID and does not include marketplace information. Due to this limitation, the status change is applied across all marketplaces associated with the seller in our system. To identify the specific marketplace impacted, we recommend reviewing the individual seller accounts. Table name: **amazon\_source\_data.**sellercentral\_account\_status\_changed\_report Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/notification-type-values#account_status_changed) | Column Name | Data type | Description | | ------------------------- | --------- | ------------------------------------------------- | | account\_name | String | Display Name | | account\_id | Integer | Intentwise Account ID | | country\_code | String | Country Code | | mws\_seller\_id | String | Selling Partner ID | | event\_id | String | Event ID | | marketplace\_id | String | Marketplace ID | | previous\_account\_status | String | The seller's account status prior to this update. | | current\_account\_status | String | The seller's new account status. | | account\_timezone | String | Account Specific Timezone | | publish\_time | DateTime | Publish Timestamp | | event\_time | DateTime | Event Timestamp | | created\_date | Date | Created Date | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/notification-reports.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.