Zen Cart Logo
Forums / General Questions / Mass update for order status

Mass update for order status

Locked

Views: 791

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
26 Aug 2009, 8:20 AM
#1
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Mass update for order status

Is it possible to run an SQL patch or something to change all orders in a certain order status to another order status, for example, from packing to dispatched?

26 Aug 2009, 9:54 AM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Mass update for order status

Yes. Though it's not as straightforward as most updates. You would need to write a patch that finds all entries in the orders_status_history table whose most recent entry matches the ID of your packing status and use that as your input list into a query that inserts a new entry into that table with the despatched status. So you are creating new entries, not amending the ones already there.

26 Aug 2009, 10:15 AM
#3
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Mass update for order status

Writing that patch may be beyond my talents or available time. Are there any walkthroughs to show me how to write a patch?
Could someone perhaps write one?

26 Aug 2009, 3:51 PM
#4
jc8125 avatar

jc8125

Zen Follower

Join Date:
Oct 2007
Posts:
143
Plugin Contributions:
0

Re: Mass update for order status

you may also want to look into a mod called super orders (available in the free downloads section). it creates a Batch Order Status update section, allowing you to, for example, find all orders that are currently set to status "x" and change them to status "y". you can also define data ranges and other criteria for the orders to be updated.