WordPress ecommerce Plugin

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

How to integrate PostAffiliatePro with WordPress ecommerce Plugin

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.

What is WordPress eCommerce Plugin?

The WordPress eCommerce Plugin, specifically known as WooCommerce, is a flexible and open-source plugin designed to transform your WordPress website into a fully functional online store. With WooCommerce, you can sell a wide array of products including physical items, digital downloads, services, bookings, and more. Its customization capabilities and extensive use cases make it a popular choice among online retailers. Being fully open-source, it allows for limitless adaptations to suit your business needs.

Originally developed by WooThemes and launched in 2011, WooCommerce quickly gained traction in the eCommerce world. In 2015, it was acquired by Automattic, the company behind WordPress.com. This acquisition led to increased development and feature enhancements, solidifying WooCommerce’s position as a leading eCommerce solution. Today, it powers over 25% of all online stores, reflecting its adaptability and the extensive growth of WordPress eCommerce solutions.

The WordPress eCommerce Plugin targets small to medium-sized business owners, online entrepreneurs, and developers aiming to expand their WordPress sites into eCommerce platforms. Whether you’re someone with minimal coding knowledge or an experienced developer, WooCommerce offers a reliable and customizable platform to foster business growth. Its flexibility supports a broad range of users, making it a go-to solution for many online retailers.

Main Features of WordPress eCommerce Plugin

• Extensive Product Management: Easily add, modify, and organize products with a user-friendly interface.
• Secure Payments: Integrated with popular payment gateways to ensure safe transactions.
• Mobile Order Management: Manage orders on-the-go with mobile compatibility.
• Unlimited Customization: Fully open-source, allowing you to customize every aspect of your store.
• Marketplace for Plugins and Themes: Access to a vast library of plugins and themes to enhance functionality and design.
• Marketing and Growth Tools: Optimize your business with built-in SEO, analytics, and marketing strategies.
• Global Sales Features: Sell to customers worldwide with multilanguage and multicurrency support.

Pricing Options for WordPress eCommerce Plugin

While WooCommerce is free to download and use, costs arise with premium extensions and add-ons to expand your store’s functionality. Alternative WordPress eCommerce plugins like Easy Digital Downloads, MemberPress, and BigCommerce offer pricing starting from $29 to $179, depending on the required features and add-ons. The total investment varies based on your specific needs and the premium extensions you choose to implement.

Key User Insights on WordPress eCommerce Plugin

Users highly appreciate WooCommerce for its flexibility, customization options, and seamless integration within the WordPress ecosystem. It’s lauded as a powerful tool for online retailers seeking a tailored eCommerce solution. However, some users point out the complexity of add-ons and the associated costs as potential drawbacks. Despite this, the overall sentiment remains positive due to the plugin’s robust capabilities and support community.

YouTube Reviews of WordPress eCommerce Plugin

• How to Build an eCommerce Website with WordPress – 2023: This review provides a comprehensive guide on setting up an eCommerce site using WordPress, highlighting WooCommerce’s features.
• Top 5 eCommerce Plugins for WordPress Compared: An in-depth comparison of the leading eCommerce plugins, including WooCommerce, showcasing strengths and weaknesses.

Alternatives to WordPress eCommerce Plugin

If you’re considering other options besides WooCommerce, here are some notable alternatives:

• Easy Digital Downloads: Ideal for selling digital products. Visit Website
• MemberPress: Great for membership sites with subscription billing. Visit Website
• BigCommerce: Offers a robust SaaS approach integrated with WordPress. Visit Website
• Shopify: A standalone eCommerce platform with WordPress integration options. Visit Website
• WP Simple Pay: Simplifies accepting payments without a full cart system. Visit Website
• WC Vendors: Turns your store into a multi-vendor marketplace. Visit Website
• Ecwid: Embeddable storefront for any website. Visit Website
• WP EasyCart: Offers a straightforward setup for small businesses. Visit Website
• WPForms: Enhances forms and payment collection on your site. Visit Website