> 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/notification-reports.md).

# 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.**&#x73;ellercentral\_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                                                                                                                                                                |
| seller\_id                    | String    | Merchant identifier associated with the offer                                                                                                                                                                  |

### **Offer Change Event Details Report**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_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                                                                                                                       |
| seller\_id                   | String    | Merchant identifier associated with the offer                                                                                                                         |

### 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.**&#x73;ellercentral\_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                                      |

### **Listings Item Offers Report**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_offers

<table><thead><tr><th width="187.77777099609375">Column Name</th><th width="115.888916015625">Data type</th><th width="288.2222900390625">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>account_name</td></tr><tr><td>account_id</td><td>Integer</td><td>account_id</td></tr><tr><td>seller_id</td><td>String</td><td>Amazon seller identifier associated with the offer.</td></tr><tr><td>sku</td><td>String</td><td>Seller SKU identifying the listed product.</td></tr><tr><td>offer_type</td><td>String</td><td>Type/category of offer associated with the SKU.</td></tr><tr><td>price_currency_code</td><td>String</td><td>Currency code for the offer price, such as USD, EUR, or GBP.</td></tr><tr><td>price_amount</td><td>Numeric</td><td>Price amount of the offer in the specified currency.</td></tr><tr><td>points_number</td><td>Integer</td><td>Number of Amazon points associated with the offer, where applicable.</td></tr><tr><td>audience_value</td><td>String</td><td>Value identifying the customer audience or eligibility associated with the offer.</td></tr><tr><td>audience_display_name</td><td>String</td><td>Display name of the audience associated with the offer.</td></tr><tr><td>download_date</td><td>Date</td><td>Date on which the offer data was downloaded from Seller Central/SP-API.</td></tr></tbody></table>

### **Listings Item Procurement**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_procurement

| Column Name                 | Data type | Description                                                            |
| --------------------------- | --------- | ---------------------------------------------------------------------- |
| account\_name               | String    | Display name of the Intentwise account.                                |
| account\_id                 | Integer   | Unique Intentwise account ID.                                          |
| seller\_id                  | String    | Unique identifier of the seller.                                       |
| sku                         | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.       |
| cost\_price\_currency\_code | String    | Currency code associated with the product's cost price.                |
| cost\_price\_amount         | Decimal   | Cost price amount of the product, expressed in the specified currency. |
| download\_date              | Date      | Date on which the data was downloaded.                                 |

### **Listings Item Summaries**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_summaries

| Column Name          | Data type | Description                                                                                    |
| -------------------- | --------- | ---------------------------------------------------------------------------------------------- |
| account\_name        | String    | Display name of the Intentwise account.                                                        |
| account\_id          | Integer   | Unique Intentwise account ID.                                                                  |
| seller\_id           | String    | Unique identifier of the seller.                                                               |
| sku                  | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.                               |
| asin                 | String    | Amazon Standard Identification Number (ASIN) of the product.                                   |
| product\_type        | String    | Product category or type assigned by Amazon.                                                   |
| item\_name           | String    | Name or title of the product listing.                                                          |
| condition\_type      | String    | Condition of the listed product, such as New or Used.                                          |
| fn\_sku              | String    | Fulfillment Network SKU assigned by Amazon to identify the product in its fulfillment network. |
| status\_buyable      | Boolean   | Indicates whether the product listing is currently available for purchase.                     |
| status\_discoverable | Boolean   | Indicates whether the product listing is discoverable by customers on Amazon.                  |
| created\_date        | DateTime  | Date and time when the product listing was created.                                            |
| last\_updated\_date  | DateTime  | Date and time when the product listing was last updated.                                       |
| main\_image\_link    | String    | URL of the primary product image.                                                              |
| main\_image\_height  | Integer   | Height of the primary product image in pixels.                                                 |
| main\_image\_width   | Integer   | Width of the primary product image in pixels.                                                  |
| download\_date       | Date      | Date on which the data was downloaded.                                                         |

### **Listings Item Issues**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_issues

