Add async, defer, or other attributes to enqueued WordPress scripts

Sometimes it’s useful to add the async or defer attributes to your script calls in order to prevent that script from blocking the rest of your page from rendering. This is particularly useful with third party scripts which you do not host in the same place as the rest of your site.

If you need to load an enqueued script asynchronously in WordPress, or modify the <script> element in any other way, you can use code like the following:

/**
 * Add async attributes to enqueued scripts where needed.
 * The ability to filter script tags was added in WordPress 4.1 for this purpose.
 */
function my_async_scripts( $tag, $handle, $src ) {
    // the handles of the enqueued scripts we want to async
    $async_scripts = array( 'some-script', 'another-script' );

    if ( in_array( $handle, $async_scripts ) ) {
        return '<script type="text/javascript" src="' . $src . '" async="async"></script>' . "\n";
    }

    return $tag;
}
add_filter( 'script_loader_tag', 'my_async_scripts', 10, 3 );

The script_loader_tag filter was added in WordPress 4.1 for specifically this purpose. It is run whenever a script tag is generated by WordPress using the wp_enqueue_script() function. In this example we compare the script $handle against a list of known scripts that we want to load asynchronously.

New Plugin: Custom Related Products for WooCommerce

I don’t think I’ve ever built a WooCommerce site where the client didn’t ask: “How do I pick which related products to display.” The answer has always been “You don’t; the system randomly picks products from the same category.” No client has ever been happy with that answer.

Now I’m happy to say I’ll never have to give that answer again, and neither will you! My latest plugin, Custom Related Products for WooCommerce, replaces the default related products functionality in WooCommerce. With the plugin activated, edit any product and click the “Linked Products” tab. In addition to Cross-sells and Upsells, you’ll now have a Related Products box. As long as you’re using a default related products implementation, the plugin will work automatically to show the products you selected in the Related Products list at the bottom of the detail view, no theme updates required.

Get it!

You can download Custom Related Products for WooCommerce from WordPress.org or install it from the Add New Plugins page in your admin starting today. If you have suggestions for changes, you can fork the plugin and submit pull requests with GitHub.

custom-related-products

WordPress Plugin: Override Comment Deadline

Today I’m pleased to release a discussion-focused plugin to the directory, called Override Comment Deadline. Now you can have “Automatically Close Comments” enabled in your discussion settings to limit spam activity on old posts while keeping commenting open on specific posts. To use it, make sure you’ve set a deadline on the discussion settings page and then edit any post and check the box to keep comments open indefinitely.

Get it!

You can download Override Comment Deadline from WordPress.org or install it from the Add New Plugins page in your admin starting today. If you have suggestions for changes, you can fork the plugin and submit pull requests with GitHub.

Clean up bloated WordPress comment tables

Spam comments are the worst. Even with Akismet active to prevent them from appearing on your site, they can still cause problems. That’s because the comment still gets stored and Akismet creates comment meta entries every time it does something. Over the course of time those unnecessary database entries can amount to hundreds of megabytes even on a reasonably small site. Multiply that by a couple hundred sites on a multisite network, and it can quickly start costing you real money in terms of hosting and causing serious problems when you back up your database.

Fortunately, MySQL can help you eliminate all this comment meta bloat with a few simple queries:

DELETE FROM wp_comments WHERE comment_approved = "spam";
DELETE FROM wp_commentmeta WHERE meta_key LIKE "akismet_%";

As always, make sure to back up your database before running any destructive queries on it.

Once you’ve deleted all of those Spam comments and Akismet meta entries, make sure to optimize the database tables.

OPTIMIZE TABLE wp_comments;
OPTIMIZE TABLE wp_commentmeta;

If you’re running a multisite network, you’ll have to run the delete queries and the optimizations for each site, or at least each site which is causing problems. To determine which tables are the most bloated, you can run a query like this:

SELECT table_name AS "Tables", 
    round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
    FROM information_schema.TABLES 
    WHERE table_schema = "YOUR_DATABASE_NAME" AND table_name LIKE "%comment%"
    ORDER BY (data_length + index_length) DESC;

This will list all comment and commentmeta tables sorted by size, from largest to smallest. Once you have a list of all tables you want to clean up, you can run the DELETE and OPTIMIZE queries for each table. Or, you could write a script to clear this generally useless data from your database at regular intervals.

Debug WP-Cron with Trigger Scheduled Events

I’ve added a new plugin to the directory called Trigger Scheduled Events, which does pretty much what it says on the tin. With it, you can view a list of all events scheduled by WP-Cron and run any of them instantly instead of waiting until the next time the event is scheduled to be fired.

WP-Cron is useful because it allows you to schedule events to happen later using the wp_schedule_event() function, but during development this can lead to a lot of waiting around to see if your code works. Trigger Scheduled Events gets around this problem by allowing you to run your events on demand.

Get it!

You can download the plugin through the Add New menu from your WordPress admin or you can download it from the plugin directory. If you’d like to make suggestions for improvements, you can do that over at the plugin’s GitHub page.