Change order number series - EXTREMELY URGENT

[Jennyh]

I was hoping someone could help me out. I usually have a UK guy help me with OsCommerce things, however he has not responded to me in a few days and I'm running out of time. I’ve been Googling and can’t find any answers that actually help me. But, our company is in the process of being purchased. The new owners will have ownership on September 30^th and we would like to roll our order numbers up to 200000 series (from a 100000 series) starting on October 1^st. Is this something I can easily do? If so, where do I find it? I'm pretty good at doing these types of things myself as long as I have step by step instructions. (:

 

Thank you in advance for all your help.

[♥bruyndoncx]

you'll have to use phpmyadmin or similar to use sql https://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

 

there is an alter statement to change the autoincrement value

 

suggest you create a new table and try it out and see for yourself.

 

 

[♥14steve14]

I remember reading somewhere on these forums that if you create an invoice then go into your database using phpmyadmin or what ever you use, and alter that invoice/order number from say 10000 to 20000 the next one will be created as 20001 as it will be one increment higher.

 

I may be wrong and totally imagining it though.

[knifeman]

In older versions we did this:

New orders that are made with new osCommerce installations start with the ID of 1.
This value can be reset so that new orders are assigned an ID from a specific starting range, for example from 1000.

Solution
The following SQL query needs to be executed with MySQL:
alter table orders auto_increment= 1000;

The above query will assign an ID of 1000 to the next order made.

The ID can be set to any number, however as the orders_id field in the database is of type signed integer, the ID must exist in the following range:


-2147483648 to 2147483647

 

 

Does this not work anymore?? Or did I misunderstand the question?