How to force order numbers to start @ 1000 [SOLVED]

[Tintarella]

Hello.

I don't want my order numbers to start at #1, but #1000 (or 1234), how do I do this?

NOTE! Changing invoice number won't do the trick.

[QuadDamage]

lol yes please! Does anyone know how to do this?
It would be very handy.

[Ion_Cannon]

You can set it by using the following mysql command in phpmyadmin:

ALTER TABLE ps_orders AUTO_INCREMENT =1234

ps_orders is the name of my orders table. Yours may be different.

[The Ge]

Actually, you could do it in the BO:

Back Office >> Orders >> Invoices >> Invoices Options >> Invoice number

As it says: "The next invoice will begin with this number, and then increase with each additional invoice"

[Ion_Cannon]

That's the invoice, not the Order #....

[The Ge]

Right, my apologies. :red:
I should sleep more.