[solved] How to set first order at a defined number f.eks 10.000

[Kim Maarup]

I have used 1.4 for years. Now I have installed 1.5

I have the problem that my Payment provider will not accept the order, starting scratch at number 1 again, because the owerlap the allredy existing order in their system.

How do I set/ change the first order to f.ex order nr 10.000 ?

Edited April 8, 2013 by vekia (see edit history)

[vekia]

YOu can change it in database manager like phpmyadmin / heidisql / mysqlworkbench

 

just log in into db manager, go to the ps_orders table and edit "options" of this table.

 

view from heidisql

 

view from phpmyadmin

 

 

all you need is to change auto_increment value for 10000 :-)

[Kim Maarup]

YOu can change it in database manager like phpmyadmin / heidisql / mysqlworkbench

 

just log in into db manager, go to the ps_orders table and edit "options" of this table.

 

view from heidisql

 

view from phpmyadmin

 

 

all you need is to change auto_increment value for 10000 :-)

 

Thank you very much !!

[vekia]

So i think that the problem is solved?

[Kim Maarup]

Oooh that was easy. Thanks a lot :-) Very fast and specific. Yes problem solved. (Nice sceenshot)

Edited April 8, 2013 by Kim Maarup (see edit history)

[vekia]

OK! so i can go ahead and mark this thread as solved, regards