How to optimize slow queries caused by filtering many meta_query custom fields in WordPress.

by Radley Sustaire | Jan 17, 2020 | MySQL, WordPress Development

If you are working with a custom post type that has many fields you might want to let users filter by those fields. This filtering can be very powerful. With the limitations of a MySQL and more specifically, WordPress’s metadata tables, filtering by custom...

Self-boxed products with the WooCommerce UPS Shipping Method plugin

by Radley Sustaire | Dec 10, 2019 | WordPress Development

“Today a customer called in to let us know a product was being quoted by UPS for $90 to be shipped, while using the UPS calculator yourself showed a total cost of $30.”– Client’s support ticket That’s an upsetting bug report to get from a...

Reverting a multisite to a single WordPress install

by Radley Sustaire | Dec 9, 2019 | WordPress Development

WordPress Multisite allows you to host multiple websites with a shared collection of users and plugins. You might need to remove one of the sites for various reasons. If you end up with only one site active, it would be nice to revert to a single site install. These...

Updating Google Maps latitude/longitude after importing addresses into ACF

by Radley Sustaire | Dec 5, 2019 | Google API's, WordPress Development

Let’s assume you are setting up a store locator or distance search system on WordPress. The client provided you with a spreadsheet of companies that you’ve already imported to a post type. The spreadsheet included business name, phone numbers, and the...