Home Integration Methods osCSS

osCSS

osCSS is the leading Open Source online shop e-commerce solution that is available for free under the GNU General Public License. It features a rich set of out-of-the-box online shopping cart functionality that allows store owners to setup, run, and maintain their online stores with minimum effort and with no costs, license fees, or limitations involved.

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

Edit template

Find and open file /includes/content/checkout_success.php

Locate right place for integration

Inside the file find this line

Add integration code

Insert the following code just above that line:

<?php
   //--------------------------------------------------------------------------
   // STAT - PAP4 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://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');

PostAffTracker.register();
             </script>";
             }
   //--------------------------------------------------------------------------
   // END - PAP4 Integration code
   //--------------------------------------------------------------------------
?>

osCSS

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