Post by ameliaa » Fri Jun 05, 2015 12:33 pm

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

New member

Posts

Joined
Fri Jan 29, 2010 6:31 pm

Post by deepvision » Sat Jun 06, 2015 8:38 pm

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.

ImageImageImage


User avatar
Active Member

Posts

Joined
Tue May 19, 2015 1:03 am

Post by ameliaa » Mon Jun 08, 2015 6:02 pm

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;

New member

Posts

Joined
Fri Jan 29, 2010 6:31 pm
Who is online

Users browsing this forum: No registered users and 40 guests