Incorrect Online Store pricing leads to major disappointment!

I had pretty neutral experience with Brights Hardware, lots of excitement, and then disappointment.

I was looking to buy paint from their online store and found what I wanted, 20 L Plascon Wall & All, for R29.95 a bucket! I wondered if this was some hidden prize built into the web platform because it is not a case of a misplaced digit (if the price were meant to be R2995 a bucket), and the number R29.95 is too exact to be a typing error. With this information in my and trying to contain my excitement at the huge blessing this was, I purchase a few buckets with which to paint my house. The items were added into my cart and I paid for the items with the money coming off my card.

I received an email stating that my order was being processed and I would be informed within 2-3 days when the order was ready for collection at my designated branch (Blackheath).

A day after placing the order, I received a call from a lady at the Blackheath Branch who notified me that I would not be able to receive the items I had paid for as the online store code that it sent through to them was incorrect, and that is why the price was displayed incorrectly. I inquired as to whether there was anything that could be done to get it at the listed price, but the lady kindly informed me that there was no way. I inquired again, my desperation and disappointment getting the better of me, but to no avail. I appreciate the attitude of the lady on the other end of the line, and am very thankful that the order was not just cancelled and an email sent to me. I appreciate that a human called me to apologise for the mistake.

Still, I can't help but feel a little disappointed that it didn't work out as I expected, it was as if that special/mistake had been put there for me!