Partner
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:
<?php
//--------------------------------------------------------------------------
// 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="https://URL_TO_PostAffiliatePro/scripts/trackjs.js" type="text/javascript"></script>'.
" <script type=\"text/javascript\">
PostAffTracker.setAccountId('Account_ID');var sale = PostAffTracker.createSale();
sale.setTotalCost('$pap_total_value');
sale.setOrderID('$pap_order_id');
PostAffTracker.register();
</script>";
}
//--------------------------------------------------------------------------
// 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.