Start my Order Number with 100000

[Guest]

Hi guys, how can I start my order number from about 100000 instead of 1. There must be a place in the php files where values are being incremented.

 

Please help!

[Flyer5]

Hi guys, how can I start my order number from about 100000 instead of 1. There must be a place in the php files where values are being incremented.

 

Please help!

<{POST_SNAPBACK}>

 

 

Go into your mysql database, open the "orders" table, the first field is the order id. select edit and change the field to 10001 or whatever you want to start counting from.

Each new order will increment by 1.

 

if you have orders in your system already, i would creat a fake order and change the number of that one; in other words, change the count from the last order, not the first!

[Guest]

Thanks Gav

 

I just tried did the change, but haven't tested the shop yet. Now I know what is required.

 

Thanks again!

[jayson]

I am still trying to find where my database is located? Any Ideas?

[kwalker]

I am still trying to find where my database is located? Any Ideas?

 

You may need to ask your hosting company. Some people have access to their databases while others do not.

 

 

Kevin