Sutherlands Home Improvement Scraper

Scrape Sutherlands.com — a US home improvement, hardware, building materials, and farm & ranch retail chain with roughly 90 stores across the central United States. Search by keyword, browse by department, brand, or exact SKU, and get real store pricing, stock status, specs, images, and category data. No login, no cookies, no proxy required.

What this actor does

• Four modes: search, byCategory, byBrand, bySku
• 27 departments covering Tools, Hardware, Building Materials, Farm & Ranch, Outdoor Power Equipment, Plumbing, Electrical, Lawn & Garden, and more
• Real pricing — per-store retail prices pulled directly from Sutherlands' own store inventory (distributor drop-ship cost rows are excluded so prices always reflect what a shopper actually pays)
• Stock & sale filters — restrict results to in-stock or on-sale items
• Price range filter — min/max USD
• Brand filters — browse an exact brand, or keep only records whose brand contains a keyword
• Category filter — keep only records whose full category breadcrumb contains a keyword (narrower than department)
• Store availability — how many physical Sutherlands stores currently carry (or can special-order/ship in) each product
• Empty fields are omitted — every record only contains fields Sutherlands actually returned

Output per product

• sku — Sutherlands item number
• title, brand, brandUrl, mfgNumber, upc
• category — full breadcrumb path (e.g. Tools > Hand Tools > Hammers)
• department — top-level department (e.g. Tools)
• description — plain text (HTML stripped)
• specifications — key/value spec map (material, size, weight, etc.)
• relevantSpecifications — which spec keys the retailer highlights for this product
• variationName — base product name shared across its color/size variants (apparel and similar variant-driven products only)
• imageUrl — product photo
• productUrl / sourceUrl — canonical Sutherlands.com product page
• sellUnit — e.g. EA, BOX, CASE
• price — lowest current in-store retail price (USD)
• priceMin / priceMax — present only when price varies by store
• inStock — true if any Sutherlands store shows on-hand inventory
• onSale — true if any Sutherlands store currently has it on sale
• storeCount — number of physical Sutherlands stores that carry this product
• shipToStoreCount — number of additional Sutherlands stores that can special-order/ship this product in
• popularity, sales — retailer-provided ranking signals
• recordType: "product", scrapedAt

Input

Field	Type	Default	Description
mode	string	search	search / byCategory / byBrand / bySku
searchQuery	string	drill	Free-text keyword search (mode=search)
department	select	–	One of 27 departments; required for byCategory, optional narrowing filter elsewhere
brandName	string	–	Exact brand to browse (mode=byBrand), e.g. IRWIN
skuOrItemNumber	string	–	Exact SKU / item number (mode=bySku)
brandContains	string	–	Keep only records whose brand contains this text (any mode)
categoryContains	string	–	Keep only records whose full category breadcrumb contains this text, e.g. Hand Tools (any mode)
minPrice / maxPrice	int	–	USD price range
inStockOnly	bool	false	Only in-stock products
onSaleOnly	bool	false	Only on-sale products
sortBy	select	relevance	relevance / popularityDesc / salesDesc / nameAsc / nameDesc
maxItems	int	50	Hard cap (1–1000, the upstream search index's own ceiling per query)

Example: cordless drills under $150, in stock

{
  "mode": "search",
  "searchQuery": "cordless drill",
  "maxPrice": 150,
  "inStockOnly": true
}

Example: browse the Farm & Ranch department

{
  "mode": "byCategory",
  "department": "Farm & Ranch",
  "maxItems": 100
}

Example: everything by a specific brand

{
  "mode": "byBrand",
  "brandName": "IRWIN",
  "sortBy": "nameAsc"
}

Example: exact SKU lookup

{
  "mode": "bySku",
  "skuOrItemNumber": "4779450"
}

Example: hand tools only, narrowed within the Tools department

{
  "mode": "byCategory",
  "department": "Tools",
  "categoryContains": "Hand Tools"
}

Use cases

• Price monitoring — track hardware and tool prices at a regional US retailer
• Market research — compare product assortment and pricing against national chains
• Catalog enrichment — pull specs, images, and categorization for product data pipelines
• Inventory intelligence — spot in-stock vs. out-of-stock trends by department
• Competitive analysis — benchmark brand coverage and sale cadence

FAQ

Do I need an account or proxy? No. Sutherlands' product search is fully public — no login, cookies, or paid proxy required.

Why do some products show a priceMin/priceMax instead of a single price? Sutherlands' catalog is store-specific — the same SKU can carry different shelf prices at different locations. When prices vary, the actor reports the full range; price is always the lowest.

Why don't all products have a price? A small number of catalog items are only available through drop-ship distributors rather than direct Sutherlands store stock; those internal wholesale unit costs are excluded so the actor never reports a misleadingly low "price."

How many results can one query return? The upstream search index returns at most 1000 matches per query (maxItems is capped accordingly). Narrow with department, brandName, or price filters to reach deeper into a large category.

What's the difference between category and department? department is the top-level store section (e.g. Tools); category is the full breadcrumb path down to the most specific subcategory (e.g. Tools > Hand Tools > Hammers). Use the categoryContains filter to narrow into a subcategory without needing the exact breadcrumb text.

What do storeCount and shipToStoreCount mean? storeCount is the number of physical Sutherlands stores that currently carry the product on their shelves. shipToStoreCount is the number of additional stores that don't stock it on-shelf but can special-order/ship it in. Both are omitted when zero.

What is variationName? Some products (mostly apparel) are sold in multiple colors/sizes that share one base product name — variationName reports that shared base name. It's only present for products that belong to such a variant family.

How fresh is the data? Sutherlands' search index reflects live store inventory and pricing at request time.

Data Source

This actor targets Sutherlands.com rather than the originally-scoped Menards.com. Menards is protected by an Incapsula/Imperva bot-management WAF that returns an instant, non-solvable block interstitial (/_Incapsula_Resource) identically across plain HTTP requests, TLS-impersonated requests, and headless-browser requests — confirmed both from local testing and from Apify's own cloud datacenter proxy (AUTO group), where the request timed out entirely rather than returning any page content. Per the zero-cost reliability policy, an actor that cannot pass a free-plan datacenter request was replaced with a same-category retailer rather than requiring a paid residential proxy. Sutherlands.com is a genuine US home-improvement/hardware/farm-and-ranch chain whose own storefront search runs on a public, search-only API — real product data and real store pricing, no bot-detection involved.