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. :-)
There's probably a reason you can't do this, but if they are rollovers, can't you just cancel the sets and redo them with the correct fee? Or have you gone down the merry renewal road too much to do that?
- Heather
Thanks for your reply.
Unknown said: can't you just cancel the sets and redo them with the correct fee?
can't you just cancel the sets and redo them with the correct fee?
We would do that, but from past experience we want to avoid confusion resulting from having cancelled Subscription orders out there. If cancelling the sets truly deleted the orders, we would do this.
In the end, if we have to open each order and add a fee manually, we'll do that (thankfully it's not all of the ro sets), but I hoped someone might have a clever fix.
Fees are not terribly difficult to add to an order. We add fees in order to charge our Met Player Monthly and Yearly Subscriptions in an automated process. I have included the code but it I consulted with the Network before I did this and would advise the same...(they always remind me of something I may have missed).....At the time they told me also to inclue the execute of TP_Update_Order_Totals. Hope this helps.
Take this with a grain of salt as I haven't done this recently, but if you cancel the seats created by rollover orders and then do the rollovers with the parameter 'Add to Orders Created After' parameter set correctly, won't that just recreate the orders in the the old cancelled roll over orders and not leave those pesky blank sub orders?
I'm pretty sure they look for orders created by the rollover process so you don't have to worry about single ticket orders and the like. As always, I'd try it on test to make sure I'm not leading you down some merry path, but I'm pretty sure that is how we've solved problems like this in the path.
That's what we've done in the past when a rollover goes wrong, cancel and reroll into the same orders. Of course you have to be careful for unseated orders since I have a vague memory that those don't cancel? So you'd need to manually clean those up either before or after.
Unknown said: Fees are not terribly difficult to add to an order.
Fees are not terribly difficult to add to an order.
This is exactly what I was hoping to hear :-)
I tested this, and it looks great. One little cursor and we'll be on our way...
Heather & Amanda-- Good to know about the cancel/reroll into existing orders method. I think when the cancelled orders showed up here we were in our first months on Tessitura and we just didn't run into that idea. A problem more substantial than this fee hiccup and we will certainly go down that road.
Thanks again for all replies.
A followup addendum to the above conversation: in addition to the code Julie listed, if the orders are season renewals, TP_UPDATE_NOTICE_FOR_CUST should be run on them as well.
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.