Skip to content

Home Depot Category API

Extract Home Depot category pages with reliable pagination coverage

Last Updated: March 16, 2026

A GET request to /api/getter/?platform="homedepot_category" returns structured category listings directly from HomeDepot.com, including pricing, media, and review signals.

Purpose-built for category merchandising

Pull up-to-date category shelves, respect store-level availability, and paginate through up to 45 result pages without juggling brittle scripts or proxies.

Example

Here's how to fetch page 1 of Home Depot's Holiday Decorations category while targeting store #4648 in ZIP code 20110.

1
curl 'https://data.unwrangle.com/api/getter/?url=https%3A%2F%2Fwww.homedepot.com%2Fb%2FHoliday-Decorations-Seasonal-Decorations%2FN-5yc1vZch29&page=1&platform=homedepot_category&store_no=4648&zipcode=20110&api_key=API_KEY'
1
2
3
4
5
import requests

url = 'https://data.unwrangle.com/api/getter/?url=https%3A%2F%2Fwww.homedepot.com%2Fb%2FHoliday-Decorations-Seasonal-Decorations%2FN-5yc1vZch29&page=1&platform=homedepot_category&store_no=4648&zipcode=20110&api_key=API_KEY'
response = requests.get(url)
print(response.json())
1
2
3
const response = await fetch('https://data.unwrangle.com/api/getter/?url=https%3A%2F%2Fwww.homedepot.com%2Fb%2FHoliday-Decorations-Seasonal-Decorations%2FN-5yc1vZch29&page=1&platform=homedepot_category&store_no=4648&zipcode=20110&api_key=API_KEY')
const data = await response.json()
console.log(data)
1
2
3
4
5
6
<?php
$url = 'https://data.unwrangle.com/api/getter/?url=https%3A%2F%2Fwww.homedepot.com%2Fb%2FHoliday-Decorations-Seasonal-Decorations%2FN-5yc1vZch29&page=1&platform=homedepot_category&store_no=4648&zipcode=20110&api_key=API_KEY';
$response = file_get_contents($url);
$data = json_decode($response, true);
print_r($data);
?>
1
2
3
4
5
6
require 'net/http'
require 'uri'

uri = URI.parse('https://data.unwrangle.com/api/getter/?url=https%3A%2F%2Fwww.homedepot.com%2Fb%2FHoliday-Decorations-Seasonal-Decorations%2FN-5yc1vZch29&page=1&platform=homedepot_category&store_no=4648&zipcode=20110&api_key=API_KEY')
response = Net::HTTP.get(uri)
puts response

Note

Always URL-encode the category url before sending it as a query parameter. You can grab any category shelf or filtered URL from HomeDepot.com, encode it, and plug it directly into the request.

Query Parameters

Category Targeting

url

Required

URL-encoded Home Depot category URL. Works with merchandising pages, filter combinations, and seasonal shelves that return paginated product grids.

page

Optional

Page number to retrieve. Defaults to 1. The API currently serves up to 45 pages per category when available.

Local Merchandising

store_no

Optional

Home Depot store number (e.g., 4648) to align inventory and pricing with an in-market location. Combine with `zipcode` for consistent localization. You can find a list of all store numbers here.

zipcode

Optional

ZIP code that corresponds to the selected store. Required when `store_no` is used to ensure localized assortment and availability. The zipcode can also be found in the same file linked above.

Required Authentication

platform

Required

Selects the Home Depot Category scraper. Set this to homedepot_category.

api_key

Required

Your Unwrangle account token. Generate and manage keys through the Unwrangle Console.

Results

Each response returns pagination metadata plus a results array containing product objects with the fields below.

