Page 1 of 1

Possible to start over order numbers every year?

Posted: Tue Jan 01, 2013 3:03 am
by growlbox
Is it possible to archive orders of 2012 and reset the order number to 0?
The only thing i could think of is to backup all orders of 2012 in the database and delete them all. Isn't there a better way?

Re: Possible to start over order numbers every year?

Posted: Tue Jan 01, 2013 3:49 am
by victorj
make a order in your cart.

go to your databse en set ordernumber to 0 or better give it a year prefix like 201300000 the next order will be 20120001

Re: Possible to start over order numbers every year?

Posted: Tue Jan 01, 2013 9:18 am
by growlbox
Ok, that's a great and simple idea! Have you tried it yourself?

Thanks alot victorj!

Happy new year!! :joker:

Re: Possible to start over order numbers every year?

Posted: Tue Jan 01, 2013 10:35 am
by growlbox
victorj wrote:make a order in your cart.

go to your databse en set ordernumber to 0 or better give it a year prefix like 201300000 the next order will be 20120001
Works great! simple but effective solution.