From time-to-time, you may need to bulk delete a set of actions scheduled with Action Scheduler. This can be done using the following SQL queries: Delete Schedule Actions DELETE FROM `wp_posts` WHERE `post_type` = ‘scheduled-action’ AND `post_title` = ‘hook_name’ Delete Orphaned Meta The above query will delete scheduled actions but not their associated meta, so […]
Read MoreBrent Shepherd
WooCommerce adds a post meta row against a coupon for every usage of that coupon
Today while reviewing a site’s database to look for performance bottlenecks, I found 4,000 rows of post meta associated with a single post ID. That meta has the key _used_by and is associated with a post of type ‘shop_coupon’ Turns out, WooCommerce keeps a record of all uses of a coupon against the coupon in […]
Read MoreTIL that Til is ranking in Google
Today I learned that Til is ranking in Google.
Read MoreOut-of-Date Version Juggling for Subscriptions & WooCommerce 🃏
To upgrade from really out-of-date versions of Subscriptions & WooCommerce is hard. WooCommerce often breaks backward compatibility, meaning you need to juggle versions. Below is an upgrade path to go from Subscriptions version 1.4.2 and WooCommerce 2.0.n to WooCommerce 3.0.n and Subscriptions 2.2.n. Subscriptions 1.4.2 -> 1.4.7 (full compatibility with WC 2.1) WooCommerce 2.0.x -> […]
Read MoreALTERNATE_WP_CRON runs inconsistently with standard WP-Cron
When the ALTERNATE_WP_CRON constant is defined, WordPress will run WP-Cron on init hook with priority 10 (the default). Unfortunately, this means any code hooked to init with priority 10 or higher will not be run before processing WP-Cron requests via the alternative WP-Cron method. This is a known issue with an open Trac ticket. In […]
Read MoreCustomise strings in Subscriptions without code
There is a free plugin called Say What that allows store owners to: alter strings on your site without editing WordPress core, or plugin code Seems pretty handy for those occasional requests we get for “How to make X say Y?“. Although it’s obviously not future proof… Mentioned in Ticket 484278.
Read MoreWe Have a New TIL Blog
Today I learned we have a new TIL blog. And it’s awesome. 💃😻
Read More
Recent Comments