How to change the ORDER NUMBER?

[fab_kukla]

Does anyone know how to change the order id numbers?

 

I set my shop live , and the order ids are #5 ,#6 and I would like to change the numbers to a higher value

 

Does anyone know how to do this?

[TasselT]

Does anyone know how to change the order id numbers?

 

I set my shop live , and the order ids are #5 ,#6 and I would like to change the numbers to a higher value

 

Does anyone know how to do this?

To change next ordernumber to e.g. 1000, run the SQL-statement

ALTER TABLE orders AUTO_INCREMENT = 1000;

in phpMyAdmin.