change order number

Author	« Topic »
ardade Advanced Member 257 Posts Pre-sales questions only (More Details...)	Posted - 09/18/2019 : 12:04:38 I need to change the next order number in the database. My order number now is 9000 i want to change the next one and subsequent order numbers to 11000. I thought I could do this is VSADIM where we start at 500 but I thought we can change this to something else.
Vince Administrator 42874 Posts	Posted - 09/18/2019 : 12:14:58 Hi Ardade Yes you can with phpMyAdmin if you have access to that. You need to go to the orders table then click on the "Operations" tab, and then you should see a box on that page with "AUTO_INCREMENT". Change that to a higher number then on "Go" and the next order should have a higher number. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
ardade Advanced Member 257 Posts Pre-sales questions only (More Details...)	Posted - 09/18/2019 : 12:21:39 Done perfect thanks!
	« Topic »