Help with changing multiple order statuses at one time

[HeleneWallis]

My order fullfillment people are bugging me to give them a way to change all the orders marked 'New Order' to 'Processing' at one time, so they don't have to go in and change them individually. We're already using the utility to print all the packing slips at one time, so this would be a logical extension to that. I've found the code where they get changed one at a time, and can probably figure out how to change them all from one status to another--I know what the SQL command needs to be. But right now, adding a button on the orders.php page, even without a dropdown list to choose from, is beyond my skills and beyond my time to work out.

Has anyone else done this and could you give me some help with it? It seems like such a useful feature that I'm surprised it isn't already included.

I do realize that we don't have to change the status before we can process the order. But it gives me a quick visual check of what is shipped and gone, what is new but hasn't been shipped, and what is really new and might need me to look it over. I look for things like a difference between the billing and shipping addresses (Paypal orders sometimes have an outdated shipping address, for example). And I look for notes on an order that might need an email before shipping. So I really need to make the distinction between a brand new order and one that just hasn't been shipped yet.

Thanks in advance :)

[torvista]

I believe Super Orders does this...but I don't use it.

[HeleneWallis]

I downloaded Super Orders, but after having a total mess from one of their other add-ons, I'm very reluctant to install it.

[torvista]

For all but the simplest "plugins", I drop it into a vanilla LOCAL install of whatever version of ZC it is SUPPOSED to be compatible with.
If it falls over at this point, you know what you are dealing with....

If it does what is says on the tin, then drop it into a vanilla LOCAL version of the current ZC, same testing and fixing before letting it loose on your LOCAL development copy of your real site. I do all on php7 too, to flag up more things in advance.

So way before it gets anywhere near your real/production/non-broken/making-money so leave it alone as much as possible site you should have enough experience to trust or bin it.

Anyone who copies code from the "plugins" to their production site without testing it somewhere else first needs professional care.

[DrByte]

Helene,
Awhile back I updated the All Invoices plugin to accommodate the ability to not only print (to screen) a list of invoices for a certain order-status (which it already did), but to also optionally update those orders to a new status afterward. I hadn't packaged it up yet, but I just did a quick (hopefully correct) merge and uploaded it:
https://www.zen-cart.com/downloads.php?do=file&id=1083

Perhaps that may be a useful tool for you ... or at least give you some code ideas to work with for accomplishing something similar to suit your needs.

[HeleneWallis]

Yes, thank you! I did install Super Orders on my test site, but the only thing it does that I have any interest in is the multiple status update. Even that is too clunky for my people to use. I just need a button they can click on to change all New Order statuses to Processing. They don't need to be putting in a date range and downloading a subset of the database first, someone would screw that up for sure.

I've go have a look at this. We normally print only packing slips, not invoices, but I can probably move the code over to the allpackingslip program.

[HeleneWallis]

For all but the simplest "plugins", I drop it into a vanilla LOCAL install of whatever version of ZC it is SUPPOSED to be compatible with.

I don't install anything without checking it on my test site first. That said, I don't really want a big hassle to uninstall something from my test site either.

I did install it on my test site and found that it doesn't answer my need to change multiple orders at one time (without multiple steps that I don't trust my people to do). And it doesn't have anything else at all that I can use. So now I have to get rid of it, which is going to be a lengthy process.

[HeleneWallis]

Helene,
Awhile back I updated the All Invoices plugin to accommodate the ability to not only print (to screen) a list of invoices for a certain order-status (which it already did), but to also optionally update those orders to a new status afterward.

After looking at it, I realized that the way you laid it out, we can change the order status without having to print the invoices. We'll use this for the time being, and thank you very much!

Oops--editing this to say that the order status didn't get updated, even after printing the invoices.

[HeleneWallis]

It's just repeatedly resetting it to New Orders every time I run it. I'm sure it's a minor fix though. Um, looking at the code, I see what the problem is. It's setting the order status to 2, which is where I have New Orders set. I can fix that.

[HeleneWallis]

Help?? Not sure what I'm doing wrong. This looks like what I need to change, but I get an error message every time. It's line 81 in all_invoices.php. I'm clearly not expressing the order_status variable correctly, but I'm not sure what I need to do different.

$sql = "UPDATE " . TABLE_ORDERS . " SET orders_status = " . (int)$status . ", last_modified = now() where orders_id = " . (int)$oID;