Amazon selectors (product page)

Want to extract Amazon product data straight into your spreadsheet?

You can see below the exhaustive list of selectors designed for any Amazon product page. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our Amazon scraper template or use them by yourself in your own spreadsheet.

=IMPORTFROMWEB("url", "name, rating")
=IMPORTFROMWEB(A2,B1:C1)

Please note that ImportFromWeb works with most of Amazon markets, including US (.com), Canada (.ca), Mexico (.com.mx), Brazil (.com.br), UK (.co.uk), France (.fr), Germany(.de), Netherlands (.nl), Spain (.es), Italy (.it), Turkey (.com.tr), India (.in), Saudi Arabia (.sa), UAE (.ae), Japan (.jp), Australia (com.au), Singapore (.sg)

Index 

  1. General information
  2. Product description
  3. Media
  4. Offer / price
  5. Product variations
  6. Technical characteristics 
  7. Product’s measurements 
  8. Parcel / Package

1. General Information

Selector Description
asinAmazon Standard Identification Number (ASIN)
titleProduct name
urlProduct URL
brand_nameProduct’s brand
manufacturerManufacturer’s name
modelItem model number (for Amazon English markets only)
country_of_originProduct’s country origin
categoriesAll the categories the product fits in (as seen in the breadcrumb)
categories_linksURLs of the categories the product fits in
best_seller_rank_1Best seller rank from the top category
best_seller_category_1Best seller category from the top category
best_seller_link_1Best seller link from the top category
best_seller_rank_2Best seller rank from the 2nd category
best_seller_category_2Best seller category from the 2nd category
best_seller_link_2Best seller link from the 2nd category
best_seller_rank_3Best seller rank from the 3d category
best_seller_category_3Best seller category from the 3d category
best_seller_link_3Best seller link from the 3d category
ratingAverage rating
rating_percentage_x_stars% of x-star ratings (where x= 1,2,3,4 or 5)
reviews_countNumber of reviews

2. Product description

SelectorDescription
a_plus_contentManufacturer’s product description (text only)
a_plus_content_imagesManufacturer’s product description (images only)
bullet_point_XBullet point X in product’s description (replace X by your chosen number)
bullet_pointsProduct’s description bullet points
descriptionProduct description (plaintext)

3. Media

SelectorDescription
featured_image_sourceProduct’s featured image. This selector can be combined with the function =IMAGE(link) which will allow you to visualize the image on google sheet
image_X_sourceProduct’s images (replace x by your choosen image position)
has_videoIndicates whether the product has a video or not (true or false)

4. Offer / price

SelectorDescription
availabilityIndicates whether the product is available or not (+ the available quantity when specified)
list_priceManufacturer Suggested Retail Price (list_price_currency to get the currency only & list_price_text to get the value together with the currency)
sale_priceSale price of the product (sale_price_currency to get the currency only & sale_price_text to get the value together with the currency)
sale_price_per_unitUnit sale price of the product
has_couponIndicates whether the product has a coupon or not (true or false)
coupon_discountCoupon value
has_dealIndicates whether the product has a current deal or not (true or false)
buybox_quantity_maxMaximum selectable quantity
buybox_winnerSeller who gets the buybox
buybox_winner_linkURL of the Buybox seller page
ships_fromIndicates the product’s shipper
offers_countIndicates the number of offers for a given product (new and used)
normal_deliveryIndicates the standard delivery date
fastest_deliveryIndicates the fastest delivery date
sellers_names*Alternative sellers*
sellers_prices*Price of the alternative sellers*
sellers_links*URL of the alternative sellers pages*
sellers_offer_types*Type of offers of the alternative sellers (new, used…)

 * when you use the selectors sellers_*** selectors, the function opens a new pop up (same as when you click on the “see other vendors” link). As a consequence, those selectors cannot be combined with any other selector within the same function.

For example, the following is OK:

=IMPORTFROMWEB(url,"vendors_names,vendors_prices")

5. Product variations

SelectorDescription
current_variation_headersHeaders of all the possible variations
variations_asinsAll ASINs related to the current product
variation_X_nameName of variation x
variation_X_child_images_sourceAll images of the selected variation (replace x by your chosen number)
variation_X_asinsAll ASINs of the selected variation (replace x by your chosen number)
variation_X_child_textsAll values of the selected variation (replace x by your chosen number)
variation_X_child_Y_textValue y in variation x
variation_X_child_Y_asinASIN of product y in variation x
variation_X_child_Y_image_sourceImage of product y in variation x
current_variation_valuesSelected variations values

6. Technical characteristics

SelectorDescription
feature_headersProduct featured characteristics headers
feature_valuesProduct featured characteristics values
details_headersProduct characteristics headers
details_valuesProduct characteristics values
capacityProduct capacity
color_nameProduct color
style_nameProduct style (for Amazon English markets only)
Has_climate_pledge_friendly_badgeDoes the amazon product have a climate pledge friendly certification (true or false)

7. Product’s measurements

SelectorDescription
item_dimensions_unit_of_measureUnit of measure used for the dimensions of the product (for Amazon English markets only)
item_heightProduct’s height (for Amazon English markets only)
item_height_unit_of_measureUnit of measure used for the height of the product (for Amazon English markets only)
item_lengthProduct’s length (for Amazon English markets only)
item_length_unit_of_measureUnit of measure used for the length of the product (for Amazon English markets only)
item_weightProduct’s weight (for Amazon English markets only)
item_weight_unit_of_measureUnit of measure used for the weight of the product (for Amazon English markets only)
item_widthProduct’s width (for Amazon English markets only)
item_width_unit_of_measureUnit of measure used for the width of the product (for Amazon English markets only)

8. Parcel / Package

SelectorDescription
package_dimensions_unit_of_measurePackage’s dimension unit of measure (cm, inch) (for Amazon English markets only)
package_heightPackage’s height (for Amazon English markets only)
package_lengthPackage’s length (for Amazon English markets only)
package_weightPackage’s weight (for Amazon English markets only)
package_weight_unit_of_measurePackage’s weight unit of measure (grams, pounds) (for Amazon English markets only)
package_widthPackage’s width (for Amazon English markets only)