Home Integration Methods Virtue Mart

Virtue Mart

Integration with Virtue Mart is made by placing sale tracking script into the confirmation page.

Using Joomla configuration

Easiest way is to integrate Virtue mart is to integrate payment method configuration directly in Joomla - navigate to Components> Virtuemart> Store> List Payment Methods - here click the method you want to integrate and then Configuration tab. Here you can modify/insert the integration code.

Edit template

Find and open file checkout.thankyou.php

It should be in administrator/components/com_virtuemart/html/

Integration

Replace last ?> with following code

$q = "SELECT * FROM #__{vm}_user_info WHERE user_id='$user_id'";
 $db->query( $q );
 $pap_user_email = $db->f('user_email');

$q = "SELECT * FROM #__{vm}_orders WHERE order_id='$order_id'";
 $db->query( $q );
 $pap_order_subtotal = $db->f('order_subtotal' );
 $pap_coupon_code = $db->f("coupon_code");
 $pap_coupon_discount = $db->f("coupon_discount");
 if (!is_null($pap_coupon_discount) && $pap_coupon_discount != '') {
   $pap_order_total =  $pap_order_subtotal - $pap_coupon_discount;
 } else {
   $pap_order_total =  $pap_order_subtotal;
 }
 
 $q = "SELECT * FROM #__{vm}_order_item WHERE order_id='$order_id'";
 $db->query( $q );
 $pap_product_id = $db->f('product_id');
 ?>
<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('<?php echo $pap_order_total ?>');
sale.setOrderID('<?php echo $order_id ?>');
sale.setProductID('<?php echo $pap_product_id ?>');
sale.setData1('<?php echo $pap_user_email ?>');
sale.setCoupon('<?php echo $pap_coupon_code ?>');
PostAffTracker.register();
</script>

This code will track subtotal of the price (with coupon discount). If you want to track something else, you can use one of this variables:
order_total, order_subtotal, order_tax, order_shipping, order_shipping_tax, coupon_discount, order_discount, order_status, customer_note

Use it in the way as it is showed in the code above in the third line.

Separated products

There is also possibility to generate unique transaction in PAP4 for every product type. With this you will have ability to edit separate product types within one order. It is useful if any refund occur. Then you will decline just one transaction (commission) assigned to product type that was refunded.
In this case please use this integration code instead of code above:

$q = "SELECT * FROM #__{vm}_user_info WHERE user_id='$user_id'";
 $db->query( $q );
 $pap_user_email = $db->f('user_email');

$q = "SELECT * FROM `#__{vm}_orders` WHERE `order_id`='$order_id'";
 $db->query( $q );
 $pap_coupon_code = $db->f('coupon_code');
 $pap_coupon_discount = $db->f('coupon_discount');
 $pap_order_subtotal = $db->f('order_subtotal');

$q = "SELECT * FROM #__{vm}_order_item WHERE order_id='$order_id'";
 $number_of_items = @ mysql_fetch_array ($q);
 $db->query( $q );
 $i='0';
 while ($db->next_record()) {
  $pap_product_id[$i] = $db->f('product_id');
  $pap_item_price[$i] = $db->f('product_final_price');
  $pap_item_quantity[$i] = $db->f('product_quantity');
  $i++;
 }
?>
 <script id="pap_x2s6df8d" src="http://www.yoursite.com/affiliate/scripts/salejs.php" type="text/javascript"> </script>
 <script type="text/javascript">
<?php
 for ($j=0; $j<=$i; $j++){
  $pap_final_price[$j] = ($pap_order_subtotal - $pap_coupon_discount) * $pap_item_price[$j] * $pap_item_quantity[$j] / $pap_order_subtotal;
  echo "var sale".$j." = PostAffTracker.createSale();\n".
       "sale".$j.".setTotalCost('". $pap_final_price[$j]."');\n".
       "sale".$j.".setOrderID('".$order_id."');\n".
       "sale".$j.".setData1('".$pap_user_email."');\n".
       "sale".$j.".setCoupon('".$pap_coupon_code."');\n".
       "sale".$j.".setProductID('".$pap_product_id[$j]."');\n\n";
 }
 ?>
PostAffTracker.register();
</script>

If you want to see name of item instead of number of item use variable 'order_item_name' instead of 'product_id' in this line: $pap_product_id[$i] = $db->f('product_id');

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.

Version 1.4

It seems like the version 1.4 needs edit of other file - checkout.result.php

It is a suggestion from one of our customers, we didn't test it.

Virtue Mart with PayPal

In case you are using VirtueMart with PayPal in your Joomla, you have to do some special steps to make integration working. First, in administrator/components/com_virtuemart/notify.php (at your server) add lines below line with code: if ($_POST) {

Now save the file and login to your Joomla.

VirtueMart with PayPal

Navigate to Components> VirtueMart> Store> List Payment Methods> PayPal> Configuration> Payment Extra Info and add on of these lines:

Insert it below line with "notify_url"=>...

The intergration code in instruction got some problem

3 years ago Ian Chin

Dear reader,
I copy the code to revise the checkout.thankyou.php but get the wrong message "Parse error: syntax error, unexpected T_EXIT in /home/ggttwcom/public_html/administrator/components/com_virtuemart/html/checkout.thankyou.php on line 1" after check out.
Can somebody tell how to solve the problem?
Thank you for help.
Ian

Integration

3 years ago Martin Pullmann, Q.U.

Ian,

please contact our Support Center for resolving the problems. You probably integrated it wrong way.

integration problem with 1.4

1 years ago sam

Your program previously worked with Joomla 1.1.3, but now tracks only clicks, but not sales.

How can this be integrated with 1.1.4 (and/or the newest versions: 1.1.5 and 1.1.6???)

Sam

Where is the support?

1 years ago sam

Really? No answer? I see that others have had this issue and are posting to freelancer.com and the like just to get your software to work with the latest version of this third-party solution.

I'm disappointed in PAP4. Upgrading our cart (security fixes and updates) has broken our affiliate program!!!

Where is the support???

Issues

1 years ago Martin Pullmann

Please,

send all your problems and questions directly to our Support Center, or contact live help. The integration methods published here are tested and works for most cases. If you can not make it working for some reason, contact us so we can check what is the problem.

If there is any permanent issue, we will update the integration method.

Thank you for understanding.

Virtue Mart

The intergration code in instruction got some problem

Integration

integration problem with 1.4

Where is the support?

Issues

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