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.
Thanks for settling these debates!
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