[HELP] Change starting order number

[tamarillojohn]

I want to change the order number starting number. I have a site that has been operating for a couple of years and is up to 762 so far. I wish to start the orders numbering from 600,000 onwards.

Any help would be appreciated.

[Dh42]

Go to your database and basically you want to run this sql statement.

ALTER TABLE `ps_orders` AUTO_INCREMENT = 600000

[tamarillojohn]

thanks for that, but my invoice number is not increasing from 600000, which table in the datbase controls that?

 

Its looks like Prestashop assigns the invoice number a different way instead of "auto increment" - ie it doesn't take the last invoice and simply add 1 to it, or it does do that somewhere in the core files and then updates the database - any one have any answers?

Edited September 19, 2012 by tamarillojohn (see edit history)

[Dh42]

the order number and the invoice number are two different things, which one are you trying to change?

[tamarillojohn]

Im trying to change the invoice number, so it starts from 600000. Mush appreciated

[Dh42]

To change the invoice number go in the back office, orders tab >> invoices and set the number there.

[tamarillojohn]

Thanks for that....feel a bit stupid now, it was sitting there all along.