Want to extract Walmart product pages straight into your spreadsheet?
You can see below the selectors to use within your =IMPORTFROMWEB() function; just pick them up and write your function as follows:
=IMPORTFROMWEB("Walmart product URL", "title, price")
=IMPORTFROMWEB(A2,B1:C1)
Product selectors
Selector | Description |
---|---|
upc | Universal Product Code |
title | Product name |
brand | Product brand |
brand_link | Link to the brand page of the product |
buybox_winner | Seller who gets the buybox |
price* | Product price |
ratings | Average rating |
reviews_count | Number of reviews |
category_N** | Category of the product (replace N by the desired value) |
categories | All product categories (make sure to leave empty cells below) |
featured_image_source | Collects the main image source for each product listed |
availability | Availability of the product |
imageN_source | Image of the product page (replace N by the image number) |
images_source | All the images of the product page (make sure to leave empty cells below) |
*Pricing information: Prices, terms, and availability may vary according to the region. Items sold online by Walmart may be eligible for price match, while items sold by Marketplace Sellers are not eligible for price match. Therefore, as the server can be located elsewhere than where you are, the price may be different.
**The categories of the product are ranked from the 1st (Home) to the last one (up to 8).
Search page selectors
Selector | Description |
---|---|
name | Collects each product name |
price | Collects each product price |
price_text | Collects the value together with the currency |
rating | Collects average rating for each product listed |
reviews_count | Collects number of reviews collected for each product listed |
link | Collects the URL of each product listed |
image_source | Collects the main image source for each product listed |
id | Collects the product id |
us_item_id | Collects the product US id |
availability | Indicates whether the product is available or not |
badge | Extracts the badge of the product |
sponsored | Indicates whether the product is sponsored or not |