Unofficial Home Depot API
265 Users · 
7 MB Indexed Access Home Depot data in 5 minutes - no coding required
Get Home Depot data today
WORK UNITS
Product Search 
UPC Lookup README
Home Depot Product Data
Access product details like photos, descriptions, ratings, etc. for individual products in JSON, CSV or RSS format.
SKU Lookup
If you're looking up products by SKU number, you'll want to use the Product Search task. Simply enter the SKU number (and optionally the Home Depot store ID for inventory information) into the keyword input field to view results.
Internet ID Lookup
If you have the Home Depot Internet ID, you may use the Product Details task and enter the ID (or set of IDs) to view details about the product(s). You may also enter a Home Depot store ID to view inventory.
Category Lookup
You can also browse products by categories. Use the Main Categories task to get a list of top-level categories in all of Home Depot, and the response will help you filter down to more specific categories.
Sample Product JSON
{
"itemType": "MERCHANDISE",
"rebates": {
"hasEcoRebates": false
},
"productId": 206666886,
"canonicalURL": "/p/Ryobi-18-Volt-ONE-Cordless-1-2-in-Hammer-Drill-Driver-Tool-Only-with-Handle-P214/206666886",
"itemAvailability": {
"buyable": true,
"discontinuedItem": false,
"inventoryStatus": true,
"backorderable": false,
"published": true,
"availableInStore": true,
"availableOnlineStore": true
},
"media": {
"mediaEntry": [
{
"height": 65,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_65.jpg",
"width": 65,
"mediaType": "IMAGE"
},
{
"height": 65,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_65.jpg",
"width": 65,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 65,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_65.jpg",
"width": 65,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 65,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_65.jpg",
"width": 65,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 65,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_65.jpg",
"width": 65,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 100,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_100.jpg",
"width": 100,
"mediaType": "IMAGE"
},
{
"height": 100,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_100.jpg",
"width": 100,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 100,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_100.jpg",
"width": 100,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 100,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_100.jpg",
"width": 100,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 100,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_100.jpg",
"width": 100,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 145,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_145.jpg",
"width": 145,
"mediaType": "IMAGE"
},
{
"height": 145,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_145.jpg",
"width": 145,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 145,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_145.jpg",
"width": 145,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 145,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_145.jpg",
"width": 145,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 145,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_145.jpg",
"width": 145,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 300,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_300.jpg",
"width": 300,
"mediaType": "IMAGE"
},
{
"height": 300,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_300.jpg",
"width": 300,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 300,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_300.jpg",
"width": 300,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 300,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_300.jpg",
"width": 300,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 300,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_300.jpg",
"width": 300,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 400,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_400.jpg",
"width": 400,
"mediaType": "IMAGE"
},
{
"height": 400,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_400.jpg",
"width": 400,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 400,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_400.jpg",
"width": 400,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 400,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_400.jpg",
"width": 400,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 400,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_400.jpg",
"width": 400,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 600,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_600.jpg",
"width": 600,
"mediaType": "IMAGE"
},
{
"height": 600,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_600.jpg",
"width": 600,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 600,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_600.jpg",
"width": 600,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 600,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_600.jpg",
"width": 600,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 600,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_600.jpg",
"width": 600,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"height": 1000,
"location": "https://images.homedepot-static.com/productImages/9658de57-408c-4741-87c4-d6faad7f844f/svn/ryobi-hammer-drills-p214-64_1000.jpg",
"width": 1000,
"mediaType": "IMAGE"
},
{
"height": 1000,
"location": "https://images.homedepot-static.com/productImages/ab09297e-0912-441b-8c08-e70c47ce5607/svn/ryobi-hammer-drills-p214-c3_1000.jpg",
"width": 1000,
"mediaType": "IMAGE_ALTERNATE_VIEW"
},
{
"height": 1000,
"location": "https://images.homedepot-static.com/productImages/202fce42-b43f-4556-8bc9-8d3ab47f19b2/svn/ryobi-hammer-drills-p214-4f_1000.jpg",
"width": 1000,
"mediaType": "IMAGE_ALTERNATE_VIEW_2"
},
{
"height": 1000,
"location": "https://images.homedepot-static.com/productImages/e7d282aa-bc40-4dde-b0a4-d836a0d0a8a3/svn/ryobi-hammer-drills-p214-1f_1000.jpg",
"width": 1000,
"mediaType": "IMAGE_ALTERNATE_VIEW_3"
},
{
"height": 1000,
"location": "https://images.homedepot-static.com/productImages/4a25cec2-309e-42c1-b922-63307e30460c/svn/ryobi-hammer-drills-p214-31_1000.jpg",
"width": 1000,
"mediaType": "IMAGE_LIFE_STYLE"
},
{
"videoStill": "https://f1.media.brightcove.com/8/1834613806001/1834613806001_5406315534001_5406316487001-vs.jpg?pubId=66036796001&videoId=5406507204001",
"title": "Ryobi Nation",
"thumbnail": "https://f1.media.brightcove.com/8/1834613806001/1834613806001_5406313332001_5406316487001-th.jpg?pubId=66036796001&videoId=5406507204001",
"shortDescription": "Ryobi Nation Rocks ",
"videoId": 5406507204001,
"video": "https://f1.media.brightcove.com/4/1834613806001/1834613806001_5406313331001_5406316487001.mp4?pubId=66036796001&videoId=5406507204001",
"mediaType": "BRIGHTCOVE VIDEO"
},
{
"location": "/DTCCOMNEW/fetch/FetchRules/Rich_Content/Rich_Content_25T_PowerTools_206666886_1017.json",
"mediaType": "RICH CONTENT"
}
],
"imageEnhancementFlag": false
},
"storeSkus": {
"storeSku": [
{
"fulfillmentOptions": {
"deliverFromStore": {
"estDeliveryCharge": 79,
"sameDayEligible": true,
"status": true
},
"shipToHome": {
"status": true
},
"fulfillable": true,
"buyOnlinePickupInStore": {
"status": true
}
},
"storeAvailability": {
"itemAvilabilityMessages": {
"availabilityMessageEntry": {
"messageKey": "check_btn",
"messageValue": "Sold At Your Local Store"
}
},
"availableInLocalStore": true,
"itemAvailable": true,
"bopisElgStore": true,
"bossMsgElgStore": true,
"bossElgStore": true
},
"storeId": 6175,
"inventory": {
"expectedQuantityAvailable": 4,
"onHandQuantity": 5
},
"storeStatusType": "ACTIVE",
"storeStatus": true,
"pricing": {
"alternatePricingDisplay": false,
"uom": "each",
"originalPrice": 69,
"dollarOff": 0,
"lowerPrice": false,
"percentageOff": 0,
"specialPrice": 69,
"unitsPerCase": 0
}
},
{
"fulfillmentOptions": {
"shipToHome": {
"status": true
},
"fulfillable": true
},
"storeAvailability": {
"itemAvilabilityMessages": {
"availabilityMessageEntry": {
"messageKey": "check_btn",
"messageValue": "Sold At Your Local Store"
}
},
"availableInLocalStore": true,
"itemAvailable": true
},
"storeId": 8119,
"storeStatusType": "ACTIVE",
"storeStatus": true,
"pricing": {
"alternatePricingDisplay": false,
"uom": "each",
"originalPrice": 69,
"dollarOff": 0,
"lowerPrice": false,
"percentageOff": 0,
"specialPrice": 69,
"unitsPerCase": 0
}
}
]
},
"itemId": 206666886,
"availabilityType": "Shared",
"promotions": "",
"shipping": {
"bossEstimatedShippingEndDate": "2018-10-17",
"sthEstimatedShippingStartDate": "2018-10-11",
"itemLevelFreeShip": false,
"sthEstimatedShippingEndDate": "2018-10-11",
"freeShippingMessageNumber": 3,
"isDynamicEta": true,
"freeShippingThreshold": "$45.00",
"excludedShipStates": "GU,PR,VI",
"freeShippingMessage": "Ships FREE with $45.00 Order",
"eligibleForFreeShipping": true,
"bossEstimatedShippingStartDate": "2018-10-12"
},
"webUrl": "https://www.homedepot.com/p/Ryobi-18-Volt-ONE-Cordless-1-2-in-Hammer-Drill-Driver-Tool-Only-with-Handle-P214/206666886",
"protectionPlanSku": 304329525,
"ratingsReviews": {
"totalReviews": 230,
"averageRating": 4.4087
},
"partNumber": 206666886,
"info": {
"productDepartment": 25,
"showProduct": false,
"backOrderFlag": false,
"onlineStatus": true,
"hasIrgItems": true,
"description": "Ryobi introduces the 18-Volt ONE+ Cordless 1/2 in. Hammer Drill/Driver (Tool Only) with Handle. This hammer drill/driver features a variable 2-speed transmission for precision and versatility and delivers up to 1,600 RPM and 24,000 BPM for powerful performance. The 24-position clutch handles high-torque applications and the clutch override allows quick mode changes from drilling to driving. New and improved GRIPZONE over mold provides optimum grip and user comfort. The Ryobi 18-Volt ONE+ 1/2 in. Cordless Hammer Drill/Driver works with all Ryobi 18-Volt ONE+ batteries (sold separately).",
"isAppliance": false,
"hasFbrItems": true,
"buyOnlineShipToStoreEligible": true,
"productSubClass": 16,
"showLocalPrice": false,
"productLabel": "18-Volt ONE+ Cordless 1/2 in. Hammer Drill/Driver (Tool Only) with Handle",
"specialOrderSKU": 1001633184,
"brandName": "Ryobi",
"productClass": 9,
"upc": "033287168040",
"isTopSeller": false,
"recommendationFeatures": "FBT",
"buyOnlinePickupInStoreEligible": true,
"genericBrandFlag": false,
"storeSkuNumber": 1001638533,
"shipType": 73,
"modelNumber": "P214",
"omsThdSku": 1001633184,
"vendorNumber": 72793,
"hasFbtItems": true
},
"attributeGroups": {
"group": [
{
"groupType": "functional details",
"entries": {
"attribute": [
{
"name": "Maximum Speed (RPM)",
"guid": "8d6e8733-5011-4783-9e07-be309e6c34ec",
"value": "1600 RPM"
},
{
"name": "Voltage (v)",
"guid": "6bcbb41f-7c6a-44f9-9924-ab10f55ec037",
"value": "18v"
},
{
"name": "Returnable",
"guid": "675afb24-0e4b-4c58-adc4-63e467935346",
"value": "90-Day"
},
{
"name": "Blows per Minute (BPM)",
"guid": "cf1a70e8-f959-45be-aa6a-977cc5b7135d",
"value": 24000
},
{
"name": "Chuck Size",
"guid": "00730ae3-e83a-470e-9876-8856e295b0bf",
"value": "1/2 In."
},
{
"name": "Included",
"guid": "850364fd-0804-4dd1-a263-dc3d1367e181",
"value": "Bits Included"
},
{
"name": "Cordless/ Corded",
"guid": "50a65226-4083-470b-8541-c1396c54e50a",
"value": "Cordless"
},
{
"name": "Battery Power Type",
"guid": "73ad41ea-b194-4279-8a68-a14772b5732b",
"value": "Lithium Ion"
},
{
"name": "Power Tool Features",
"guid": "a149d9fe-2459-458b-8c7c-8740bfe0d3ee",
"value": "LED Light,Variable Speed"
},
{
"name": "Charger Included",
"guid": "3a7afc38-d68f-4849-afe6-276717ed7e14",
"value": "Charger Not Included"
},
{
"name": "Tools Product Type",
"guid": "79de8a6a-916e-4584-a920-56e7f3c78d76",
"value": "Power Tool"
},
{
"name": "Drill/ Driver Type",
"guid": "0c6af3b1-dfc6-44f6-9943-e4406bd6728b",
"value": "Hammer Drill/ Driver"
},
{
"name": "Color Family",
"guid": "97770c0a-f65e-48bc-a139-53c241f4d786",
"value": "Green"
},
{
"name": "Condition",
"guid": "9da2a36f-1190-4299-a842-63d759e18036",
"value": "New"
},
{
"name": "Battery Amp Hours",
"guid": "1931c038-012a-48d1-81d2-fe4eacceaf27",
"value": "No Battery"
},
{
"name": "Battery/Charger",
"guid": "badd2342-7cca-4795-b2d2-40c0af54b71f",
"value": "Tool Only"
},
{
"name": "Product Weight (lb.)",
"guid": "e17c7a92-90d8-49b5-acbe-12bd21067613",
"value": 3.2
},
{
"name": "Number of Batteries Included",
"guid": "584cb33a-324d-4e87-9078-f7fe86432055",
"value": 0
},
{
"name": "Chuck Type",
"guid": "54d2a151-88c1-42b1-a4a9-b39a0d387ae9",
"value": "Keyless"
},
{
"name": "Motor Type",
"guid": "e517a636-6f66-4ed4-b9de-7c988cb7fb68",
"value": "Brushed"
}
]
}
},
{
"groupType": "product highlights",
"entries": {
"attribute": [
{
"name": "Product Highlight 2",
"guid": "a431668b-cd35-4707-ba9f-06edc9f59bca",
"value": "18-Volt battery and charger sold separately"
},
{
"name": "Product Highlight 1",
"guid": "47697f2f-69f9-4e4d-a887-2e835606fb3c",
"value": "600 in. lbs. torque to power through the toughest applications"
},
{
"name": "Product Highlight 3",
"guid": "0fc219a4-a27f-4e03-97bd-143f4594e9ab",
"value": "Compatible with over 100+ Ryobi 18-Volt ONE+ tools"
}
]
}
},
{
"groupType": "notDisplayed",
"entries": {
"attribute": [
{
"name": "OMS THD Sku Type",
"guid": "bcdfe1a4-626a-4042-9a2e-5298f9b952a8",
"value": "S"
},
{
"name": "THD Dot Com Onlinestatus",
"guid": "ccdfe24e-1138-4601-9575-66bc717edbc0",
"value": true
},
{
"name": "Description (36)",
"guid": "48956d44-8156-46df-af1a-3eff05b3a842",
"value": "RYB 18V HAMMER DRILL - TOOL ONLY"
},
{
"name": "GLN",
"guid": "25f09af3-1458-48fc-844e-5deab11c770f",
"value": "0033287000005"
},
{
"name": "OMS THD Category",
"guid": "8c50bd36-118e-4ac3-a6b1-e1f132cb7290",
"value": 110
},
{
"name": "THDOMSValidated",
"guid": "eb8db341-33c1-4ca4-9316-84dfba75e7fb",
"value": true
},
{
"name": "THD Vendor #",
"guid": "57719267-5477-4f2e-84b6-1bf342fa23d2",
"value": 64921
},
{
"name": "Dotcom Shipping Carton Height (in)",
"guid": "5ddbe247-f603-48b7-8476-245c990f2b0f",
"value": "7.874 In."
},
{
"name": "Dotcom Yow Enrich Start Time",
"guid": "b4218868-1312-4f23-aa5c-bbab63035d18",
"value": 1454351301510
},
{
"name": "IBI SKU - Wilmar",
"guid": "06bf5a8d-96ff-45e9-8865-1ebc30bc8843",
"value": "35-70884"
},
{
"name": "Channel Status",
"guid": "3c28a010-fa26-4dd6-bfb2-f3a00638934d",
"value": "B2B_ININITIATE,B2B_PENDING,DOTCOM_CERTIFIED,STORE_CERTIFIED"
},
{
"name": "COUNTRY OF ORIGIN",
"guid": "84ebbc8a-5c11-44e7-b1f1-d37babdb0833",
"value": "CN"
},
{
"name": "OMS THD Dept",
"guid": "ae4d63ea-744b-428a-bcfc-589f050f8d3b",
"value": 25
},
{
"name": "OMSID",
"guid": "d9947b6c-5ebf-48b8-aeb6-e7ebd9221420",
"value": 206666886
},
{
"name": "THD Sub Class",
"guid": "27ba4961-93f2-4d87-9bb3-9229f77d1015",
"value": 16
},
{
"name": "Proposition 65 Warning",
"guid": "b711ccb9-ec96-4fbb-8188-8972df5678b3",
"value": "Cancer and Reproductive Harm - www.p65warnings.ca.gov"
},
{
"name": "Power Tool Product Type",
"guid": "c47ddf6f-42f6-41b5-956c-0ae74b269495",
"value": "Drills & Drivers"
},
{
"name": "THD Sub Sub-Class",
"guid": "9991ed9a-06d2-4cb1-8a8a-b8b9deb88893",
"value": 106
},
{
"name": "Proposition 65 warning required?",
"guid": "aee97348-db1c-4e33-a1d8-932f31f2ed35",
"value": "Yes"
},
{
"name": "Dotcom QC1 Time Diff",
"guid": "44bf5cf7-c6dd-4119-95b1-1e3fe5c6e406",
"value": 6273
},
{
"name": "Collection Path",
"guid": "2050cead-7bf9-4395-ad92-4ee6465ff9ff",
"value": "/Tools/Power Tools & Accessories/Power Tools/Cordless/Drills & Drivers/Hammer Drills"
},
{
"name": "Rich Content Setup",
"guid": "0a6ef6d8-407b-4405-ad49-f48da27989e7",
"value": "Display Rich Content with Marketing Copy and Bullets"
},
{
"name": "Dotcom Logistics Start Time",
"guid": "9073d11c-9cc2-40b8-9158-c7f3a924b9f2",
"value": 1454094833237
},
{
"name": "THD SKU # (NO dashes)",
"guid": "27156dfb-3ce8-4307-bd7e-b36cae566a3f",
"value": 1001638533
},
{
"name": "Dotcom QC1 Start Time",
"guid": "1cd6c964-44d0-4cf0-b0ea-89acdf39c3ff",
"value": 1452552083699
},
{
"name": "MAP Flag (IBI)",
"guid": "be5328c5-7de9-482c-a19f-ee3077692589",
"value": "No"
},
{
"name": "Dotcom Channel Mgt End Time",
"guid": "49e10607-bc71-4e1a-b77f-930f9a44d8dd",
"value": 1454081847393
},
{
"name": "ShipType",
"guid": "1c18afcb-cb1d-4424-a9d6-81c318626a17",
"value": 73
},
{
"name": "OMS THD Sub Sub-Class",
"guid": "f8fca106-b543-432b-be73-81ab18beb768",
"value": 106
},
{
"name": "Packaged Depth (in)",
"guid": "f85abef2-7945-4889-9796-3ebff6d3e348",
"value": "9.68 in"
},
{
"name": "ItemLevelFreeShip",
"guid": "8b6366a5-1f08-4573-b3d2-c5a978c6189d",
"value": false
},
{
"name": "EligibleFreeShip",
"guid": "19e476b8-e751-4b8d-b372-d4d2b62b6a21",
"value": true
},
{
"name": "Dotcom Channel Mgt Start Time",
"guid": "a140a352-c651-4294-b03a-4cbfd013be4c",
"value": 1454081846126
},
{
"name": "Parent Leaf GUID",
"guid": "7bf53929-7cfd-4bf9-bcb3-c715ffc5be79",
"value": "bb47b2be-b168-4d21-852d-4edd0fefeb4f"
},
{
"name": "First Online Browse Date",
"guid": "89628b6a-5112-434b-8386-c4e80e7211af",
"value": "2015-11-06"
},
{
"name": "SEO Description",
"guid": "9e747da5-fef5-45ed-8495-97ca2fbb8507",
"value": "Quickly drill holes with this Ryobi ONE+ Cordless Hammer Drill or Driver with Handle. Use hammer mode to drill holes in masonry and concrete."
},
{
"name": "BackOrdersAllowed",
"guid": "82904470-0dbd-4e33-a681-6fef5e2992fe",
"value": false
},
{
"name": "Marketing Copy (1500)",
"guid": "e3c42525-70f9-4121-a1cb-b1550db51803",
"value": "Ryobi introduces the 18-Volt ONE+ Cordless 1/2 in. Hammer Drill/Driver (Tool Only) with Handle. This hammer drill/driver features a variable 2-speed transmission for precision and versatility and delivers up to 1,600 RPM and 24,000 BPM for powerful performance. The 24-position clutch handles high-torque applications and the clutch override allows quick mode changes from drilling to driving. New and improved GRIPZONE over mold provides optimum grip and user comfort. The Ryobi 18-Volt ONE+ 1/2 in. Cordless Hammer Drill/Driver works with all Ryobi 18-Volt ONE+ batteries (sold separately)."
},
{
"name": "Dotcom Logistics End Time",
"guid": "b25afa81-e3b1-403c-b29e-03712e82edc6",
"value": 1454094836298
},
{
"name": "OMS THD Sub Class",
"guid": "459ed8bb-73f1-48d2-aebf-9ef43dbfe201",
"value": 16
},
{
"name": "UOMCd",
"guid": "c924a8d7-350a-4cdf-9841-1864341bb606",
"value": "EA"
},
{
"name": "Dotcom Shipping Carton Gross Weight (lb)",
"guid": "6013739a-4343-4579-b770-ae00e49d1b52",
"value": "4.0400"
},
{
"name": "Protection Plan SSKU Object OMSID",
"guid": "5fcb86d4-d4f7-413c-b133-ab60685703ba",
"value": 304301279
},
{
"name": "THD Class",
"guid": "d96fcf59-ca33-47e2-9f36-c105510b4d00",
"value": 9
},
{
"name": "ShippingSurcharge",
"guid": "d1cdfb22-c198-46e4-ac93-260d042b8dd2",
"value": 0
},
{
"name": "Dotcom Logistics Time Diff",
"guid": "dda46e5d-db85-45f9-aac0-8d7d04ac9691",
"value": 3061
},
{
"name": "YOW Description (35)",
"guid": "c69a4f10-8875-4bd0-889f-6fa7a8c8a638",
"value": "P214 18V 1/2 IN. HAMMER DRILL"
},
{
"name": "Same day Delivery",
"guid": "c6e6ed23-4f74-47ca-89c6-d27901326732",
"value": true
},
{
"name": "OMS THD SKU",
"guid": "ae8c38ff-4109-44b1-9fc4-93d1b586a680",
"value": 1001633184
},
{
"name": "Dotcom QC1 End Time",
"guid": "6bf4adf8-ace2-498b-9b53-36a629edbb8c",
"value": 1452552089972
},
{
"name": "Dotcom Yow Enrich Time Diff",
"guid": "70cd08c1-5014-4a10-88e4-4871fc2f55bd",
"value": 195627
},
{
"name": "First Online Date",
"guid": "49754011-870d-4a6e-969e-653def06109c",
"value": "2015-11-06 00:00:00"
},
{
"name": "Dotcom Shipping Carton Depth (in)",
"guid": "812fcf72-7fbc-473f-93de-ce9acdc0ecac",
"value": "9.685 In."
},
{
"name": "Battery Platform",
"guid": "1d7c4afd-4939-49e8-88c0-8012ae3050d5",
"value": "Ryobi 18v ONE+"
},
{
"name": "TaxwareCode",
"guid": "20574c03-de83-42ec-b3de-ad2b24237020",
"value": 89998
},
{
"name": "Will children be exposed to your product for more than an hour (Ex. clothing, footwear, jewelry, certain toys)?",
"guid": "482298b3-5f79-4dd7-9c09-5d99d3df2303",
"value": "No"
},
{
"name": "THD Browse Onlinestatus",
"guid": "bf15fa45-176c-4749-8481-2c8a2f9dd70f",
"value": true
},
{
"name": "Show Online Price",
"guid": "ceb143c4-4db8-423b-9a45-a1da401b68f4",
"value": false
},
{
"name": "Vendor Processing Days",
"guid": "a91fa6bd-c9c5-43b5-a05b-87607b5c15a2",
"value": 1
},
{
"name": "BOSS eligible",
"guid": "4efcb9a4-dcf6-4c8e-a5b4-0834a2318562",
"value": true
},
{
"name": "YOW Enrich Bypass",
"guid": "bcf99c21-3e27-41dc-8b1f-7c2cc584b20e",
"value": "Yes"
},
{
"name": "Dotcom Shipping Carton Width (in)",
"guid": "c1ba7181-5ae3-4954-94c2-4aca970c8816",
"value": "3.071 In."
},
{
"name": "OMS THD Vendor Name",
"guid": "6120da58-d2ae-42ef-9ac1-d2e123faa759",
"value": "YOW"
},
{
"name": "FieldDestroy",
"guid": "9df05b5f-8807-4870-be9a-3b62038c74e6",
"value": false
},
{
"name": "Item Weight",
"guid": "228a54a1-045b-4ca4-9c0a-02df98efd77b",
"value": 4.04
},
{
"name": "MFG Name",
"guid": "37f3fed4-5bf3-4bf8-88bd-310bd2addb56",
"value": "Techtronic Industries, Co. Ltd."
},
{
"name": "Online Video ID",
"guid": "678aa7da-8cf7-4eef-8f4e-e8be17e22a0f",
"value": 5406507204001
},
{
"name": "THDInMarket401",
"guid": "6f8487bb-858f-4c1c-b17a-8c91f2b57ff5",
"value": "Y"
},
{
"name": "Hide SKU on Web Site",
"guid": "3099803b-b76a-4abb-a364-f5f8bf8308c8",
"value": false
},
{
"name": "Packaged Height (in)",
"guid": "3606c2cc-8cac-43cd-beae-91705b13bf82",
"value": "7.87 in"
},
{
"name": "THD Category",
"guid": "b21a0531-6bce-4a47-9faa-12be2eae5bee",
"value": 110
},
{
"name": "Freight Class",
"guid": "e5271c05-f70f-4dd4-bc89-2e559827f8c8",
"value": 85
},
{
"name": "Is your product intended to be put into children s mouths, intended to be applied to children s bodies, or is it mouthable (able to be sucked or chewed) by children under 3 years of age?",
"guid": "789e9714-d059-4eec-aacc-c36d432d32e9",
"value": "No"
},
{
"name": "THD OnlineStatus",
"guid": "f6ef55f4-9f5b-46d9-869d-40b671d668c1",
"value": true
},
{
"name": "Ship From YOW/CHUB",
"guid": "7eb1e571-64d3-4800-85ff-7bae9f84e334",
"value": "YOW"
},
{
"name": "THD SO SKU",
"guid": "51267e1b-c462-4343-adba-1b4f8dcfaeeb",
"value": 1001633184
},
{
"name": "Sell UOM (as sold to consumer)",
"guid": "ba5bbbf2-01bd-4b0c-bc68-025df2150266",
"value": "EA-Each"
},
{
"name": "Supplier SKU",
"guid": "e5491a59-0ea3-4e73-a02c-fa32b3956342",
"value": "P214"
},
{
"name": "Packaged Width (in)",
"guid": "6710ad06-8409-46f1-b972-a44abc3a4785",
"value": "3.07 in"
},
{
"name": "DFM Review End Time",
"guid": "669010c1-6fff-4257-9777-9d3e24da1805",
"value": 1452058668718
},
{
"name": "Vendor Turn Time (Business Days)",
"guid": "3e8d618c-017d-4d4a-87e0-c45a1cbf4f09",
"value": 1
},
{
"name": "PRODUCT_TYPE",
"guid": "9de2009d-e656-4cba-af51-df453a8dd419",
"value": "MERCHANDISE"
},
{
"name": "Is your product primarily designed and intended for children 12 years of age and under?",
"guid": "5e92d511-8359-42fc-bc18-d45f7f4b684e",
"value": "No"
},
{
"name": "YOW SKU # (NO dashes)",
"guid": "cdca4473-4693-4d3f-a917-1e45db88f20b",
"value": 720475
},
{
"name": "bopis eligible",
"guid": "d9fd4421-ab85-4015-a228-fb2d2e4f9081",
"value": true
},
{
"name": "UPC",
"guid": "6d030ff8-72ce-4f42-ba53-023f55c53a20",
"value": "033287168040"
},
{
"name": "MFG Model #",
"guid": "2bce6533-87c7-4646-a3b7-d5efb49bf927",
"value": "P214"
},
{
"name": "Are your products labeled with age grading or otherwise packaged, labeled or marketed for children?",
"guid": "71c66892-e793-4415-abab-b58556fc16ab",
"value": "No"
},
{
"name": "MFG Part #",
"guid": "cd250fb8-fb00-4f9d-813a-dea949605715",
"value": "P214"
},
{
"name": "DFM Review Start Time",
"guid": "c66634bc-94e7-4f19-a827-0fd72fb6930d",
"value": 1452058666506
},
{
"name": "Product Name (120)",
"guid": "a40be0d3-5c49-446d-a835-ef6af29c016e",
"value": "18-Volt ONE+ Cordless 1/2 in. Hammer Drill/Driver (Tool Only) with Handle"
},
{
"name": "THD Base Table UOM",
"guid": "2c161aa6-9710-4364-8626-4418e3295890",
"value": "EA-Each"
},
{
"name": ".com Merch Vendor #",
"guid": "770b0397-4cff-4e8d-8a0b-dd11ccc77e9e",
"value": 72793
},
{
"name": "THD Object Type",
"guid": "6a3681b7-0205-4cae-95cc-257bf4cfb51a",
"value": "Item"
},
{
"name": "Dotcom Yow Enrich End Time",
"guid": "e72a7ded-485b-4e91-afb9-c36ba5e3006c",
"value": 1454351497137
},
{
"name": "DFM Review Time Diff",
"guid": "1791fd78-2194-4507-92cb-4f9ce8ce628e",
"value": 2212
},
{
"name": "IBI USN",
"guid": "b0358509-6171-4cc9-9d2c-7f44aa2961f2",
"value": 3570884
},
{
"name": "BODFS Eligible",
"guid": "030f9c4c-444a-4487-9b88-4a1475494229",
"value": true
},
{
"name": "ExcludedShipStates",
"guid": "90c8023b-39e6-43dd-91b1-7d1df23fa356",
"value": "GU,PR,VI"
},
{
"name": "Sell Pkg Qty (as sold to consumer)",
"guid": "3735eab9-2ab3-4eeb-b5c3-d538d42dea73",
"value": 1
},
{
"name": "Packaged Gross Weight (lb)",
"guid": "2e824d83-8b70-443a-8883-4330f9480331",
"value": "4.04 lb"
},
{
"name": "DF Core Vendor #",
"guid": "de4c01a3-183c-47b1-bec1-263fa12f664f",
"value": 18424
},
{
"name": "THD Dept",
"guid": "31fb6392-36cd-49ca-bc2d-177ddc7a8a55",
"value": 25
},
{
"name": "OMS THD Class",
"guid": "6ec6731b-f6cf-4b8a-980d-b706b17b1c00",
"value": 9
}
]
}
},
{
"groupType": "pdf documents",
"entries": {
"attribute": [
{
"name": "Warranty",
"value": "46ce381f-b4bf-4b12-bed1-a79682be64c9.pdf",
"url": "https://images.homedepot-static.com/catalog/pdfImages/46/46ce381f-b4bf-4b12-bed1-a79682be64c9.pdf"
},
{
"name": "Use and Care Manual",
"value": "8ee5e8bd-eb64-460e-aaec-e19dae26b973.pdf",
"url": "https://images.homedepot-static.com/catalog/pdfImages/8e/8ee5e8bd-eb64-460e-aaec-e19dae26b973.pdf"
}
]
}
},
{
"groupType": "descriptive",
"entries": {
"attribute": [
{
"bulletedAttr": true,
"name": "Bullet07",
"guid": "db7ffb34-7fcf-4167-a8c3-1af4ae8d981a",
"value": "LED light illuminates work surfaces for increased visibility"
},
{
"bulletedAttr": true,
"name": "Bullet01",
"guid": "3b8d7d7e-9ff9-4b2b-99ca-57a1ba19eb94",
"value": "24-position clutch and 2-speed gear box to match drilling and driving needs"
},
{
"bulletedAttr": true,
"name": "Bullet09",
"guid": "3acca797-8968-45f5-9b2c-2bcbbe35341a",
"value": "Includes: 18-Volt ONE+ cordless 1/2 in. hammer drill/driver (tool only) with handle, battery and charger are sold separately"
},
{
"bulletedAttr": true,
"name": "Bullet02",
"guid": "15271107-6854-40a9-bcd6-b320407d8544",
"value": "1/2 in. all-metal, keyless, ratcheting chuck for increased strength and durability"
},
{
"bulletedAttr": true,
"name": "Bullet08",
"guid": "dc178130-aeed-4c0f-9fc4-39521ded5adf",
"value": "MAGTRAY magnetic holder for convenient placement of screws and bits"
},
{
"bulletedAttr": true,
"name": "Bullet05",
"guid": "c69c774b-774d-4887-9656-c77807342c64",
"value": "Drive mode: for driving screws and bolts"
},
{
"bulletedAttr": true,
"name": "Bullet10",
"guid": "e78a9b12-e44a-4dd0-9052-e466a3d0249d",
"value": "3 year manufacturer's warranty"
},
{
"bulletedAttr": true,
"name": "Bullet06",
"guid": "1905c003-bc16-459c-848d-930ce2db71bb",
"value": "Hammer mode: for drilling holes in masonry and concrete"
},
{
"bulletedAttr": true,
"name": "Bullet23",
"guid": "b88573b2-a809-469a-b6c4-8fce90391a6f",
"value": "<a href=https://www.homedepot.com/c/electronics_recycling_programs style=color:#F96302; target=_blank>Click here for more information on Electronic Recycling Programs</a>"
},
{
"bulletedAttr": true,
"name": "Bullet03",
"guid": "fed33381-f352-458d-9732-11e1053008c2",
"value": "Clutch override for quick mode changes from drilling to driving"
},
{
"name": "MFG Brand Name",
"guid": "29d438d9-64f2-4623-8f4e-09f9368e93bb",
"value": "Ryobi"
},
{
"bulletedAttr": true,
"name": "Bullet11",
"guid": "543ab816-5598-44fb-92cd-fc131ed7b8df",
"value": "On-board bit storage for convenience"
},
{
"bulletedAttr": true,
"name": "Bullet04",
"guid": "8736c9b6-a1db-4bd9-a9b5-938234b899ec",
"value": "Drill mode: for drilling holes in wood, plastic and metal"
}
]
}
},
{
"groupType": "supplemental dimensions",
"entries": {
"attribute": [
{
"name": "Product Height (in.)",
"guid": "542b2138-e766-4426-aa1a-250eadc74b50",
"value": 7.87
},
{
"name": "Product Width (in.)",
"guid": "fac03a00-67f9-402b-a121-fb9448fc552d",
"value": 3.07
},
{
"name": "Product Depth (in.)",
"guid": "5ad8d718-20da-4ce0-9872-fe7c84f24bb2",
"value": 9.69
}
]
}
},
{
"groupType": "base dimensions",
"entries": {
"attribute": [
{
"name": "Certifications and Listings",
"guid": "ac0f9ad9-ce83-4a79-9c29-d4d4403908ff",
"value": "1-UL Listed"
},
{
"name": "Manufacturer Warranty",
"guid": "18a2f6bd-81b5-4c8e-9cff-15ca6824eb5a",
"value": "3 Year Manufacturer's Warranty"
}
]
}
}
]
},
"dimensions": {
"dimensionEntry": [
{
"dimensionValue": {
"name": "Hammer Drills",
"id": 571421,
"url": "https://www.homedepot.com/b/Tools-Power-Tools-Drills-Hammer-Drills/N-5yc1vZc8wt"
},
"dimensionId": 2,
"isDefaultBreadCrumb": true,
"ancestors": {
"entries": [
{
"name": "Tools",
"id": 562390,
"url": "https://www.homedepot.com/b/Tools/N-5yc1vZc1xy"
},
{
"name": "Power Tools",
"id": 562796,
"url": "https://www.homedepot.com/b/Tools-Power-Tools/N-5yc1vZc298"
},
{
"name": "Drills",
"id": 562731,
"url": "https://www.homedepot.com/b/Tools-Power-Tools-Drills/N-5yc1vZc27f"
}
]
},
"dimensionName": "Category"
},
{
"dimensionValue": {
"name": "Ryobi One Plus Starter Kit Promo",
"id": 580840
},
"dimensionId": 2,
"ancestors": {
"entries": {
"name": "Featured Products",
"id": 529469
}
},
"dimensionName": "Category"
},
{
"dimensionValue": {
"name": "Ryobi",
"id": 1688
},
"dimensionId": 4,
"ancestors": "",
"dimensionName": "Brand"
}
]
}
}
Home Depot Store Data
You can find Home Depot stores in any location using the Stores task. This reveals what stores exist in a given market with useful data about a specific store or finding store IDs to use with other Home Depot tasks.
Sample Store JSON
{
"storeId": "6175",
"name": "Manhattan West 23rd St",
"phone": "(212) 929-9571",
"address": {
"postalCode": "10010",
"county": "New York",
"state": "NY",
"country": "US",
"city": "New York",
"street": "40 West 23rd Street"
},
"coordinates": {
"lat": 40.741983,
"lng": -73.990877
},
"services": {
"loadNGo": false,
"propane": false,
"toolRental": true,
"penske": false,
"keyCutting": true,
"wiFi": true,
"applianceShowroom": false,
"expandedFlooringShowroom": false,
"largeEquipment": false,
"kitchenShowroom": true
},
"storeContacts": [
{
"name": "Richard P.",
"role": "Manager"
}
],
"storeHours": {
"monday": {
"open": "7:00",
"close": "22:00"
},
"tuesday": {
"open": "7:00",
"close": "22:00"
},
"wednesday": {
"open": "7:00",
"close": "22:00"
},
"thursday": {
"open": "7:00",
"close": "22:00"
},
"friday": {
"open": "7:00",
"close": "22:00"
},
"saturday": {
"open": "7:00",
"close": "22:00"
},
"sunday": {
"open": "8:00",
"close": "20:00"
}
},
"url": "/l/Manhattan-West-23rd-St/NY/New-York/10010/6175",
"distance": 1.4508585150318452,
"toolRentalPhone": "(212) 337-5428",
"proDeskPhone": "(212) 337-5422",
"flags": {
"bopisFlag": true,
"assemblyFlag": true,
"bossFlag": true,
"bossMsgFlag": true,
"bodfsFlag": true,
"bodfsSameDayFlag": false
},
"marketNbr": "0373",
"axGeoCode": "00",
"storeTimeZone": "EST5EDT",
"storeOpenDt": "2004-09-09",
"storeType": "retail"
}