> ## Content Index > Fetch the complete content index at: https://serpapi.com/blog/llms.txt > Use this file to discover other available public pages before exploring further. # Scraping Product Details from Walmart, Home Depot and Google Shopping with SerpApi - URL: https://serpapi.com/blog/scraping-product-details-from-walmart-home-depot-and-google-shopping-with-serpapi/ - Published: 2023-02-27T18:28:45.000Z - Updated: 2025-10-01T04:36:23.000Z - Description: Understanding the link between search results and product pages. - Author: Ryan Schafer - Tags: Tips&Tricks, serpapi, Google Product, Google Shopping, Walmart, The Home Depot, Use Cases, api ## Intro SerpApi streamlines the process of scraping search results pages. A common use case is scraping product info from Google, HomeDepot, and/or Walmart. While still much simpler than manually scraping these sites yourself, getting product details is slightly less straightforward than some of the other data you can scrape with SerpApi. For example, look at this Google Shopping API search example in the [SerpApi Playground](https://serpapi.com/playground?engine=google%5Fshopping&q=Big+Mouth+Billy+Bass): ![](https://lh4.googleusercontent.com/_xfuDzweK7YWDLdMSU4MFNtPAsnb_IX3E277VVlAU5F2-1VJnybKKXWufR9Ykyapczlo8MMzsucmG4gkSOtXjRHSkpyahIzmbMtH6DLSHik56_GYlV7lN6Nm537lKnW9A5JDTUnjefFgfTKrNNpv4zA) You can see there is some information available here about each product. But how do we get reviews, ratings, buying options, and sellers? If you were searching in your browser, you could click on the product to expand it, then click “View product details” to get more information. But how can we do this with SerpApi, since we need to be able to do it programmatically? ## Google Shopping API and Google Product API If you go back to the [Playground](https://serpapi.com/playground?engine=google%5Fshopping&q=Big+Mouth+Billy+Bass) and click the dropdown in the top left corner, you will see that in addition to the[ Google Shopping API](https://serpapi.com/playground?engine=google%5Fshopping&q=Big+Mouth+Billy+Bass), we also have a [Google Product API](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=4887235756540435899&gl=us&hl=en): > Google Product API is discontinued Previously, the product information was available on the Google Product API, which is what we use for the rest of this article. Unfortunately, Google seems to have discontinued this endpoint. So, we can use the Google Immersive Product API as the replacement. Here is the new blog post on [scraping product details from Google Shopping](https://serpapi.com/blog/scrape-product-detail-information-from-google-shopping/). [![](https://lh3.googleusercontent.com/H0-9PjTlGZ41opm63Sqeegal8KksZRHpdXGx5_ZFauYEnQlFwkO7RvfPdcVf_AiYBGN1CEZXaQpX2QgjwPajdwJsmwF-5GwnYKX7oZG16fbyzNUIx00ctK6MzTTCWa5-68jAQJsDWrBm5CtXuHJMKBs)](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=4887235756540435899&gl=us&hl=en) However, if you select the [Google Product API](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=4887235756540435899&gl=us&hl=en) in the [Playground](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=4887235756540435899&gl=us&hl=en), you will notice that the only way to search is with something called a **`product_id`.** If you go back to the Google Shopping API example and click on one of the products to select it, then look over at the selected part of the JSON response, you will notice there is a key named **`product_id`**: ![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/Screenshot-from-2023-02-27-10-13-35.png) This is what we need in order to [find the item with the Product API](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=5343671454698368249&gl=us&hl=en): [![](https://lh6.googleusercontent.com/1QehVlpPs1XMlIwi-Lg_m6ndHhX1zq8jGZDdeJ5hEm5h6UN8jqrZAN-yTavWK0u7_9Rymdr_tElrloB659PIqREIbTUCBNz-crpCICS-6OXRTAfiSvoiOMgjonA_Kqt1KVP6u86oDxsSrVqmFzETM_I)](https://serpapi.com/playground?engine=google%5Fproduct&product%5Fid=5343671454698368249&gl=us&hl=en) ## Home Depot API The process for scraping product details from Home Depot is almost identical to the one for scraping them from Google. First we have to use the [Home Depot Search API](https://serpapi.com/playground?engine=home%5Fdepot&q=Fishing+Pole) to find the product and get the **`product_id`**. [![](https://lh3.googleusercontent.com/kAgHbXphVEmIru5503O34BYqZ42g3bTcTOMmSsolY6NxfSXi0xwloTHYI4QaBIIZyCWqitH59NXlG-eMcb4RNpD-xTbJdmOIGYoA1L7hPl-JR_yc-PJP9rJU5VD0kVHpIwB5gGJys1qD6hfSU6BX1xQ)](https://serpapi.com/playground?engine=home%5Fdepot&q=Fishing+Pole) Then we can search the [Home Depot Product API](https://serpapi.com/playground?engine=home%5Fdepot%5Fproduct&product%5Fid=313326839 ) with the **`product_id`:** [![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/image-15.png)](https://serpapi.com/playground?engine=walmart%5Fproduct%5Freviews&product%5Fid=110950227) ## Walmart API There are a few differences when scraping product details from the Walmart API. While product results in a Walmart search do have a **`product_id`,** they also have a **`us_item_id`.** We need to use the **`us_item_id`** if we want the results to include Reviews. First with the [Walmart Search API](https://serpapi.com/playground?engine=walmart&query=crock+pot ) to get the **`product_id`** and the **`us_item_id`**: [![](https://lh4.googleusercontent.com/Fe6SxRKotiapYSgwH3rWc-oSpUxnLNt9zcCV8nEIPGh4_JLMfh665DaSgYuVmh20jsY5xLNbVPya8ESjH6_2IhJ98B4sCUjiL2xzrKlf_mwI3qDEkBE1FW_raEo-BilsQPVmLYXXFi-I-oa7iMU5TEs)](https://serpapi.com/playground?engine=walmart&query=crock+pot ) We can then get the product page with the [Product APIusing the **product\_id**](https://serpapi.com/playground?engine=walmart%5Fproduct&product%5Fid=7J80Z4XN3RDT )**,** but there won’t be any reviews**:** [![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/image-11.png)](https://serpapi.com/playground?engine=walmart%5Fproduct&product%5Fid=7J80Z4XN3RDT ) So if we want the reviews we need to use the **`us_item_id`.** Don't be confused by the name of the parameter, it says **`product_id`** but we can set it's value to the **`us_item_id`**: [![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/image-12.png)](https://serpapi.com/playground?engine=walmart%5Fproduct&product%5Fid=110950227) If you scroll down, you can see there are reviews: ![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/image-13.png) We also have a [separate API](https://serpapi.com/playground?engine=walmart%5Fproduct%5Freviews&product%5Fid=110950227 ) for getting [Walmart Product Reviews](https://serpapi.com/playground?engine=walmart%5Fproduct%5Freviews&product%5Fid=110950227 ). This API also requires the **`us_item_id`** to be supplied as the value of the **`product_id`** parameter**:** [![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/02/image-14.png)](https://serpapi.com/playground?engine=walmart%5Fproduct%5Freviews&product%5Fid=110950227) ## Conclusion We have seen how to get product details from Google, Home Depot, and Walmart using SerpApi. I hope you found the tutorial informative and easy to follow. If you have any questions, feel free to contact me at ryan@serpapi.com. ## Links - [Google Shopping API](https://serpapi.com/google-shopping-api) - [Google Product API](https://serpapi.com/google-product-api) - [Home Depot Search API](https://serpapi.com/home-depot-search-api) - [Home Depot Product API](https://serpapi.com/home-depot-product) - [Walmart Search API](https://serpapi.com/walmart-search-api) - [Walmart Product API](https://serpapi.com/walmart-product-api) - [Walmart Product Reviews API ](https://serpapi.com/walmart-product-reviews-api) ###