Has anyone successfully implemented online functionality with the public view events to allow discounting. For example enter a code (aka coupon) that validates against a value within iMIS and then provides a set discount to the online basket. Most preferrably adds a specific function to the basket that is defined with a negative amount (the discount).
Looking for ideas - thanks
Tricia
For products you coudl do something like this with out of the box. I didn't say it would be pretty but this is out of the box.
Create a user defined field called coupon code
Let the user edit/fill that out through the public views
Setup special pricing on each item (yes EACH item) to look for that code and calculate a discount. OR if you want to have a coupon with a negative number put an item in the store called discount that is always $0 unless the person has the UD field and special pricing is calculated. This woudl work for a $10 off coupon or the like.
In events you coudl use the same user defined field and then create a special registrant class for the discounted price. Use the option to calculate registrant class through a stored procedure which would look for that code.
Similarly special pricing could be setup in dues to loko for that code.
I am not sure i would ever recommend to one of my clients to do it this way. Instead i would build a custom cart using the .NET IBO's (which we have done). But they say if there is a will there is a way and while it may not be pretty you could technically use some of these techniques to get this done.
Thanks,
Randy (rrichter@atsol.org)
Hi Tricia,
If you would like to contact me lbrown@ibconcepts.com I can provide you with some information on an add on that we created that allows a member online add a "coupon" code and modifies the cart.
Thanks
Lisa Brown
IBC
I have just posted a question about using the SQL registration validation for a similar purpose.
In my case, we want a discounted price above a certain quantity of registrantion functions (we actually fake our event tables as functions).
I have not gotten this working because I cannot find the information on what context I have. There is what appears to be an array called AsiSQL(orders.st_id). Presumably other values are also available in addition to orders.st_id)
I wrote a stored procedure to edit the value of the price of a function if the quantity was above a certain value. Since the parameters passed are visible in the registration checking sql, it is easy for staff to edit for other events.
Tom McIntyre Treasurer/Consultant NAWCC
Hi Tricia This functionality
Hi Tricia
This functionality doesn't exist in iMIS anywhere, so it can't really be supported in the public view.
You might be in a position where you have to go to a third party event rego system and integrate to iMIS. The only other thing I can think of would be to set a registration class that has the discounts you want in the pricing and then do a customisation that removes the registration from the shopping cart, changes the registration class to the discounted class and then ads in back in again. You'd still need some way of manaing your coupon codes though - and there's not really anything out of the box in iMIS to do that.
Sorry - not much help.
Jay