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 (25.32 KiB) Viewed 1377 times
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
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
ALTER TABLE tablename AUTO_INCREMENT = 1
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Who is online
Users browsing this forum: No registered users and 63 guests