Normal 0 false false false EN-US X-NONE X-NONE
We have a stored procedure that updates constituent subscription history for our non-fixed subscription packages. Everything has been working properly for the majority of our constituents, but it has recently come to my attention that anyone who exchanges all of the tickets in their subscription package loses their season subscriber status in ticket history -> subscription history. The stored procedure appears to look at the lack of package seats with the “Seated” status and doesn't retain their subscription status. This is causing problems for my marketing folks.
I've attached a screen shot of a subscription order with exchanges and would really appreciate some guidance from anyone with experience with non-fixed packages and the lp_update_subs_hist procedure.
Thank you,
Alden
You probably want to change your stored procedure from referencing package slis to determine "subscriber" status to instead reference tickets with price type category "subscription". Then it won't matter if there have been exchanges because anyone with a subscription ticket is deemed a subscriber.