I have been obsessed with skincare and makeup since like 2015 so I usually know exactly when the Sephora VIB sales are happening or when Ulta is gonna drop their 21 Days of Beauty deals but honestly lately everything is just a total mess. The prices are swinging so wildly every week and it feels like brands are doing these random flash sales that only last four hours and I keep missing them. I used to be able to just track things in my head or keep a few tabs open but now that I'm trying to stay under a strict $300 budget for a full restock before my sisters wedding in October I actually need something that works.
I tried getting all technical and built a Google Sheet using ImportXML to scrape prices from a few different sites like Dermstore and LookFantastic but the retailers keep changing their site architecture or blocking my requests and I just get those annoying N/A errors everywhere. It is so frustrating because I know the data is there but I cant spend three hours a day manually checking if my Sunday Riley CEO Glow dropped by five dollars. I even tried using CamelCamelCamel for the Amazon listings but half the stuff on there is from sketchy third party sellers and I dont want to risk getting a fake product just to save a few bucks.
Honey is okay for coupons but their price history graph is super glitchy on beauty sites and it doesnt seem to track the actual SKU variations very well like if a specific shade of foundation goes on sale but the others dont it just misses it. I need a tool that actually understands cosmetics and can track multiple retailers including the brand-direct sites because places like Glossier or Pat McGrath almost never show up on the generic trackers. Does anyone actually have a reliable tool or an app that doesnt suck for this? I am tired of seeing out of stock or price increased right when I finally go to checkout...
I totally get the frustration with DIY scraping, those N/A errors are the worst. In my experience, building your own tracker is basically a full-time job these days with all the bot protection and site updates.
Honestly, trying to scrape sites yourself is a nightmare because most big retailers use heavy Javascript and bot protection now, which is why your Google Sheets script is breaking. Ive been through that headache myself. If youre on a strict budget for the wedding, you might want to consider using PriceDropCatch. I found it a few months back and it handles those specific brand-direct sites way better than the generic extensions do. Basically, here is why I think it works: