** We are self-hosted **
My coworker has reported to me that the mode of sale on some recent web orders is not correct. Based on the information she gave me (see below), I went to look at SQL Server Agent jobs, but didn't see any jobs that reference mod of sale.
I guess the first thing I need to know is if switching a subscriber purchase into a new MOS is a native function of Tessitura or if it is custom to the SLSO? Can anyone help me?
Per my coworker: "We had 4 subs purchase tickets online yesterday. Two of them had the MOS switch to sub web mos, but one was in internet offer mos, and the last one was in internet mos. I'm not sure what is causing the difference...The (script/procedure/job/whatever) that runs to switch a subscriber into a new MOS is not behaving as it has in the past, and i'm pretty sure part of the confusion is that we don't have any 21S subscribers."
Thanks,
Ashley
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Hi all,
Thanks for the feedback. The original issue was subscribers not getting their subscriber discount for single ticket purchases online, but I think updating the rankings was the missing piece of the puzzle. I've made a couple of edits to the TR_WEB_RANKING table, and seem to be getting the MOS switch as expected when I made myself "subscriber for a day" by adding the ranking to my account. Waiting to confirm it's working consistently for real subscribers, but I think we're in good shape.
Thanks again!