Home Integration Methods osc2nuke

osc2nuke

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

Edit template

Find and open file: modules\catalog\checkout_success.php

Locate integration place

Find following line in this file:

Integration

Add following code before this line:

//--------------------------------------------------------------------------
 // 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 script 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>
<script type=\"text/javascript\">
var sale = PostAffTracker.createSale();
sale.setTotalCost('$pap_total_value');
sale.setOrderID('$pap_order_id');

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

osc2nuke

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