If you do any sort of software or web development, then those headslap/facepalm moments are probably more common than for most ‘ordinary’ people. They usually also involve utterances such as ‘So THAT’S why it doesn’t work?! How come I am SO DUMB?! How did I not notice that?! WHEN did I break that?! WHY did …
Finally – you can now type an Amazon ASIN into the search box above and get a list of products, including the UPC. Try it now! Search for B07XLGMM47 (example). You can use this to reverse search UPCs from ASINs, the 10-digit code beginning with B that all Amazon products have. Go to Amazon and …
Apologies to users for the incredibly slow running of the site recently. It took ages to first realise there was a problem and then get round to checking it out, and then actually fix it. Turns out we broke something in an update a while back – what a surprise. So for the techies, basically …
After fixing the problem with our SSL certificate we took the opportunity to look into a few more bugs that have been present for a while but never properly addressed, mostly to do with the PriceTracker: PriceTracker storing 0.00 prices:Ā for whatever reason, some vendors report prices of 0.00. Obviously they are not giving anything away, …
Sorry if you got a scary warning visiting our site over the last few hours – our SSL certificate, the cypher that all modern websites use to keep your browsing private – expired briefly. Many browsers, Chrome especially, start throwing panicky warnings about criminals stealing your data and whatnot. We assure you that the chances …
Just checking in to apologise if you couldn’t reach UPCZilla over the last 24 hours. A server misconfiguration, possibly coupled with some kind of DDoS attack, caused our server to completely fail, and as luck would have it nobody noticed for almost a day – seemingly our emergency notification also failed. Sigh… So it’s back …
We did it – we made 2,000,000 UPCs! Let’s make it clear – quality is the goal on UPCZilla, not quantity. We could probably have dumped huge numbers of UPCs into our database a long time ago, but we prefer a slow and steady approach. There are technical issues to address, we need to make …
Recently UPCZilla saw a major drop in traffic from Google. We quickly realised it was very likely due to the large number of soft 404s the Googlebot was finding, as well as excessive 500 errors due to some unoptimised database queries causing MySQL to hang when traffic was heavy. The soft 404s, it turned out, …
This won’t interest most visitors to this site, but I had to post it somewhere as it will help someone out there, so it’s filed under Techie stuff. A bout of heavy Google crawling of the site forced me to look at some of our slow database queries, which could be overlooked when we had …