Post by growlbox » Tue Jan 01, 2013 3:03 am

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?

New member

Posts

Joined
Sat Jun 11, 2011 6:16 pm

Post by victorj » Tue Jan 01, 2013 3:49 am

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

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by growlbox » Tue Jan 01, 2013 9:18 am

Ok, that's a great and simple idea! Have you tried it yourself?

Thanks alot victorj!

Happy new year!! :joker:

New member

Posts

Joined
Sat Jun 11, 2011 6:16 pm

Post by growlbox » Tue Jan 01, 2013 10:35 am

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.

New member

Posts

Joined
Sat Jun 11, 2011 6:16 pm
Who is online

Users browsing this forum: No registered users and 55 guests