Home Integration Methods osCommerce

osCommerce

Integration with osCommerce is made by placing sale tracking script into the confirmation page. To obtain the values of OrderID and TotalSale, snippet connects to osCommerce database and retrieves the values from there.

Find file checkout_success.php

Find and open file checkout_success.php in osCommerce source files.

Locate right place for integration

Inside the file find this line if ($global['global_product_notifications'] != '1') { ...
it should be somewhere after <! DOCTYPE ........> line.

Add integration code

insert the following code just above that line

//get product ids
    $sql = "select products_id from " .TABLE_ORDERS_PRODUCTS.
          " where orders_id=".(int)$pap_order_id;
    $pap_orders_products_query = tep_db_query($sql);
    $pap_orders_products = '';
    while ($row = tep_db_fetch_array($pap_orders_products_query)) {
        $pap_orders_products .= $row['products_id'] . ',';
    }
    $pap_orders_products = substr($pap_orders_products, 0, -1);
 
   // draw invisible image to register sale
   if($pap_total_value != "" && $pap_order_id != "")
   {
      print '<script id="pap_x2s6df8d" src="http://www.yoursite.com/affiliate/scripts/salejs.php" type="text/javascript"> </script>
'."<script type=\"text/javascript\">
var sale = PostAffTracker.createSale();
sale.setTotalCost('$pap_total_value');
sale.setOrderID('$pap_order_id');
sale.setProductID('$pap_orders_products');

PostAffTracker.register();
</script>";
   }
   //--------------------------------------------------------------------------
   // END of integration code
   //--------------------------------------------------------------------------

Integration is finished

It is now integrated. Every time customer enters the order confirmation page the tracking code is called and it will register a sale for referring affiliate.

Another integration

If you plan to divide products into more campaigns, you will probably need another integration, that will divide the whole sale into single product sales.

//--------------------------------------------------------------------------
   // integration code
   //--------------------------------------------------------------------------
   // get order id
   $sql = "select orders_id from ".TABLE_ORDERS.
          " where customers_id='".(int)$customer_id.
          "' order by date_purchased desc limit 1";
   $pap_orders_query = tep_db_query($sql);
   $pap_orders = tep_db_fetch_array($pap_orders_query);
   $pap_order_id = $pap_orders['orders_id'];
    
    //get variables for script
    $sql = "select products_id,products_price,products_quantity from " .TABLE_ORDERS_PRODUCTS.
          " where orders_id=".(int)$pap_order_id;
    $pap_products_total_query = tep_db_query($sql);
    $k = 0;
    while ($row = tep_db_fetch_array($pap_products_total_query)) {
        $pap_products_total[$k+1] = $row['products_price'] * $row['products_quantity'];
        $pap_products[$k+1] = $row['products_id'];
        $k++;
    }
    
    // draw invisible image to register sale
    if($pap_order_id != "")
    {  
   
    ?>
    <script id="pap_x2s6df8d" src="http://www.yoursite.com/affiliate/scripts/salejs.php" type="text/javascript"> </script>
    <script type="text/javascript">
     <?php
     for ($j=1; $j<=$k; $j++){
      echo "var sale".$j." = PostAffTracker.createSale();\n".
           "sale".$j.".setTotalCost('". $pap_products_total[$j]."');\n".
           "sale".$j.".setOrderID('".$pap_order_id."');\n".
           "sale".$j.".setProductID('".$pap_products[$j]."');\n\n";
     }
    ?>
    
    PostAffTracker.register();
    </script>;
    <?php
    }
   //--------------------------------------------------------------------------
   // END of integration code
   //--------------------------------------------------------------------------

Direct PayPal integration with osCommerce

If you want to rely on PayPal IPN (as this is secure and 100% sure that the transaction will be recorded), you can directly edit the PayPal button template in osCommerce. Login to your FTP and navigate to
catalog/includes/modules/payment/
and edit file paypal_standard.php
Find function process_button and scroll down to end of it. You should find this block of code:

} else {
    reset($parameters);
    while (list($key, $value) = each($parameters)) {
      $process_button_string .= tep_draw_hidden_field($key, $value);
    }
 }
      
  return $process_button_string;

