How to Reset Order ID for Opencart 2.0.1.1?

Hi,

I recently purchased a mod to generate a random order id. Unfortunately it did not behave as intended.

For example, three consecutive orders (order 771, 772 and 773) should have order id like 771989, 772013, and 773989 but it didn't turn out that way. All the digits are random.

I have since disabled the mod (wasted $30 on this). How do I reset the order id to a specific number? In my case the number I need for it to be reset to is 5371.

p.s. I have searched the forums and found instructions only for earlier versions of opencart.

Thank you,
Ameliaa

Order IDs are incremented automatically. They cannot be changed for existing orders.
But you can change the auto_increment value to something larger.
So that next orders will be given Order IDs starting from that value.
Also you can change the invoice numbers.

deepvision wrote:Order IDs are incremented automatically. They cannot be changed for existing orders.
But you can change the auto_increment value to something larger.
So that next orders will be given Order IDs starting from that value.
Also you can change the invoice numbers.

Thanks for the reply.

The auto_increment works.

ALTER TABLE `order` AUTO_INCREMENT = 5400;