Adding a fee to existing orders

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. :-)

Parents Reply Children
  • Thanks for your reply.

    Unknown said:

    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.

  • 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.

    - Heather

  • 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.