Thread: Changing order status back to new?

Is there a way in the back end to change the order status back to new for any order?

Hi,

As we know, currently the only way to change the order status back to new is using the SQL statement in the admin site.

Our developers in house could customize this tool on your website for you. If you are interested in working with us, you could send your requriements to analysis@storefrontunited.com. Our staff will get back to you in 24 hours.

Originally Posted by 2ndSwing

Is there a way in the back end to change the order status back to new for any order?

This is incredibly simple if you have RDP access to your sites server and SQL management studio. IsNew is the 6th column in the orders table and you simply have to change it from 0 back to 1. That is it.
As always, be very careful when touching your database and make a backup before making any serious changes. I personally spend A LOT of time directly in the database because it is so much faster then using the back end of the website.
Good luck!

If you develop the SQL script you can run it from the admin portal.