Promo Code distribution

Posted on 2014-10-06
Last Modified: 2014-10-16
I am trying to implement the promo code system. Where I can refer a friend and both will get a discount. I kind of know what to do. I have a created a promo code table. Now i need to find a way to distribute a promo code. I was thinking about sending an email. But the problem is the user need to be loggin first .

Once the firsdt user purchase the item it will use the existing promo code and append the user id to a promo-code and in this case I will know who send the promo code.

Please advice what would be best approach to distribute the promo code in a best manner.
Question by:erikTsomik
  • 4
  • 3
LVL 19

Author Comment

ID: 40363894
Are there any suggestions
LVL 36

Accepted Solution

SidFishes earned 500 total points
ID: 40364326
You've got the right idea. You don't really need the user to be logged in if they provide a valid email address that they will use -when- they login or register

Select link to send promo code
Enter user1 Email address, user2 email address
Submit form
Save u1 & u2 emails in table each to its own row with promo code. May want an identifier to indicate whether row is referral or referr-ee for referral success tracking. Also include a promo code usedYN field if the promo code is one time use. May also want to add datetime if referrals can expire (also for tracking)
cfmail promo code to u1 with easily cut and pastable or forwardable text for u1 to send to u2
don't send promo code to u2 ( u1 needs to do this otherwise it's not a referral, just spam)
When promo codes are used, look up email vs promo code in referral table and update to add time when used if required as well as usedYN field.
LVL 19

Author Comment

ID: 40364358
I only have 1 dilemma such as when the first person buys it they do not get the chance to provide a promo code. I will put this person into the lookup table with the promo code i generate for his/her friends. Once the user pass his/her promo to a friend and use it I will mark this code as used (from business logic it can be reused many times by different people,but only once by the same person) and generate the code for them so they can pass it to their friends.

How would I build the database at this point. because the promo code I want to use not just for referral I want to use it in regular bases   as well
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

LVL 36

Expert Comment

ID: 40364413
Since promo codes can be anything and you can have as many as you like, I'd think about having a specific one for referrals if for no other reason than it is easier to track if your referral program is effective.
LVL 19

Author Comment

ID: 40364419
Do you think creating a type of promotion on the promoCode table is a good Idea. (Referral program or just promotional code ). Something like that
LVL 36

Expert Comment

ID: 40371522
Yes. Having the ability to specify unique promo types can be quite useful, even if you don't use it right away.  Allows ofr lots of flexibility and reporting options.
LVL 19

Author Comment

ID: 40371600
How would I say which promo to use. I have decided to create a generic promos. By using a  referral program I need a way to figured out where is this promo code is came from so I said I just add an id to the end of the code.

The dilemma is how to know which generic code to use,because I may end up with many

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CSS Question.. 3 77
WordPress/WooCommerce security best practices? 2 82
Microsoft Edge 9 91
Logging into a website with Facebook/Twitter/Google etc. 2 69
E-commerce is quite a gambling world, and you should never entrust your business to a lucky chance. In order to outrun your competitors in a race to attract as many customers as possible, you need to have a well thought-out strategy under your belt.…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now