Your best option would be to get to that store first thing tomorrow morning to see if you can find it. If not, see if you can find someone selling it? Get your hands it quickly, whatever the cost.
We do everything possible to avoid canceling an order. But, sometimes that’s the only option.
I’ve found Amazon customers to be reasonable when apologizing for having to cancel their orders. It’s too bad that it happened to be your first order.
Since you returned the item and can’t buy it anymore, the best thing to do is to reach out to the customer who placed the order. Let them know what happened and offer alternatives like a refund or a similar item.
Contact the customer immediately, apologize for the inconvenience, and offer alternatives or a refund. Communicate transparently to build trust, and consider diversifying your product offerings for future orders.