Sephora Advent Calendar Not Prepared In Store - Refund Still Not Received

I purchased the Sephora Benefit Glam Cube Advent Calendar through the “pick up in store within 2 hours” option on Sephora’s online website because it was out of stock online, and I completed the payment. Although the product was supposed to be ready the same day, when I traveled from Tekirdağ to Istanbul — a 2-hour trip — the next day and went to the Sephora Nişantaşı store, I was told that the product was not available and that my order would be canceled. They did not deliver the product I had purchased, causing a significant loss of time and money. My order was canceled by Sephora the same day, and despite paying approximately ₺10,500, I still have not received a refund after three days. I have also not been provided with any information regarding the refund; the only thing visible on my account is a notice stating that my order was canceled. In addition, around ten days ago, due to a customer service error, my Black Card membership, worth 20–30 thousand points, was removed from my account. I have contacted customer service many times about this issue, messaged their Instagram account, and called customer support, yet I have not been offered any solution and have received no response. I have experienced similar problems before, and I am extremely uncomfortable with Sephora repeatedly causing such issues. My order number: 8004890904. I request that my refund be processed urgently and that the issue with my points and membership be resolved. I am unable to receive any support from customer service, and I want my grievance to be addressed as soon as possible.