–Hidden comment

Use attributes in format region_from and region_to= to change the languages showing in language switcher.
Available regions are:
europe_from europe_to
asia_from asia_to
mideast_from mideast_to
america_from america_to

Example:
europe_from=0 europe_to=22 will put all languages (ordered in language switcher settings) from 1 to 21 to Europe region:
asia_from=22 asia_to=25 will put all languages from 23 to 24 (so only 2) into Asia region.

WordPress ecommerce Plugin

A free, powerful plugin that empowers you to sell anything.

This integration was successfully tested on WP ecommerce plugin v 3.8.13.3

You can track per product information with this integration method.

Edit template

In your wordpress installation, open and edit the file:

wp-content/plugins/wp-e-commerce/wpsc-theme/functions/wpsc-transaction_results_functions.php

Find function transaction_results. Right below the line with function definition, there are global variables listed. Add another one there:

$wpdb

Then find the last line of the function:

return $message_html;

Integration

Put the following integration code ABOVE the line:

/*Post Affiliate Pro integration code */
$purchase = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= %s LIMIT 1", $sessionid ) );

$message_html .= '<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('".$purchase->totalprice."');
sale.setOrderID('".$purchase->id."');
PostAffTracker.register();
</script>";

/* /Post Affiliate Pro integration code */

In case you want to use tax and shipping variables, here you are:

  • $total_tax
  • $total_shipping

Per product integration

If you want to track commissions per product, just use this code instead:

/*Post Affiliate Pro integration code */
$purchase = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= %s LIMIT 1", $sessionid ) );
$cart_items = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . WPSC_TABLE_CART_CONTENTS . " WHERE purchaseid = %d", $purchase->id ), ARRAY_A );

$message_html .= '<script id="pap_x2s6df8d" src="https://URL_TO_PostAffiliatePro/scripts/trackjs.js" type="text/javascript"></script>
<script type="text/javascript">'."PostAffTracker.setAccountId('Account_ID');";

$i = 1;
foreach ($cart_items as $item) {
  $item = array_map('wp_specialchars_decode', $item);

  $message_html .= "var sale$i = PostAffTracker.createSale();
    sale$i.setTotalCost('".($item['price']*$item['quantity'])."');
    sale$i.setOrderID('".$purchase->id."($i)');
    sale$i.setProductID('".$item['prodid']."');
    PostAffTracker.register();";
  $i++;
}
$message_html .= "</script>";
/* /Post Affiliate Pro integration code */

If you want to use category name for the product ID, this is how to get it:

$category = wp_get_object_terms($item['prodid'],'wpsc_product_category',array( 'orderby' => 'count', 'order' => 'DESC', 'fields' => 'all_with_object_id'));

Then, the name is defined in:

$category[0]->name;

In case you want to use item name, use variable $item[‘name’] instead of $item[‘prodid’].

In case you want to use SKU, use this code first:

$item['sku'] = get_post_meta($item['prodid'], '_wpsc_sku', true);

Place it below the line with “arraymap” and then, simply replace $item[‘prodid’] with $item[‘sku’]_.

Do not forget to integrate your WordPress with the click tracking code. You can do it by placing the click tracking cade to your WP footer file, in Appearance > Edit menu of your WP.

Back to Integrations Create account for FREE

Our website uses cookies. By continuing we assume your permission to deploy cookies as detailed in our privacy and cookies policy.

×

Schedule a one-on-one call and discover how Post Affiliate Pro can benefit your business.

We’re available on multiple dates

Schedule a call