Walmart
On walmart.com and walmart.ca, WebToSheets supports two page types:
product pages and search results, each with its own selectors.
lightbulb
There is no need to write any of this by hand. Open the sidebar's Formula
Builder, pick Walmart, choose Product or Search results, and fill in the rest.
Scraping a product page
From a product URL like walmart.com/ip/<product-id>, WebToSheets will pull one item's full details, right down to its rating, seller, and gtin.
Available selectors
| Field | Selector | Example value |
|---|---|---|
| Product name Product name |
name
|
Samsung 65-inch QLED 4K TV |
| Price Current price (numeric value only) |
price
|
1297.00 |
| Currency Currency code from the price |
currency
|
USD |
| Original price Original/strike-through price |
list_price
|
1499.99 |
| Brand Brand name |
brand
|
Samsung |
| Rating Average rating (out of 5) |
rating
|
4.8 |
| Number of reviews Number of reviews |
reviews_count
|
2341 |
| Availability Stock status (e.g. IN_STOCK) |
availability
|
In stock |
| Seller Seller of the main offer |
seller
|
Walmart.com |
| Image URL Product image URL. Use image/2 for the second image, etc. |
image
+ /N
|
https://i5.walmartimages… |
| Description Short product description |
description
|
Quantum Dot technology… |
| Category Product category |
category
|
Electronics › TV & Video |
| GTIN / UPC GTIN / UPC barcode |
gtin
|
0887276423452 |
| Item ID Walmart item ID |
product_id
|
5254334127 |
Example
Sometimes you only want to monitor a single product's price, rating, and stock. To do so, pass those selectors to =SCRAPE():
=SCRAPE("https://www.walmart.com/ip/5254334127", "name,price,rating,availability")A
B
C
D
1
|
Samsung 65-inch QLED 4K TV
1297.00
4.8
In stock
fx
Mapping search results
For a search page like walmart.com/search?q=..., every selector returns a
column of results (one page, around 15 items). If you would like a single row instead, add /N.
Available selectors
| Field | Selector | Example value |
|---|---|---|
| Product name Product names |
name
+ /N
|
Keurig K-Classic |
| Price Prices |
price
+ /N
|
79.00 |
| Currency Currency |
currency
+ /N
|
USD |
| Brand Brands |
brand
+ /N
|
Keurig |
| Product URL Product URLs |
link
+ /N
|
https://walmart.com/ip/… |
| Image URL Result image URLs |
image
+ /N
|
https://i5.walmartimages… |
| Rating Ratings |
rating
+ /N
|
4.5 |
| Number of reviews Review counts |
reviews_count
+ /N
|
1205 |
| Availability Stock status |
availability
+ /N
|
In stock |
| Seller Sellers |
seller
+ /N
|
Walmart.com |
| Item ID Walmart item IDs |
product_id
+ /N
|
123456789 |
| Badges Badges (e.g. Rollback, Best seller) |
badges
+ /N
|
Best Seller |
| Sponsored Whether the result is sponsored |
sponsored
+ /N
|
Sponsored |
Example
To map prices and sellers across an entire search, hand the relevant selectors to =SCRAPE():
=SCRAPE("https://www.walmart.com/search?q=coffee+maker", "name,price,seller")A
B
C
1
|
Cuisinart Stainless Steel 12-Cup Coffee Maker, Black
69.95
Walmart.com
2
Keurig K-Express Essentials Plus Single-Serve Coffee Maker, Black
69.00
Walmart.com
3
Hamilton Beach FlexBrew Single-Serve and 12-Cup Coffee Maker, Black
135.99
Hamilton Beach Brands Inc
4
Mainstays Black 12-Cup Drip Coffee Maker
16.88
Walmart.com
5
Mainstays 5-Cup Coffee Maker, Black
13.44
Walmart.com
6
Keurig K-Supreme Single-Serve K-Cup Pod Coffee Maker, Black
99.99
Walmart.com
7
Keurig K-Express Essentials Single-Serve Coffee Maker, Black
54.97
Walmart.com
8
Cuisinart Stainless Steel 14-Cup Coffee Machine, Silver
119.00
Walmart.com
9
Mainstays 12-Cup Programmable Drip Coffee Maker, Black
24.86
Walmart.com
10
Mainstays Dual Brew Single-Serve Coffee Maker, Black Matte
24.68
Walmart.com
11
Ninja 12-Cup Programmable Drip Coffee Maker, CE250, Black
64.97
Walmart.com
12
Hamilton Beach 2-Way Programmable Coffee Maker, Black
89.99
Hamilton Beach Brands Inc
13
Beautiful 12-Cup Programmable Coffee Maker by Drew Barrymore
54.96
Walmart.com
14
Keurig K-Duo Essentials Single-Serve and Carafe Coffee Maker, Black
124.00
Walmart.com
fx
Still stuck?
We usually reply within 24 hours on business days.