So, who’s gonna upload a receipt for me to use?
3 Likes
At the very least I could use a UPC…
Here are the details:
SKU: 1000822410
MODEL: 797977
UPC: 8718291488705
1 Like
So… A pic of a receipt showing the sale sale price is all that’s needed…
Any body? ? ? ?
Beuller? ? ?
1 Like
Ok… No receipts for us to get a price match…
I’d be the first to post if I had one…lol
1 Like
I guess the HD stores in CT don’t like none of this clearance stuff 
1 Like
My hd price matches everything… I just need a pic of a receipt.
My HD doesn’t price match shiiitttttttt!
Not quite clearance, but HD has the Gen 3 Nest Thermostat on sale for $199 for the next few days. If you price match it at lowes, they will beat it by 10%, making it $190. Just in case anyone was waiting for a great nest thermostat deal!
Here you go. Cropped out the credit card info at the bottom. But it shows the $20.03 x 4 price.
1 Like
Hopefully this doesn’t show up as too long…
I’m working on a HD.com scraper. Here are the stores that I can see that have the Hue bulb marked as clearance (SKU 1000822410). I can’t get the price so I don’t know if these are x.06, x.03 or some other price. Inventory numbers (and everything else) is YMMV.
This is csv formatted, so people can import into a spreadsheet.
Friends of Hue 40W Equivalent Adjustable Color Connected LED Bloom Lamp White Single [205316161/1000822410],,,
"6/26/2016, 11:50:32 AM",,,
Store, Quantity, Status, Aisle/Bay
"Southland / Orlando, FL",10,CLEARANCE,36 / 010
"Quincy Ii / Quincy, MA",9,CLEARANCE,
"Watsonville / Watsonville, CA",6,CLEARANCE,E8 / 006
"Westmoreland / Dallas, TX",5,CLEARANCE,SL / 020
"Delano / Delano, CA",5,CLEARANCE,E2 / 002
"Jacksonville Beach / Jacksonville Beach, FL",5,CLEARANCE,E2 / 008
"New Albany / New Albany, IN",5,CLEARANCE,
"Absecon / Absecon, NJ",4,CLEARANCE,
"Victorville / Victorville, CA",4,CLEARANCE,E2 / 001
"Gainesville,TX / Gainesville, TX",4,CLEARANCE,E2 / 004
"Marble Falls / Marble Falls, TX",4,CLEARANCE,
"Bastrop / Bastrop, TX",4,CLEARANCE,E2 / 006
"Aberdeen / Aberdeen, WA",4,CLEARANCE,
"Rhinelander / Rhinelander, WI",4,CLEARANCE,BW / 019
"Parkersburg / Vienna, WV",4,CLEARANCE,E2 / 003
"Bennington / Bennington, VT",4,CLEARANCE,
"Johnston / Johnston, RI",4,CLEARANCE,
"Easton / Easton, PA",4,CLEARANCE,
"Ada / Ada, OK",4,CLEARANCE,
"Sandusky / Sandusky, OH",4,CLEARANCE,E2 / 012
"Vicksburg / Vicksburg, MS",4,CLEARANCE,
"S Annapolis / Annapolis, MD",4,CLEARANCE,
"Owensboro / Owensboro, KY",4,CLEARANCE,
"Paducah / Paducah, KY",4,CLEARANCE,
"Auburn,IN / Auburn, IN",4,CLEARANCE,E3 / 002
"Albany,NY / Albany, NY",4,CLEARANCE,FE / 009
"Greer / Greer, SC",4,CLEARANCE,
"Parsippany / Parsippany, NJ",3,CLEARANCE,E2 / 003
"Huntsville,TX / Huntsville, TX",3,CLEARANCE,E2 / 007
"Tucker / Norcross, GA",3,CLEARANCE,
"Oak Harbor / Oak Harbor, WA",3,CLEARANCE,E2 / 004
"Wake Forest / Wake Forest, NC",3,CLEARANCE,41 / 018
"W Asheville / Asheville, NC",3,CLEARANCE,
"South Charlotte / Charlotte, NC",3,CLEARANCE,
"Jackson / Jackson, MI",3,CLEARANCE,E2 / 014
"Benton Harbor / Benton Harbor, MI",3,CLEARANCE,40 / 006
"Topsham / Topsham, ME",3,CLEARANCE,E6 / 006
"Hutchinson / Hutchinson, KS",3,CLEARANCE,E3 / 001
"Peoria,IL / Peoria, IL",3,CLEARANCE,
"Vallejo / Vallejo, CA",2,CLEARANCE,E2 / 020
"Sierra Vista / Sierra Vista, AZ",2,CLEARANCE,E2 / 003
"Texarkana / Texarkana, TX",2,CLEARANCE,03 / 009
"Venice / Venice, FL",2,CLEARANCE,39 / 017
"Kissimmee / Kissimmee, FL",2,CLEARANCE,E3 / 002
"College Station / College Station, TX",2,CLEARANCE,06 / 021
"Wenatchee / Wenatchee, WA",2,CLEARANCE,E2 / 003
"Lebanon,PA / Lebanon, PA",2,CLEARANCE,E2 / 008
"Tulsa Central / Tulsa, OK",2,CLEARANCE,03 / 009
"E Wyoming / Wyoming, MI",2,CLEARANCE,E2 / 004
"Pasadena,MD / Glen Burnie, MD",2,CLEARANCE,
"Turfland / Lexington, KY",2,CLEARANCE,99 / 007
"S Overland Park / Overland Park, KS",2,CLEARANCE,
"Bettendorf / Bettendorf, IA",2,CLEARANCE,E2 / 014
"Eagle Creek / Indianapolis, IN",2,CLEARANCE,43 / 013
"Ewing / Ewing, NJ",1,CLEARANCE,
"Pelham / Pelham, AL",1,CLEARANCE,BW / 004
"Franklin,TN / Franklin, TN",1,CLEARANCE,47 / 020
"Show Low / Show Low, AZ",1,CLEARANCE,
"Victoria / Victoria, TX",1,CLEARANCE,
"Spring Cypress / Cypress, TX",1,CLEARANCE,
"Weslaco / Weslaco, TX",1,CLEARANCE,
"Oviedo / Oviedo, FL",1,CLEARANCE,35 / 032
"Cape Coral / Cape Coral, FL",1,CLEARANCE,01 / 003
"Hamilton Mill / Dacula, GA",1,CLEARANCE,E4 / 006
"W Seattle / Seattle, WA",1,CLEARANCE,
"Carrollton / Carrollton, TX",1,CLEARANCE,E2 / 009
"West Port St Lucie / Port Saint Lucie, FL",1,CLEARANCE,E4 / 002
"Biloxi / Biloxi, MS",1,CLEARANCE,E3 / 001
"S Attleboro / South Attleboro, MA",1,CLEARANCE,E4 / 012
"Rockland,ME / Rockland, ME",1,CLEARANCE,E1 / 006
"St Matthews / Louisville, KY",1,CLEARANCE,07 / 003
"Cedar Rapids / Cedar Rapids, IA",1,CLEARANCE,E3 / 018
"Post Road / Indianapolis, IN",1,CLEARANCE,E2 / 006
"Marion / Marion, IL",1,CLEARANCE,
"Elston/Leavitt / Chicago, IL",1,CLEARANCE,01 / 002
"S Fontana / Fontana, CA",1,CLEARANCE,E2 / 005
"Murrells Inlet / Murrells Inlet, SC",1,CLEARANCE,E2 / 008
"Ridgecrest / Ridgecrest, CA",1,CLEARANCE,
"Hercules / Hercules, CA",1,CLEARANCE,E3 / 015
"N Fresno / Fresno, CA",1,CLEARANCE,E3 / 016
"Newton / Newton, NJ",0,CLEARANCE,
"E Windsor / East Windsor, NJ",0,CLEARANCE,
"Freehold / Freehold, NJ",0,CLEARANCE,01 / 001
"Chattanooga / Chattanooga, TN",0,CLEARANCE,
"Centerline / Knoxville, TN",0,CLEARANCE,34 / 009
"Thompson Lane / Nashville, TN",0,CLEARANCE,
"Collierville / Collierville, TN",0,CLEARANCE,BW / 044
"Maryville / Maryville, TN",0,CLEARANCE,E2 / 005
"Johnson City / Johnson City, TN",0,CLEARANCE,E3 / 006
"Rohnert Pk / Rohnert Park, CA",0,CLEARANCE,E2 / 013
"Fair Ave / San Antonio, TX",0,CLEARANCE,E4 / 002
"Wylie / Wylie, TX",0,CLEARANCE,
"Bridgepoint / Corpus Christi, TX",0,CLEARANCE,
"Abilene / Abilene, TX",0,CLEARANCE,
"Terrell / Terrell, TX",0,CLEARANCE,E3 / 002
"Kerrville / Kerrville, TX",0,CLEARANCE,E2 / 007
"Galveston / Galveston, TX",0,CLEARANCE,
"Flower Mound / Flower Mound, TX",0,CLEARANCE,05 / 014
"Silverlake / Pearland, TX",0,CLEARANCE,
"Slaughter Lane / Austin, TX",0,CLEARANCE,RT / 003
"N Lafayette / Lafayette, LA",0,CLEARANCE,E2 / 004
"Denham Springs / Denham Springs, LA",0,CLEARANCE,E2 / 007
"Holiday / Holiday, FL",0,CLEARANCE,E3 / 001
"Leesburg, FL / Leesburg, FL",0,CLEARANCE,
"Jupiter / Jupiter, FL",0,CLEARANCE,
"Lake Mary / Lake Mary, FL",0,CLEARANCE,
"Forest City / Altamonte Springs, FL",0,CLEARANCE,
"Casselberry / Casselberry, FL",0,CLEARANCE,E5 / 002
"Port Richey / Port Richey, FL",0,CLEARANCE,E3 / 009
"Southside / Jacksonville, FL",0,CLEARANCE,
"Vero Beach / Vero Beach, FL",0,CLEARANCE,E4 / 003
"Lake Wales / Lake Wales, FL",0,CLEARANCE,E2 / 011
"Peachtree City / Peachtree City, GA",0,CLEARANCE,
"Chesterfield,MO / Chesterfield, MO",0,CLEARANCE,
"Moses Lake / Moses Lake, WA",0,CLEARANCE,
"S Reno / Reno, NV",0,CLEARANCE,
"Ukiah / Ukiah, CA",0,CLEARANCE,
"Vh-Elizabeth / Elizabeth, NJ",0,CLEARANCE,
"Toccoa,GA / Toccoa, GA",0,CLEARANCE,
"Bustleton Ave / Philadelphia, PA",0,CLEARANCE,E2 / 003
"W Tallahassee / Tallahassee, FL",0,CLEARANCE,
"W St Petersburg / Saint Petersburg, FL",0,CLEARANCE,
"Palm Coast / Palm Coast, FL",0,CLEARANCE,E4 / 003
"W Kendall / Miami, FL",0,CLEARANCE,E3 / 004
"Corning / Painted Post, NY",0,CLEARANCE,E4 / 004
"Menomonee Falls / Menomonee Falls, WI",0,CLEARANCE,E3 / 002
"Charleston,WV / Charleston, WV",0,CLEARANCE,
"Huntington / Barboursville, WV",0,CLEARANCE,E3 / 001
"Ashburn / Ashburn, VA",0,CLEARANCE,E4 / 003
"Marple / Broomall, PA",0,CLEARANCE,
"Tullytown / Levittown, PA",0,CLEARANCE,E4 / 003
"Ontario,OR / Ontario, OR",0,CLEARANCE,E2 / 005
"Klamath Falls / Klamath Falls, OR",0,CLEARANCE,
"Salem, OR / Salem, OR",0,CLEARANCE,E2 / 008
"Bowling Green, OH / Bowling Green, OH",0,CLEARANCE,
"Avon,OH / Avon, OH",0,CLEARANCE,RT / 003
"Macedonia / Macedonia, OH",0,CLEARANCE,48 / 008
"Fuquay Varina / Fuquay Varina, NC",0,CLEARANCE,
"E Greensboro / Greensboro, NC",0,CLEARANCE,E3 / 009
"Winston Salem / Winston Salem, NC",0,CLEARANCE,E3 / 003
"Durham / Durham, NC",0,CLEARANCE,E3 / 002
"Kannapolis / Kannapolis, NC",0,CLEARANCE,E2 / 002
"Gastonia / Gastonia, NC",0,CLEARANCE,
"University / Charlotte, NC",0,CLEARANCE,35 / 013
"Matthews / Matthews, NC",0,CLEARANCE,E3 / 002
"Roswell,NM / Roswell, NM",0,CLEARANCE,
"Nashua Mall / Nashua, NH",0,CLEARANCE,
"Hooksett / Hooksett, NH",0,CLEARANCE,E2 / 013
"Spanish Springs / Sparks, NV",0,CLEARANCE,
"Carson City / Carson City, NV",0,CLEARANCE,
"W Reno / Reno, NV",0,CLEARANCE,
"Reno / Reno, NV",0,CLEARANCE,
"Carson City,NV / Carson City, NV",0,CLEARANCE,
"N Reno / Reno, NV",0,CLEARANCE,
"Grand Island / Grand Island, NE",0,CLEARANCE,
"Madison, MS / Madison, MS",0,CLEARANCE,E3 / 004
"Hattiesburg / Hattiesburg, MS",0,CLEARANCE,E2 / 005
"Gulfport / Gulfport, MS",0,CLEARANCE,E3 / 002
"Auburn Hills / Auburn Hills, MI",0,CLEARANCE,E3 / 014
"Bay City / Bay City, MI",0,CLEARANCE,TR / 008
"Quincy / Quincy, MA",0,CLEARANCE,33 / 009
"Tewksbury / Tewksbury, MA",0,CLEARANCE,E3 / 003
"Greenfield,MA / Greenfield, MA",0,CLEARANCE,
"Towson / Parkville, MD",0,CLEARANCE,33 / 013
"Elizabethtown / Elizabethtown, KY",0,CLEARANCE,E2 / 001
"Lexington / Lexington, KY",0,CLEARANCE,
"S Olathe / Olathe, KS",0,CLEARANCE,
"Lawrence / Lawrence, KS",0,CLEARANCE,02 / 010
"Leavenworth / Leavenworth, KS",0,CLEARANCE,E3 / 004
"Valparaiso / Valparaiso, IN",0,CLEARANCE,
"Seymour / Seymour, IN",0,CLEARANCE,E3 / 003
"Castleton / Indianapolis, IN",0,CLEARANCE,E2 / 002
"Noblesville / Noblesville, IN",0,CLEARANCE,E2 / 008
"Southport / Indianapolis, IN",0,CLEARANCE,
"Elgin / Elgin, IL",0,CLEARANCE,01 / 003
"Rockford / Rockford, IL",0,CLEARANCE,E8 / 002
"Flowery Branch / Flowery Branch, GA",0,CLEARANCE,01 / 002
"Gainesville Ne / Gainesville, FL",0,CLEARANCE,E3 / 003
"Dover,DE / Dover, DE",0,CLEARANCE,35 / 010
"Benton / Benton, AR",0,CLEARANCE,E2 / 003
"N Myrtle Beach / North Myrtle Beach, SC",0,CLEARANCE,E3 / 003
"Hilton Head / Bluffton, SC",0,CLEARANCE,
7 Likes
I went to the top two locations online, and this is what they show:
When calling them up to see if I could place the order over the phone, they would only do it if I walked in to pick it up. They wouldn’t ship.
For whatever reason Home Depot likes to hide the inventory on their website for clearance items and they never show clearance prices. I would doubt you can get them to ship from a store.
I posted the list so people could look for a local store. If you go to one of these stores and it looks like it is full price, do a price check at the register. There is a good chance the updated label just wasn’t posted.
The list includes those showing zero inventory. They probably are out of stock, but the inventory can be off and I’m not confident that all the zeroes are correct.
No, I understand it’s purpose here in this thread (and thank you BTW - I’m considering the 2 hour drive to Orlando myself), but you said that you were working on a scraper, and while it’s good to plug a sku in, I’m wondering if it would be cool to plug a store number in and get all product marked clearance? That way you can query the store before you go
I’ve thought about that, but haven’t created it yet. Instead of everything, it would use a search term like “hammer” or “Husky”.
Thanks for the list! Struck out at the 5 HD I tried this weekend, which your list shows as inventory of 0. But I see 3 showing at a store I will be only a few miles from tomorrow that I was going to skip, but I’ll give that one a shot.
Forgive my ignorance. What is special about these hue bulbs? Why would I want one? I am driving cross country right now to Mississippi to see my 91 year old mom. I have no Hue bulbs…do I have Ave to have a hue hub? What do y’all do with them?
It’s not so much as needing them… lol… I have 4 sets of the hue lights strips, 2 hue blooms, and a hue Iris sitting on the table… I have no idea what I’m going to do with them… so they are sitting there with the other 30 devices I have that I have not found a use for yet…
But at the 90% (average) mark down I got everything for… It’s ok if they sit there… lol
It’s an addiction… one that I love!!!
5 Likes