So we cannot change anything in MySQL then to change to a different OrderID?
Order Id is AUTO INCREMENT Field - Auto-increment allows a unique number to be generated when a new record is inserted into a table.
There is another id related to the orders - Invoice ID. In admin when you open order there is Generate button to generate invoice id. Also AbanteCart have few
settings for invoice number - Invoice Start No. and Invoice Prefix. It is AUTO INCREMENT too but this id is separate from ORDER ID and not required.
I placed 3 test orders (1 by mobile phone) using Malaysia address exactly as this customer did and went thru the entire order process. Each time only Global Priority Int'l was listed and the correct shipping was charged. I used the cheque method which wont charge me anything. Could it have been a glitch?
Try to replicate issue with customer account. Go to admin-sales-customers find needed customer and click on 'Act on behalf' button. This will allow you to login as customer
It seems this person may have just registered for an account. There was no order assigned to them. They appear in Customers but not in orders. They would have been #2. They were given an OrderID of 2 I thought.
You can see that 4 & 5 are missing because those where my test orders that I deleted
If customer did not complete order it will be not visible in Admin-Orders
. Maybe you need
Abandoned Orders View extension with this extension you can view orders that were not completed or if customers never checkout or had issues completing order.
One more thing. Next time please create separate topics for each question