OpenCart Community

Posted: **Tue Mar 15, 2016 5:33 pm**

For example: I want my Order ID starting from: 2001

I remember in OC 1.5, I can modify it inside PhpMyAdmin,
but come to OC 2.2, I lost.

Posted: **Tue Mar 15, 2016 7:14 pm**

you can run this simple query from your phpmyadmin. change "oc_" to your database table prefix.

ALTER TABLE oc_order AUTO_INCREMENT = 2001;

please noted that running a queries directly to the db is pretty dangerous, please consider make a backup

How to modify "Order ID"?