Change range of ordernumbers?

[JovanMcHellAngle]

Hi!

I would like OsCommerce to start with ordernumber 6100 instead of 1.

Ist it possible?

Where in the tables can i change it?

 

Best regards Johan

[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

[Jeremy at oddly enough]

In the orders table of your database, change an order id (any one) to 6099. The next order that comes through will be 6100. Jeremy

 

UPDATE orders SET orders_id='6099' WHERE orders_id='1';

 

ought to do the trick.

 

Jeremy