Need to delete currently pending orders

[adtastic]

We've migrated a fully productive zencart site to prestashop. Migration included customers and order data. We want to keep the customer database. We'd also like to keep all of their order data. But under the old configuration orders were always set to "processing" and were never updated to shipped or anything since the client had an external system beyond that point for communicating with the customer when the product was shipped or processed (unique situation) but under the new system they will be using the prestashop configuration completely in this regard).

 

Anyways, here is our problem. On the dashboard under currently pending we have 14,410 orders. We want to reset this to zero. So, in other words we want to take all of the existing orders and change the disposition to something such as "processed". Believing, in effect this will remove them from pending and make it easier now to quickly find and access new orders once the store goes live. At the same time, we want to insure that no customers get an email when we do this. The "Processed" status is ticked to not send an email to the customer so I am assuming that would work. But how to convert all of these pending orders to "processed" and insure the customer does not get an email too?

 

Short of that, the next best solution would be to simply delete all of the existing orders. So if there is not an answer to the first requested solution any answer to simply deleting all of the old orders?

Edited September 17, 2015 by adtastic (see edit history)

[shacker]

you only need to run a sql query to change all the orders with status pending (orders table, current_status field) check the id of the pending status and run a query like

 

UPDATE ps_orders SET

current_state =1 WHERE  current_state = 10 

 

 

10 is the id of the pending order and 1 your id of the state you want to put