| Column Name                                    | Data type | Description                                                                                 |
| ---------------------------------------------- | --------- | ------------------------------------------------------------------------------------------- |
| account\_name                                  | String    | Display name of the Intentwise account.                                                     |
| account\_id                                    | Integer   | Unique Intentwise account ID.                                                               |
| seller\_id                                     | String    | Unique identifier of the seller.                                                            |
| sku                                            | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.                            |
| issue\_code                                    | String    | Unique code identifying the listing issue reported by Amazon.                               |
| issue\_message                                 | String    | Description of the listing issue or problem identified by Amazon.                           |
| attribute\_names                               | String    | Names of the product attributes associated with the identified issue.                       |
| severity\_error                                | Boolean   | Indicates whether the issue is classified as an error.                                      |
| severity\_warning                              | Boolean   | Indicates whether the issue is classified as a warning.                                     |
| severity\_info                                 | Boolean   | Indicates whether the issue is classified as informational.                                 |
| category\_invalid\_attribute                   | Boolean   | Indicates whether the issue relates to an invalid product attribute.                        |
| category\_missing\_attribute                   | Boolean   | Indicates whether the issue relates to a missing product attribute.                         |
| category\_invalid\_image                       | Boolean   | Indicates whether the issue relates to an invalid product image.                            |
| category\_missing\_image                       | Boolean   | Indicates whether the issue relates to a missing product image.                             |
| category\_invalid\_price                       | Boolean   | Indicates whether the issue relates to an invalid product price.                            |
| category\_missing\_price                       | Boolean   | Indicates whether the issue relates to a missing product price.                             |
| category\_duplicate                            | Boolean   | Indicates whether the issue is related to a duplicate listing or product.                   |
| category\_qualification\_required              | Boolean   | Indicates whether additional qualification or approval is required for the product.         |
| enforcement\_action\_listing\_suppressed       | Boolean   | Indicates whether the listing has been suppressed due to the identified issue.              |
| enforcement\_action\_attribute\_suppressed     | Boolean   | Indicates whether one or more product attributes have been suppressed.                      |
| enforcement\_action\_catalog\_item\_removed    | Boolean   | Indicates whether the product has been removed from the Amazon catalog.                     |
| enforcement\_action\_search\_suppressed        | Boolean   | Indicates whether the product has been suppressed from Amazon search results.               |
| exemption\_status\_exempt                      | Boolean   | Indicates whether the product or issue is currently exempt from the applicable requirement. |
| exemption\_status\_exempt\_until\_expiry\_date | Boolean   | Indicates whether the exemption remains valid until the specified expiry date.              |
| exemption\_status\_not\_exempt                 | Boolean   | Indicates whether the product or issue is not exempt from the applicable requirement.       |
| exemption\_expiry\_date                        | DateTime  | Date and time when the applicable exemption expires.                                        |
| download\_date                                 | Date      | Date on which the data was downloaded.                                                      |

### **Listings Item Issues Change**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_issues\_change

| Column Name      | Data type | Description                                                                            |
| ---------------- | --------- | -------------------------------------------------------------------------------------- |
| account\_name    | String    | Display name of the Intentwise account.                                                |
| account\_id      | Integer   | Unique Intentwise account ID.                                                          |
| event\_id        | String    | Unique identifier of the event generated by Amazon.                                    |
| seller\_id       | String    | Unique identifier of the seller.                                                       |
| marketplace\_id  | String    | Amazon marketplace identifier associated with the event.                               |
| asin             | String    | Amazon Standard Identification Number (ASIN) of the product associated with the event. |
| sku              | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.                       |
| payload\_version | String    | Version of the event payload schema used by Amazon.                                    |
| publish\_time    | DateTime  | Date and time when the event was published by Amazon.                                  |
| created\_date    | Date      | Date on which the event record was created.                                            |
| created\_at      | DateTime  | Timestamp indicating when the event record was created in the system.                  |
| vendor\_code     | String    | Unique code identifying the vendor associated with the event.                          |

### **Listings Item Issues Change Detail**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_issues\_change\_detail

| Column Name   | Data type | Description                                                                 |
| ------------- | --------- | --------------------------------------------------------------------------- |
| account\_name | String    | Display name of the Intentwise account.                                     |
| account\_id   | Integer   | Unique Intentwise account ID.                                               |
| event\_id     | String    | Unique identifier of the event generated by Amazon.                         |
| type          | String    | Type of event associated with the notification.                             |
| kind          | String    | Classification or category of the event indicating the specific event type. |
| created\_date | Date      | Date on which the event record was created.                                 |
| created\_at   | DateTime  | Timestamp indicating when the event record was created in the system.       |

### **Listings Item Issues Events (Deprecated)**

**Use - amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_issues as substitute

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_issues\_events

