Pricing Rules: Pre-sale and virtual memberships

Brian

Appreciate your willingness to reply and certainly acknowledge how nice having a SQL guru can be.  In this case though there would not be a list yet – it would be virtual and no constituency or invalid constituency.

Would be great if someone could just let us know if we need to change our membership or not. 

From: Brian Parker [mailto:bounce-brianparker6265@tessituranetwork.com]
Sent: Wednesday, December 14, 2016 1:27 PM
To: McKinley, Leslie <LMcKinley@nycitycenter.org>
Subject: Re: [Tessitura Technical Forum] Pricing Rules: Pre-sale and virtual memberships

Leslie,

1.) My guess on this would be TRUE but I know that our SQL guru for our consortium set up a List Manager Criteria we've labeled Constituency* (ALL) which will pull anyone to a list that has had a specified (or a multi-selection of specified) Constituency even if it is no longer active. Obviously, this could have negative implications because you might pull people who shouldn't be promoted, but this might be one solution to a "virtual" membership that hasn't technically begun but should be active for ticketing.

Code:

Select Distinct a.customer_no 

 From V_CUSTOMER_WITH_PRIMARY_GROUP a  WITH (NOLOCK)

 JOIN (Select a1.customer_no From lxs_const_cust a1 WITH (NOLOCK) Where a1.constituency in (274)) as e ON e.customer_no = a.customer_no

 Where IsNull(a.inactive, 1) = 1

2.) As far as I know this would also be TRUE. I believe you can set Constituent Criteria with a given Pricing Rule so you could set the on-sale date for that Pricing Rule to be prior to your public on-sale availability. We do this with our Center for Dance Education (kind of) by turning on our internal ability to sell tuition to classes before they are publicized on our TNEW page, so I'm assuming that Constituent Criteria could be a solution for a public TNEW on-sale. I'm admittedly not as seasoned on this, though.

Thank you,

Brian

Hi Leslie,

Virtual constituencies considered by pricing rules are based solely on what’s in the cart. So if a constituent has a membership at a level with a constituency defined in the cart, then the pricing rule will treat the constituent as if he has that constituency; start dates on the membership record don’t come into play at that point. If a membership is not in the cart, there is no virtual constituency functionality. So if I buy a membership today, and then I come back tomorrow to buy a ticket, that membership I bought the day before has no effect on the pricing rule. If you want constituents who have pending memberships on their accounts to receive discounts from memberships, you’ll need the constituent criteria to consider something like a list of all constituents with a membership that starts next month (and then use the Generate a List utility to update the list contents nightly).

To your second question, because pricing rules only affect pricing, not MOS or access to performances, they can’t be used to manage presales. Automatic presale access is generally managed by ranking based MOS shifts: http://www.tessituranetwork.com/Help_System_v125/Content/Tessitura_and_the_Web/Rank%20Based%20Mode%20of%20Sale%20Shifts.htm

Kevin Sheehan

Senior Technical Writer & Consultant

Tessitura Network

+1 888 643 5778 x 329

ksheehan@tessituranetwork.com

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Leslie McKinley
Sent: Wednesday, December 14, 2016 11:33 AM
To: Kevin Sheehan <ksheehan@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Pricing Rules: Pre-sale and virtual memberships

We trying to work through the steps and changes that may be needed to use the new Pricing Rules and  two questions within Development seem to take us in circles

1) Virtual memberships -- memberships start the first of the next month so a person becoming a new member would be given a constituency that begins the first of the next month (true too for upgrades when constituencies change).  

The rules says the constituency must be active  -- based on the above the virtual membership will not work since membership/constituency will not be active until the next month.

TRUE or FALSE?

2)  Pre-sales  -- rather than discounts we tend to do more pre-sale for members.   Since by definition prior to public sales -- it is possible to set a pricing rule that allows members to login and buy ahead of public sales.   

TRUE or FALSE?

Thanks for settling these debates!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thanks this helps and it does mean we need to change our member set up and you have certainly made our next discussion on pre-sales more interesting.

Hi Leslie,

