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…

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…

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…

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…