Integration with osc2nuke is made by placing sale tracking script intothe confirmation page. To obtain the values of OrderID and TotalSale,snippet connects to osc2nuke database and retrieves the values fromthere.
Edit template
Find and open file ‘modules/catalog/checkout_success.php‘
Locate integration place
Find following line in this file:
require(DIR_WS_CLASSES . 'checkout_success.php');
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="https://URL_TO_PostAffiliatePro/scripts/trackjs.js" type="text/javascript"></script>'."
</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 of integration code
//--------------------------------------------------------------------------
The article discusses the PostAffiliate Pro software, which is designed for tracking business sales through affiliate marketing. The software is available for free and offers a range of features and integrations, including support for AspDotNetStorefront. The article includes instructions for integrating the software with a website to track commissions per order and supports lifetime commissions. The article also provides contact information for sales support and customer reviews of the software.
