Post by brettcyr » Sat Mar 18, 2017 8:43 am

I have created a new cart and ran some test products. The Order ID was up to 7 and when I deleted the orders and tried to get the order id to go back to 0 I went to the phpadmin and ran ALTER TABLE `oc_order` AUTO_INCREMENT = 0; and get the return in the image shown. I try a test order and it just keeps increasing by 1 and now up to 10 instead of starting over at 1. Is there something I'm missing or skipping after running the above code?

Attachments

ScreenHunter_32 Mar. 17 19.41.jpg

ScreenHunter_32 Mar. 17 19.41.jpg (25.32 KiB) Viewed 1374 times


Newbie

Posts

Joined
Fri Jun 17, 2016 9:27 am

Post by tingwing » Sat Mar 18, 2017 3:08 pm

i donot think this would bother your business
how to back to 0?
i think,what is it doing is adding 1 to the current biggest orderID for the latest orderID.
so delete all that orders at backend-sale-order you created when tested .

if this doesot work,you need to find " the current biggest orderID" by phpmyadmin,then change it to 0
Last edited by tingwing on Sun Mar 19, 2017 11:54 am, edited 1 time in total.

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by thekrotek » Sat Mar 18, 2017 3:59 pm

ALTER TABLE tablename AUTO_INCREMENT = 1

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 59 guests