change order number

[djdeuce]

I'd like to raise the order number in my shop so the next orders will all sync up to the new larger number. I see there is multiple tables this number is on so I don't want to break it. :)

 

Anyone know an easy way to change the order number? Thanks!

[Guest]

@@djdeuce

 

Unique Order Numbers

 

 

 

Chris

[djdeuce]

Thanks Chris! But I just want to put a 1 in front of the number there now to make it in the thousands. I really don't want a huge unique number like this one. Do you know how to do that?

[Jack_mcs]

@@djdeuce You need to place an order (unless you don't care about the last one being edited), edit the orders, orders_products, orders_status_history and orders_total and change the orders id in each to the number you want to start at. Then place a new order to update the auto updater and make sure it works.

[burt]

In phpmyadmin, do this:

 

ALTER TABLE orders AUTO_INCREMENT = X

 

Change X to the number of the number you want the orders to start at.

Forget the older orders, all these will have low numbers.

[myquestionone]

order numbers are the same as invoice numbers ?

[djdeuce]

thanks everyone! i used the auto increment update from burt and it worked perfectly :)

 

for future people trying to figure this out just go to your phpmyadmin in cpanel, select the database and run this sql statement:

 

ALTER TABLE orders AUTO_INCREMENT = X