Home Depot Clearance Scraper

Home Depot Clearance Scraper

Scrapes clearance products from any Home Depot store using direct GraphQL API requests — no browser needed, 10x faster than browser-based scrapers. Returns full product details with original and clearance pricing, inventory status, and category data.

• Direct GraphQL API integration — no browser overhead, lightning-fast execution
• Store-specific results by store ID or zipcode lookup
• Complete clearance pricing with dollar-off and percentage-off savings
• 100+ pre-loaded clearance categories scraped automatically
• Smart deduplication across runs — no duplicate products in your dataset
• Parallel processing with configurable concurrency (1–20 requests)
• Outputs clean JSON, CSV, or Excel via Apify dataset export

What data does it extract?

Each result contains:

Product info: item ID, product name, brand, model number, SKU, product type

Pricing: current price, original price, clearance price, dollar savings, percentage off

Media: product image URLs in multiple resolutions

Reviews: average rating, total review count

Availability: store-specific inventory status, stock quantity, store name, fulfillment options

Category: category title, full breadcrumb path (e.g., "Heating, Venting & Cooling > Air Filters")

Links: direct Home Depot product URL with store parameter

All data exports as JSON, CSV, or Excel directly from the Apify dataset.

Use cases

• Bargain hunting: Find deep discounts on Home Depot clearance items at specific stores near you
• Inventory monitoring: Track clearance product availability and pricing changes across stores over time
• Reselling: Identify high-value clearance deals for retail arbitrage opportunities
• Price tracking: Monitor when products go on clearance and how much is discounted from the original price
• Market research: Analyze clearance trends across Home Depot product categories and departments
• Store comparison: Compare clearance inventory and pricing between different Home Depot locations

How to use

1. Click Try for free on the Actor page
2. In the Input tab, enter a Home Depot Store ID (e.g., 6643) or a Zipcode (e.g., 92807) — the Actor will find the nearest store automatically
3. Adjust Parallel Requests if needed (default is 3, increase for faster runs with good proxies)
4. Leave Proxy Configuration as default (Apify Residential US) for best results
5. Click Start and wait for the run to complete (typically 5–15 minutes depending on store inventory)
6. Download your results as JSON, CSV, or Excel from the Output tab

Input parameters

Parameter	Type	Required	Description
storeId	String	No	Home Depot store ID for location-specific pricing. Example: 6643
zipcode	String	No	US zipcode to find the nearest Home Depot store. Only used if storeId is not provided. Default: 92807
parallelRequests	Integer	No	Number of parallel API requests (1–20). Higher values increase speed but may trigger rate limiting. Default: 3
proxyConfig	Object	No	Proxy configuration. Defaults to Apify Residential proxy with US country targeting. Recommended to leave as default.

Note: Provide either storeId or zipcode, not both. If neither is provided, the Actor defaults to zipcode 92807.

Output example

{
  "itemId": "337106319",
  "identifiers": {
    "storeSkuNumber": "1014491215",
    "brandName": "Simply",
    "itemId": "337106319",
    "productLabel": "20 in. x 25 in. x 1 in. MERV 11 FPR 7 Pleated Furnace Air Filter (6-Pack)",
    "modelNumber": "S-11-06-20251"
  },
  "pricing": {
    "value": 56.97,
    "original": 56.97,
    "clearance": {
      "value": 29.99,
      "dollarOff": 26.98,
      "percentageOff": 47
    }
  },
  "reviews": {
    "ratingsReviews": {
      "averageRating": "4.7",
      "totalReviews": "541"
    }
  },
  "isClearanceItem": true,
  "categoryTitle": "Air Filters",
  "categoryPath": "Heating, Venting & Cooling > Air Filters",
  "URL": "https://homedepot.com/p/Simply-20-in-x-25-in-x-1-in-MERV-11-FPR-7-Pleated-Furnace-Air-Filter-6-Pack-S-11-06-20251/337106319?store=6643"
}

Pricing

This Actor is free to use — you only pay for Apify platform compute time and proxy usage.

A typical run scraping one full store costs approximately $0.50–$1.50 in Apify platform credits depending on the number of clearance items and parallel request settings.

New Apify accounts receive $5 in free credits — enough to run multiple full store scrapes.

Cost optimization tips:

• Set memory to 512 MB (the Actor typically uses only ~135 MB)
• Use the default parallel requests setting of 3 for a good balance of speed and cost
• The Actor uses HTTP requests instead of browsers, keeping compute costs minimal

Technical notes

• No browser needed: Uses direct GraphQL API requests via curl — 10x faster and cheaper than browser-based scrapers
• Residential proxy required: US residential proxies are recommended for best success rates. The default Apify Residential US proxy works out of the box.
• 100+ categories: All Home Depot clearance categories are pre-loaded and scraped automatically
• 720 product cap: Home Depot's API limits results to 720 products per category (30 pages × 24 items). This is a platform limitation, not an Actor limitation.
• Memory efficient: Typical usage is ~135 MB. Recommended memory setting is 512 MB.
• Smart deduplication: Tracks previously processed items via key-value store so repeated runs only return new products
• Retry logic: Multi-layer retry mechanism with exponential backoff handles intermittent failures automatically
• Data freshness: All data is scraped live from Home Depot — no cached or stale results

Integrations

Outputs are compatible with:

• Apify API: Run the Actor programmatically and retrieve results via the Apify REST API or JavaScript/Python SDK
• Make (formerly Integromat): Use the Apify module to trigger runs and route clearance data to other apps
• Zapier: Connect Actor runs to 5,000+ apps via the Apify Zapier integration

Support

Have questions or found a bug? Reach out:

• Email: ScrapySpider@protonmail.com
• Website: ScrapySpider.com
• Apify: Open a support issue on this Actor's page
• Response time: Within 24–48 hours on weekdays