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

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

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