Home Improvement Retail Data: Home Depot Prices, Brands & Availability
Power tools are one of the most price-sensitive and brand-driven aisles in home improvement. Shoppers compare battery platforms, kit contents and sale prices before they buy, and manufacturers fight for shelf space. Home Depot product data shows that competition in a structured, comparable form.
To make this concrete, we collected a free sample of 95 power tool listings and published it as a CSV on the Home Depot Power Tools Prices dataset page. This article walks through what the sample shows, which fields matter, and how teams use this kind of data for pricing, assortment and brand analysis.
One note on scope before the numbers: the sample is a snapshot of the first listing page of several Power Tools categories, not the whole catalog. Brand shares below describe this sample, not Home Depot's total assortment.
Why Home Depot product data matters
Home Depot is one of the largest home improvement retailers in the US, and its website is a public price reference for tools, building materials and hardware. For a brand manager, a category buyer or a competing retailer, the useful questions are simple:
- Which brands dominate the listing pages?
- How deep and how frequent are the discounts?
- Where do ratings and review volume signal real demand?
- Which model numbers are listed at which price?
Answering these by hand across hundreds of products is slow and hard to repeat. A dataset turns it into a filter and a pivot table. If you already track prices elsewhere, our e-commerce price monitoring playbook explains how to build a refresh routine around data like this, and our write-up on retail intelligence from MediaMarkt data shows the same approach on a European electronics retailer.
What our Home Depot sample shows
The sample has 95 unique products and 10 columns. About 1.2% of all cells are empty, almost all of them missing brand names on five listings. Here is what the numbers say.
Brand mix. Milwaukee accounts for 49 of the 95 listings (51.6%), DEWALT for 23 (24.2%) and RYOBI for 11 (11.6%). RIDGID has 5 listings and Makita 2. Five listings have no brand value in the page data. Because we pulled the first page of each category, this mix partly reflects how Home Depot ranks those pages, which is itself a useful signal about visibility.
Price level. The median price is $199 and the average is $257.50. Prices run from $49.97 to $1,268. In total, 18 products cost less than $100 and 24 cost $300 or more. Brand medians differ clearly: Milwaukee $249, DEWALT $199 and RYOBI $79.
Discount frequency. 47 of 95 products (49.5%) show an original price above the current price. That means about half the sample is on markdown at the moment of collection.
Discount depth. Among the discounted products, the average reduction is 35.6%, the median is 33.6% and the deepest is 68.2%. By brand, Milwaukee discounted 22 of 49 listings (45%) at an average of 43.7% off. DEWALT discounted 12 of 23 (52%) at 33.9%. RYOBI discounted 6 of 11 (55%) at 31.2%.
Ratings and reviews. The average rating is 4.65 and the median is 4.68, so ratings alone barely separate products. Review counts do: the sample totals 239,615 reviews with a median of 1,982 per product. The most reviewed item is a DEWALT 20V MAX cordless 1/2 in. drill/driver kit with 17,420 reviews.
Here is an excerpt of five rows from the CSV:
| brand | model_number | price | was_price | rating | review_count |
|---|---|---|---|---|---|
| Milwaukee | 2960-20-48-59-1850 | 489 | 489 | 4.65 | 1563 |
| RYOBI | PCL206K1-PCL515B-PCL406B | 237.97 | 237.97 | 4.54 | 3571 |
| RYOBI | FVD02K-FVD50K | 69.94 | 99.94 | 4.14 | 1642 |
| Milwaukee | 3697-22 | 399 | 399 | 4.77 | 3858 |
| Milwaukee | 2880-20 | 229 | 229 | 4.79 | 3429 |
You can download all 95 rows from the dataset page and check every figure above yourself.
Reading the brand and discount data
A few patterns are worth pulling out.
Milwaukee leads in listings and in discount depth. It has the biggest presence in the sample and, when it does discount, the cuts are larger than for DEWALT or RYOBI. Many of those are kit and bundle promotions, where the original price is high and the sale price brings the kit closer to a competitor's offer.
RYOBI sits in a different price band. With a median of $79 against $249 for Milwaukee, it competes on entry price. Its discount rate is the highest of the three big brands, but the cuts are shallower.
DEWALT owns the review volume. Its top product has 17,420 reviews, far above the sample median. High review counts make a product a safe default for shoppers and a useful benchmark for anyone pricing a competing tool.
Rating is a weak filter. When the average is 4.65 across the whole sample, a 4.1 stands out and a 4.8 does not. Use rating together with review count, not alone.
Which fields matter and why
The sample uses ten fields. These are the ones that do the most work:
- product_id and model_number. The item ID is the stable key for tracking a listing over time. The manufacturer model number lets you match a Home Depot listing to the same tool at another retailer or in your own catalog. Kit listings often have long, combined model numbers, so expect some cleaning.
- price and was_price. Together they give you the discount. Compare them carefully: when both values are equal there is no markdown, which is the case for roughly half the sample.
- brand. Needed for share-of-shelf analysis. A few listings return it empty, so a fallback that parses the title is a good idea in production.
- rating and review_count. Use them as a quality and demand signal.
- product_url. A direct link for audits and for follow-up collection of specs and descriptions.
- scraped_at_utc. Prices change, so every record needs a timestamp.
Where availability fits in
Many buyers also ask for store pickup and delivery availability, because stock position is part of retail shelf data. Our planned columns for those two fields are not in this sample: the listing pages we used do not expose them in their embedded data. Availability on Home Depot depends on the selected store and is shown at product level, which requires a store ID and ZIP code for each request. If you need it, that is a scoped project: choose the stores or ZIP codes you care about and we collect product-level availability for them.
Use cases
- Competitive pricing. Compare your tool prices against Home Depot's current and original price by model number.
- Promotion tracking. Measure how often a brand is discounted and how deep the cuts go, then plan your own promotions around them.
- Assortment and brand analysis. See which brands and battery platforms get the most visibility in a category.
- Market sizing and demand proxies. Review counts are a rough indicator of which products sell, useful when sales data is not available.
- Marketplace and dropshipping research. Find categories where price gaps leave room for resellers.
Common challenges in Home Depot scraping
Anyone attempting Home Depot scraping at scale runs into the same issues:
- Anti-bot protection. Large retailers filter automated traffic. Requests need realistic browser behavior and well-distributed network access, and some pages need full rendering.
- Pagination that does not behave. In our run, changing the page offset in the URL returned the same first page. We reached 95 records by collecting several sub-category pages instead. A robust pipeline checks that page two really differs from page one.
- Data hidden in embedded state. Products often sit in a JSON state block, not in visible HTML. Parsing that block is more reliable than reading page markup, but it changes when the site is redeployed.
- Store-dependent prices. Prices and availability vary by store, so the same URL can show different numbers. Fix the store context and record it.
- Duplicates across categories. The same tool appears in several categories. Deduplicate on item ID.
- Layout changes. Selectors and JSON keys change. Add validation that flags empty columns early.
How often to refresh
Match the refresh rate to the decision you are making:
- Daily for active price monitoring and promotion tracking, especially around seasonal sale periods.
- Weekly for brand share and assortment analysis.
- Monthly for market sizing and catalog matching.
Keep every snapshot with its timestamp. The history is what lets you see discount patterns, not just one day's prices.
FAQ
What is in the free Home Depot sample? 95 power tool listings with item ID, title, brand, model number, price, original price, rating, review count, product URL and a collection timestamp.
Is the sample the full power tools catalog? No. It is a snapshot of the first listing page of several categories. Brand shares and discount rates describe this sample only.
Does the data include store pickup or delivery availability? Not in this sample. Availability depends on the selected store and is collected at product level in custom projects.
Can I use the data commercially? The records are public product data. Review the CSV, check it against your use case and contact us if you have questions about reuse.
Get product data for your own target
If you want Home Depot product data for specific categories, stores or brands, or the same view for another retailer, we can scope it for you. Datasets start from $49 on our pricing page. To see what your own data would look like first, request a free sample of your own target.
Author: DataHarbor Team