Understanding How Category Order and Taxonomy Terms Order Stores Your Data
Content
If you're using the 'Category Order and Taxonomy Terms Order' plugin, you might be curious about how it handles your website's data. A common question from users is about the plugin's database footprint—specifically, where the custom term order is stored and what happens to that data if the plugin is removed.
This is a crucial consideration for website maintenance, database integrity, and understanding the potential impact of the plugin on your WordPress installation.
Where is the Order Data Stored?
Unlike some plugins that create custom tables or store information in the postmeta table, 'Category Order and Taxonomy Terms Order' utilizes the existing WordPress database structure. According to information from the plugin's support, the custom order for your terms is stored within the standard wp_terms table in a dedicated column named term_order.
This method integrates the ordering information directly alongside the core term data, which can be more efficient than using a separate meta table.
What Happens on Uninstall?
Based on community discussions, a key concern is what occurs when the plugin is deactivated or deleted. The primary question is: will the terms revert to their default order, or will the custom order data persist?
While the exact uninstall behavior is not detailed in the provided threads, the storage method provides a clue. The data resides in a column within a core WordPress table. It is unlikely that the plugin removes this column upon uninstallation, as that could affect other site functions. Therefore, the custom order data most likely remains in the database even after the plugin is removed.
If you were to reinstall the plugin at a later date, it would likely detect and use the existing term_order values. If you wish to completely revert to the default WordPress ordering (typically by ID or name), you would likely need to manually clear the term_order values from the wp_terms table using a database management tool like phpMyAdmin. Warning: Direct database manipulation should only be performed by users with adequate experience and after creating a full backup.
GDPR and Data Collection
For users concerned about privacy regulations like GDPR, the plugin's approach is straightforward. As confirmed in support threads, the 'Category Order and Taxonomy Terms Order' plugin does not collect any user data. Its function is solely to manage the display order of taxonomy terms on your site, and all related data is stored locally in your database without being transmitted externally.
Understanding how a plugin interacts with your database empowers you to make informed decisions about your website's architecture and maintenance.
Related Support Threads Support
-
Compatible with PHP v7.3?https://wordpress.org/support/topic/compatible-with-php-v7-3-2/
-
Where is data stored?https://wordpress.org/support/topic/where-is-data-stored-6/
-
Plugin Farsi Languagehttps://wordpress.org/support/topic/plugin-farsi-language/
-
GDPR Compliance?https://wordpress.org/support/topic/gdpr-compliance-127/
-
Working Properly in 4.0?https://wordpress.org/support/topic/working-properly-in-40/
-
Very good but donate not workinghttps://wordpress.org/support/topic/very-good-but-donate-not-working/
-
very convenient pluginhttps://wordpress.org/support/topic/very-convenient-plugin-5/
-
Changelog? Github?https://wordpress.org/support/topic/changelog-github/
-
[Plugin: Category Order and Taxonomy Terms Order] Better compatibility with WPML and woocommercehttps://wordpress.org/support/topic/plugin-category-order-and-taxonomy-terms-order-better-compatibility-with-wpml-and-woocommerce/
-
Use of database?https://wordpress.org/support/topic/use-of-database-2/
-
Japanese translation and a patchhttps://wordpress.org/support/topic/japanese-translation-and-a-patch/
-
Release tags in Subversion?https://wordpress.org/support/topic/release-tags-in-subversion/
-
WP 4.9 compatible?https://wordpress.org/support/topic/wp-4-9-compatible/
-
[enhancement] use pre_get_terms and term metahttps://wordpress.org/support/topic/enhancement-use-pre_get_terms-and-term-meta/