WooCommerce Subscriptions: MySQL Query To Export All Subscriptions

Here are two queries that will allow you to generate a quick report showing you all Subscriptions. Why would you want to do this? Well, in some very large sites, the WooCommerce Subscriptions Reports will not load. This provides you with a report which can be exported from your MySQL client. I’ve tested these queries…

Speed Up Large WordPress & WooCommerce Website Back-End

Last week while trying to find ways to improve KelbyOne’s Website speed, I came across a particular query being ran on the back-end that was responsible for slowing it down. Every time you tried loading an Order, Course, Lesson, Subscription or anything else, that query was responsible for almost 80% of the time it took…

Serving Images From Multiple CDNs In WordPress

Thanks for WordPress flexibility and it’s hundreds of filters and action, it is possible to serve images from Multiple CDNs with completely different URL structures. If you are wondering why would anyone do this think about the following scenario. You were a customer of CDN A and you moved your Website to WP Engine (Very…

WooCommerce Memberships: Useful Functions To Know

If you are are just starting to work with WooCommerce Memberships and are having to do various things programatically, here are some functions that are useful to know and will make your life and job a lot easier. Retrieve User’s Memberships Retrieve a list of memberships this particular user belongs to. This function will return…

Faster Ajax Calls In WordPress By Using The AjaxFlow Plugin

Is it possible to achieve faster Ajax Calls in WordPress? You bet it is possible and you can start doing it right now with very little edits to the code you already have in place. We are going to be using a little plugin called AjaxFlow to speed it up, but first let’s go over…

Connecting WooCommerce To Salesforce: OAuth2 Authorization

Along with learning Typescript in the fast few months, I’ve also been putting a lot of time an energy into learning Salesforce and the Apex language. So far it has been an amazing journey and my end goal for learning Salesforce is so that I can write REST APIs that would synchronize WooCommerce and Salesforce…

Mastering WooCommerce Hooks: Setting Minimum And Maximum Order Quantities

I’ve been thinking about continuing my Mastering WooCommerce Hooks series here on my personal Website instead of another Website. It has been a long time since I write anything related to WooCommerce and WordPress so hopefully this series will help me do just that, about one post every week or so. This week’s article we’ll…

Prevent Product From Being Checked-Out Outside Of US

Happy New Year! Here is a quick snippet of code to prevent a product from being bought at your store from outside of the US or any other country you specify. Very useful in some situations and we use it often at work to do just that, preventing someone buying the product outside of the…

Adding Custom Columns To Different Post Screens

So you want to add custom columns to different posts or pages screen, perhaps even to a custom post type and you’ve stumbled with this article after a quick search on Google. If you are wondering whether or not this is even possible, it is; and WordPress makes it really simple to add and even…