The Home Depot API
SerpApi's The Home Depot Search API provides real-time product information from The Home Depot US and Canada, allowing you to effortlessly gather data for e-commerce automation without in-depth web scraping knowledge.
The API supports both country-specific and common parameters for a flexible and customizable search experience.
For The Home Depot US, use parameters such as hd_sort, hd_filter_tokens, delivery_zip, store_id, nao, and ps.
For The Home Depot Canada, utilize parameters like store, sort, filter, minmax, and pagesize.
Common parameters applicable to both countries include q, country, and page.
Product results encompass essential information like title, brand, price, and product_id. Additional details like rating, reviews, price variations, and delivery options may also be available. Refine your search with filters and ordering/sorting options to tailor the results to your needs.
Explore the API playground for a live and interactive demo, and start harnessing the power of The Home Depot Search API for your e-commerce automation today.
API Parameters
Advanced Home Depot Parameters
hd_sort
Optional
Parameter defines results sorted by different options in Home Depot US.
It can be set to:top_sellers: Top Sellers,price_low_to_high: Price Low to High,price_high_to_low: Price High to Low,top_rated: Top Rated,best_match: Best Match
hd_filter_tokens
Optional
Used to pass filter tokens divided by comma. Filter tokens can be obtained from API response
store_id
Optional
Store ID to filter the products by the specific store only. See all Home Depot stores
store
Optional
Store ID to filter the products by the specific store only in Home Depot Canada. The default store is Gatineau (7140).
See all Home Depot Canada stores
sort
Optional
Parameter defines results sorted by different options in Home Depot Canada.
It can be set to:price-asc: Price Low to High,price-desc: Price High to Low,reviewAvgRating: Top Rated,relevance: Recommended (Default)
filter
Optional
Used to pass filter tokens divided by dash (-) in Home Depot Canada. Filter tokens can be obtained from API response
Price Limit
minmax
Optional
Defines lower and upper bound for price in CAD.
Parameter is only used in the Home Depot Canada.
Example: price:[100 TO 500](Between $100 to $500)
Example: price:[100 TO *](Minimum $100)
Example: price:[0 TO 500](Maximum $500)
Example: price:%5B100%20TO%20500%5D(Encoded version, Between $100 to $500)
Pagination
nao
Optional
Defines offset for products result. A single page contains 24 products. First page offset is 0, second -> 24, third -> 48 and so on.
page
Optional
Value is used to get the items on a specific page. (e.g., 1 (default) is the first page of results, 2 is the 2nd page of results, 3 is the 3rd page of results, etc.). This parameter is common for both US and CA searches.
Serpapi Parameters
no_cache
Optional
Parameter will force SerpApi to fetch the Home Depot results even if a cached version is already present. A cache is served only if the query and all parameters are exactly the same. Cache expires after 1h. Cached searches are free, and are not counted towards your searches per month. It can be set to false (default) to allow results from the cache, or true to disallow results from the cache. no_cache and async parameters should not be used together.
async
Optional
Parameter defines the way you want to submit your search to SerpApi. It can be set to false (default) to open an HTTP connection and keep it open until you got your search results, or true to just submit your search to SerpApi and retrieve them later. In this case, you'll need to use our Searches Archive API to retrieve your results. async and no_cache parameters should not be used together. async should not be used on accounts with Ludicrous Speed enabled.
zero_trace
Optional
Enterprise only. Parameter enables ZeroTrace mode. It can be set to false (default) or true. Enable this mode to skip storing search parameters, search files, and search metadata on our servers. This may make debugging more difficult.
API Results
JSON Results
JSON output includes structured data for products and more.
A search status is accessible through search_metadata.status. It flows this way: Processing -> Success || Error. If a search has failed, error will contain an error message. search_metadata.id is the search ID inside SerpApi.
HTML Results
This API does not have html response, just a text. search_metadata.prettify_html_file contains prettified version of result. It is displayed in playground.
API Examples
Example results for q: chair (the Home Depot US)
{
"search_metadata": {
"id": "6499df2331dccc6414aaf9ce",
"status": "Success",
"json_endpoint": "https://serpapi.com/searches/e130b36251ee6087/6499df2331dccc6414aaf9ce.json",
"created_at": "2023-06-26 18:55:31 UTC",
"processed_at": "2023-06-26 18:55:31 UTC",
"home_depot_url": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=0",
"raw_html_file": "https://serpapi.com/searches/e130b36251ee6087/6499df2331dccc6414aaf9ce.html",
"prettify_html_file": "https://serpapi.com/searches/e130b36251ee6087/6499df2331dccc6414aaf9ce.prettify",
"total_time_taken": 1.42
},
"search_parameters": {
"q": "chair",
"nao": "0",
"ps": 24,
"delivery_zip": "04401",
"store_id": "2414",
"engine": "home_depot"
},
"search_information": {
"results_state": "Results for exact spelling",
"total_results": 19495,
"store_id": "2414",
"store_name": "Bangor"
},
"taxonomy": [
{
"title": "Furniture",
"link": "https://www.homedepot.com/b/Furniture/N-5yc1vZc7pc/Ntk-elasticplus/Ntt-chair?NCNI-5"
}
],
"products": [
{
"position": 1,
"product_id": "304602833",
"title": "Lillith Navy Blue Mid Century Modern Chair",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_65.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_100.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_145.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_300.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_400.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_600.jpg",
"https://images.thdstatic.com/productImages/c70c272d-8fb5-4df7-8c53-85642593c60f/svn/navy-blue-lifestyle-solutions-accent-chairs-lk-lgfsp1gu3051-64_1000.jpg"
]
],
"link": "https://www.homedepot.com/p/Lifestyle-Solutions-Lillith-Navy-Blue-Mid-Century-Modern-Chair-LK-LGFSP1GU3051/304602833",
"serpapi_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot_product&product_id=304602833&store_id=2414",
"model_number": "LK-LGFSP1GU3051",
"brand": "Lifestyle Solutions",
"collection": "https://www.homedepot.com/collection/Home-Decor/Lifestyle-Solutions-Lillith-Collection-in-Navy-Blue/Family-317835866?omsid=304602833",
"variants": [
{
"title": "Navy Blue",
"link": "https://www.homedepot.com/p/Lifestyle-Solutions-Lillith-Navy-Blue-Mid-Century-Modern-Chair-LK-LGFSP1GU3051/304602833",
"thumbnail": "https://images.thdstatic.com/catalog/swatchImages/35/5f/5f4399ff-27e7-433c-af73-1171c8bfbcc3_35.jpg"
},
{
"title": "Heather Grey",
"link": "https://www.homedepot.com/p/Lifestyle-Solutions-Lillith-Heather-Grey-Mid-Century-Modern-Chair-LK-LGFSP1GU3073/304602841",
"thumbnail": "https://images.thdstatic.com/catalog/swatchImages/35/84/84b3f85d-5109-4d07-be97-f39267503168_35.jpg"
}
],
"favorite": 2419,
"rating": 4.393,
"reviews": 430,
"price": 224.63,
"price_was": 249.0,
"price_saving": 24.37,
"percentage_off": 10.0,
"price_badge": "Special-Buy",
"delivery": {
"free": true,
"free_delivery_threshold": false
},
"pickup": {
"free_ship_to_store": true
}
},
{
"position": 2,
"product_id": "304177386",
"title": "Beige Metal Stackable Folding Chairs",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_65.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_100.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_145.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_300.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_400.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_600.jpg",
"https://images.thdstatic.com/productImages/e7870b4a-02d0-456e-b673-df6d310fe11e/svn/beige-folding-chairs-sc004x001a-64_1000.jpg"
]
],
"link": "https://www.homedepot.com/p/Beige-Metal-Stackable-Folding-Chairs-SC004X001A/304177386",
"serpapi_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot_product&product_id=304177386&store_id=2414",
"model_number": "SC004X001A",
"collection": "https://www.homedepot.com",
"favorite": 618,
"rating": 4.7532,
"reviews": 1552,
"price": 13.98,
"price_was": 15.979999542236328,
"price_saving": 2.0,
"percentage_off": 13.0,
"price_badge": null,
"delivery": {
"schedule_delivery": true
},
"pickup": {
"quantity": 26,
"store_name": "Bangor",
"distance": 0
}
},
{
"position": 3,
"product_id": "204841281",
"title": "Plastic Seat Folding Chair in Black (Set of 4)",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_65.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_100.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_145.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_300.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_400.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_600.jpg",
"https://images.thdstatic.com/productImages/758a30d1-5ab6-4c57-b244-8a6dca9173e0/svn/black-hdx-folding-chairs-2ff004hdx-64_1000.jpg"
]
],
"link": "https://www.homedepot.com/p/HDX-Plastic-Seat-Folding-Chair-in-Black-Set-of-4-2FF004HDX/204841281",
"serpapi_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot_product&product_id=204841281&store_id=2414",
"model_number": "2FF004HDX",
"brand": "HDX",
"collection": "https://www.homedepot.com",
"favorite": 475,
"rating": 4.7079,
"reviews": 623,
"price": 148.97,
"unit": "package",
"badges": [
"exclusive"
],
"delivery": {
"free": true,
"free_delivery_threshold": false
},
"pickup": {
"free_ship_to_store": true
}
},
...
],
"filters": [
{
"key": "Review Rating",
"value": [
{
"name": "5",
"count": "3668",
"value": "bwo5q",
"link": "https://www.homedepot.com/b/Furniture/Best-Rated/N-5yc1vZc7pcZbwo5q/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "4 & Up",
"count": "8240",
"value": "bwo5o",
"link": "https://www.homedepot.com/b/Furniture/Highly-Rated/N-5yc1vZc7pcZbwo5o/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
...
]
},
{
"key": "Category",
"value": [
{
"name": "Living Room Furniture",
"count": "14068",
"value": "c7p3",
"link": "https://www.homedepot.com/b/Furniture-Living-Room-Furniture/N-5yc1vZc7p3/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "Kitchen & Dining Room Furniture",
"count": "9601",
"value": "c7ou",
"link": "https://www.homedepot.com/b/Furniture-Kitchen-Dining-Room-Furniture/N-5yc1vZc7ou/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
...
]
},
{
"key": "New Arrival",
"value": [
{
"name": "Recently Added",
"count": "2688",
"value": "1z179pc",
"link": "https://www.homedepot.com/b/Furniture/Recently-Added/N-5yc1vZc7pcZ1z179pc/Ntk-elasticplus/Ntt-chair?NCNI-5"
}
]
},
{
"key": "Get It Fast",
"value": [
{
"name": "Pick Up Today",
"count": "36",
"value": "1z175a5",
"link": "https://www.homedepot.com/b/Furniture/Pick-Up-Today/N-5yc1vZc7pcZ1z175a5/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "Next-Day Delivery",
"count": "36",
"value": "1z175cq",
"link": "https://www.homedepot.com/b/Furniture/Next-Day-Delivery/N-5yc1vZc7pcZ1z175cq/Ntk-elasticplus/Ntt-chair?NCNI-5"
}
]
},
{
"key": "Brand",
"value": [
{
"name": "Linon Home Decor",
"count": "406",
"value": "axi",
"link": "https://www.homedepot.com/b/Furniture/Linon-Home-Decor/N-5yc1vZc7pcZaxi/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "International Concepts",
"count": "556",
"value": "cws",
"link": "https://www.homedepot.com/b/Furniture/International-Concepts/N-5yc1vZc7pcZcws/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "Noble House",
"count": "1170",
"value": "mgr",
"link": "https://www.homedepot.com/b/Furniture/Noble-House/N-5yc1vZc7pcZmgr/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
...
]
},
{
"key": "Price",
"value": [
{
"name": "$0 - $10",
"count": "63",
"value": "12kx",
"link": "https://www.homedepot.com/b/Furniture/N-5yc1vZc7pcZ12kx/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "$10 - $20",
"count": "70",
"value": "12ky",
"link": "https://www.homedepot.com/b/Furniture/N-5yc1vZc7pcZ12ky/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
{
"name": "$20 - $30",
"count": "91",
"value": "12kz",
"link": "https://www.homedepot.com/b/Furniture/N-5yc1vZc7pcZ12kz/Ntk-elasticplus/Ntt-chair?NCNI-5"
},
...
]
},
],
"related_products": [
],
"pagination": {
"current": 1,
"next": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=24",
"other_pages": {
"2": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=24",
"3": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=48",
"4": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=72",
"5": "https://www.homedepot.com/b/N-5yc1v/Ntt-chair?Nao=96"
}
},
"serpapi_pagination": {
"current": 1,
"next_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=24&ps=24&q=chair&store_id=2414",
"next": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=24&ps=24&q=chair&store_id=2414",
"other_pages": {
"2": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=24&ps=24&q=chair&store_id=2414",
"3": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=48&ps=24&q=chair&store_id=2414",
"4": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=72&ps=24&q=chair&store_id=2414",
"5": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&nao=96&ps=24&q=chair&store_id=2414"
}
}
}
Example results for country: ca, and q: chair (the Home Depot Canada)
{
"search_metadata": {
"id": "6336f5b3e7d08a30abeca932",
"status": "Success",
"json_endpoint": "https://serpapi.com/searches/c0e7c5e2b11169ed/6336f5b3e7d08a30abeca932.json",
"created_at": "2022-09-30 13:57:07 UTC",
"processed_at": "2022-09-30 13:57:07 UTC",
"home_depot_url": "https://www.homedepot.ca/search?q=Chair&store=7140",
"raw_html_file": "https://serpapi.com/searches/c0e7c5e2b11169ed/6336f5b3e7d08a30abeca932.html",
"prettify_html_file": "https://serpapi.com/searches/c0e7c5e2b11169ed/6336f5b3e7d08a30abeca932.prettify",
"total_time_taken": 2.95
},
"search_parameters": {
"q": "Chair",
"country": "ca",
"store": "7140",
"engine": "home_depot"
},
"search_information": {
"results_state": "Results for exact spelling",
"total_results": 5785,
"store_id": "7140"
},
"taxonomy": [
{
"title": "Patio Dining Chairs",
"link": "https://www.homedepot.ca/search?q=chair&filter=wbe",
"thumbnail": "https://images.homedepot.ca/productimages/p_1001580444.jpg"
},
{
"title": "Dining Chairs",
"link": "https://www.homedepot.ca/search?q=chair&filter=wu2",
"thumbnail": "https://images.homedepot.ca/productimages/p_1001127375.jpg"
},
{
"title": "Office Chairs",
"link": "https://www.homedepot.ca/search?q=chair&filter=2n5",
"thumbnail": "https://images.homedepot.ca/productimages/p_1001699101.jpg"
},
...
],
"products": [
{
"position": 1,
"product_id": "1001580444",
"title": "Mix & Match Graphite Sling Stacking Patio Dining Chair",
"thumbnails": [
[
"https://images.homedepot.ca/productimages/p_1001580444.jpg?product-images=s",
"https://images.homedepot.ca/productimages/p_1001580444.jpg?product-images=m",
"https://images.homedepot.ca/productimages/p_1001580444.jpg?product-images=l"
]
],
"link": "https://www.homedepot.ca/product/stylewell-mix-match-graphite-sling-stacking-patio-dining-chair/1001580444",
"model_number": "FCS00015J-GRAN",
"brand": "StyleWell",
"base_product_code": "base-70002430-54-1001025293",
"variants": [
{
"title": "Dark Slate-Grey",
"type": "Seat / Cushion Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Dark_Slate-Grey.jpg",
"link": "https://www.homedepot.ca/product/stylewell-mix-match-graphite-sling-stacking-patio-dining-chair/1001580444",
"category_code": "vvc-cls_l5-diningchairs-attribute_id_ssku_seatcushioncolour-hdcn-11-dark-slate-grey"
},
{
"title": "Taupe",
"type": "Seat / Cushion Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Taupe.jpg",
"link": "https://www.homedepot.ca/product/stylewell-mix-match-riverbed-sling-stacking-patio-dining-chair/1001580445",
"category_code": "vvc-cls_l5-diningchairs-attribute_id_ssku_seatcushioncolour-hdwn-3-taupe"
},
{
"title": "Medium Dark Red",
"type": "Seat / Cushion Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Medium_Dark_Red.jpg",
"link": "https://www.homedepot.ca/product/stylewell-mix-match-conley-chili-sling-stacking-patio-dining-chair/1001580411",
"category_code": "vvc-cls_l5-diningchairs-attribute_id_ssku_seatcushioncolour-hd1-7-medium-dark-red"
}
],
"rating": 4.4981,
"reviews": 263,
"price": 16.98,
"currency": "CAD",
"aisle": "LC",
"pickup": {
"out_of_stock": true
},
"delivery": {
"not_available_for_delivery": true
},
"stock_information": {
"general_stock": 0,
"general_stock_status": "No Longer Available",
"store_stock": 0,
"store_stock_status": "Out Of Stock"
}
},
{
"position": 2,
"product_id": "1000757845",
"title": "Patio Leisure Line Recycled Plastic Folding Adirondack Chair - Grey",
"thumbnails": [
[
"https://images.homedepot.ca/productimages/p_1000757845.jpg?product-images=s",
"https://images.homedepot.ca/productimages/p_1000757845.jpg?product-images=m",
"https://images.homedepot.ca/productimages/p_1000757845.jpg?product-images=l"
]
],
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-grey/1000757845",
"model_number": "271151",
"brand": "Leisure Line",
"base_product_code": "base-70004042-6-1001541050",
"variants": [
{
"title": "Medium Dark Slate-Grey",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Medium_Dark_Slate-Grey.jpg",
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-grey/1000757845",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hdcn-10-medium-dark-slate-grey"
},
{
"title": "Black",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Black.jpg",
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-black/1001541050",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hdgs-5-black"
},
{
"title": "Red",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Red.jpg",
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-red/1000665058",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hd1-6-red"
},
{
"title": "White",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_White.jpg",
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-white/1001541049",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hdgs-1-white"
},
{
"title": "Dusk-Blue",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Dusk-Blue.jpg",
"link": "https://www.homedepot.ca/product/leisure-line-patio-leisure-line-recycled-plastic-folding-adirondack-chair-blue/1000665097",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hd18-6-dusk-blue"
}
],
"rating": 4.7778,
"reviews": 675,
"price": 179,
"currency": "CAD",
"aisle": "SS",
"add_to_cart": true,
"buy_online_pay_in_store": true,
"pickup": {
"out_of_stock": true
},
"delivery": {
"schedule_delivery": true
},
"check_nearby_stores": true,
"stock_information": {
"general_stock": 0,
"general_stock_status": "No Longer Available",
"store_stock": 0,
"store_stock_status": "Out Of Stock"
}
},
{
"position": 3,
"product_id": "1001030330",
"title": "Muskoka Contour Chair in Teal",
"thumbnails": [
[
"https://images.homedepot.ca/productimages/p_1001030330.jpg?product-images=s",
"https://images.homedepot.ca/productimages/p_1001030330.jpg?product-images=m",
"https://images.homedepot.ca/productimages/p_1001030330.jpg?product-images=l"
]
],
"link": "https://www.homedepot.ca/product/gracious-living-muskoka-contour-chair-in-teal/1001030330",
"model_number": "11626-20",
"brand": "Gracious Living",
"base_product_code": "base-70001274-11-1000862040",
"variants": [
{
"title": "Light Teal",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Light_Teal.jpg",
"link": "https://www.homedepot.ca/product/gracious-living-muskoka-contour-chair-in-teal/1001030330",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hd15b-6-light-teal"
},
{
"title": "Red",
"type": "Swatch Colour",
"thumbnail": "https://images.homedepot.ca/productimages/swatchImage_Red.jpg",
"link": "https://www.homedepot.ca/product/gracious-living-muskoka-contour-chair-in-red/1000862040",
"category_code": "vvc-cls_l5-muskokachairs-attribute_id_ssku_colourfamily-hd1-6-red"
}
],
"rating": 4.5811,
"reviews": 265,
"price": 19.98,
"currency": "CAD",
"price_was": "$29.98",
"price_saving": "$10.00",
"percent_off": "33%",
"aisle": "LC",
"badges": [
"CLR"
],
"add_to_cart": true,
"buy_online_pay_in_store": true,
"pickup": {
"out_of_stock": true
},
"delivery": {
"not_available_for_delivery": true
},
"check_nearby_stores": true,
"stock_information": {
"general_stock": 0,
"general_stock_status": "No Longer Available",
"store_stock": 0,
"store_stock_status": "Out Of Stock"
}
},
...
],
"filters": [
{
"key": "Delivery & Pick-Up",
"code": "deliverySpeed",
"value": [
{
"name": "FREE Ship to Store",
"count": 4182,
"value": "26ig",
"link": "https://www.homedepot.ca"
},
{
"name": "FREE Shipping",
"count": 4071,
"value": "26ie",
"link": "https://www.homedepot.ca"
},
{
"name": "Express Delivery",
"count": 71,
"value": "26if",
"link": "https://www.homedepot.ca"
},
...
]
},
{
"key": "Frame Material",
"code": "attributeidFrameMaterial",
"value": [
{
"name": "Aluminum",
"count": 133,
"value": "bkl",
"link": "https://www.homedepot.ca"
},
{
"name": "Cardboard",
"count": 1,
"value": "19ts",
"link": "https://www.homedepot.ca"
},
{
"name": "Cast Aluminum",
"count": 131,
"value": "cdo",
"link": "https://www.homedepot.ca"
},
...
]
},
{
"key": "Stock",
"code": "stock",
"value": [
{
"name": "In Stock Today at",
"count": 39,
"value": "43j",
"link": "https://www.homedepot.ca"
},
{
"name": "Hide Unavailable Products",
"count": 0,
"value": "1jx3",
"link": "https://www.homedepot.ca"
}
]
},
...
],
"pagination": {
"current": 1,
"next": "https://www.homedepot.ca/search?q=Chair&page=2&store=7140",
"other_pages": {
"2": "https://www.homedepot.ca/search?q=Chair&page=2&store=7140",
"3": "https://www.homedepot.ca/search?q=Chair&page=3&store=7140",
"4": "https://www.homedepot.ca/search?q=Chair&page=4&store=7140",
"5": "https://www.homedepot.ca/search?q=Chair&page=5&store=7140"
}
},
"serpapi_pagination": {
"current": 1,
"next_link": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=2&q=Chair&store=7140",
"next": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=2&q=Chair&store=7140",
"other_pages": {
"2": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=2&q=Chair&store=7140",
"3": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=3&q=Chair&store=7140",
"4": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=4&q=Chair&store=7140",
"5": "https://serpapi.com/search.json?country=ca&engine=home_depot&page=5&q=Chair&store=7140"
}
}
}
More complex examples with multiple optional parameters (the Home Depot US)
Search can be refined using filters hd_filter_tokens,
ordering/sorting hd_sort and pagination nao can be used.
The URL below fetches:
- • The third page (nao =
48) of the results, - • for the search "hammer" (q =
hammer), - • with price sorted from low to high (hd_sort =
price_low_to_high)
{
"search_metadata": {
"id": "61257a27b5c11d5208683b8b",
"status": "Success",
"json_endpoint": "https://serpapi.com/searches/5340e3c78c57eb62/61257a27b5c11d5208683b8b.json",
"created_at": "2021-08-24 23:00:55 UTC",
"processed_at": "2021-08-24 23:00:55 UTC",
"home_depot_url": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=48&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"raw_html_file": "https://serpapi.com/searches/5340e3c78c57eb62/61257a27b5c11d5208683b8b.html",
"prettify_html_file": "https://serpapi.com/searches/5340e3c78c57eb62/61257a27b5c11d5208683b8b.prettify",
"total_time_taken": 1.19
},
"search_parameters": {
"q": "hammer",
"nao": "48",
"hd_sort": "price_low_to_high",
"ps": 24,
"delivery_zip": "04401",
"store_id": "2414",
"engine": "home_depot"
},
"search_information": {
"results_state": "Results for exact spelling",
"total_results": 430,
"store_id": "2414",
"store_name": "Bangor"
},
"taxonomy": [
{
"title": "Tools",
"link": "https://www.homedepot.com/b/Tools/N-5yc1vZc1xy/Ntk-elastic/Ntt-hammer?NCNI-5"
},
{
"title": "Hand Tools",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools/N-5yc1vZc1zg/Ntk-elastic/Ntt-hammer?NCNI-5"
},
{
"title": "Hammers",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/N-5yc1vZc98g/Ntk-elastic/Ntt-hammer?NCNI-5"
}
],
"products": [
{
"position": 1,
"product_id": "305237799",
"title": "6 oz. Soft Face Mallet with 10 in. Hardwood Handle",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/edaec0e7-8dfa-4868-9964-514a319a17a1/svn/vaughan-mallets-sf6-64_65.jpg",
"https://images.thdstatic.com/productImages/edaec0e7-8dfa-4868-9964-514a319a17a1/svn/vaughan-mallets-sf6-64_100.jpg",
"https://images.thdstatic.com/productImages/edaec0e7-8dfa-4868-9964-514a319a17a1/svn/vaughan-mallets-sf6-64_145.jpg",
...
]
],
"link": "https://www.homedepot.com/p/Vaughan-6-oz-Soft-Face-Mallet-with-10-in-Hardwood-Handle-SF6/305237799",
"serpapi_link": "https://serpapi.com/search.json?engine=home_depot_product&product_id=305237799",
"model_number": "SF6",
"brand": "Vaughan",
"favorite": 54,
"rating": 4.3333,
"reviews": 6,
"price": 13.99,
"delivery": "Free delivery",
"pickup": "Free ship to store for pickup"
},
{
"position": 2,
"product_id": "309274393",
"title": "16 oz. Multi-Purpose Claw Hammer",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/aef2e809-5c73-488f-ae91-46706f3018de/svn/stark-claw-hammers-15000-64_65.jpg",
"https://images.thdstatic.com/productImages/aef2e809-5c73-488f-ae91-46706f3018de/svn/stark-claw-hammers-15000-64_100.jpg",
"https://images.thdstatic.com/productImages/aef2e809-5c73-488f-ae91-46706f3018de/svn/stark-claw-hammers-15000-64_145.jpg",
...
]
],
"link": "https://www.homedepot.com/p/Stark-16-oz-Multi-Purpose-Claw-Hammer-15000/309274393",
"serpapi_link": "https://serpapi.com/search.json?engine=home_depot_product&product_id=309274393",
"model_number": "15000",
"brand": "Stark",
"rating": 2.0,
"reviews": 1,
"price": 13.99,
"delivery": "Free delivery",
"pickup": "Free ship to store for pickup"
},
{
"position": 3,
"product_id": "205560103",
"title": "2-1/2 lb. Stubby Drilling Hammer",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/69e2370c-2fba-453d-9a72-ea4462470a75/svn/tekton-drilling-hammers-31201-64_65.jpg",
"https://images.thdstatic.com/productImages/69e2370c-2fba-453d-9a72-ea4462470a75/svn/tekton-drilling-hammers-31201-64_100.jpg",
...
]
],
"link": "https://www.homedepot.com/p/TEKTON-2-1-2-lb-Stubby-Drilling-Hammer-31201/205560103",
"serpapi_link": "https://serpapi.com/search.json?engine=home_depot_product&product_id=205560103",
"model_number": "31201",
"brand": "TEKTON",
"favorite": 23,
"rating": 5.0,
"reviews": 1,
"price": 14.68,
"delivery": "Free delivery",
"pickup": "Free ship to store for pickup"
},
{
"position": 4,
"product_id": "311877778",
"title": "2 lbs. Hand Drill Hammer with Hickory Handle",
"thumbnails": [
[
"https://images.thdstatic.com/productImages/3da62a50-49ed-40df-8df8-84296fc95b36/svn/graintex-drilling-hammers-hh1672-64_65.jpg",
"https://images.thdstatic.com/productImages/3da62a50-49ed-40df-8df8-84296fc95b36/svn/graintex-drilling-hammers-hh1672-64_100.jpg",
]
],
"link": "https://www.homedepot.com/p/Graintex-2-lbs-Hand-Drill-Hammer-with-Hickory-Handle-HH1672/311877778",
"serpapi_link": "https://serpapi.com/search.json?engine=home_depot_product&product_id=311877778",
"model_number": "HH1672",
"brand": "Graintex",
"rating": 0.0,
"reviews": 0,
"price": 14.7,
"unit": "piece",
"delivery": "Free delivery",
"pickup": "Free ship to store for pickup"
},
...
],
"filters": [
{
"key": "Availability",
"value": [
{
"name": "Hide Unavailable Products",
"value": "bwo5s",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Hide-Unavailable-Products/N-5yc1vZc98gZbwo5s?NCNI-5"
}
]
},
{
"key": "Category",
"value": [
{
"name": "Specialty Hammers",
"count": "176",
"value": "c98q",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers-Specialty-Hammers/N-5yc1vZc98q"
},
{
"name": "Claw Hammers",
"count": "173",
"value": "c98p",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers-Claw-Hammers/N-5yc1vZc98p"
},
...
]
},
{
"key": "Savings Center",
"value": [
{
"name": "Special Buys",
"count": "5",
"value": "1z11ao3",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Special-Buys/N-5yc1vZc98gZ1z11ao3?NCNI-5"
},
...
]
},
{
"key": "Get It Fast",
"value": [
{
"name": "Pick Up Today",
"count": "61",
"value": "1z175a5",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Pick-Up-Today/N-5yc1vZc98gZ1z175a5"
}
]
},
{
"key": "Review Rating",
"value": [
{
"name": "5",
"count": "162",
"value": "bwo5q",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Best-Rated/N-5yc1vZc98gZbwo5q?NCNI-5"
},
{
"name": "4 & Up",
"count": "533",
"value": "bwo5o",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/N-5yc1vZc98gZbwo5o?NCNI-5"
},
...
]
},
{
"key": "Brand",
"value": [
{
"name": "Estwing",
"count": "166",
"value": "iu",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Estwing/N-5yc1vZc98gZiu"
},
{
"name": "Halder",
"count": "96",
"value": "nf6",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Halder/N-5yc1vZc98gZnf6"
},
...
]
},
{
"key": "Saving by Percentage Off",
"value": [
{
"name": "40% Off or more",
"count": "1",
"value": "bwo55",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/N-5yc1vZc98gZbwo55"
},
...
]
},
{
"key": "Hand Tool Type",
"value": [
{
"name": "Hammer",
"count": "681",
"value": "1z116l8",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Hammer/N-5yc1vZc98gZ1z116l8"
},
{
"name": "Mallet",
"count": "132",
"value": "1z0uqo2",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/Mallet/N-5yc1vZc98gZ1z0uqo2"
},
...
]
},
{
"key": "Price",
"value": [
{
"name": "$0 - $10",
"count": "35",
"value": "12kx",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/N-5yc1vZc98gZ12kx?NCNI-5"
},
{
"name": "$10 - $20",
"count": "173",
"value": "12ky",
"link": "https://www.homedepot.com/b/Tools-Hand-Tools-Hammers/N-5yc1vZc98gZ12ky?NCNI-5"
},
...
]
}
],
"related": [
"sledge hammer",
"tool set",
"tools",
"pry bar",
"mallet",
"framing hammer",
"ball peen hammer",
"screwdriver"
],
"pagination": {
"current": 3,
"next": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=72&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"previous": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=24&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"other_pages": {
"1": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=1&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"2": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=24&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"4": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=72&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0",
"5": "https://www.homedepot.com/b/N-5yc1v/Ntt-hammer?Nao=96&sortorder=asc&sortby=price&Ns=P_REP_PRC_MODE%7C0"
}
},
"serpapi_pagination": {
"current": 3,
"previous_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=24&page_size=24&q=hammer&store_id=2414",
"previous": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=24&page_size=24&q=hammer&store_id=2414",
"next_link": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=72&page_size=24&q=hammer&store_id=2414",
"next": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=72&page_size=24&q=hammer&store_id=2414",
"other_pages": {
"1": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=1&page_size=24&q=hammer&store_id=2414",
"2": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=24&page_size=24&q=hammer&store_id=2414",
"4": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=72&page_size=24&q=hammer&store_id=2414",
"5": "https://serpapi.com/search.json?delivery_zip=04401&engine=home_depot&hd_sort=price_low_to_high&nao=96&page_size=24&q=hammer&store_id=2414"
}
}
}