Jump to content

Archived

This topic is now archived and is closed to further replies.

rob_illinois

Order Status issue

Recommended Posts

      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

Share this post


Link to post
Share on other sites

@@Rob_illinois,

 

 

      I would make 0 = Order

 

Do this and set it to default status

Share this post


Link to post
Share on other sites

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;
 

Share this post


Link to post
Share on other sites

×