| Column Name                                    | Data type | Description                                                                           |
| ---------------------------------------------- | --------- | ------------------------------------------------------------------------------------- |
| account\_name                                  | String    | Display name of the Intentwise account.                                               |
| account\_id                                    | Integer   | Unique Intentwise account ID.                                                         |
| seller\_id                                     | String    | Unique identifier of the seller.                                                      |
| sku                                            | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.                      |
| marketplace\_id                                | String    | Amazon marketplace identifier associated with the listing issue.                      |
| issue\_code                                    | String    | Unique code identifying the listing issue reported by Amazon.                         |
| issue\_message                                 | String    | Description of the listing issue or problem identified by Amazon.                     |
| attribute\_names                               | String    | Names of the product attributes associated with the identified issue.                 |
| severity\_error                                | Boolean   | Indicates whether the issue is classified as an error.                                |
| severity\_warning                              | Boolean   | Indicates whether the issue is classified as a warning.                               |
| severity\_info                                 | Boolean   | Indicates whether the issue is classified as informational.                           |
| category\_invalid\_attribute                   | Boolean   | Indicates whether the issue relates to an invalid product attribute.                  |
| category\_missing\_attribute                   | Boolean   | Indicates whether the issue relates to a missing product attribute.                   |
| category\_invalid\_image                       | Boolean   | Indicates whether the issue relates to an invalid product image.                      |
| category\_missing\_image                       | Boolean   | Indicates whether the issue relates to a missing product image.                       |
| category\_invalid\_price                       | Boolean   | Indicates whether the issue relates to an invalid product price.                      |
| category\_missing\_price                       | Boolean   | Indicates whether the issue relates to a missing product price.                       |
| category\_duplicate                            | Boolean   | Indicates whether the issue is related to a duplicate listing or product.             |
| category\_qualification\_required              | Boolean   | Indicates whether additional qualification or approval is required for the product.   |
| enforcement\_action\_listing\_suppressed       | Boolean   | Indicates whether the listing has been suppressed due to the identified issue.        |
| enforcement\_action\_attribute\_suppressed     | Boolean   | Indicates whether one or more product attributes have been suppressed.                |
| enforcement\_action\_catalog\_item\_removed    | Boolean   | Indicates whether the product has been removed from the Amazon catalog.               |
| enforcement\_action\_search\_suppressed        | Boolean   | Indicates whether the product has been suppressed from Amazon search results.         |
| exemption\_status\_exempt                      | Boolean   | Indicates whether the product or issue is exempt from the applicable requirement.     |
| exemption\_status\_exempt\_until\_expiry\_date | Boolean   | Indicates whether the exemption remains valid until the specified expiry date.        |
| exemption\_status\_not\_exempt                 | Boolean   | Indicates whether the product or issue is not exempt from the applicable requirement. |
| exemption\_expiry\_date                        | DateTime  | Date and time when the applicable exemption expires.                                  |
| download\_date                                 | Date      | Date on which the data was downloaded.                                                |
| event\_id                                      | String    | Unique identifier of the event associated with the listing issue.                     |

### **Listings Item Attributes**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_attributes

| Column Name       | Data type | Description                                                      |
| ----------------- | --------- | ---------------------------------------------------------------- |
| `account_name`    | String    | Display name of the Intentwise account.                          |
| `account_id`      | Integer   | Unique Intentwise account ID.                                    |
| `seller_id`       | String    | Unique identifier of the seller.                                 |
| `sku`             | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product. |
| `attribute_value` | String    | Value of the product attribute associated with the SKU.          |
| `download_date`   | Date      | Date on which the data was downloaded.                           |

### **Listings Item Fulfillment Availability**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_listings\_item\_fulfillment\_availability

| Column Name     | Data type | Description                                                                 |
| --------------- | --------- | --------------------------------------------------------------------------- |
| `account_name`  | String    | Display name of the Intentwise account.                                     |
| `account_id`    | Integer   | Unique Intentwise account ID.                                               |
| `seller_id`     | String    | Unique identifier of the seller.                                            |
| `sku`           | String    | Seller-defined Stock Keeping Unit (SKU) identifying the product.            |
| `channel_code`  | String    | Code identifying the sales or distribution channel associated with the SKU. |
| `quantity`      | Integer   | Quantity associated with the SKU for the specified channel.                 |
| `download_date` | Date      | Date on which the data was downloaded.                                      |
