www.webdeveloper.com
Results 1 to 4 of 4

Thread: coupon generation and redemption

Hybrid View

  1. #1
    Join Date
    Jun 2012
    Posts
    2

    coupon generation and redemption

    Hi everybody,

    I am wondering if I could throw this out there and get a bit of feedback/advice on this project.

    We are trying to provide our users with access to coupons that they can print from their computer. We currently use a learning management system (written in PHP) so our users will be logged in we can easily access their name, user_id, and the like with just a few lines of PHP.

    As the user is going through material, they will see a graphic that says, "click her for a coupon". This graphic can popup a new windows. In the new window, we want to have information about the merchant/discount and a button that says, "print". After the user clicks print, a dynamically generated coupon would be created and print out.

    Features/Restrictions we would like in place:

    - dynamically generated coupons: merchant name, discount, location, logo, unique coupon id number and user's name drawn from a database and contained on the coupon as it is generated "on-the-fly"

    - users can only print the coupon one time

    - If the user tries to print the coupon more than one time, they should see a message that says, "you have already printed this coupon on INSERT PRINTED DATE HERE"

    - We would also like the user to be able to access a sort of coupon dashboard where they would see a list of all the coupons and a column with the "status" of a coupon which would indicate if the coupon is "locked", "unlocked and printed", or "unlocked and not printed". A coupon will be "locked" until the view the graphic for the first time that says, "click here for the coupon"

    Does anybody have any ideas on the logic of this setup? I am thinking of doing the following:

    - When the user clicks the graphic that says, "click here to print", that will be a link that opens a new window like displayOffer.php?id=123

    the id variable will correspond to the coupon_id variable.

    How would you guys go about tracking when the coupon has been displayed, when the user clicks print, and assigning unique coupon id#s to each coupon?

    So far, I am thinking I will need the following DB tables setup:

    COUPONS
    - coupon_id (int)
    - merchant_id (int)
    - discount (varchar)
    - expiration (date)

    MERCHANTS
    - merchant_id (int)
    - name (varchar)
    - address (varchar)
    - phone (varchar)
    - city (varchar)
    - email (varchar)
    - website (varchar)

    USER_COUPONS
    - user_id (int)
    - coupon_id (int)
    - status (varchar)
    - unlocked_date (date)
    - print_date (date)

  2. #2
    Join Date
    Mar 2012
    Posts
    1,560
    The idea of restricting the user to printing the coupon only once will not work:
    a) What if the printout fails (for any of a plethora of reasons)?
    b) If you ask "printout ok?" what's to stop them saying "no" when it has?
    c) What if they "print" to a pdf file? They can then print it as many times as they like!!!

    It just is not reliable, and could cause more bad feeling, and time-wasting, than good. A better solution is to:
    a) Tell the users that the redemption of vouchers will be monitored, so not to abuse the system.
    b) Record the issue of vouchers to individuals (as you had already intended).
    c) Record the redemption of vouchers, allowing for multiple usage, and date-last-used.
    d) Periodically run a simple report to output multiple usage in a date-last-used range.
    e) Take whatever action is appropriate...

  3. #3
    Join Date
    Jun 2012
    Posts
    2

    thanks

    thank you for your response - I really appreciate it.

  4. #4
    Join Date
    Sep 2007
    Posts
    4
    We were looking at the same thing, thanks for the feedback Jed!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles