A free online store software that makes selling your services easy and quick.

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


Edit template

Find and open file /templates/content/checkout_success.tpl.php


Locate right place for integration

Inside the file find this line <?php if(AFFILIATE_COMMISSION_JUNCTION=='true'){


Add integration code

Insert the following code just above that line:

   // STAT - PAP 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 total amount of order
   $sql = "select value from ".TABLE_ORDERS_TOTAL.
          " where orders_id='".(int)$pap_order_id.
          "' and class='ot_subtotal'";
   $pap_orders_total_query = tep_db_query($sql);
   $pap_orders_total = tep_db_fetch_array($pap_orders_total_query);
   $pap_total_value = $pap_orders_total['value'];

   // Draw invisible image to register sale
   if($pap_total_value != "" && $pap_order_id != "")
      print '<script id="pap_x2s6df8d" src="http://URL_TO_PostAffiliatePro/scripts/trackjs.js" type="text/javascript"></script>'.
"            <script type=\"text/javascript\">
             PostAffTracker.setAccountId('Account_ID');var sale = PostAffTracker.createSale();

   // END - PAP 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.