Home Depot Product SKU Match & Details | Stevesie Data

Home Depot Product SKU Match & Details

Get Home Depot product details (brand name, model number, description, photos, price, inventory & more) from a list of SKUs. This is useful if you need to look up product data in bulk but don’t want to sit and manually search for each product one-by-one on the Home Depot website.

This formula contains 2 workflows which need to be used together, the first workflow accepts a list of SKUs to search for on Home Depot. It will filter the results and only return back results that match the SKU exactly, so you probably won’t get 100% coverage if Home Depot doesn’t carry the exact SKU you want. Also be warned that sometimes SKUs will differ by leading zeros or other strange characters, so you may need to make edits to your input list if that’s the case.

From your list of matching results, you need to copy and paste the Item IDs (Home Depot’s internal identifier for products) into the product details lookup workflow, which takes a list of Home Depot Item IDs and gets back the details for them, one-by-one, as the second step.

Getting Started

Start by importing this formula, which will add 2 workflows to your account. Start by entering your SKUs into the search workflow to see the execution plan for what the worfklow could do if executed.

Disclaimer: This formula contains endpoints that are not part of official APIs endorsed by homedepot.com and is documented here only for informational purposes. These endpoints were obtained through use of software or services made publicly available by homedepot.com. Use of this formula may breach the terms of service governing homedepot.com. Learn more here: Is Data Scraping Legal?
Home Depot Product Details
Home Depot Item IDs
List
➡️ Item IDs

API Key Example: MtNfr9rEWkRsxkc71IdtDBAp7E2p8GSy

Required to use the Home Depot API. The default value is what appears to ship with the iOS Home Depot app, but you may have access to additional information if you intercept this value via proxy using your account.

Additional Attributes Example: notDisplayed

Leave this as notDisplayed if you need extra data back.

Response Fields Example: media,pricing,info,ratingsReviews,shipping,itemAvailability,promotions,dimensions,attributeGroups,fulfillmentOptions,inventory,storeAvailability

What fields the API should return. Override this if you only need a subset.

Store IDs Example: 6175

ID of the store(s) to return inventory results on. Separate multiple IDs with a comma. You can search Home Depot stores by location to get the IDs.

  • Home Depot Product Details
Home Depot Product SKU Match
Home Depot SKUs
List
➡️ Keyword

API Key Example: MtNfr9rEWkRsxkc71IdtDBAp7E2p8GSy

Required to use the Home Depot API. The default value is what appears to ship with the iOS Home Depot app, but you may have access to additional information if you intercept this value via proxy using your account.

Keyword

Search by keyword, SKU, UPC, model number or Internet ID.

Store ID

ID of the store(s) to return inventory results on. Separate multiple IDs with a comma. You can search Home Depot stores by location to get the IDs.

In-Store Filter Example: all

Use this when providing a Store ID in the input. Change this to instore to only get back products that are in-stock at the store. The default value of all will show all products the store may carry (in and out of stock).

Page Size Example: 48

Page Size

Pagination Offset Example: 0

Pagination Offset

Category ID

Category ID(s) of products to search within. You can fetch Home Depot’s Main Categories to start with the top-level categories. For sub-categories, you can browse homedepot.com and use the last part of a category’s URL (e.g. 5yc1vZbrfe) to show products from that category. Search multiple categories by separating each ID with a comma.

  • Home Depot Product Search Associated SKU Match