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.

Your Digital Commerce Experts
Nexcess Logo

How to cleanup WooCommerce GeoIP transients for Performance Gains

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 aslo 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


Product Operations Manager at Nexcess. A devoted husband and tween wrangler. Synthwave enthusiast. Jerry Goldsmith fan. Doctor Who fan and related gubbins.