Still waiting for refund for my order

Refund for what? This is a user to user support forum and we can't do anything with your order numbers (and for privacy reasons you should not post them here anyway).

Get a refund for purchases made with credit or debit cards using Apple Pay --> Get a refund for purchases made with credit or debit cards using Apple Pay - Apple Support

…“it might take several days to appear on your card statement.”

This support article explains how to check the status of a refund for apps or media content that you bought from Apple, and how long it takes to receive a refund if you are granted one --> Check the status of a refund for apps or content that you bought from Apple - Apple Support

After you request a refund you'll receive a status update by email within 48 hours. IF your refund is approved (with a few exceptions Apple does not automatically grant refunds), the funds are applied to the same payment method that you used to buy the item. How long it takes for a refund to appear on your account or statement depends upon the payment method used:

● Store credit—It might take up to 48 hours to see the refund in your Apple Account balance.

● Mobile phone billing—It might take up to 60 days for the statement to show the refund. Processing time might be affected by your carrier. You can contact your carrier for an update.

● Credit and debit cards, Apple Pay, Apple Cash, and all other payment methods—It might take up to 30 days for the statement to show the refund. If you don't see the refund after 30 days, contact your financial institution."

Since the article specifically says "statement", which for me is the thing that arrives monthly in my mailbox, I wonder if you check your daily card transactions if you might see it earlier?

For apps and media you can also sign into https://reportaproblem.apple.com to check if the status of your item is "Refunded".

Apple Store --> Refunds - Returns & Refunds - Shopping Help - Apple

Once we receive your item, a refund is initiated immediately. If you canceled a pickup item, and you were billed for it, we initiate your refund immediately after you submit your cancellation request. The way your refund is processed depends on your original payment method:

If you paid by credit or debit card, refunds will be sent to the card-issuing bank within five business days of receipt of the returned item or cancellation request. Please contact the card-issuing bank with questions about when the credit will be posted to your account.

Refunds on products purchased from Apple using an Apple Gift Card (or previous generations of Apple gift cards) will be issued to you as an Apple Gift Card by email. If you’d like us to send you a physical Apple Gift Card by mail, ask the representative helping you.

Products paid for using your Apple Account Balance will be refunded to your Apple Account Balance.