rob_illinois Posted July 22, 2016 Share Posted July 22, 2016 I am running Oscommerce version 2.3.4. I get an issue every so often where a new order will disappear from the admin area, as the order status goes to a 0. I then have to goto the db file and find that order and edit the status from 0 to 1 and then it shows back up in the admin area. I would like to know what I need to add in the DB, and anywhere else if required so there is a status for 0. This way new orders do not disappear from the admin area every so often. Right now there is 1- Pending 2- Packing 3 - Shipped. I would make 0 = Order Thanks Link to comment Share on other sites More sharing options...
♥raiwa Posted July 22, 2016 Share Posted July 22, 2016 @@Rob_illinois, I would make 0 = Order Do this and set it to default status 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...
rob_illinois Posted July 22, 2016 Author Share Posted July 22, 2016 Ok, I have Pending set as default. I did wonder why this did not work fine as it was and moved orders to a status of 0 which did not exists? So on adding a new option I just need to add this code below to orders_status, and then in admin area change it to the new default?ALTER TABLE `orders_status` ADD `Order` VARCHAR(128) NULL; Link to comment Share on other sites More sharing options...
♥raiwa Posted July 22, 2016 Share Posted July 22, 2016 yes 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...
rob_illinois Posted July 23, 2016 Author Share Posted July 23, 2016 This did not work, it did not create the order status name "order" in orders_status as option 0. Link to comment Share on other sites More sharing options...
rob_illinois Posted July 23, 2016 Author Share Posted July 23, 2016 Ok, got it now. Hope this works and I do not get the issue anymore on orders disappearing. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.