order numbers

[Guest]

Hello, my site is pretty much ready for the public (opens in 2 days) and I was wondering 2 things

 

1: how do u get it to display the order number anfter the cust conferms the checkout? so far it seems that the order number only displays in the email sent to the cust.

 

2: is there a way to get it to start counting the order numbers higher? Im sure that people will get a little off the sorts when they get the email or display of "If you are paying my check or money order please write your order number on your check/money order. Your order number is 1

 

 

thanks for the help

[Guest]

no ideas where the oderd id number to start form/stored for the next order id?

[Guest]

well I found out how to do this so for anyone who wants to know

 

you need to do the following sql query in phpmyadmin

 

ALTER TABLE customers AUTO_INCREMENT = 1

 

where 1 is the number you want the order numbers to start at, so if you want it to start at say 54673 it will look like

 

sql query in phpmyadmin

 

ALTER TABLE customers AUTO_INCREMENT = 54673