Lowe's Scraper

ENDPOINTS
GET/products/lookup

Product Lookup

Resolve an item number, model number or UPC to the one product it names, with the full product record.

QUERY PARAMS

An item number (the "Item #" on the product page and shelf tag), a manufacturer model number, or a UPC barcode (1-80 characters).

Examples:

  • Model number: DCD793D1
  • Item number: 5220845
{
  "query": "DCD793D1",
  "product_id": "5014148635",
  "product": {
    "id": "5014148635",
    "item_number": "5220845",
    "model_number": "DCD793D1",
    "upc": "885911904919",
    "name": "DEWALT 20-volt Max 1/2-in Keyless Brushless Cordless Drill 1 -Batteries Included, and Charger Included",
    "brand": "DEWALT",
    "link": "https://www.lowes.com/pd/DEWALT-20-volt-Max-Brushless-Drill-1-Battery-Included-Charger-Included-and-Soft-Bag-included/5014148635",
    "description": "Get up to 16% more power** with the new 20V MAX* Brushless 1/2 in. Drill/Driver. At over 2 in. shorter in length** (tool head length only) at 6.38 in. and 404 unit watts out, this brushless drill/driver can complete a variety of drilling applications on the jobsite. The on-tool LED work light helps to provide illumination to maximize efficiency and productivity.",
    "short_description": "20-volt Max 1/2-in Keyless Brushless Cordless Drill 1 -Batteries Included, and Charger Included",
    "highlights": [
      "Over 2-in shorter in length at 6.38-in (tool head length only) to tackle tough jobs",
      "Get up to 16% more power with 404 UWO and up to 1,650 RPMs no load for a variety of drilling applications",
      "High bit retention with 1/2-in ratcheting chuck",
      "Illuminate workspaces using the on-tool LED work light",
      "Includes : (1) 20V MAX* Brushless Cordless 1/2-in Drill/Driver, (1) DCB203 20V MAX* 2.0Ah Battery, (1) DCB107 12V/20V MAX* Li-ion Battery Charger, (1) Belt Hook",
      "**The DCD793 is over 2-in shorter in length compared to DCD771, tool head length only",
      "***The DEWALT® DCD793 with a DEWALT® DCB203 battery provides up to 16% more power versus DEWALT® DCD771 with a DEWALT® DCB203 battery"
    ],
    "image": "https://mobileimages.lowes.com/productimages/00257ce0-26b9-42f6-97ae-c8d32e4c96c4/74509365.tiff",
    "images": [
      "https://mobileimages.lowes.com/productimages/00257ce0-26b9-42f6-97ae-c8d32e4c96c4/74509365.tiff",
      "https://mobileimages.lowes.com/productimages/9064656c-563a-4125-b074-99e4b9092989/75331790.jpeg",
      "https://mobileimages.lowes.com/productimages/2f13bf66-2e21-48dd-8dcf-af61459d3f75/62621397.jpg",
      "https://mobileimages.lowes.com/productimages/0a2bf918-4535-4ddf-aefd-7e229c77bc57/62621406.jpg",
      "https://mobileimages.lowes.com/productimages/6e07e917-aae2-4c36-93d6-9250606ac19a/62529511.jpg",
      "https://mobileimages.lowes.com/productimages/3089bce2-4870-4132-af68-01fb229288d2/63838223.jpg",
      "https://mobileimages.lowes.com/productimages/58879b16-21ac-48db-8348-e57708427a7e/62529514.jpg",
      "https://mobileimages.lowes.com/productimages/75a0e018-549c-4105-98cd-21034749589f/62529512.jpg",
      "https://mobileimages.lowes.com/productimages/896097f2-0bfd-49a2-952c-330860fcbcfd/62529515.jpg",
      "https://mobileimages.lowes.com/productimages/367f196b-6491-4fcf-b32d-2af0ed5957af/62529507.jpg",
      "https://mobileimages.lowes.com/productimages/989e4695-8439-47a5-a2b6-19e5aff816db/62621395.jpg",
      "https://mobileimages.lowes.com/productimages/2f4b9874-f8b7-4f2a-8a17-278edbcbfc50/69123822.jpeg",
      "https://mobileimages.lowes.com/productimages/ce9e7d14-6f62-451b-8c91-6ac07edde2d4/65561066.jpg"
    ],
    "videos": [
      {
        "title": "Product Marketing Video",
        "link": "https://cdnapisec.kaltura.com/p/4215793/sp/421579300/playManifest/entryId/1_uesoxuz3/format/applehttp/protocol/https",
        "thumbnail": "https://mobileimages.lowes.com/productimages/cac4d1ae-0474-40bc-978f-d944ad60508e/DW-Lowes-Product-Spot-30sec-16x9-EN-VCV2_thumbnail.jpg",
        "duration_seconds": 32
      }
    ],
    "has_360_view": true,
    "rating": 4.5,
    "review_count": 791,
    "brand_rating": null,
    "brand_review_count": null,
    "price": {
      "amount": 99,
      "was": null,
      "savings": null,
      "is_on_sale": false,
      "is_deal_of_the_day": false,
      "min": null,
      "max": null,
      "is_range": false,
      "type": "network",
      "currency": "USD"
    },
    "price_per_unit": null,
    "store": {
      "number": "0595",
      "name": "Mooresville Lowe's",
      "city": "Mooresville",
      "state": "NC",
      "zip": "28117",
      "link": "https://www.lowes.com/store/NC-Mooresville/0595"
    },
    "is_in_stock": true,
    "store_quantity": 33,
    "network_quantity": 85,
    "store_location": {
      "aisle": "15",
      "bay": "ENDCAP FRONT"
    },
    "store_locations": [
      {
        "aisle": "15",
        "bay": "ENDCAP FRONT",
        "section": "FASHION ELECTRICAL"
      },
      {
        "aisle": "69",
        "bay": "1",
        "section": "TOOLS"
      },
      {
        "aisle": "330",
        "bay": "PBT01",
        "section": null
      },
      {
        "aisle": "2",
        "bay": "ECF",
        "section": "HARDWARE"
      }
    ],
    "fulfillment": {
      "shipping": {
        "is_available": true,
        "quantity": 15,
        "network_quantity": 70,
        "lead_time_days": 2,
        "earliest_date": "2026-10-31"
      },
      "pickup": {
        "is_available": false,
        "quantity": 33,
        "network_quantity": 103,
        "lead_time_days": 0,
        "earliest_date": "2026-10-29",
        "nearest_stores": [
          {
            "store_number": "2697",
            "distance_miles": 45.7,
            "is_available": true,
            "quantity": 15
          },
          {
            "store_number": "1812",
            "distance_miles": 53.1,
            "is_available": true,
            "quantity": 18
          },
          {
            "store_number": "2568",
            "distance_miles": 54,
            "is_available": true,
            "quantity": 26
          },
          {
            "store_number": "1874",
            "distance_miles": 71.8,
            "is_available": true,
            "quantity": 86
          },
          {
            "store_number": "3444",
            "distance_miles": 81.1,
            "is_available": true,
            "quantity": 18
          },
          {
            "store_number": "2479",
            "distance_miles": 82.7,
            "is_available": true,
            "quantity": 23
          },
          {
            "store_number": "2432",
            "distance_miles": 85,
            "is_available": true,
            "quantity": 22
          },
          {
            "store_number": "0246",
            "distance_miles": 88.8,
            "is_available": true,
            "quantity": 18
          }
        ]
      },
      "delivery": {
        "is_available": true,
        "quantity": 0,
        "network_quantity": 103,
        "lead_time_days": 1,
        "earliest_date": "2026-10-29"
      },
      "same_day_delivery": {
        "is_available": false,
        "quantity": 33,
        "network_quantity": 33,
        "lead_time_days": null,
        "earliest_date": null,
        "carrier": "GIG_DELIVERY"
      }
    },
    "has_free_delivery": false,
    "promotions": [
      {
        "id": "100000135895",
        "name": "Free Parcel Shipping $25 Guest Customers - UPS",
        "label": "Free Delivery",
        "kind": "ExtOrderLevelFixedShippingDiscount",
        "group": "ShippingPromotion",
        "starts_at": "2026-04-28T00:00:00Z",
        "ends_at": null
      },
      {
        "id": "100000123950",
        "name": "Free Parcel Shipping MLR Customers - UPS",
        "label": "Free Delivery",
        "kind": "ExtOrderLevelFixedShippingDiscount",
        "group": "ShippingPromotion",
        "starts_at": "2026-02-02T00:00:00Z",
        "ends_at": null
      },
      {
        "id": "100000124000",
        "name": "2.99 Gig Delivery Micro 1/31/2026-no end date MLR",
        "label": "Delivery",
        "kind": "ExtOrderLevelFixedShippingDiscount",
        "group": "ShippingPromotion",
        "starts_at": "2026-02-02T00:00:00Z",
        "ends_at": null
      },
      {
        "id": "100000125948",
        "name": "Nationwide $25 Minimum Threshold Micro GIG MLR",
        "label": "Free Delivery",
        "kind": "ExtOrderLevelFixedShippingDiscount",
        "group": "ShippingPromotion",
        "starts_at": "2026-02-23T00:00:00Z",
        "ends_at": null
      },
      {
        "id": "100000125950",
        "name": "Nationwide $25 Minimum Threshold Micro $4.99 GIG Guests",
        "label": "Delivery",
        "kind": "ExtOrderLevelFixedShippingDiscount",
        "group": "ShippingPromotion",
        "starts_at": "2026-02-23T00:00:00Z",
        "ends_at": null
      },
      {
        "id": "8922198449360845083",
        "name": "5 OFF WITH LCC CARD CREDIT NEW .com",
        "label": "Financing Discount",
        "kind": "ExtLCCOrderLevelPercentDiscount",
        "group": "OrderLevelPromotion",
        "starts_at": "2025-02-19T00:00:00Z",
        "ends_at": null
      }
    ],
    "max_purchase_quantity": null,
    "specifications": [
      {
        "name": "Sub-Brand",
        "value": "N/A",
        "group": "General"
      },
      {
        "name": "Package Quantity",
        "value": "1",
        "group": "General"
      },
      {
        "name": "Battery Type",
        "value": "Lithium ion (Li-ion)",
        "group": "General"
      },
      {
        "name": "Battery Voltage",
        "value": "20-volt max",
        "group": "General"
      },
      {
        "name": "Chuck Type",
        "value": "Keyless",
        "group": "General"
      },
      {
        "name": "Handle Type",
        "value": "Ergonomic",
        "group": "General"
      },
      {
        "name": "Number of Clutch Settings",
        "value": "15",
        "group": "General"
      },
      {
        "name": "Amperage",
        "value": "0",
        "group": "Dimensions"
      },
      {
        "name": "Cord Length (Feet)",
        "value": "0",
        "group": "Dimensions"
      },
      {
        "name": "Tool Weight (lbs.)",
        "value": "5",
        "group": "Dimensions"
      },
      {
        "name": "Tool Length (Inches)",
        "value": "12",
        "group": "Dimensions"
      },
      {
        "name": "Battery Amp Hours",
        "value": "2",
        "group": "Dimensions"
      },
      {
        "name": "Maximum Chuck Size",
        "value": "1/2-in",
        "group": "Dimensions"
      },
      {
        "name": "Tool Width (Inches)",
        "value": "3.25",
        "group": "Dimensions"
      },
      {
        "name": "Tool Height (Inches)",
        "value": "9",
        "group": "Dimensions"
      },
      {
        "name": "Number of Batteries Included",
        "value": "1",
        "group": "Features"
      },
      {
        "name": "Maximum Speed (RPM)",
        "value": "1650",
        "group": "Features"
      },
      {
        "name": "Brushless",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Right Angle",
        "value": "No",
        "group": "Features"
      },
      {
        "name": "Forward and Reverse Switch Included",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Hybrid Capable",
        "value": "No",
        "group": "Features"
      },
      {
        "name": "Accessories Included",
        "value": "No",
        "group": "Features"
      },
      {
        "name": "Charge Time (Minutes)",
        "value": "30",
        "group": "Features"
      },
      {
        "name": "Variable Speed",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Charger Included",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Battery Included",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Cordless",
        "value": "Yes",
        "group": "Features"
      },
      {
        "name": "Tool Power Output",
        "value": "404 UWO",
        "group": "Features"
      },
      {
        "name": "Side Handle Included",
        "value": "No",
        "group": "Features"
      },
      {
        "name": "Works with iOS",
        "value": "No",
        "group": "Compatibility"
      },
      {
        "name": "Works with Android",
        "value": "No",
        "group": "Compatibility"
      },
      {
        "name": "Wi-Fi Compatibility",
        "value": "No",
        "group": "Compatibility"
      },
      {
        "name": "App Compatibility",
        "value": "No",
        "group": "Compatibility"
      },
      {
        "name": "Bluetooth Compatibility",
        "value": "No",
        "group": "Compatibility"
      },
      {
        "name": "Warranty",
        "value": "3-year limited",
        "group": "Warranty"
      },
      {
        "name": "Battery Warranty",
        "value": "2-year limited",
        "group": "Warranty"
      },
      {
        "name": "CA Residents: Prop 65 Warning(s)",
        "value": "No",
        "group": "Certifications"
      },
      {
        "name": "Safety Listing",
        "value": "UL safety listing",
        "group": "Certifications"
      },
      {
        "name": "Features",
        "value": null,
        "group": "Hidden"
      },
      {
        "name": "Number of Removable Battery(s)",
        "value": "1",
        "group": "Hidden"
      },
      {
        "name": "Included",
        "value": null,
        "group": "Hidden"
      },
      {
        "name": "Removable Battery(s) Included",
        "value": "Yes",
        "group": "Hidden"
      },
      {
        "name": "Removable Battery(s) Type",
        "value": "Lithium ion (Li-ion)",
        "group": "Hidden"
      },
      {
        "name": "Height (Inches)",
        "value": "9",
        "group": "Hidden"
      },
      {
        "name": "Length (Inches)",
        "value": "12",
        "group": "Hidden"
      },
      {
        "name": "Width (Inches)",
        "value": "3.25",
        "group": "Hidden"
      },
      {
        "name": "UNSPSC",
        "value": "27112700",
        "group": "Miscellaneous"
      }
    ],
    "key_specs": [
      {
        "name": "Cordless",
        "value": "Yes",
        "group": null
      },
      {
        "name": "Brushless",
        "value": "Yes",
        "group": null
      },
      {
        "name": "Battery Included",
        "value": "Yes",
        "group": null
      }
    ],
    "dimensions": {
      "width": {
        "value": 3.25,
        "unit": "Inches"
      },
      "height": {
        "value": 9,
        "unit": "Inches"
      },
      "depth": {
        "value": 12,
        "unit": "Inches"
      },
      "weight": {
        "value": 5,
        "unit": "lbs."
      },
      "volume": {
        "value": 0.203125,
        "unit": "Cu. Feet"
      },
      "net_content": {
        "value": 1,
        "unit": "Count"
      }
    },
    "documents": null,
    "barcodes": [
      {
        "code": "10198706012537",
        "level": "CASE",
        "quantity": 3
      },
      {
        "code": "40028877644927",
        "level": "CASE",
        "quantity": 3
      },
      {
        "code": "60885911669599",
        "level": "PLLT",
        "quantity": 180
      },
      {
        "code": "885911904919",
        "level": "EACH",
        "quantity": 1
      }
    ],
    "program_type": "stock",
    "selling_channels": [
      "Store",
      "Online"
    ],
    "is_buyable": true,
    "is_special_order": false,
    "is_marketplace": false,
    "is_lowes_exclusive": false,
    "is_energy_star": false,
    "is_discontinued": false,
    "status": "ACTIVE",
    "hazmat": {
      "code": "L",
      "description": "Item is a lithium ion battery with Watt hours (Wh) </= to 100 Wh and Battery Packed with Equipment"
    },
    "prop_65_warning": null,
    "social_proof": {
      "bought_last_week": "1K+ bought last week",
      "bought_last_month": "5K+ bought last month",
      "pros_bought_last_week": "80 Pros bought last week",
      "pros_bought_last_month": "100+ Pros bought last month",
      "repeat_buyers": "1K+ bought multiple times"
    },
    "collection": {
      "id": "GR_19966",
      "type": "PCR_GROUP",
      "link": "https://www.lowes.com/collections/DEWALT-20-Volt-Max-1-2-In-Keyless-Brushless-Cordless-Drill-1-Battery-Charger-Included-With-6-1-2-In-Cordless-Circular-Saw/GR_19966"
    },
    "collections": [
      {
        "id": "GR_19966",
        "name": "20-Volt Max 1/2-In Keyless Brushless Cordless Drill (1 Battery & Charger Included) With 6-1/2-In Cordless Circular Saw",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20-Volt-Max-1-2-In-Keyless-Brushless-Cordless-Drill-1-Battery-Charger-Included-With-6-1-2-In-Cordless-Circular-Saw/GR_19966",
        "image": "https://mobileimages.lowes.com/productimages/19e982a6-7344-488d-9e30-e19378ca468d/82916442.jpeg",
        "price": {
          "amount": 338,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "3962443",
          "5014148635"
        ],
        "is_available": true
      },
      {
        "id": "GR_15733",
        "name": "20V Max 1/2-in Keyless Brushless Cordless Drill & 4.5-in 20V Max Trigger Switch Cordless Angle grinder",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20V-Max-1-2-in-Keyless-Brushless-Cordless-Drill-4-5-in-20V-Max-Trigger-Switch-Cordless-Angle-grinder/GR_15733",
        "image": "https://mobileimages.lowes.com/productimages/c29e6238-8574-471b-ac19-6e34075c8eab/74547235.jpeg",
        "price": {
          "amount": 338,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "3962539",
          "5014148635"
        ],
        "is_available": false
      },
      {
        "id": "GR_15742",
        "name": "20-volt Max 1/2-in Keyless Brushless Cordless Drill & 20-volt Max Variable Speed Cordless Reciprocating Saw",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20-volt-Max-1-2-in-Keyless-Brushless-Cordless-Drill-20-volt-Max-Variable-Speed-Cordless-Reciprocating-Saw/GR_15742",
        "image": "https://mobileimages.lowes.com/productimages/b2c75ff7-01de-4792-9a89-4f63721ca7ba/74547230.jpeg",
        "price": {
          "amount": 338,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "3962537",
          "5014148635"
        ],
        "is_available": true
      },
      {
        "id": "GR_19970",
        "name": "20-Volt Max 1/2-In Keyless Brushless Cordless Drill (1 Battery & Charger Included) With 1/4-In Brushless Cordless Impact Driver",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20-Volt-Max-1-2-In-Keyless-Brushless-Cordless-Drill-1-Battery-Charger-Included-With-1-4-In-Brushless-Cordless-Impact-Driver/GR_19970",
        "image": "https://mobileimages.lowes.com/productimages/b5c6f748-b39c-4ec4-90f8-3d5e8135e0ab/82916425.jpeg",
        "price": {
          "amount": 338,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "5013829393",
          "5014148635"
        ],
        "is_available": false
      },
      {
        "id": "GR_18772",
        "name": "20V Max 1/2-in Keyless Cordless Drill w/ battery and charger + 20V 4 Ah Battery",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20V-Max-1-2-in-Keyless-Cordless-Drill-w-battery-and-charger-20V-4-Ah-Battery/GR_18772",
        "image": "https://mobileimages.lowes.com/productimages/0cb35b7c-812d-4e16-800c-31924d4e2ec8/75867777.jpeg",
        "price": {
          "amount": 312.21,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "50238973",
          "5014148635"
        ],
        "is_available": true
      },
      {
        "id": "GR_18771",
        "name": "20V Max 1/2-in Keyless Cordless Drill w/ battery and charger & 4 -Piece Oscillating Multi-Tool",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20V-Max-1-2-in-Keyless-Cordless-Drill-w-battery-and-charger-4-Piece-Oscillating-Multi-Tool/GR_18771",
        "image": "https://mobileimages.lowes.com/productimages/e49cb290-0a0a-4557-bd58-36b9463f4069/75867773.jpeg",
        "price": {
          "amount": 398,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "1001008764",
          "5014148635"
        ],
        "is_available": true
      },
      {
        "id": "GR_18770",
        "name": "20V Max 1/2-in Keyless Cordless Drill w/ battery and charger & 1/2-in square Drive Cordless Impact Wrench",
        "brand": "DEWALT",
        "type": "PCR_GROUP",
        "link": "https://www.lowes.com/collections/DEWALT-20V-Max-1-2-in-Keyless-Cordless-Drill-w-battery-and-charger-1-2-in-square-Drive-Cordless-Impact-Wrench/GR_18770",
        "image": "https://mobileimages.lowes.com/productimages/6f1b4a8a-5ae8-42e8-8807-637310844551/75867762.jpeg",
        "price": {
          "amount": 398,
          "was": null,
          "currency": "USD"
        },
        "member_ids": [
          "5013016129",
          "5014148635"
        ],
        "is_available": true
      }
    ],
    "faq": null,
    "category_id": "100529",
    "hierarchy": {
      "business_area": "HARDLINES",
      "division": "POWER EQUIPMENT",
      "sub_division": "HANDHELD POWER TOOLS",
      "product_group": "DEWALT 20V POWER TOOLS",
      "assortment": "DEWALT 20V KITTED TOOLS"
    },
    "vendor_number": "70",
    "created_at": "2022-08-05T14:10:06Z",
    "updated_at": "2026-10-19T05:01:19Z"
  }
}