How to reset order No.?

[snowrabbit]

I have made a lot of testing in my store, the order No. Now is 160, how do I reset it to be stared with 0 again? Thanks.

[Guest]

Try the link below. Where it says

alter table osc_orders auto_increment = 1000;

Change to

alter table orders auto_increment = 1000;

Change 1000 to 1

 

Change Order ID

[♥mdtaylorlrim]

I have made a lot of testing in my store, the order No. Now is 160, how do I reset it to be stared with 0 again? Thanks.

alter table orders set auto_increment=0

 

 

You will probably need to manually delete the orders from the db. Why not just leave it, or better yet, set it to start at 10000?

[snowrabbit]

Try the link below. Where it says

alter table osc_orders auto_increment = 1000;

Change to

alter table orders auto_increment = 1000;

Change 1000 to 1

 

Change Order ID

 

Thanks, worked