I can't remember why I did this, but I created an additional order status "Shipped" (ID5). Is there a sql query I could run to change all of these to Shipped (ID3)?
Thanks in advance....
I can't remember why I did this, but I created an additional order status "Shipped" (ID5). Is there a sql query I could run to change all of these to Shipped (ID3)?
Thanks in advance....
you can simply run UPDATE orders SET orders_status = '3'
* Please bear in mind few steps
1. this will change every order in your shop to shipped.
2. this will not show on order history as that is a seperate table.
Make a db backup, then:
UPDATE orders SET orders_status = '3' WHERE orders_status = '5';
UPDATE orders_status_history SET orders_status = '3' WHERE orders_status = '5';
If the number of orders with status 5 is small, though, you might just do this by hand so you could make a status update note about the change you're making. To determine the number of orders in this state, do
SELECT COUNT(*) FROM orders WHERE orders_status = '5';
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
Bookmarks