Start Order Number at higher value

[netbouy]

Does anyone know an easy way to start the order number auto increment at a different value other than 1?

I need the order number to be 6 numbers long and would like to start it at 100000.

Any ideas?

[kobra]

100,000???

How many products do you have???

[netbouy]

I just want to start the order numbers at 100000, not the product numbers.

This would mean that order #1 would be 100000, order #2 = 100001, order #3 =100002 etc... or something similar.

Preferably not with zeros padding the front (i.e. 000001).

[kobra]

OH I thought you were referring to "Sort Order" -
This is in the DB in the orders table I believe

[netbouy]

Ok... found this answer here. I knew there must be an easy answer

Cheers