Set Start Point Order Number

[torweb]

I'm needing to set the order number start point higher...say 1,000. I've seen quite a few posts with regards to this request, but no answers. Wondering if anyone knew where to look to make this change.

Thank you!!

[nemail]

Hi torweb

There's a reference to this in the osCommerce Knowledge Base here:
http://www.oscommerce.info/kb/osComm..._and_Tricks/31
However, the relevant SQL query you'll require to execute in phpMyAdmin will apparently need to be modified from what they actually show in the documentation (which is for MS3) to the following (which is for MS2):
alter table orders auto_increment = 1000

I've not personally tried this so, as always, it would be best to backup before you make any changes. Perhaps others may be able to offer additional advice also.

Good luck!