# 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 |