Could you cancel my first order, please? Since I thought my order hadn't gone through the first time, I tried again. However, I now realize it did work the first time. In other words, I accidentally ordered the same item twice
Imagine someone needed a glass of water but I brought him a glass of tea by mistake.
He said: I didn't want to drink tea.
I replied : sorry I thought you wanted to drink tea but now I realise I was wrong .
I don't understand why the first one is not past simple " did not get through". The meaning is in both sentences:" I thought something happened or did not happen and in fact I realise I was wrong" . Both actions are almost simultaneous and in chronological order :
The payment,the thinking of the non payment and in fact perhaps the payment
Client wants water,the thinking of tea for the client and the mistake (I realise he did not want tea )