Link to home
Start Free TrialLog in
Avatar of erikTsomik
erikTsomikFlag for United States of America

asked on

Promo Code distribution

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.
Avatar of erikTsomik
erikTsomik
Flag of United States of America image

ASKER

Are there any suggestions
ASKER CERTIFIED SOLUTION
Avatar of SidFishes
SidFishes
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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.
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
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.
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