Order number SQL query??

[Guest]

Hi Board

 

I'd like to set my order numbers, beginning at a specific number, that I decide. I found this explanation in the knowledge base, but how do I impliment it?

 

:blink:

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;

:blink:

 

 

Any suggestions would be appreciated.

 

naz