Updating Website

January 11 2010 by Scott in About, iKreativ

Wow, I’ve just realised how much updating the site needs. What with client work, side projects and xmas there just hasn’t been time to add new stuff to our ‘folio.

We’ve got a few more jobs to complete and then hopefully I’ll be able to find time to add some fresh work onto the site

Fix WP Ecommerce IPN issues

2 Comments

January 7 2010 by Scott in Open Source, Technology, Web Design

I was recently asked by a client to implement the WP Ecommerce plugin into their Wordpress site in order to sell digital products. Our client used PayPal as the merchant facility and was having issues getting the PayPal IPN feature to work.

I tried every setting possible within the plugin, and also within PayPal to get the IPN to work. Nothing seemed to fix the issue.

So I decided to have a dig around in the plugin core files to see if I could find a fix. I did!

If you go inside your /wp-content/plugins/wp-ecommerce/ folder you will find a folder called /merchant/, inside this folder is the file you require. Open paypal_multiple.php in your favourite editor and then you need to find line 233.

The line below is what you are looking for

if(get_option(‘paypal_ipn’) == 0) { //ensures that digital downloads still work for people without IPN, less secure, though
//$wpdb->query("UPDATE `".WPSC_TABLE_PURCHASE_LOGS."` SET `processed` = ‘2′ WHERE `sessionid` = ".$sessionid." LIMIT 1");
}

The fix is simple, you just need to uncomment the above line so it reads like so:

if(get_option(‘paypal_ipn’) == 0) { //ensures that digital downloads still work for people without IPN, less secure, though
$wpdb->query("UPDATE `".WPSC_TABLE_PURCHASE_LOGS."` SET `processed` = ‘2′ WHERE `sessionid` = ".$sessionid." LIMIT 1");
}

Once you have done this save the file and return to your Wordpress installation. Now go to the WP Ecommerce plugin settings > payment settings and uncheck the ‘use IPN’ checkbox. Now go into PayPal and again remove the IPN settings.

That’s it, your WP Ecommerce should now work and you will be able to sell your digital products.