Hi all,
I have a question for those of you familiar with the membership functionality in Tessitura. We give out "complimentary" memberships on occasion, either for charity auctions or for use by our sponsoring organizations. This is all manual outside of Tessitura right now, and when the correct forms are received, we create constituent records with the appropriate information and add a comp membership to the account.
Trouble is, this means the recipient gets a form, but has to mail it back and wait for it to get processed before they get member access. Is there any way we might be able to use online promo codes or offers to let these people "buy" a membership online, but give it to them for free? Or is all the offer functionality tied specifically to price types for tickets?
Thanks, everyone!
Beth
Beth, we have created a local procedure to be called by the API that will insert a complimentary membership. Then the website can fire off the local procedure when appropriate. That part was pretty easy and we'd be happy to share the code for that.
The Tricky part was how to send member cards (acknowledgement) to a comp membership as an acknowledgment letter request is only created with a contribution. JCA came up with a customization to the acknowledgment letter stored procedure. In a nutshell, they added code to look for all memberships with a $0.00 contribution amount and when found, insert a row into T_ACK_EXT so that cards can be printed, and then reprinted if necessary. Works pretty well.
Christian