Page 1 of 1

Reset order number and invoice number counter

Posted: 14 Apr 2023, 08:25
by SAF
Hello, I kindly ask how to reset (start from zero numbering) the order counter and the invoice counter.
After testing the paypal sandbox, I would like to put the site online and start from a value of 0 with the numbering of orders and invoices. Where do I have to intervene to do this? Thanks in advance

Re: Reset order number and invoice number counter

Posted: 14 Apr 2023, 23:05
by Jan
Hi, for this, you need to truncate the tables directly in database (e.g. with help of phpMyAdmin). Only deleting items does not help, the "truncate" command will even reset the autoincrement which is here for adding numbers.

Image

Jan

Re: Reset order number and invoice number counter

Posted: 17 Apr 2023, 08:38
by SAF
Thanks Jan for the help, I'll do as you say

Re: Reset order number and invoice number counter

Posted: 17 Apr 2023, 16:55
by Jan
Ok