Home Depot Category API
Extract Home Depot category pages with reliable pagination coverage
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 | |
1 2 3 4 5 | |
1 2 3 | |
1 2 3 4 5 6 | |
1 2 3 4 5 6 | |
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