One of my clients uses the plugin Woocommerce Order/Customer CSV Export to export his customers’ orders into a spreadsheet for managing a mailing list. The other day, he emailed me to tell me that instead of being prompted to download the CSV when he clicked the “Export” button, he was getting a nasty screen-full of text.
It took a while to troubleshoot, but it turned out the problem was caused by the 34,000+ records that CSV Export had inserted into the WordPress comments and commentmeta tables. Each time the client was clicking that “Export” button, a new record was added to each table for each exported order, and as the number of orders added up, the records were increasing proportionally. Not only was it causing serious database-bloat, but it was also cluttering up the Order Notes box for each order with “Order exported to CSV and successfully downloaded” notes that the client neither wanted or needed.
Continue reading “Turn Off Pesky Order Notes for Woocommerce Order/Customer CSV Export”
Many of WordPress’ default themes come with a style sheet called editor-style.css that overrides the built-in style sheet for TinyMCE, making the font a bit larger and more legible in WordPress. Unfortunately, a number of themes don’t override any of the default TinyMCE styles. I’ve had quite a few clients complain about difficulty reading the default TinyMCE font in WordPress after the theme they selected was installed.
Of course, you could just quickly edit the TinyMCE style sheet and change the font size; however, future WordPress updates might overwrite the change. Fortunately, there are a couple of simple workarounds that will allow you to not only alter the font-size, but also make other styling changes to the editor that won’t be overwritten.
Continue reading “Changing the WordPress Editor Font Size”
In a previous post on optimizing WordPress, I suggested configuring WordPress so that revisions are not saved, and to delete old revisions to make the wp_posts table smaller and faster to query, but I didn’t mention how to do it. That’s because there is a little more to deleting old revisions than many posts on the web, and some plugins designed to delete revisions, would have you believe.
Several months ago, in his WordPress.org post “Deleting Post Revisions: do NOT use the a,b,c JOIN code you see everywhere,” kitchin, and the discussion that follows, provides an excellent description of the problems one may encounter when attempting to clean out old post revisions. As you will find if you read that post, there is an easy way to safely remove old post revisions. You can even optimize your database tables while you’re at it.
Continue reading “Safely Deleting WordPress Post Revisions”
I have been dealing with a WordPress site that was consuming a lot of resources on the server on which it is installed. In the course of discussing the problems I was seeing with the web host’s support team, the support representative suggested that I try W3 Total Cache instead of WP Super Cache to see if it improved the site’s loading time and reduced the resource usage for the site.
I have used W3 Total Cache in the past, and what I remember most about it was that I had one text widget which simply would not update on the front end until I deactivated the plugin and activated it once more, but I had already done everything I could think of to optimize this problem site, so I was game. And he got me thinking, which of these caching plugins really works the best?
First, I ran GoDaddy’s P3 (Plugin Performance Profiler) on the site several times to obtain a baseline measure of its performance with WP Super Cache installed and configured as I have described in a previous post on optimizing WordPress. WP Super Cache was set up to use mod_rewrite.
Continue reading “WP Super Cache Versus W3 Total Cache”
My purpose today is to share some of the methods I’ve found that really work to optimize WordPress, reduce the load on the server, increase the performance of a site, and improve the user experience.
Before you get started, you may want to install GoDaddy’s P3 (Plugin Performance Profiler) and run a baseline test so you can see the benefits of each optimization step.
Continue reading “Optimizing WordPress”