Can anyone tell me if this DB query would do the job of changing the ID's from 17 to 3
Code: Select all
UPDATE oc_order_status SET order_status_id = '3' WHERE order_status_id = '17'Hi, we need to delete an old order status off our site but whenever we try in admin it wont let us as it says it is assigned to xx amount of orders. Obviously it will be a pain to go through each and every order and look for the ones that have this order status ID.
Can anyone tell me if this DB query would do the job of changing the ID's from 17 to 3
Can anyone tell me if this DB query would do the job of changing the ID's from 17 to 3
Running OC 1.5.5.1 with vqmods.
http://www.aislings.co.uk
http://www.lovers-paradise-toys.co.uk
While it may do the job, ensure the changes you make for the order_status_id does not affect the relation entity to other database tables.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 191 guests
