Increasing the order number

[JohnnyVegas]

Hello.. I recently reinstalled my OSC commernce after my host by mistake deleted my account instead of reloading a backup from the night before. what a mess.

 

The issue is Now my order number is at 110. I want to increase this to where it was before as I believe it gives customers more a sense of well being. PLUS it will really help with the filled order from for the past few years.

 

Where and how to I do this?

 

If I'm at 110 now where do I change this? I am looking in the SQL database but really see any figure to change. I believe it's in the orders table but whet to change?

 

Any help please.

 

thanks

[knifeman]

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 osc_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