Field Data Type Description
name string Product title exactly as shown on the category shelf.
brand string Displayed brand name.
id string Home Depot product ID.
url string PDP URL for the listing.
model_no string Manufacturer or Home Depot model number.
upc string Universal Product Code.
retail_id string Retailer's internal listing ID.
product_type string Product type (e.g. MERCHANDISE).
parent_id string ID of the parent product grouping.
is_primary_sku boolean Whether this is the primary SKU in a product group.
thumbnails list Thumbnail image URLs for the product.
images list Detailed image objects with url and type (PRIMARY, SECONDARY).
variants list Product variant details.
total_options int/null Total number of variant options available.
rating float Average star rating.
total_reviews int Number of reviews referenced in the category tile.
price float Current selling price shown to shoppers.
list_price float Original or crossed-out price when available.
price_per_unit float/null Price per unit when applicable.
unit_of_measure string Unit of measure (e.g. each, set).
units_per_case float Units per case for bulk items.
bulk_pricing object/null Bulk pricing tiers when available.
discount_campaign string/null Active discount campaign name (e.g. Special Buys).
clearance object/null Clearance pricing details when applicable.
conditional_promotions list Conditional promotions with tiers.
currency string ISO currency code (typically USD).
currency_symbol string Currency symbol (e.g. $).
highlights list Product highlight badges.
specifications object/null Key product specifications.
categories list Product category hierarchy.
department string Product department name.
breadcrumbs list Navigation breadcrumb trail.
collection object/null Product collection details.
availability string Availability status (e.g. Shared, Online, Browse Only).
discontinued boolean Whether the product has been discontinued.
backordered boolean Whether the product is backordered.
in_stock boolean Whether the product is currently in stock.
fulfillment_options list Fulfillment methods with inventory, delivery dates, and store details.
excluded_ship_states string Comma-separated state codes excluded from shipping.
is_sponsored boolean/null Flag for sponsored placements when Home Depot marks them.
retailer_badges list Retailer badges (e.g. Best Seller, New, Exclusive).
returnable string Return policy (e.g. 90-Day).
quantity_limit int Maximum purchase quantity (0 = no limit).
has_subscription boolean Whether subscription purchasing is available.
favorites_count int/null Number of times the product has been favorited.

Response Example

