Use this page to map your existing ingestion logic from Sales Estimates, ASIN Metadata, and ASIN Descriptors to the new Product Sales and Attributes dataset. Because Product Sales and Attributes consolidates these three legacy datasets into a single variant-level table, some fields carry forward unchanged, some have been renamed or expanded, and some are net new. The mapping below is intended to help you identify the correct replacement field for each legacy field in your pipeline, understand which prior dataset it came from, and flag any changes that may require updates to downstream transformations, joins, or business logic. Where relevant, the notes column also calls out important differences in field behavior, structure, or availability.

New Dataset Fields Replaced Field Associated Previous Dataset Is New or Modified? Notes For Snowflake Clients: New Dataset
marketplace marketplace standard across multiple datasets FALSE standard across multiple datasets
start_date start_date standard across multiple datasets FALSE Product Sales and Attributes
end_date end_date standard across multiple datasets FALSE Product Sales and Attributes
parent_asin parent_asin asin_metadata FALSE standard across multiple datasets
asin asin standard across multiple datasets FALSE standard across multiple datasets
is_available is_available asin_metadata FALSE Product Sales and Attributes
brand brand asin_metadata FALSE Product Sales and Attributes
title title asin_metadata FALSE standard across multiple datasets
image_url_hero image_urls asin_metadata TRUE The first image displayed for the variant ASIN on its product page Product Sales and Attributes
buybox_price_median buybox_price_median asin_metadata FALSE Product Sales and Attributes
buybox_price_mode buybox_price_mode asin_metadata FALSE Product Sales and Attributes
list_price_median list_price_median asin_metadata FALSE Product Sales and Attributes
parent_average_rating parent_rating_average sales_estimates FALSE Product Sales and Attributes
parent_rating_count parent_rating_count asin_metadata FALSE Product Sales and Attributes
breadcrumb_path_category_ids breadcrumb_path_category_ids asin_metadata FALSE Product Sales and Attributes
category_ranks category_ranks asin_metadata FALSE Product Sales and Attributes
first_date_available first_date_available asin_metadata FALSE Product Sales and Attributes
revenue revenue sales_estimates FALSE Product Sales and Attributes
revenue_1p revenue_1p sales_estimates FALSE Product Sales and Attributes
revenue_3p revenue_3p sales_estimates FALSE Product Sales and Attributes
sales sales sales_estimates FALSE Product Sales and Attributes
sales_1p sales_1p sales_estimates FALSE Product Sales and Attributes
sales_3p sales_3p sales_estimates FALSE Product Sales and Attributes
dominant_seller_id dominant_seller_id asin_metadata FALSE Product Sales and Attributes
discounts discounts asin_metadata FALSE Product Sales and Attributes
fee_breakdown fee_breakdown asin_metadata FALSE Product Sales and Attributes
fees fees asin_metadata FALSE Product Sales and Attributes
sellers sellers asin_metadata TRUE This field previously existed in the Sales Estimates and ASIN Metadata dataset, but it now contains additional fields for each seller: seller name, is_featured_merchant, ships_from_country, shipping_median_price. Product Sales and Attributes
Description Description asin_descriptors FALSE This field was previously in the asin_descriptors dataset and will now be included with the Product Sales and Attributes dataset. ASIN Descriptors
image_urls image_urls asin_metadata FALSE ASIN Descriptors
unit_count unit_count asin_metadata FALSE ASIN Descriptors
unit_count_measure unit_count_measure asin_metadata FALSE ASIN Descriptors
variation_theme_attributes variation_theme_attributes asin_metadata FALSE ASIN Descriptors
product_type product_type asin_metadata FALSE ASIN Descriptors
country_of_origin country_of_origin asin_metadata FALSE ASIN Descriptors
fsa_hsa_eligible fsa_hsa_eligible asin_metadata FALSE ASIN Descriptors
sustainability sustainability asin_metadata FALSE ASIN Descriptors
upcs upcs asin_metadata FALSE ASIN Descriptors
gtins gtins asin_metadata FALSE ASIN Descriptors
eans eans asin_metadata FALSE ASIN Descriptors
part_number part_number asin_metadata FALSE ASIN Descriptors
feature_bullets feature_bullets asin_descriptors FALSE ASIN Descriptors
num_packs TRUE ASIN Descriptors
items_per_pack TRUE ASIN Descriptors
total_items TRUE ASIN Descriptors
item_display_dimensions TRUE ASIN Descriptors
color_raw TRUE ASIN Descriptors
color_normalized TRUE ASIN Descriptors
size_raw TRUE ASIN Descriptors
size_normalized TRUE ASIN Descriptors
style_raw TRUE ASIN Descriptors
style_normalized TRUE ASIN Descriptors
special_size_type_raw TRUE ASIN Descriptors
special_size_type TRUE ASIN Descriptors
pattern_raw TRUE ASIN Descriptors
pattern_normalized TRUE ASIN Descriptors
flavor_raw TRUE ASIN Descriptors
flavor_normalized TRUE ASIN Descriptors
material_raw TRUE ASIN Descriptors
material_normalized TRUE ASIN Descriptors
metal_type_raw TRUE ASIN Descriptors
metal_type_normalized TRUE ASIN Descriptors
scent_raw TRUE ASIN Descriptors
scent_normalized TRUE ASIN Descriptors
fit_type_raw TRUE ASIN Descriptors
fit_type_normalized TRUE ASIN Descriptors
ingredients_raw TRUE ASIN Descriptors
ingredients_normalized TRUE ASIN Descriptors
item_form_raw TRUE ASIN Descriptors
item_form_normalized TRUE ASIN Descriptors
Attributes Attributes asin_descriptors FALSE This field will always contain the new raw attribute values, in addition to many other attributes that are not regularly present across ASINs. ASIN Descriptors
No new equivalent variant_rating_count asin_metadata TRUE Jungle Scout is not able to deliver this anymore.
No new equivalent variant_review_count asin_metadata TRUE Jungle Scout is not able to deliver this anymore.
No new equivalent average_rating asin_metadata TRUE Jungle Scout is not able to deliver this anymore.