Posts Tagged with “WordPress”

Best related posts plugins to replace nRelate

On 1 December 2014, nRelate announced that it would be switching off its related posts recommendation service. Their Related Posts plugin and service for WordPress was an extremely popular plugin because of its ease of use and many options. So now that they are shutting their doors, many WordPress site owners are looking around for a replacement. Here is what I am recommending to my WordPress tech support customers at ClickWP.

IMPORTANT: Choosing the wrong related posts plugin can severely slow your site down. This is because calculating the related-ness of posts is a resource intensive process. For sites with more than 200 posts, I recommend off-loading the computational work to an external service.

The best plugin to replace nRelate is… it depends.

tl;dr Summary

If you use Jetpack and don’t care about customization, use the Jetpack Related Posts module.

If you don’t want to signup for other accounts & services, Contextual Related Posts is a good option for sites with less than 200 posts. Another to consider is Related Posts for WordPress which claims to be able to handle a lot more posts.

If you don’t mind or need an external service to compute your related posts, Shareaholic and AddThis are the best options. One thing to note is that AddThis settings are controlled outside of WordPress, so you must signup for an AddThis account to use this option.

If you’re a publisher who’s willing to pay to increase your audience engagement with your content, Contextly seems very promising.

Want more options? Read this post by Followistic: The 10 Best Related Posts Plugins for WordPress

My thoughts on each of the above options: Read More »

Comments Closed

New ClickWP.com

logo-clickwp

I finally launched the new ClickWP website, after almost a year of planning, designing, and 4 weeks of furious coding. Along with it is an all new branding by Reese Spykerman as well.

Read More »

Comments Closed

Useful SQL queries for migrating a WordPress database

First, if at all possible, use the WP Migrate DB Pro or BackupBuddy plugins to migrate your WordPress database. The money spent will save yourself a lot of frustration and hair pulling, and hours if not days of cleanup and massaging of the WordPress database.

But if that’s not possible, welcome to my world for the past week. I’ve had to migrate a WordPress database without my favorite migration tools. After scouring the web for tutorials and tips, I’m compiling them here for easy reference.

Gather Your Tools

First thing you need is to get your hands on the following:

1. Database name, prefix, user and password.

You can find these defined in the wp-config.php file. In the following examples, be sure to swap out the database name wordpress and prefix wp_ with the correct values from your situation.

2. Access to phpMyAdmin so that you can interact with the database.

We’ll be running the commands below through the SQL tab in phpMyAdmin.

phpmyadmin-sqlquery

Running SQL queries on your database with phpMyAdmin

You could also connect directly to MySQL through the terminal / shell prompt. Good luck if you don’t have phpMyAdmin.

3. Backup, Backup, Backup

Don’t say I didn’t warn you. Export your untouched database and lock it up. If all goes wrong, restore to this backup.

Change the Site URL

The first thing you would want to do is to change the site URL. You can browse the wp_options table for the siteurl and home options values directly, or you can use this SQL command:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'siteurl' OR option_name = 'home';

Next, you’ll want to replace all instances of oldsiteurl.com in your post’s contents and GUID.

UPDATE wp_posts SET post_content = REPLACE (post_content, '//www.oldsiteurl.com', '//www.newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (guid, '//www.oldsiteurl.com', '//www.newsiteurl.com');

Read More »

Comments Closed

Sweden With Love

Happy day! We are finally live! A brand new online experience. #swedenwithlove. Beautifully designed by @thedarlingtree. xo

Sweden With Love was a ClickWP project for Ulrica Wihlborg. It features a custom WordPress theme built on the Genesis Framework. Jo Klima from The Darling Tree created the design while I was responsible for coding the theme and site implementation.

Read More »

Comments Closed

I wrote a guest post for Phase Creative, an awesome WordPress production small business in Sydney.

So, what should you do to ensure that your website is running in tip-top shape? Here is myEssential WordPress Maintenance Checklist. The tasks on this checklist are divided into daily, weekly and quarterly tasks and following this schedule will only take 10 minutes a week with an additional 30-60 minutes per quarter.

Read the full post →

Comments Closed

sandbox

You’ve created your WooCommerce store, uploaded all your products and are ready to accept payments via PayPal. But how would you know if PayPal will play nice with your store?

Most people will make a small purchase with a friend’s PayPal account as a live test. But that costs real money and is annoying if you have to test multiple times. This post explains how to test the payment system using the PayPal Sandbox.

The PayPal Sandbox is a place where you can test your shopping cart and other PayPal integrations in a realistic way, except that no money changes hands. This means you can test your PayPal processes in the Sandbox and know they will behave the same on the when you go live.

Read the full article on ClickWP: Test payments in WooCommerce with the PayPal Sandbox

Comments Closed

wp10logoIn conjunction with WordPress’ 10th Anniversary I wrote down some reflections on my journey with WordPress on the ClickWP blog:

WordPress is one of the blessings I count every day because it is entirely free to use. It was created freely and given away freely to the world. I am where I am today because of this generosity.

Happy birthday WordPress ♥

At the beginning of 2011, I began hosting my websites on Site5. I have been singing their praises and recommending everyone I know to them. Today iThemes publicly announced their endorsement of Site5 hosting (and how terrible Hostgator is too). I’m really excited about the development because iThemes is a major WordPress plugins and themes vendor, so their endorsement confirms my feelings about Site5. Also, the CEOs of both companies have been communicating directly which will hopefully result in even better WordPress compatibility with Site5. Check out the announcement post, Site5 has a 6-month free trial (!) for the iThemes community.