Virtual constituencies considered by pricing rules are based solely on what’s in the cart. So if a constituent has a membership at a level with a constituency defined in the cart, then the pricing rule will treat the constituent as if he has that constituency; start dates on the membership record don’t come into play at that point. If a membership is not in the cart, there is no virtual constituency functionality. So if I buy a membership today, and then I come back tomorrow to buy a ticket, that membership I bought the day before has no effect on the pricing rule. If you want constituents who have pending memberships on their accounts to receive discounts from memberships, you’ll need the constituent criteria to consider something like a list of all constituents with a membership that starts next month (and then use the Generate a List utility to update the list contents nightly).

To your second question, because pricing rules only affect pricing, not MOS or access to performances, they can’t be used to manage presales. Automatic presale access is generally managed by ranking based MOS shifts: http://www.tessituranetwork.com/Help_System_v125/Content/Tessitura_and_the_Web/Rank%20Based%20Mode%20of%20Sale%20Shifts.htm

Kevin Sheehan

Senior Technical Writer & Consultant

Tessitura Network

+1 888 643 5778 x 329

ksheehan@tessituranetwork.com

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Leslie McKinley
Sent: Wednesday, December 14, 2016 11:33 AM
To: Kevin Sheehan <ksheehan@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Pricing Rules: Pre-sale and virtual memberships

We trying to work through the steps and changes that may be needed to use the new Pricing Rules and  two questions within Development seem to take us in circles

1) Virtual memberships -- memberships start the first of the next month so a person becoming a new member would be given a constituency that begins the first of the next month (true too for upgrades when constituencies change).  

The rules says the constituency must be active  -- based on the above the virtual membership will not work since membership/constituency will not be active until the next month.

TRUE or FALSE?

2)  Pre-sales  -- rather than discounts we tend to do more pre-sale for members.   Since by definition prior to public sales -- it is possible to set a pricing rule that allows members to login and buy ahead of public sales.   

TRUE or FALSE?

Thanks for settling these debates!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

One last clarification/confirmation     -  A Virtual Constituency only pertains to a pricing rule and cannot impact ranking SO that means if we have a person who is joining to be able to  take advantage of the pre-sale that person will need to have Promo Code with an Override Ranking Ind.

Hi Leslie,

Virtual constituencies considered by pricing rules are based solely on what’s in the cart. So if a constituent has a membership at a level with a constituency defined in the cart, then the pricing rule will treat the constituent as if he has that constituency; start dates on the membership record don’t come into play at that point. If a membership is not in the cart, there is no virtual constituency functionality. So if I buy a membership today, and then I come back tomorrow to buy a ticket, that membership I bought the day before has no effect on the pricing rule. If you want constituents who have pending memberships on their accounts to receive discounts from memberships, you’ll need the constituent criteria to consider something like a list of all constituents with a membership that starts next month (and then use the Generate a List utility to update the list contents nightly).

To your second question, because pricing rules only affect pricing, not MOS or access to performances, they can’t be used to manage presales. Automatic presale access is generally managed by ranking based MOS shifts: http://www.tessituranetwork.com/Help_System_v125/Content/Tessitura_and_the_Web/Rank%20Based%20Mode%20of%20Sale%20Shifts.htm

Kevin Sheehan

Senior Technical Writer & Consultant

Tessitura Network

+1 888 643 5778 x 329

ksheehan@tessituranetwork.com

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Leslie McKinley
Sent: Wednesday, December 14, 2016 11:33 AM
To: Kevin Sheehan <ksheehan@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Pricing Rules: Pre-sale and virtual memberships

We trying to work through the steps and changes that may be needed to use the new Pricing Rules and  two questions within Development seem to take us in circles

1) Virtual memberships -- memberships start the first of the next month so a person becoming a new member would be given a constituency that begins the first of the next month (true too for upgrades when constituencies change).  

The rules says the constituency must be active  -- based on the above the virtual membership will not work since membership/constituency will not be active until the next month.

TRUE or FALSE?

2)  Pre-sales  -- rather than discounts we tend to do more pre-sale for members.   Since by definition prior to public sales -- it is possible to set a pricing rule that allows members to login and buy ahead of public sales.   

TRUE or FALSE?

Thanks for settling these debates!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

That is correct.