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 |
|---|---|---|---|---|
| marketplace | marketplace | standard across multiple datasets | FALSE | |
| start_date | start_date | standard across multiple datasets | FALSE | |
| end_date | end_date | standard across multiple datasets | FALSE | |
| parent_asin | parent_asin | asin_metadata | FALSE | |
| asin | asin | standard across multiple datasets | FALSE | |
| is_available | is_available | asin_metadata | FALSE | |
| brand | brand | asin_metadata | FALSE | |
| title | title | asin_metadata | FALSE | |
| image_url_hero | image_urls | asin_metadata | TRUE | The first image displayed for the variant ASIN on its product page |
| buybox_price_median | buybox_price_median | asin_metadata | FALSE | |
| buybox_price_mode | buybox_price_mode | asin_metadata | FALSE | |
| list_price_median | list_price_median | asin_metadata | FALSE | |
| average_rating | parent_rating_average | sales_estimates | FALSE | |
| parent_rating_count | parent_rating_count | asin_metadata | FALSE | |
| breadcrumb_path_category_ids | breadcrumb_path_category_ids | asin_metadata | FALSE | |
| category_ranks | category_ranks | asin_metadata | FALSE | |
| first_date_available | first_date_available | asin_metadata | FALSE | |
| revenue | revenue | sales_estimates | FALSE | |
| revenue_1p | revenue_1p | sales_estimates | FALSE | |
| revenue_3p | revenue_3p | sales_estimates | FALSE | |
| sales | sales | sales_estimates | FALSE | |
| sales_1p | sales_1p | sales_estimates | FALSE | |
| sales_3p | sales_3p | sales_estimates | FALSE | |
| dominant_seller_id | dominant_seller_id | asin_metadata | FALSE | |
| discounts | discounts | asin_metadata | FALSE | |
| fee_breakdown | fee_breakdown | asin_metadata | FALSE | |
| fees | fees | asin_metadata | FALSE | |
| 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. |
| 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. |
| image_urls | image_urls | asin_metadata | FALSE | |
| unit_count | unit_count | asin_metadata | FALSE | |
| unit_count_measure | unit_count_measure | asin_metadata | FALSE | |
| variation_theme_attributes | variation_theme_attributes | asin_metadata | FALSE | |
| product_type | product_type | asin_metadata | FALSE | |
| country_of_origin | country_of_origin | asin_metadata | FALSE | |
| fsa_hsa_eligible | fsa_hsa_eligible | asin_metadata | FALSE | |
| sustainability | sustainability | asin_metadata | FALSE | |
| upcs | upcs | asin_metadata | FALSE | |
| gtins | gtins | asin_metadata | FALSE | |
| eans | eans | asin_metadata | FALSE | |
| part_number | part_number | asin_metadata | FALSE | |
| feature_bullets | feature_bullets | asin_descriptors | FALSE | |
| num_packs | TRUE | |||
| items_per_pack | TRUE | |||
| total_items | TRUE | |||
| item_display_dimensions | TRUE | |||
| color_raw | TRUE | |||
| color_normalized | TRUE | |||
| size_raw | TRUE | |||
| size_normalized | TRUE | |||
| style_raw | TRUE | |||
| style_normalized | TRUE | |||
| special_size_type_raw | TRUE | |||
| special_size_type | TRUE | |||
| pattern_raw | TRUE | |||
| pattern_normalized | TRUE | |||
| flavor_raw | TRUE | |||
| flavor_normalized | TRUE | |||
| material_raw | TRUE | |||
| material_normalized | TRUE | |||
| metal_type_raw | TRUE | |||
| metal_type_normalized | TRUE | |||
| scent_raw | TRUE | |||
| scent_normalized | TRUE | |||
| fit_type_raw | TRUE | |||
| fit_type_normalized | TRUE | |||
| ingredients_raw | TRUE | |||
| ingredients_normalized | TRUE | |||
| item_form_raw | TRUE | |||
| item_form_normalized | TRUE | |||
| 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. |
| 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. |