Correct Order Status on multiple orders
Somehow a batch of old orders, about 500 of them, that were status: shipped got changed to status: prosessing. What is the best way to go about moving them back to shipped? Would I use a sql statement? or open the database and manually change it in the table where it resides? Any other ideas?
Re: Correct Order Status on multiple orders
It would be easiest using a sql statement. However there would need to be something common for all orders to make this work. Eg you could use the date. The satement based on date would be:
update `zen_orders` set `orders_status` = 3 WHERE zen_orders.date_purchased >= '2007-01-15' and zen_orders.date_purchased <= '2007-01-21'
You would need to change dates as per you range and if you don't use the 'zen_" prefix in your database you would also remove the prefix from above statement.
By cupcake in forum Managing Customers and Orders
Last Post: 10 Apr 2008, 02:04 PM
By vivaknievel in forum Managing Customers and Orders
Last Post: 3 Aug 2007, 09:16 PM
By tj1 in forum Built-in Shipping and Payment Modules
Last Post: 16 Sep 2006, 05:55 PM
By PeterBKK in forum General Questions
Last Post: 20 Aug 2006, 06:22 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC