How to setup an OSCommerce Affiliate Program

If you have the OSCommerce Shopping Cart and you are looking to setup your own affiliate program, this can be easily done. If you do not already have an affiliate software system you can sign up for one of the Omnistar Affiliate Software Plans.

After you have your Affiliate Software account setup the integration into OSCommerce Cart is really easy. Simply follow the steps below.

We have made it easy to integrate your affiliate software with your shopping cart or gateway by following the instructions below. If you would like our technical team to integrate the software for you then you can sign up for our Managed Integration option.

Step 1. Add Code to your Landing Pages

Move the following code to your landing page. The landing page is the main page of your web site where web users will end up after clicking on the affiliate link. 
Please Note: Where it says, please replace that URL with the actual URL of where your software is installed.

var resource = document.createElement('script'); 
resource.src = "";
var script = document.getElementsByTagName('script')[0];
script.parentNode.insertBefore(resource, script);

Step 2. Add the Sale Tracking code

1. Find and open checkout_success.php, which is located in the osCommerce source files.

2. Inside the file find the following line of code:
if ($global['global_product_notifications'] != '1') { 

3. Insert the following code just above the line from step two.

// get order id
$sql = "select orders_id from ".TABLE_ORDERS.
" where customers_id='".(int)$customer_id.
"' order by date_purchased desc limit 1";
$omnistar_orders_query = tep_db_query($sql);
$omnistar_orders = tep_db_fetch_array($omnistar_orders_query);
$omnistar_order_id = $omnistar_orders['orders_id'];

// get total amount of order
$sql = "select value from ".TABLE_ORDERS_TOTAL.
" where orders_id='".(int)$omnistar_order_id.
"' and class='ot_subtotal'";
$omnistar_orders_total_query = tep_db_query($sql);
$omnistar_orders_total = tep_db_fetch_array($omnistar_orders_total_query);
$omnistar_total_value = $omnistar_orders_total['value'];

//get product ids
$sql = "select products_id from " .TABLE_ORDERS_PRODUCTS.
" where orders_id=".(int)$omnistar_order_id;
$omnistar_orders_products_query = tep_db_query($sql);
$omnistar_orders_products = '';
while ($row = tep_db_fetch_array($omnistar_orders_products_query)) {
$omnistar_orders_products .= $row['products_id'] . ',';
$omnistar_orders_products = substr($omnistar_orders_products, 0, -1);

// draw invisible image to register sale
if($omnistar_total_value != "" && $omnistar_order_id != "") {
function hideIF() { 
document.getElementById('IF').style.display = '';
function getSaleInfo() {
document.getElementById('st_code').innerHTML='<iframe src="<?php echo $omnistar_total_value; ?>&transaction=<?php echo $omnistar_order_id; ?>" alt="" id=IF width=50 height=50 border="0" frameborder="0" onload="hideIF()">';
window.onload = getSaleInfo;
<div id="st_code"></div>

Step 3. Test

Now you should test the affiliate program by creating a test user from your user area. Once you create a test user, sign in as that test user and copy the link under where it says "Link To Promote" and then click on the affiliate link that is shown. Next you should go through the entire process of completing an order with your shopping cart or order form by using a test credit card. Once you go through the process then you can make sure the test user received credit for the sale.