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
Reset order number and invoice number counter
- SAF
- Phoca Member
- Posts: 17
- Joined: 27 Mar 2023, 09:49
- Jan
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Reset order number and invoice number counter
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.
Jan
Jan
If you find Phoca extensions useful, please support the project
- SAF
- Phoca Member
- Posts: 17
- Joined: 27 Mar 2023, 09:49
Re: Reset order number and invoice number counter
Thanks Jan for the help, I'll do as you say
- Jan
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Reset order number and invoice number counter
Ok
If you find Phoca extensions useful, please support the project