Reset Invoice start number

Author	« Topic »
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 01/12/2025 : 11:26:25 Is there a way to reset the Invoices and/or Orders to start at a particular number? Terry (Redsei)
Vince Administrator 42825 Posts	Posted - 01/14/2025 : 00:40:20 Hi Terry If you have access to phpMyAdmin then click on the "orders" table and then "Operations" and you'll see a value there for AUTO_INCREMENT and you can change that. But do beware as if you set this to a lower value you'll end up re-using old order id's and will get "ghost" options added to products and things like that. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 01/14/2025 : 04:18:19 You still will get the ghosting even if you purge everything as well? Terry (Redsei)
dbdave ECT Moderator USA 10447 Posts	Posted - 01/14/2025 : 06:33:52 Hi Terry, no, not as long as you dump all of the related tables. cart, orders, cartoptions are a few I can think of. David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 01/14/2025 : 07:48:01 OK. Thanks for the info Dave Terry (Redsei)
	« Topic »