We are getting started with our '11-'12 season rollover, and after executing our first two Rollover Sets, we find that the fee rule wasn't quite right, and none of these orders have a handling fee.
Is anyone aware of a way to add these en masse? Crazy SQL solutions welcome. :-)
Hey! I know this forum entry is from over a decade ago... but I'm having this same problem. We didn't have the subscription order fee in when we did the rollover. Now we need to add it to all those orders. I don't full understand Chris Jensen's solution before. Is there a way to do this without manually adding a fee to every order?
We have had need to add fees in bulk via SQL a number of times since 2013, so I have code for this. Please drop me a line at chrisj@guthrietheater.org, and I will send.