Reset Theme Options

WordPress offers a standard modifications API for themes. Although not many themes use it (they prefer custom, often bloated solutions) it’s still a very handy API. If you want to see it in action check out default WP themes – Twenty Seventeen and Twenty Nineteen. 

The tool resets all options (mods) for all themes. That includes non-active themes too. Again, it’s only effective for themes that use the WordPress theme modification API. If options are saved in some other, 3rd party custom way, they won’t be reset.

The tool runs one DB query to delete all themes’ options/mods. Two option names are used as one is a legacy one and the other current.

DELETE FROM $wpdb->options WHERE option_name LIKE 'theme_mods\_%' OR option_name LIKE 'mods\_%'