I need a PHP/MySQL developer to help with an existing application that I developed for a client to include a "Refer a Friend" tracking system. The current application essentially is a contact management system that allows my client to collect client information via a form on their website and then provides a back-end management tool that allows them to:
A. export customer records to a CSV file
B. edit the information of the users and
C. Add new records to the database.
Essentially, my client wants to add a referral tracking system to the current customer management system. Here's the workflow I would like to see:
Step 1. Client sends out an email to current customers with a promotion of a $5 store credit for every "Friend" they refer that fills out a catalog request form online.
Step 2. Customer visits "refer a friend" page and enters the name and email address for up to 6 friends (or more possibly).
Step 3. Email is sent to the "Friends" that were referred that contains a link to the Catalog Request Form on my client's website.
Step 4. "Friend" signs up to receive a catalog and their information is added to the customer database.
Step 5. My client needs to be able to log into the existing system and open a page that shows which "Friends" signed up for a catalog and which "Referrals" sent them the email. He will then need to send out coupon codes or gift certificates manually and then check off the people who have received a coupon code so he doesn't see them on the list again.
If you have any questions, please post below. The current system is very, very basic. There should be no problem learning the current app's architecture.