[SOLVED]Change the Starting number for ORDERS ?

[L. Brett Sinclair]

Hello
in beta 3, you can change the starting # for the invoices, but I could not locate where I could set the starting # for ORDERS ?

anyone knows ?
Thank you

[Bruz]

The # is set by the autoincrement field id_oder in the table ps_order - I assume you could create a new line directly in the DB with your desired value in the id_oder-field and every later order starts from there.

[Melinda]

You could put in a test order and then change the number of it in the database.

Then put in another test order and it should show the next increment.

Then you can delete the first test order from the database itself.

I haven't tried this on PrestaShop yet but should be possible.

[vraptor5]

Ok, step by step:

- Enter phpMyAdmin

- click on your database

- click on ps_orders (on the left)

- click on Operations (at the top of the page)

- in auto_increment put the number you want

- click on Go

 

and you're done.
The next order will continue from the number you just entered.

Greetings!