Nexcess Logo

How to cleanup WooCommerce GeoIP transients for Performance Gains

Knowledge Base Home

Notice anything different?

We've enhanced the appearance of our portal and we're working on updating screenshots. Things might look different, but the functionality remains the same.
May 26, 2021

WooCommerce has a built-in feature to get the customers’ default location using geolocation. The geolocation feature in WooCommerce uses the MaxMind API. Currently, if you are using this feature on your WooCommerce store you could have 20-40k transients related to it.

Transients are used for storing cached temporary data that is stored in the options database table. WooCommerce will store the geolocation transients in the site’s options database table for one week.

You can easily delete any existing geolocation transients from WooCommerce by using phpMyAdmin to search for the following option names:


_transient_geoip_%

_transient_timeout_geoip_%

_transient_external_ip_address_%

_transient_timeout_external_ip_address_%


You could also use a plugin like WP Data Access then you could explore the options database table and look for all of the related transient options to delete those. 


WordPress core does have a cron event called:


delete_expired_transients


That cron event will run daily to automatically delete all expired transients. WooCommerce also has a built-in tool from wp-admin;


WooCommerce >Status > Tools

Reducing transients stored in the site's database as well as making sure that expired transients are deleted will help keep your site performing well and will help with wp-admin load times.


For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.

Luke Cavanagh
Luke Cavanagh

Luke Cavanagh, Strategic Support & Accelerant at Liquid Web, brings a decade of experience working with WordPress and WooCommerce to our product team. His GitHub page offers a glimpse into his multiple areas of subject matter expertise.

"Ninja stuff with WordPress and WooCommerce," is an apropos way to describe Luke's savviness with these platforms — and his way of influencing our organization for improving to them.

Coming out of the University of Brighton with a Business and Technology Education Council (BTEC) Higher National Diploma (HND) in 2D & 3D Design, Luke's credentials prepared him well for his current role that blends both web development and design. His HND credential leveraged his foundational learning at West Kent College, where he received a National Diploma (ND) in Graphic Design.

In his personal life, Luke is a devoted husband and teen wrangler. He considers himself a Synthwave enthusiast, Jerry Goldsmith fan, and Doctor Who aficionado. He is happy to introduce his friends and teammates to essential vocabulary for life found only in British English, such as "gubbins" and similar terms.

We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.