Restricting shipping method for specific performance

Hi Oscar

We are doing something similar but its not restricted to any particular performance. I've created a stored procedure which runs daily via SQL Jobs and updates the Delivery Method to Box Office Collect if the order by WEB is placed 10 days prior to the concert and has delivery method as Postal Mail.

Similarly you can also create an SP with the parameter of Performance Number and create SQL job to run daily for that specific performance till the performance date is reached.. This can take care of any manual errors.

Hope this helps.

cheers, Varsha

Hi Oscar

We are doing something similar but its not restricted to any particular performance. I've created a stored procedure which runs daily via SQL Jobs and updates the Delivery Method to Box Office Collect if the order by WEB is placed 10 days prior to the concert and has delivery method as Postal Mail.

Similarly you can also create an SP with the parameter of Performance Number and create SQL job to run daily for that specific performance till the performance date is reached.. This can take care of any manual errors.

Hope this helps.

cheers, Varsha

Hi Varsha,

I do not believe we have that much access to the database as RAMP user.  Is there any other way?

Thanks

Oscar