// --------------------------------------------
// change this whole block of code to this block:

} else {
        reset($parameters);
        while (list($key, $value) = each($parameters)) {
          if ($key == "custom") {
            $tofix = tep_draw_hidden_field($key, $value);
            $process_button_string .= substr($tofix,0,-1) .' id="pap_ab78y5t4a" >';
          }
          else {
            $process_button_string .= tep_draw_hidden_field($key, $value);
          }
        }
      }

$process_button_string .= '<script type="text/javascript">';
      $process_button_string .= 'document.write(unescape("%3Cscript id=%27pap_x2s6df8d%27 src=%27" + (("https:" == document.location.protocol) ? "https://" : "http://") + "www.yoursite.com/affiliate/scripts/trackjs.js%27 type=%27text/javascript%27%3E%3C/script%3E"));';
      $process_button_string .= '</script><script type="text/javascript">PostAffTracker.setAccountId(\'default1\');';
      $process_button_string .= 'PostAffTracker.setAppendValuesToField(\'||\');';
      $process_button_string .= 'PostAffTracker.writeCookieToCustomField(\'pap_ab78y5t4a\');</script>';
      
      return $process_button_string;

This will add tracking script directly to the paypal button and insert proper value into custom parameter.

Now, you have to resend the IPN from osCommerce to PAP too. See the next step.

PayPal redirect to PAP

When there is a sale, PayPal sends IPN to your osCommerce. You have to resend it to PAP to save the transaction. Navigate to catalog/ext/modules/payment/paypal/ in your FTP and modify file standard_ipn.php . Insert the following code to the beginning of the file:

The last step is to modify customer ID saved in custom field, to the the value without PAP4 visitor ID. Find line
if ($result == 'VERIFIED') {
and add the following code above the line:
$separator = '||';
    if ($_POST['custom'] != '') {
      $explodedCustomValue = explode($separator, $_POST['custom'], 2);
          if (count($explodedCustomValue) == 2) {
            $_REQUEST['custom'] = $_POST['custom'] = $explodedCustomValue[0];
            $HTTP_POST_VARS['custom'] = $explodedCustomValue[0];
      }
    }

Integration doubt

3 years ago Anandkumar

Hi,

I am finding the "if ($global['global_product_notifications'] != '1')" link two places on the checkout_success.php" file, could you please advice me where i need to place the script exactly.

Thanks,
Anand

Re-Visitor

3 years ago sTu

What happens, when a customer, who was once registered as an affiliate custumer returns to the confirmation page without clicking on the affiliate link before.

Two occurrences of code from step 2

3 years ago Martin Pullmann, Q.U.

If you can see two occurrences, then it should be enough to insert integration code only once there. If it will not work, then please contact us and we will revise it.

When customer is back

3 years ago Martin Pullmann, Q.U.

When cookies are saved then customer - as a registered affiliate - will not get commissions, but the original referrer.

Second occurrence of line

3 years ago Martin Pullmann, Q.U.

I revised it and it have to be the second occurrence - the one that is somewhere after <! DOCTYPE ........> line.

Is the fix also applicible to OSC Merchant 2.3 ?

1 years ago David

I have Merchant 2.3 .. just wondering if the fix is the same ?

osCommerce

Integration doubt

Re-Visitor

Two occurrences of code from step 2

When customer is back

Second occurrence of line

Is the fix also applicible to OSC Merchant 2.3 ?

Affiliate software

Customer support

Other products

	All the menu items will lead you to qualityunit.com site Company home About us Our team Company history

	Affiliate software Post Affiliate Pro Simple and intuitive system for most merchants Post Affiliate Pro Full featured system Customer support Support Center Helpdesk, email management and KB LiveAgent Live Chat for your web Other products Post Member Pro Membership software Unit Miner Web data extraction

	All the menu items will open in new window Knowledgebase Forums Member's area

	Earn commission for referring our products Affiliate program