Amazon data 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)

You want to scrape in another language than English ? We made a special FAQ there.

1. General Information

SelectorDescription
asinAmazon Standard Identification Number (ASIN)
titleProduct name
urlProduct URL
brand_nameProduct’s brand
manufacturerManufacturer’s name
modelItem model number
release_dateWhen the product has been released on Amazon
country_of_originItem’s country origin
categoriesAll the categories the product fits in (as seen in the breadcrumb)
categories_linksURLs of the categories the product fits in
bought_in_past_monthnumber of units sold in past month
best_seller_rank_1Best Sellers Rank from the top category
best_seller_category_1Best Sellers category from the top category
best_seller_link_1Best sellers link from the top category
best_seller_rank_2Best Sellers Rank from the 2nd category
best_seller_category_2Best sellers category from the 2nd category
best_seller_link_2Best sellers link from the 2nd category
ratingAverage rating
rating_percentage_x_stars% of x-star ratings (where x= 1,2,3,4 or 5)
reviews_countNumber of reviews
part_numberPart Number of the product
box_contentContent of the box

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 (plain text)

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_sourceImages source URL (replace x by your choosen image position, up to 10 images)
has_videoIndicates whether the product has a video or not (true or false)
video_urlVideo source URL

4. Offer / price

SelectorDescription
availabilityIndicates whether the product is available or not (+ the available quantity when specified)
list_priceStrike-Through Price / Manufacturer 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 / BuyBox price
(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
prime_priceReturns the price of the product with an Amazon Prime account
badgeIndicates “best sellers”, “Amazon’s choice” and “Amazon exclusive” ASINs
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_quantity_minMinimum selectable quantity
buybox_winnerSeller who gets the buybox
buybox_winner_linkURL of the Buybox seller page
sns_sale_priceSubscribe and Save price
sns_buybox_winnerSubscribe and Save’s buy box winner
ships_fromIndicates the product’s shipper
shipping_costShipping price
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*Lists the first 12 sellers of the product including the buybox winner*
sellers_prices*Lists their prices including the buybox price*
sellers_links*URL of the first 12 sellers pages including the buybox winner*
sellers_offer_types*Type of offers for the first 12 sellers (new, used…) including the buybox winner

 * when you use the 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,"sellers_names,sellers_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)