Normal 0 false false false EN-GB X-NONE X-NONE
Hi there, Hoping someone can help!
At the Philharmonia Orchestra box office, we operate a flexible subscription scheme for each season, where the level of discount is determined by the number of concerts each patron attends.
No. of concerts Discount Price type 3-5 10% Subs 3-5 6-8 15% Subs 6-8 9-11 20% Subs 9-11 12-14 25% Subs 12-14 15+ 30% Subs 15+ We would like to use pricing rules to apply the discounts, but is it possible to apply the discounts correctly, where there are different numbers of patrons coming to each concert? For example: A patron is coming to 15 concerts (and qualifies for the 30% discount). However, his wife only wants to come to 11 concerts (and only qualifies for the 20% discount). In my current setup I have ticked the box "Apply discount to lowest common number of seats". When I create the order, the correct price type (Subs 15+) has been applied to the SLIs where there are 15 concerts, but for the 11 tickets that do not qualify, the price type has reverted to the Standard price type, rather than Subs 9-11. I tried to get this to work by experimenting with Ranking in the Pricing Rule Set, but this didn't seem to work. If I untick the "Apply discount to lowest common number of seats" box, the discount is incorrectly applied to all SLIs. Another possible solution would be to set up a separate Pricing Rule Set for each rule?? Is there any way that I can get this to work using pricing rules? We often have very complex mixed subscriptions where a group of 8 people come to different numbers of concerts over the whole season, and if we could get this to work it would make our lives a lot simpler!
Thanks for any assistance. Murray Goulstone - Box Office Manager Philharmonia Orchestra 6 Chancel Street London SE1 0UX Box Office Telephone: +44 20 7921 9137 murray.goulstone@philharmonia.co.uk
Hi Murray,
This is a puzzler.
"SLIs to which manual price edits and discounts have been applied are excluded from pricing rules. Conversely, discounts cannot be applied to an SLI to which a rule already has been applied. However, manually editing an SLI to which a rule already has been applied will override the rule and may disqualify and reset the pricing on other SLIs that relied on the edited SLI to qualify for the rule."
I may be interpreting this wrong.
Kelly
It is not currently possible to accomplish the scenario you described with pricing rules.
Here’s what’s going on (from the documentation, with the key bit highlighted):
SLIs can only be affected by one pricing rule, the highest ranking qualifying rule in the rule set associated with the order's mode of sale. SLIs that have been affected by a rule are noted with an R in the Rule column on the Sub Line Items tab.
SLIs that are not repriced but are used as qualifiers in Add On and Buy One Get One rules are marked with a Q and are not considered when lower ranked rules in the set are evaluated against the order. SLIs that qualified for a rule but were not repriced because they were past the seat max for the rule and SLIs that did not qualify for a rule but are for the same product as SLIs that did qualify for the rule are also marked with a Q and are not considered by lower ranked rules.
(Kelly, you were definitely on the right track here, but the topic you referenced was the abbreviated QuickSale version of the pricing rules in action topic, and that topic doesn’t include the above quote. I’m going to look at improving that QuickSale topic to both make it more clear that it’s an abbreviated version and add an abbreviated version of the above quote)
In this case, when Apply Discount To Lowest Common Denominator of Seats box is checked, you have a total of 15 performances, 11 with 2 seats reserved, and 4 with only 1 seat reserved, so the lowest common denominator among all performances is 1 seat and the rule is applied to 1 seat in each of the 15 performances (marking those SLIs with P). The rule is not applied to the remaining 11 seats (i.e. the 2nd seat in those 11 performances the wife is going to attend) but as they are for the same performances to which a rule was applied, those 11 SLIs get marked with a Q and will be unavailable for any other rules. If you don’t check the Apply Discount To Lowest Common Denominator of Seats box, then all seats (SLIs) for all 15 performances will get the rule applied.
To sum up, while you can definitely create a sliding scale of product volume rules, but you can’t apply more than one of those rules to a single order.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Hi Kevin,Many thanks for your helpful, and comprehensive, reply.
Cheers.Murray