Results 1 to 7 of 7

Thread: Referral Program Software or?

  1. #1
    Chairman/CEO TMCG
    Join Date
    Jan 2005
    Location
    Virginia
    Posts
    2,651
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Referral Program Software or?

    I am thinking of launching a referral program for my recycling business where people can earn either say $50 for every 3 people that they refer that use our services, or x amount off their own recycling job with us.

    I am trying to figure out if anyone knows of a way or program that would be good to keep track of everything.
    GeorgeB
    www.instantrewards4you.com EARN $20 TO $70 PER REFERRAL PAID DAILY INTO PAYPAL| www.viprecycling.com JUNK REMOVAL CO.| www.kgbeale.com ONLINE AUCTION SITE WITH NO LIMITS AND CHEAPER FEES |

  2. #2
    Junior Member
    Join Date
    Aug 2011
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not sure if this is what you're looking for but here's something that I found: http://www.hotscripts.com/listing/pr...d-site-script/

    If that's not what your looking for I recommend searching around more on HotScripts they have some pretty reputable scripts listed on there apposed to Google.

  3. #3
    NLC Ben's Avatar
    Join Date
    Jun 2001
    Location
    Atlanta
    Posts
    7,545
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    It sounds like something that could be easily managed with Access. Make a customer table, include a column for number of referrals. Then if you need the list of people with 3 referrals when it's time to send bills in the mail, just run a report in Access.

    Or something could even be hacked together with Excel ... just use the sort function to sort by the Referral column, then manually read the data off of it.
    "They're polyurethane --- toys, Joe. They aren't capable of judgment."

  4. #4
    Chairman/CEO TMCG
    Join Date
    Jan 2005
    Location
    Virginia
    Posts
    2,651
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @Ben:

    Yeah, basically, I just want something simple. So when I get a job, I can put in their details, then after the 3rd job, know that the referral is due their money or their discount on a future job.

    Unfortunately, I am not at all familiar with either Access or Excel, but do have them both, so will look into it.
    GeorgeB
    www.instantrewards4you.com EARN $20 TO $70 PER REFERRAL PAID DAILY INTO PAYPAL| www.viprecycling.com JUNK REMOVAL CO.| www.kgbeale.com ONLINE AUCTION SITE WITH NO LIMITS AND CHEAPER FEES |

  5. #5
    NLC Ben's Avatar
    Join Date
    Jun 2001
    Location
    Atlanta
    Posts
    7,545
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Here's a quick intro to creating a table in Access (although it probably goes into more detail than you'll need for what you mentioned)
    http://office.microsoft.com/en-us/ac...001224251.aspx

    And another intro to creating reports in Access
    http://office.microsoft.com/en-us/ac...001230739.aspx

    Access may be overkill for your needs, if you don't want to ever do anything with a customer database except mark how many referrals someone has. Excel, on the other hand, is fairly straightforward and seems like it may fit this singular task. But this seems like a decent intro. I've not looked through the whole thing, though
    http://people.usd.edu/~bwjames/tut/excel/
    "They're polyurethane --- toys, Joe. They aren't capable of judgment."

  6. #6
    FWS Addict Seraphim's Avatar
    Join Date
    Oct 2009
    Location
    Drawing Board
    Posts
    908
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was just thinking of hacking together something similar using PHP/MySQL to be plugged into my billing system. That way I can distribute coupon codes through the local news and keep track of who has used them, as well as implementing a referral discount of sorts for new clients.

    It wouldn't take much, just a table for the codes and a few SQL queries to do the sorting and checking. In my case I would just add the required columns for tracking referrals to my existing customers table and then a new table to keep track of coupon/referral codes and how many times they have been used.
    SeraphimLabs LLC, persistent hosting for your needs.
    Come what may we'll be there for you, keeping your dreams safe and growing.
    Chat with us, you don't have to be hosted by SeraphimLabs to get general tech help.

  7. #7
    Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1. Add a new field to user/registered.users table via phpmyadmin control panel(mysql, "add new field after x"), example name it "ref" (example. user with id "1" refers an new user who future id(after registration) is "2" and so into field "ref" will be inserted "1" (the user 1 referred him))

    2. The users "1" personal ref URL looks something like this url/-------1 (the users id).

    This URL should insert a cookie to a visitor browser and sets value ref="1", expires example in 1 month. (modify your index page or if you have a header separately add cookie command to it. the command that saves the referral value to new users pc)
    (search Google cookies and php)

    So I suggest retrieve the ref value to registration form from a cookie, and after new user(future id "2") clicks register, the email, name etc.. now also ref fields will be inserted/saved to db(you need to add a new insert value "ref", should be inserted like other users info, just need to add a new field).
    php example add new user to database:
    mysql(insert int user (email, name, ref) values (dd@dd.com, Oskar, $ref));

    Also add cash to the old user "1" for referring "2" example: 15+to the account balance.
    php example update old user and credit him:
    mysql(update user set cashbalance=cashbalance+15 where id=1);

    This is to identify who referred who. and credits it directly.


    So it will be done with PHP

Similar Threads

  1. Looking for a OEM software Affiliate Program
    By Hooligans in forum Ad Revenue
    Replies: 0
    Last Post: May 22nd, 2010, 09:24
  2. Just Launched Affiliate Program: $80/referral
    By ilyabern in forum Ads & Offers
    Replies: 0
    Last Post: August 4th, 2006, 13:46
  3. Replies: 0
    Last Post: January 5th, 2005, 17:46
  4. Wich Is The Best Chat Program Or Software??
    By olle in forum Free Services
    Replies: 5
    Last Post: January 30th, 2002, 22:45

Bookmarks

Posting Permissions

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