{
    "success": true,
    "platform": "homedepot_category",
    "store_no": "4648",
    "zipcode": "20110",
    "url": "https://www.homedepot.com/b/Holiday-Decorations-Seasonal-Decorations/N-5yc1vZch29",
    "page": 1,
    "total_results": 1032,
    "no_of_pages": 43,
    "result_count": 24,
    "results": [
        {
            "name": "47.5 in. Hello Spring/Home Sweet Home MDF Leaners",
            "brand": "Hampton Bay",
            "id": "317832111",
            "url": "https://www.homedepot.com/p/Hampton-Bay-47-5-in-Hello-Spring-Home-Sweet-Home-MDF-Leaners-IG153929/317832111",
            "model_no": "IG153929",
            "upc": "018697798315",
            "retail_id": "1006726203",
            "product_type": "MERCHANDISE",
            "parent_id": "317832111",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/be24c6f6-2cc9-4828-ac1e-387042697c44/svn/hampton-bay-seasonal-decorations-ig153929-64_1000.jpg",
                "https://images.thdstatic.com/productImages/991c6159-a550-47ab-bbb9-1a36cb93fba9/svn/hampton-bay-seasonal-decorations-ig153929-e4_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/be24c6f6-2cc9-4828-ac1e-387042697c44/svn/hampton-bay-seasonal-decorations-ig153929-64_65.jpg",
                    "type": "PRIMARY"
                },
                {
                    "url": "https://images.thdstatic.com/productImages/991c6159-a550-47ab-bbb9-1a36cb93fba9/svn/hampton-bay-seasonal-decorations-ig153929-e4_65.jpg",
                    "type": "SECONDARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 4.45,
            "total_reviews": 83,
            "price": 19.98,
            "list_price": 19.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "department": null,
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Shared",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 1368,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-22",
                    "delivery_end_date": "2026-03-22",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 1368,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [
                {
                    "type": "exclusive",
                    "label": "Exclusive"
                }
            ],
            "returnable": "90-Day",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "8.25 x 10.25 In. Metal and Glass School House Black Lantern with LED Candle",
            "brand": "Hampton Bay",
            "id": "335781141",
            "url": "https://www.homedepot.com/p/Hampton-Bay-8-25-x-10-25-In-Metal-and-Glass-School-House-Black-Lantern-with-LED-Candle-38538HDV/335781141",
            "model_no": "38538HDV",
            "upc": "037916464978",
            "retail_id": "1005652235",
            "product_type": "MERCHANDISE",
            "parent_id": "335781141",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/98946da4-9f5e-4fe3-827e-59527280f178/svn/hampton-bay-seasonal-decorations-38538hdv-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/98946da4-9f5e-4fe3-827e-59527280f178/svn/hampton-bay-seasonal-decorations-38538hdv-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 0.0,
            "total_reviews": 0,
            "price": 29.98,
            "list_price": 29.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "department": null,
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Browse Only",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "bopis",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 1,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "express delivery",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-16",
                    "delivery_end_date": "2026-03-16",
                    "delivery_timeline": "today",
                    "inventory": {
                        "quantity": 2,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": null,
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "30.5 in. H Easter Resin Macaron Stacked Egg & Bunny Porch Decor",
            "brand": "Glitzhome",
            "id": "340283959",
            "url": "https://www.homedepot.com/p/Glitzhome-30-5-in-H-Easter-Resin-Macaron-Stacked-Egg-Bunny-Porch-Decor-2043000001/340283959",
            "model_no": "2043000001",
            "upc": "6926783230820",
            "retail_id": "1015226837",
            "product_type": "MERCHANDISE",
            "parent_id": "340283959",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/8b210335-a4c2-4db8-b252-69152df01a60/svn/glitzhome-easter-decorations-2043000001-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/8b210335-a4c2-4db8-b252-69152df01a60/svn/glitzhome-easter-decorations-2043000001-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 5.0,
            "total_reviews": 2,
            "price": 91.08,
            "list_price": 99.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": "Special Buys",
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Easter Decorations"
            ],
            "department": "Easter Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 28,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-19",
                    "delivery_end_date": "2026-03-23",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 28,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": true,
            "retailer_badges": [
                {
                    "type": "new",
                    "label": "New"
                }
            ],
            "returnable": "Non-Returnable",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "28 in. 149-Light LED Blue and Cool White Bethlehem Star with Cross Center",
            "brand": "Wintergreen Lighting",
            "id": "310112143",
            "url": "https://www.homedepot.com/p/Wintergreen-Lighting-28-in-149-Light-LED-Blue-and-Cool-White-Bethlehem-Star-with-Cross-Center-73392/310112143",
            "model_no": "73392",
            "upc": "840052143597",
            "retail_id": "1004461792",
            "product_type": "MERCHANDISE",
            "parent_id": "310112143",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/b25fb325-599f-4da9-b09a-cc337a70586d/svn/wintergreen-lighting-christmas-novelty-lights-73392-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/b25fb325-599f-4da9-b09a-cc337a70586d/svn/wintergreen-lighting-christmas-novelty-lights-73392-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 4.33,
            "total_reviews": 6,
            "price": 149.0,
            "list_price": 149.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Christmas Decorations",
                "Christmas Lights",
                "Christmas Novelty Lights"
            ],
            "department": "Christmas Novelty Lights",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 176,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-19",
                    "delivery_end_date": "2026-03-19",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 176,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "GU,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": "90-Day",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": 4
        },
        {
            "name": "RWB Streamer Cannon",
            "brand": null,
            "id": "334666766",
            "url": "https://www.homedepot.com/p/RWB-Streamer-Cannon-320966/334666766",
            "model_no": "320966",
            "upc": "027736050314",
            "retail_id": "1013979382",
            "product_type": "MERCHANDISE",
            "parent_id": "334666766",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/d2ea99c9-f4b1-4f2a-9868-1e6e0e028e84/svn/patriotic-decorations-320966-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/d2ea99c9-f4b1-4f2a-9868-1e6e0e028e84/svn/patriotic-decorations-320966-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 0.0,
            "total_reviews": 0,
            "price": 3.0,
            "list_price": 3.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Patriotic Decorations"
            ],
            "department": "Patriotic Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Browse Only",
            "discontinued": false,
            "backordered": false,
            "in_stock": false,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "bopis",
                    "fulfillable": false,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 0,
                        "in_stock": false,
                        "out_of_stock": true,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,AL,AR,AZ,CA,CO,CT,DC,DE,FL,GA,GU,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,OR,PA,PR,RI,SC,SD,TN,TX,UT,VA,VI,VT,WA,WI,WV,WY",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": null,
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "Party Poppin Bag",
            "brand": null,
            "id": "334679212",
            "url": "https://www.homedepot.com/p/Party-Poppin-Bag-102763/334679212",
            "model_no": "102763",
            "upc": "027736047710",
            "retail_id": "1013980054",
            "product_type": "MERCHANDISE",
            "parent_id": "334679212",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/546dad62-e2f0-4948-8597-3f238abbb23a/svn/patriotic-decorations-102763-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/546dad62-e2f0-4948-8597-3f238abbb23a/svn/patriotic-decorations-102763-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 0.0,
            "total_reviews": 0,
            "price": 5.0,
            "list_price": 5.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Patriotic Decorations"
            ],
            "department": "Patriotic Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Browse Only",
            "discontinued": false,
            "backordered": false,
            "in_stock": false,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "bopis",
                    "fulfillable": false,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 0,
                        "in_stock": false,
                        "out_of_stock": true,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,AL,AR,AZ,CA,CO,CT,DC,DE,FL,GA,GU,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,OR,PA,PR,RI,SC,SD,TN,TX,UT,VA,VI,VT,WA,WI,WV,WY",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": null,
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "Freedom Poppers",
            "brand": null,
            "id": "334681673",
            "url": "https://www.homedepot.com/p/Freedom-Poppers-320963A/334681673",
            "model_no": "320963A",
            "upc": "027736053674",
            "retail_id": "1013980051",
            "product_type": "MERCHANDISE",
            "parent_id": "334681673",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/fac2bc36-e49e-460b-a7f1-c0ddaac4a532/svn/patriotic-decorations-320963a-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/fac2bc36-e49e-460b-a7f1-c0ddaac4a532/svn/patriotic-decorations-320963a-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 0.0,
            "total_reviews": 0,
            "price": 5.0,
            "list_price": 5.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Patriotic Decorations"
            ],
            "department": "Patriotic Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Browse Only",
            "discontinued": false,
            "backordered": false,
            "in_stock": false,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "bopis",
                    "fulfillable": false,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 0,
                        "in_stock": false,
                        "out_of_stock": true,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,AL,AR,AZ,CA,CO,CT,DC,DE,FL,GA,GU,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,OR,PA,PR,RI,SC,SD,TN,TX,UT,VA,VI,VT,WA,WI,WV,WY",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": null,
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "Party Poppers 6-Pack",
            "brand": null,
            "id": "334680481",
            "url": "https://www.homedepot.com/p/Party-Poppers-6-Pack-320537J/334680481",
            "model_no": "320537J",
            "upc": "027736023950",
            "retail_id": "1013980049",
            "product_type": "MERCHANDISE",
            "parent_id": "334680481",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/7754175f-3214-40d2-86b5-d1fa89a5653a/svn/patriotic-decorations-320537j-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/7754175f-3214-40d2-86b5-d1fa89a5653a/svn/patriotic-decorations-320537j-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 0.0,
            "total_reviews": 0,
            "price": 1.0,
            "list_price": 1.0,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Patriotic Decorations"
            ],
            "department": "Patriotic Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Browse Only",
            "discontinued": false,
            "backordered": false,
            "in_stock": false,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "bopis",
                    "fulfillable": false,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 0,
                        "in_stock": false,
                        "out_of_stock": true,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,AL,AR,AZ,CA,CO,CT,DC,DE,FL,GA,GU,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,OR,PA,PR,RI,SC,SD,TN,TX,UT,VA,VI,VT,WA,WI,WV,WY",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": null,
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "18 ft. 108-Light Red and White Striped Candy Cane Incandescent Christmas Rope Light",
            "brand": "Northlight",
            "id": "312041369",
            "url": "https://www.homedepot.com/p/Northlight-18-ft-108-Light-Red-and-White-Striped-Candy-Cane-Incandescent-Christmas-Rope-Light-32912618/312041369",
            "model_no": "32912618",
            "upc": "191296157704",
            "retail_id": "1005002715",
            "product_type": "MERCHANDISE",
            "parent_id": "312041369",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/be0d414d-7914-4bd4-bc50-f8faf3ef71b5/svn/northlight-christmas-rope-lights-32912618-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/be0d414d-7914-4bd4-bc50-f8faf3ef71b5/svn/northlight-christmas-rope-lights-32912618-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 4.48,
            "total_reviews": 29,
            "price": 33.98,
            "list_price": 33.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Christmas Decorations",
                "Christmas Lights",
                "Christmas Rope Lights"
            ],
            "department": "Christmas Rope Lights",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 826,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-20",
                    "delivery_end_date": "2026-03-20",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 826,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [
                {
                    "type": "bestseller",
                    "label": "Best Seller"
                }
            ],
            "returnable": "90-Day",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": 6
        },
        {
            "name": "Mayflower Market Patriotic White 24 in. Faceted Metal Star Wall Hanger",
            "brand": "VHC BRANDS",
            "id": "330003945",
            "url": "https://www.homedepot.com/p/VHC-BRANDS-Mayflower-Market-Patriotic-White-24-in-Faceted-Metal-Star-Wall-Hanger-85031/330003945",
            "model_no": "85031",
            "upc": "840233931074",
            "retail_id": null,
            "product_type": "MERCHANDISE",
            "parent_id": "330003945",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/c46bfb0d4bc548b0b7a3a2a00b33c039/svn/vhc-brands-patriotic-decorations-85031-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/c46bfb0d4bc548b0b7a3a2a00b33c039/svn/vhc-brands-patriotic-decorations-85031-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 5.0,
            "total_reviews": 1,
            "price": 24.98,
            "list_price": 24.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Patriotic Decorations"
            ],
            "department": "Patriotic Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 196,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-19",
                    "delivery_end_date": "2026-03-19",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 196,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [
                {
                    "type": "bestseller",
                    "label": "Best Seller"
                }
            ],
            "returnable": "90-Day",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "Qty 5-11 in. Tall-LED Pastel Colored Easter Eggs-Plastic JUMBO Eggs-Battery Operated with Built in Timer",
            "brand": "HoliScapes",
            "id": "334684693",
            "url": "https://www.homedepot.com/p/HoliScapes-Qty-5-11-in-Tall-LED-Pastel-Colored-Easter-Eggs-Plastic-JUMBO-Eggs-Battery-Operated-with-Built-in-Timer-Easter-Eggs-5/334684693",
            "model_no": "Easter-Eggs-5",
            "upc": "810182980041",
            "retail_id": null,
            "product_type": "MERCHANDISE",
            "parent_id": "334684693",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/8d6e9e9e57ac4a4e8930bcb6b91864d6/svn/holiscapes-easter-decorations-easter-eggs-5-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/8d6e9e9e57ac4a4e8930bcb6b91864d6/svn/holiscapes-easter-decorations-easter-eggs-5-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": null,
            "rating": 5.0,
            "total_reviews": 2,
            "price": 39.98,
            "list_price": 39.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Easter Decorations"
            ],
            "department": "Easter Decorations",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 67,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-17",
                    "delivery_end_date": "2026-03-18",
                    "delivery_timeline": "tomorrow",
                    "inventory": {
                        "quantity": 67,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": "Non-Returnable",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": null
        },
        {
            "name": "25 ft. 25-Count Multi Christmas C9 Incandescent String Lights",
            "brand": "Brite Star",
            "id": "205116355",
            "url": "https://www.homedepot.com/p/Brite-Star-25-ft-25-Count-Multi-Christmas-C9-Incandescent-String-Lights-37-860-00/205116355",
            "model_no": "37-860-00",
            "upc": "021995378608",
            "retail_id": "1001045929",
            "product_type": "MERCHANDISE",
            "parent_id": "205116355",
            "is_primary_sku": false,
            "thumbnails": [
                "https://images.thdstatic.com/productImages/10c1bbd6-bed1-41f2-bc6f-8b77e10fe547/svn/brite-star-christmas-string-lights-37-860-00-64_1000.jpg"
            ],
            "images": [
                {
                    "url": "https://images.thdstatic.com/productImages/10c1bbd6-bed1-41f2-bc6f-8b77e10fe547/svn/brite-star-christmas-string-lights-37-860-00-64_65.jpg",
                    "type": "PRIMARY"
                }
            ],
            "variants": [],
            "total_options": 1,
            "rating": 4.18,
            "total_reviews": 11,
            "price": 22.98,
            "list_price": 22.98,
            "price_per_unit": null,
            "unit_of_measure": "each",
            "units_per_case": 0.0,
            "bulk_pricing": null,
            "discount_campaign": null,
            "clearance": null,
            "conditional_promotions": [
                {
                    "promotion_id": null,
                    "tags": null,
                    "tiers": []
                }
            ],
            "currency": "USD",
            "currency_symbol": "$",
            "highlights": [],
            "specifications": null,
            "categories": [
                "Holiday Decorations",
                "Christmas Decorations",
                "Christmas Lights",
                "Christmas String Lights"
            ],
            "department": "Christmas String Lights",
            "breadcrumbs": [
                "Holiday Decorations",
                "Seasonal Decorations"
            ],
            "collection": null,
            "availability": "Online",
            "discontinued": false,
            "backordered": false,
            "in_stock": true,
            "fulfillment_options": [
                {
                    "fulfillment_type": "pickup",
                    "service_type": "boss",
                    "fulfillable": true,
                    "has_free_shipping": false,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": null,
                    "delivery_timeline": null,
                    "inventory": {
                        "quantity": 493,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "4648",
                    "store_name": "East Manassas",
                    "curbside_pickup": null
                },
                {
                    "fulfillment_type": "delivery",
                    "service_type": "sth",
                    "fulfillable": true,
                    "has_free_shipping": true,
                    "free_delivery_threshold": null,
                    "delivery_charge": null,
                    "total_charge": 0.0,
                    "delivery_start_date": "2026-03-18",
                    "delivery_end_date": "2026-03-18",
                    "delivery_timeline": "later",
                    "inventory": {
                        "quantity": 493,
                        "in_stock": true,
                        "out_of_stock": false,
                        "limited_quantity": false
                    },
                    "store_id": "8119",
                    "store_name": null,
                    "curbside_pickup": null
                }
            ],
            "excluded_ship_states": "AK,GU,HI,PR,VI",
            "is_sponsored": null,
            "retailer_badges": [],
            "returnable": "90-Day",
            "quantity_limit": 0,
            "has_subscription": false,
            "favorites_count": 7
        },
        ...
    ],
    "credits_used": 2.5,
    "remaining_credits": 9784299.0
}

Request Cost

2.5 credits per request are deducted for each successful request.

Support

Need help or want to request a new feature? Reach out to us at support@unwrangle.com