Hello all,
We are about to launch our digital season and it has come to our attention that in order for patrons to view the productions, the order must be processed on the household level if one exists. I'm trying to figure out a way to pull all orders in this season that were processed to an individual where a household exists. Then, we would transfer the orders to the household.
I imagine a query would be possible, however, I'm still a SQL beginner.
Unfortunately, time is of the essence. Any help would be appreciated!
Thanks in advance,
Michelle
Is your transact_as_household_order setting in T_DEFAULTS set to "no"? Setting that to "yes" will make it so all ticket orders will be redirected to the household automatically for future orders. It marks the individual placing the order as the initiator on the order if you still need to know which individuals are placing orders.