WooCommerce Database Cleanup – How to Clean Your WooCommerce Database

Some plugins use WordPress transients for caching that look like expired data but are still needed. If transient cleanup deleted active transients, rebuild them by visiting the relevant admin pages (WooCommerce settings, shipping zones). If a plugin broke, check if its transients were deleted and contact the plugin developer.

Slow WooCommerce admin is often caused by the orders table growing very large. Enable HPOS (High-Performance Order Storage) in WooCommerce → Settings → Advanced – this moves orders to dedicated tables optimised for querying. Also check for slow database queries using Query Monitor.

Run cleanup in batches rather than all at once. Most cleanup plugins allow setting a batch size. Start with expired transients (lowest risk), then orphaned data, then revisions. Increase PHP max_execution_time for the cleanup session. Always backup first.

For active WooCommerce stores, monthly automated cleanup is appropriate. High-volume stores (hundreds of orders daily) benefit from weekly transient cleanup. Schedule cleanup during off-peak hours (3-4am) to avoid performance impact during business hours.

Safe to delete: expired transients, old sessions (over 48 hours), orphaned order items with no parent order, old error logs. Keep: completed orders and their metadata, product data, customer records, tax records (legal retention requirements vary by jurisdiction). Never auto-delete orders without confirming your legal obligations.

WooCommerce includes a basic transient clear in WooCommerce → Status → Tools → Clear transients. For comprehensive cleanup including orphaned data and revisions, a dedicated plugin like WP-Optimize or Advanced Database Cleaner covers more ground.

Primarily it speeds up the WooCommerce admin – order lists, reports, and product management. Frontend speed depends more on caching, image optimisation, and hosting. Database cleanup has a smaller direct impact on customer-facing pages unless your database queries are particularly slow.

WP-Optimize is a solid free option with WooCommerce-specific cleanup. Advanced Database Cleaner offers more granular control. For stores on managed hosting (Kinsta, WP Engine), the host often provides database optimisation tools – check your hosting dashboard before installing a plugin.

Results vary widely. Stores that have never been cleaned with many revisions and accumulated transients can see 50-80% size reduction. Stores cleaned regularly see smaller gains of 10-20%. The most impactful cleanup targets are post revisions (often the largest contributor) and old session data on high-traffic stores.