driven22 Posted December 28, 2018 Share Posted December 28, 2018 Hi, I would like to change my order id from ex 11500 to 600, but when i change in phpmyadmin to 600, or when i delete this order - next orders is continue 11501.. - alter table orders auto_increment = 600; - not work I have osc BS (last version from gburton) Some idea ? Link to comment Share on other sites More sharing options...
♥raiwa Posted December 28, 2018 Share Posted December 28, 2018 Hello @driven22, Try the following: In phpMyAdmin : select the orders table : click the "operations" tab : enter in "Auto Increment" the next orders ID you wish to use. Take care that there doesn't already exist any higher id in the table. About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
driven22 Posted December 28, 2018 Author Share Posted December 28, 2018 I have 10 id higher than id "600" - so i must change manual this orders in table orders, orders history, orders total and where else ? Two days ago when i have only one orders higher than id:600 I was delete that Id orders in table orders, orders history, orders total and i was put: alter table orders auto_increment = 600; -but not work Such a high order number appeared on import to the database of the missing record from the previous store. Therefore, such a high numbering of orders suddenly appeared. I thought it would be easy to change this order numbering Link to comment Share on other sites More sharing options...
♥JcMagpie Posted December 28, 2018 Share Posted December 28, 2018 This problem has been looked at before see if this solution works for you. Link to comment Share on other sites More sharing options...
♥raiwa Posted December 28, 2018 Share Posted December 28, 2018 15 minutes ago, driven22 said: I have 10 id higher than id "600" - so i must change manual this orders in table orders, orders history, orders total and where else ? Two days ago when i have only one orders higher than id:600 I was delete that Id orders in table orders, orders history, orders total and i was put: alter table orders auto_increment = 600; -but not work Such a high order number appeared on import to the database of the missing record from the previous store. Therefore, such a high numbering of orders suddenly appeared. I thought it would be easy to change this order numbering Order_id is used in all tables beginning with "orders_" except "orders_status". However I wouldn't recommend to change existing order ids. They may have been already refernced in order confirmation or status update mails. i would recommend to use the next number of the highest already existing order id for to manually set auto increment to avoid any conflicts. About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.