Known Seller IDs attributed to Amazon (Vendor/1P)

Table Definition

Name	Type	Note
marketplace	string	Amazon Marketplace 2 letter identifier
seller_id	string	Amazon merchant ID
seller_name	string	Seller business name
company_address	string	Seller Address (if available)
company_phone_number	string	Seller Phone number (if available)
company_email	string	Seller Email (if available)
brands	array<string>	array of brands held by seller
vat_id	string	VAT (Value Add Tax) ID
trade_number	string	Trade Register Number
business_type	string	Business Type - null if unavailable
business_representative	string	The name of the business representative
rating_count_30	bigint	Count of ratings during 30 days prior to last update
rating_count_90	bigint	Count of ratings during 90 days prior to last update
rating_count_365	bigint	Count of ratings during 365 days prior to last update
rating_count_lifetime	bigint	Count of lifetime ratings prior to last update
positive_rating_30	bigint	Count of positive (4 or 5 star) ratings during 30 days prior to last update
positive_rating_90	bigint	Count of positive (4 or 5 star) ratings during 90 days prior to last update
positive_rating_365	bigint	Count of positive (4 or 5 star) ratings during 365 days prior to last update
positive_rating_lifetime	bigint	Count of positive (4 or 5 star) ratings during lifetime prior to last update
negative_rating_30	bigint	Count of negative (1 or 2 star) ratings during 30 days prior to last update
negative_rating_90	bigint	Count of negative (1 or 2 star) ratings during 90 days prior to last update
negative_rating_365	bigint	Count of negative (1 or 2 star) ratings during 365 days prior to last update
negative_rating_lifetime	bigint	Count of negative (1 or 2 star) ratings during lifetime prior to last update
neutral_rating_30	bigint	Count of neutral (3 star) ratings during 30 days prior to last update
neutral_rating_90	bigint	Count of neutral (3 star) ratings during 90 days prior to last update
neutral_rating_365	bigint	Count of neutral (3 star) ratings during 365 days prior to last update
neutral_rating_lifetime	bigint	Count of neutral (3 star) ratings during lifetime prior to last update
ships_from_china	boolean	Boolean value indicating whether or not this seller ships from China
updated_at	date	date of last update
tracked_since	date	date of first known existence of seller_id
contact_email_address	string	Contact’s email address
contact_first_name	string	Contact’s first name
contact_last_name	string	Contact’s last name
contact_direct_phone_number	string	Contact’s direct phone number
contact_mobile_phone_number	string	Contact’s mobile phone number
contact_job_title	string	Latest known job title of contact
contact_linkedin_url	string	Contact’s LinkedIn URL
company_website	string	Parent Company’s website
company_country_code	string	Country in which the company's headquarters is located
current_rating	bigint	Current seller rating on a scale of 0-100