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)
Index
- General information
- Product description
- Media
- Offer / price
- Product variations
- Technical characteristics
- Product’s measurements
- Parcel / Package
1. General Information
| Selector | Description |
| asin | Amazon Standard Identification Number (ASIN) |
| title | Product name |
| url | Product URL |
| brand_name | Product’s brand |
| manufacturer | Manufacturer’s name |
| model | Item model number |
| country_of_origin | Product’s country origin |
| categories | All the categories the product fits in (as seen in the breadcrumb) |
| categories_links | URLs of the categories the product fits in |
| best_seller_main_category | Best seller rank category |
| best_seller_main_rank | Best seller rank |
| rating | Average rating |
| times_evaluated | Number of reviews |
2. Product description
| Selector | Description |
| a_plus_content | Manufacturer’s product description |
| bullet_point_X | Bullet point X in product’s description (replace X by your chosen number) |
| bullet_points | Product’s description bullet points |
| description | Product description |
3. Media
| Selector | Description |
| featured_image_source | Product’s featured image |
| image_X_source | Product’s images (replace x by your choosen number) |
| other_images_sources | All the product’s images |
| has_video | Does the amazon page have a video (true or false) |
4. Offer / price
| Selector | Description |
| availability | Available quantity in Stock |
| list_price | Manufacturer Suggested Retail Price |
| sale_price | Sale price of the product |
| sale_price_per_unit | Unit sale price of the product |
| buybox_quantity_max | Maximum selectable quantity |
| buybox_winner | Buybox seller |
| buybox_winner_link | URL of the Buybox seller page |
| vendors_names* | Alternative sellers* |
| vendors_prices* | Prices of the alternative sellers* |
| vendors_links* | URL of the alternative sellers pages* |
* when you use the selectors vendors_names / vendors_prices / vendors_links, 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
| Selector | Description |
| current_variation_headers | Headers of all the possible variations |
| variation_X_name | Name of variation x |
| variation_X_child_images_source | All images of the selected variation (replace x by your chosen number) |
| variation_X_asins | All ASINs of the selected variation (replace x by your chosen number) |
| variation_X_child_texts | All values of the selected variation (replace x by your chosen number) |
| variation_X_child_Y_text | Value y in variation x |
| variation_X_child_Y_asin | ASIN of product y in variation x |
| variation_X_child_Y_image_source | Image of product y in variation x |
| current_variation_values | Selected variations values |
6. Technical characteristics
| Selector | Description |
| feature_headers | Product featured characteristics headers |
| feature_values | Product featured characteristics values |
| details_headers | Product characteristics headers |
| details_values | Product characteristics values |
| capacity | Product capacity |
| color_name | Product color |
| style_name | Product style |
| Has_climate_pledge_friendly_badge | Does the amazon product have a climate pledge friendly certification (true or false) |
7. Product’s measurements
| Selector | Description |
| item_dimensions_unit_of_measure | Unit of measure used for the dimensions of the product |
| item_height | Product’s height |
| item_height_unit_of_measure | Unit of measure used for the height of the product |
| item_length | Product’s length |
| item_length_unit_of_measure | Unit of measure used for the length of the product |
| item_weight | Product’s weight |
| item_weight_unit_of_measure | Unit of measure used for the weight of the product |
| item_width | Product’s width |
| item_width_unit_of_measure | Unit of measure used for the width of the product |
8. Parcel / Package
| Selector | Description |
| package_dimensions_unit_of_measure | Package’s dimension unit of measure (cm, inch) |
| package_height | Package’s height |
| package_length | Package’s length |
| package_weight | Package’s weight |
| package_weight_unit_of_measure | Package’s weight unit of measure (grams, pounds) |
| package_width | Package’s width |