Post by nightcat » 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.

User avatar
New member

Posts

Joined
Mon Aug 15, 2011 1:41 pm

Post by ocart777 » Tue Mar 15, 2016 7:14 pm

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

Code: Select all

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

You can't control the weather, but you can change your mood.
You can't modify the visage, but you can show your smile.
You can't command someone else, but you can hold yourself.
You can't forecast tomorrow, but you can using today.
You can't obtain thanks, but you can exert yourself in everything.


OCEXTENSION.COM - YOUR PROFESSIONAL OPENCART EXTENSION STORE


User avatar
Active Member

Posts

Joined
Mon Jun 10, 2013 4:57 pm
Location - Malaysia
Who is online

Users browsing this forum: Bing [Bot] and 17 guests