Reset order number and invoice number counter

Phoca Cart - complex e-commerce extension
User avatar
SAF
Phoca Member
Phoca Member
Posts: 17
Joined: 27 Mar 2023, 09:49

Reset order number and invoice number counter

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Reset order number and invoice number counter

Post 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
If you find Phoca extensions useful, please support the project
User avatar
SAF
Phoca Member
Phoca Member
Posts: 17
Joined: 27 Mar 2023, 09:49

Re: Reset order number and invoice number counter

Post by SAF »

Thanks Jan for the help, I'll do as you say
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Reset order number and invoice number counter

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply