Notice: Undefined variable: s_offline in /homepages/6/d168803796/htdocs/officetrio.com/o3/o3start.php on line 314
Free PHP Affiliates Tracking Script OfficeTrio: The Integrated ECommerce Solution OfficeTrio: The Integrated ECommerce Solution OfficeTrio: Features OfficeTrio: User Manual OfficeTrio: Testimonials OfficeTrio: The Demo is Offline! OfficeTrio: Order O3 Now

Free Affiliates Tracking Script

NEW Version 4.0 Released 4 March 2004!

Now handles variable commissions and multiple products!

An affiliates tracking script can help boost your sales dramatically. Recruit a worldwide army of eager salesmen with this (fairly) simple to understand but powerful script...

See the page on EWS: Free ECommerce Website System for a complete system based on this script. It's includes fully-functional affiliates-management and products-management scripts, PLUS a full-featured PayPal IPN handler to record your sales and referrals automatically. Works with all the PayPal merchant's tools... More...

This free script allows your affiliates to sign up, get links, change their details and retrieve lost passwords. It includes a banners manager, an admin 'control-panel' page and a stats page. It's basic but functional!

Script Features:
  • Handles full lifecycle from signup to removal
  • Tracks down 3 levels of referrals
  • Works with any number of products.
  • Handles product price changes.
  • Affiliates can see how many hits / referrals / sales they have made
  • Example explanation text included.



To see this free script in action on a test database - click here: Affiliates Tracking Script - LIVE.



To download any of the free scripts, please go to the Free Scripts page.
My scripts are FREE for non-profit use.
If you use them commercially, please make a donation. Thanks.


Requirements

You need to be able to install the scripts in the root directory of your website. If you need an FTP tool, see the page on Telnet and FTP.

You need to enter your database login details into the two scripts using a text editor. If you need an HTML / PHP Editor, see the page on HTML Editors.

You need to have access to PHP and a MySQL Database. You'll need to know your database username and password because these must be entered into the scripts.

You need access to PHPMyAdmin or similar tool so you can create the database tables.



Installation - Free Script

See the





How The Script Works:

  1. An affiliate signs up.

  2. A unique ID is generated for them.

  3. They are sent an email with this info in it.

  4. Once logged in, they can see a 'banner' link to your website to cut and paste into their webpages, i.e.

    http://yourdomain.com/index.php?referrer_id=1

  5. That link contains their ID, and when the browser arrives at your site...

  6. A cookie with that ID is placed on the prospect's computer using the code described above.

    Cookies contain values which are transmitted back to the site they came from. That's all they do!

  7. If they click to buy your product, the referrer_id is included in the post to PayPal by including the line in the paypal button form code as described above.

  8. The referrer_id value is passed through the PayPal ordering system, and ends up, along with the rest of the order info, at your ipn.php (payment processing) script.

  9. The ipn.php script records the affiliate's ID along with the rest of the order info into the 'sales' table in the database.


It's then up to you to pay your affiliates!

Note: A lot of people ask me about getting an automated system setup to pay their affiliates. This isn't possible thru PayPal - they have 'Mass Pay' but the amounts must be pre-set (apparently). If you're making enough sales for it to be a problem - you can afford to hire someone else to do it!

I hope you find this script useful. Let me know how you get on!



For More Info....

  • A popular commercial tutorial on making your affiliate program a success is James Martell's Affiliate Master Course. I hear it's a good read, but I've yet to read it myself.

  • 'The Affiliate Masters Course' is an excellent free ebook from SiteSell.com. It's available in the free ebooks library.

  • For more info on affiliate programs, what they are, how they work etc. see the affiliates page.

  • This script is listed in totalscripts.com!


    To download any script, please go to the Free Scripts page.


Tutorials

Contents

Free EBooks
Free Scripts

Introduction
What Can I Do With A Website?
Internet History
Introduction
Preparation
Website Builders

Webmaster's Tools
Tools Intro
HTML Editor
PHP IDEs
Graphics Resources
Telnet and FTP
Miscellaneous Tools

Web Design
Web Design
Domains
Keywords/Description
Logo/Graphics

Creating Web Pages
Setup
HTML
HTML Tips And Tricks
Home Page
Navigation
Other Pages

Webhosting and Unix
Webhosting
Telnet/Unix
More Unix
Website Upload
Analyse And Verify

Programming
Programming 1
Programming 2

PHP
PHP
PHP Scripts
PHP Hit Counter Script
PHP Download Tracking Script
PHP Navigation Script
PHP Affiliates Tracking Script
PHP Users Management
PHP Site Search Script

Perl
Perl
Perl Hit Counter Script
Perl Order Processing Script

Databases
Databases
SQL
Database Setup

ECommerce
ECommerce

Automation
Automating Order Processing
PayPal Automation
Email Automation
Installing Scripts

Security
Basic Security

Affiliates
Affiliates Programs

Managing Your Website
Website Management
Promotion/Advertising
Search Engines
Search Engine Optimisation



Powered By OfficeTrio