Reset The Order ID Value

[maggiemk]

Dear all,

 

I've read the documentation but still don't know how to reset the Order ID value. I would very much appreciate it if you could lead me to reset it. The documentation said that the following SQL query needs to be executed with MySQL:

 

alter table orders auto_increment = 1000;

 

I have no idea how I can find the above query.

 

Thanks in advance,

Maggie

[MEDIAZONE]

Dear all,

 

I've read the documentation but still don't know how to reset the Order ID value. I would very much appreciate it if you could lead me to reset it. The documentation said that the following SQL query needs to be executed with MySQL:

 

alter table orders auto_increment = 1000;

 

I have no idea how I can find the above query.

 

Thanks in advance,

Maggie

 

Hi you would just need to enter this in MYSQL query box, I can run this for you if you supply me with your site details

[rabbitseffort]

phpmyadmin is the way to work with your database

 

another easy way to change the order number is t make a test order, then go to your mysql database and edit that order and change the value from whatever it is to whatever you want your next order number to be, for example, if the order number is 1, and you want the orders to start at 2538, then change the 1 to 2537

then the next order will be 2538

[♥Vger]

If you follow the Network link at the top of this page to the Knowledge Base --> Tips and Tricks it will tell you how to do it.

 

Vger

[maggiemk]

Thanks MEDIAZONE, rabbitseffort and Rhea.

 

I've just read the tips & tricks but still haven't got a clue. Do you mind telling me the steps as I am not familiar with MySQL. I've just opened the cpancel and there is a MySQL Database, I created the following database in MySQL database before the installation of OCS. There is no open button in MySQL database, so I really don't know how to open it and alter the order ID value.

 

Connection Strings

Perl $dbh = DBI->connect("DBI:mysql:xxx_xxx:localhost","xxx_xxx","<PASSWORD HERE>");

PHP $dbh=mysql_connect ("localhost", "xxx_xxx", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("xxx_xxx");

 

I hope you could give me further help.

 

Thank you,

Maggie

[rabbitseffort]

do you have phpmyadmin in there? you should, open that up then click on the correct database from the dropdown menu, and make the necessary changes

[maggiemk]

Dear Rabbitseffort,

 

Thank you so much indeed. I've successfully altered the order id value.

 

Thanks again. :D

Maggie