Forums / Basic Configuration / Is bulk change of order status possible?

Is bulk change of order status possible?

Views: 5,943

Results 1 to 11 of 11
2 Mar 2011, 4:54 PM
#1
dduane avatar

dduane

New Zenner

Join Date:
Jan 2011
Location:
County Wicklow, Ireland
Posts:
4
Plugin Contributions:
0

Is bulk change of order status possible?

Greetings all!

My Zen Cart is working fairly well, all things considered: but one answer I've been searching for and haven't found. (Hoping I haven't simply been looking in the wrong places...)

I have a whole bunch of orders that are marked "pending" and need to be changed to "processing". Is there a way to do this all at once rather than one at a time?

Many thanks!

Best -- Diane

2 Mar 2011, 5:15 PM
#2
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,187
Plugin Contributions:
0

Re: Is bulk change of order status possible?

Dd,
Sure you could by a .sql command to the database for that table..
Make sure you back up your Database First .. Very important if you make a mistake...

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.

2 Mar 2011, 5:25 PM
#3
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,187
Plugin Contributions:
0

Re: Is bulk change of order status possible?

Dd,
Read this thread all the way to the bottom and you will find your answer ...

http://www.zen-cart.com/forum/showthread.php?t=149488

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.

2 Mar 2011, 5:26 PM
#4
dduane avatar

dduane

New Zenner

Join Date:
Jan 2011
Location:
County Wicklow, Ireland
Posts:
4
Plugin Contributions:
0

Re: Is bulk change of order status possible?

haredo:

Dd,
Sure you could by a .sql command to the database for that table..
Make sure you back up your Database First .. Very important if you make a mistake...

I take your point, but I was hoping to do it without monkeying with mySQL -- I'm not proficient at that. Is there nothing inside Zen Cart as it stands that would allow you to select a group of orders and act on them as a group instead of one at a time?

Best! -- D.

2 Mar 2011, 5:28 PM
#5
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,187
Plugin Contributions:
0

Re: Is bulk change of order status possible?

Dd,
Please read post #3 and your answer is given no there is no admin control for this function unless you pain staking do it one at a time...
But the fun is learning and it will be done in milla seconds with the .sql command...

Welcome to ZenCart, The Art of Learning by Doing ....

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.

2 Mar 2011, 5:34 PM
#6
dduane avatar

dduane

New Zenner

Join Date:
Jan 2011
Location:
County Wicklow, Ireland
Posts:
4
Plugin Contributions:
0

Re: Is bulk change of order status possible?

haredo:

Dd,
Please read post #3 and your answer is given no there is no admin control for this function unless you pain staking do it one at a time...
But the fun is learning and it will be done in milla seconds with the .sql command...

Thanks, haredo! I had a look at that post and I think I see what they're getting at. I'll take a run at this later on.

Best -- D.

2 Mar 2011, 5:38 PM
#7
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,187
Plugin Contributions:
0

Re: Is bulk change of order status possible?

Dd,
Make sure to make a back up, yes a back up of the database before you try.. Will save you a major headache if you miss write the .sql command...

It is straight forward though you can do it, it is the curosity in your brain ....

Please post back on your results and the code your wrote... :wink:

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.

26 Aug 2014, 1:56 PM
#8
nimitdudani avatar

nimitdudani

New Zenner

Join Date:
Sep 2010
Location:
India
Posts:
1
Plugin Contributions:
0

Re: Is bulk change of order status possible?

Yes, I found one plugin which can change bulk order status and bulk print.

will share link shortly

21 Apr 2015, 12:38 AM
#9
jakedownhere avatar

jakedownhere

New Zenner

Join Date:
Aug 2006
Posts:
38
Plugin Contributions:
0

Re: Is bulk change of order status possible?

nimitdudani:

Yes, I found one plugin which can change bulk order status and bulk print.

will share link shortly

Link? I've been looking for a plugin that can do this...