Sign In Register

The Home Depot API

API uptime
100.000%

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

Search Query

q

Required

Parameter defines the search query. You can use anything that you would use in a regular The Home Depot search.

Localization

country

Optional

Parameter defines the country to use for the Home Depot search. Only United States(us), and Canada(ca) are supported.

Advanced Home Depot Parameters

hd_sort

Optional

Parameter defines results sorted by different options.

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

delivery_zip

Optional

ZIP Postal code. To filter the shipping products by a selected area.

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 the 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 the Home Depot Canada.

It can be set to:
priceSaving: Top Sellers,
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 the Home Depot Canada. Filter tokens can be obtained from API response

Price Limit

lowerbound

Optional

Defines lower bound for price in USD.

upperbound

Optional

Defines upper bound for price in USD.

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.

ps

Optional

Determines the number of items per page. There are scenarios where Home depot overrides the ps value. By default Home depot returns 24 results.

pagesize

Optional

Determines the number of items per page in the Home Depot Canada. By default, the Home Depot Canada returns 40 (maximum allowed value) results.

Serpapi Parameters

engine

Required

Set parameter to home_depot to use The Home Depot API engine.

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.

api_key

Required

Parameter defines the SerpApi private key to use.

output

Optional

Parameter defines the final output you want. It can be set to json (default) to get a structured JSON of the results, or html to get the raw html retrieved.

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)

Example results for q: chair (the Home Depot US)

JSON Example

{
  "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)

Example results for country: ca, and q: chair (the Home Depot Canada)

JSON Example

{
  "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)

More complex examples with multiple optional parameters (the Home Depot US)

JSON Example

{
  "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"
    }
  }
}