Hello,
I am in need of any information on how to bulk update delivery methods for a large number of orders. There are about 4000 orders that we would like to bulk update to our "Electronic Delivery" method.
We are using True Tickets digital tickets for our E-Tickets. Currently, to change a delivery method requires loading the order, changing it then clicking "Done" which invokes the True Tickets process to pull the tickets into the customers digital wallet.
Brute Force changes are not an option for a lot of reasons many of you will already be aware of.
The alternative is to create a custom utility the creates a batch and loads all the orders into the batch and changes their delivery method.
If anyone has prior work on this they're willing to share, we would appreciate it very much.
Thanks in advance!
Hi Jerry,
I had a similar issue. In SQL, I was able to update the delivery method for a number of orders based on performance number, using the below query (update the highlighted bits):
UPDATE o
Set o.delivery = xx
FROM T_Order o
Join t_lineitem l on o.order_no = l.order_no
join t_perf p on l.perf_no = p.perf_no
where o.delivery = xx
and p.perf_no in ('xx','xx')
You could also have it apply to a whole Production season, but changing the last line to:
and p.prod_Season_no = xx
Hope that helps!
Colin