[ic] Gift Certificates

Paul Jordan interchange-users@icdevgroup.org
Thu Feb 6 01:04:00 2003


> This being the case, whether pertinent or not, we would like to
> implement gift certificates so that when checking out; a user
> enters the certificate number and it will auto recalc as that the
> number is checked against those in a dbase and deducts the proper
> amount from the order total no matter what the payment term or type is.
>
> I trust this is clear.  If anyone knows the best direction to
> head or if there is a better form or way of doing this, please
> advise.  Any and all help is appreciated.
>
> Thanks,
> Dan

Hi Dan

Do you mean gift certificates or coupons? If it is the prior, FWICR
interchange has gift certificate functionality, I think there is even
something in the demo, but I have never looked into it. However, in your
question, it seems like you mean coupons, becuase you don't make mention of
how to give the ability for a person to "buy" a gift certificate, which IMO
would be the hard part.

Either way, and if you mean coupons, this can be done with (at the very
minimum, and would not be the most efficient) itl, the discount tag, with a
table, and columns like:

cert_id  cert_type  min_amt  cert_amt  start_date  end_date  cert_foo....

then make a special page that just process data, place a query in it to
check

1. if the coupon code exists
2. what type, $off %off
3. if there is a time limit
4  if there is a minimum dollar amount
5. etc

and then if it all qualifies, to apply the [discount] tag, with the outcome
of the query tag, and then bounce back to the original page.

http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=ictags04%2e20

It can be alot cleaner, and more robust if you know perl, or hire someone
who does, but the db,query,discount thing works fine.

Paul