Order / Invoice ID reset to 1

[Guest]

Greeting friends!

 

I was wondering can i reset my order/invoice number back to one, so it can look like fresh start?

 

now i have order_id - 132, but i want to start them again from order_id - 1

 

 

Any suggestions on this?

 

Thanks

[Guest]

Is this something like this?

 

ALTER TABLE `orders` AUTO_INCREMENT = 0

 

or

 

ALTER TABLE `orders` AUTO_INCREMENT = 1

[♥mdtaylorlrim]

Greeting friends!

 

I was wondering can i reset my order/invoice number back to one, so it can look like fresh start?

 

now i have order_id - 132, but i want to start them again from order_id - 1

 

 

Any suggestions on this?

 

Thanks

Not a good idea because you will start overwriting old orders. How about starting at 1001?

 

phpMyAdmin, sql, alter table orders auto_increment = 1001

[Guest]

Not a good idea because you will start overwriting old orders. How about starting at 1001?

 

phpMyAdmin, sql, alter table orders auto_increment = 1001

 

 

Thanks!

 

Before i put my shop online i will delete all order and yes it`s a good idea to start with 1001

 

 

But it`s possible to start over again - i was looking in DB and found the way to do it manually, but before that i needed to delete all orders what have been made

 

in table orders there is ROW STATISTICS and there i found Next Autoindex 133 if click on Operation it`s possible to change the value of 133 to 1, and i did so.

 

The result was what i wanted!

 

I think this also an option!