WooCommerce System Tools

WooCommerce includes a set of built-in tools to help troubleshoot issues, optimize performance, and manage key settings in one place. The WooCommerce system tools, including database cleanup and clearing your site’s cache, can help WooCommerce run smoothly.

You can access these settings from WooCommerce > Status > Tools.

What Are Transients?

↑ Back to top

A transient is temporary cached data with an expiration time. WordPress can remove a transient before that time, so cached data may need to be recreated.

The expired-transients tool removes expired transient entries. It does not clear every active transient.

Default WooCommerce System Tools

↑ Back to top

The below tools are available by default when WooCommerce is installed and active.

WooCommerce Transients

↑ Back to top

Delete all shop and product transient data: Clears temporary data related to shop and products.

Expired Transients

↑ Back to top

Clear expired transients: Removes expired transient entries from WordPress.

Orphaned Variations

↑ Back to top

Delete variations without a parent product: These are product variations that no longer have an associated main product, which can cause errors such as incorrect product counts.

Used-up Download Permissions

↑ Back to top

Delete expired download permissions: Removes permissions for downloads that have either expired or reached the limit of allowed downloads.

Product Lookup Tables

↑ Back to top

Regenerate product lookup tables: These tables store product data for quick access, speeding up the database. If they become out of sync with the products, incorrect product details may show up. Regenerating them ensures they match the actual product data. While regeneration is running, the button changes to Regenerating in progress and WooCommerce displays a View progress link. If WP-Cron is disabled, the link reads View queued updates.

Coupons lookup table

↑ Back to top

Repair coupon lookup data: Select Repair to sync coupon data for orders whose lookup entries have a zero discount amount. This process may take a while. Back up your database before running the repair.

If no entries have a zero discount amount, WooCommerce reports that the lookup table is up to date. If the table does not exist, WooCommerce reports that instead. After a repair, the result message shows how many entries were processed and how many had errors.

Term Counts

↑ Back to top

Recount product term counts: Recalculates product counts for categories and attributes. This can help correct inaccurate counts after settings change which products appear in the catalog.

Capabilities

↑ Back to top

Reset capabilities: Resets the Administrator, Customer, and Shop Manager roles to their WooCommerce defaults. Use this if users cannot access all of the WooCommerce admin pages.

Clear Customer Sessions

↑ Back to top

Delete active customer session data: Clear data from all ongoing customer sessions, including cart contents.

Clear Template Cache

↑ Back to top

Reset template cache: Clear the cache for theme templates. This helps when theme customizations aren’t showing up on the front end.

Create Default WooCommerce Pages

↑ Back to top

Create missing WooCommerce pages: Generate any missing default WooCommerce pages without replacing pages that are already set up. Use this if a default page is missing.

Delete WooCommerce Tax Rates

↑ Back to top

Remove all tax rates: Delete all configured tax rates, which is useful if you need to start over with a clean tax setup.

Regenerate Shop Thumbnails

↑ Back to top

Recreate shop images: After you change the image size settings in the customizer or theme, this regenerates the shop images to ensure old sizes are updated. This process runs in the background and may take some time. While regeneration is running, the button changes to Regenerating in progress and a Cancel action appears beside it.

Update Database

↑ Back to top

Update the WooCommerce database: This updates the WooCommerce database to the latest version. This can be useful if you suspect version mismatches may be causing issues. Always back up the database before running this update.

Re-create Order Address FTS index

↑ Back to top

This tool will recreate the full text search index for order addresses, which can help when trying to find order information based on a customer address.

You can find out more about FTS search here.

Verify Base Database Tables

↑ Back to top

Check for missing WooCommerce tables: This ensures all required WooCommerce tables are present in the database.

Rebuild Analytics Tax Data

↑ Back to top

Before you start: Use WooCommerce 11.2.0 or later and an account that can open WooCommerce > Status > Tools.

WooCommerce queues a background migration during the update to WooCommerce 11.2.0. It rebuilds older Analytics tax lookup records so each tax line on an order has its own record. The migration processes orders in the background. Until an order is processed, its Analytics reports continue using the lookup data already stored for that order.

The Rebuild analytics tax data tool shows how many orders remain. While the rebuild is running, WooCommerce displays Stop rebuilding analytics tax data with the number of orders left to process. Select Stop rebuilding to stop the background process. Any remaining orders stay pending, and you can select Rebuild to start the process again. If there are no orders left to rebuild, the tool is disabled and says that there are currently no orders to rebuild.

If the database change needed for the rebuild is missing, the tool is disabled and asks you to run Verify base database tables, then return to this page. For the report that uses these records, see the Taxes Report.

For technical details about the changed lookup records and investigating an order that did not rebuild, share the Analytics tax lookup migration reference with your developer.

Clear Analytics Cache

↑ Back to top

Reset WooCommerce Analytics cache: This clears the analytics cache, which can be helpful if analytics appear inaccurate. You can then re-import data afterward from the Analytics ➔ Settings page.

Fix Analytics Full Refund Data

↑ Back to top

Repair historical analytics for fully refunded orders: This tool appears only on stores that may still use older full-refund analytics data, or after a repair has run but the tool has not yet been dismissed. It is intended for stores where a fully refunded order can leave negative net sales, or where net sales, taxes, and shipping do not net to zero in Analytics.

1. Select Check. This checks for affected analytics records without changing data.
2. If WooCommerce finds affected orders, select Fix. WooCommerce schedules the affected historical refund records for re-import in batches. This updates Analytics lookup data; it does not refund orders or change their status.
3. Allow the scheduled Analytics import actions to finish before checking the Analytics reports again. You can monitor them under WooCommerce > Status > Scheduled Actions.
4. Run Check again. If no affected orders remain, the action changes to Disable tool. Select it to dismiss the tool and remove it from this page.

This is a targeted repair for historical full-refund analytics. It is not a general Analytics reset.

Refresh Remote Inbox Notifications

↑ Back to top

Use Refresh Remote Inbox Notifications to fetch the latest WooCommerce Marketplace notifications for your inbox.

To enable remote notifications in WooCommerce, the following setting must be enabled:

1. Navigate to WooCommerce > Settings > Advanced > WooCommerce.com.
2. Enable Marketplace Suggestions.

With this setting enabled, WooCommerce can display product updates and Marketplace suggestions in your inbox.

Delete an Inbox Notification

↑ Back to top

The Delete an Inbox Notification tool in WooCommerce allows you to remove specific notifications from your inbox using “slug.” This feature is useful for managing your inbox and keeping only relevant or important notifications visible.

Each inbox notification has a unique identifier known as a “slug.” You can find the slug of the notification you wish to delete and enter the notification slug in the textbox labeled Search for inbox notification and delete the specific inbox notification.

Synchronise Approved Download Directories

↑ Back to top

This tool triggers a fresh scan of the product catalog. When downloadable product paths are discovered that are not already covered by existing Approved Download Directory rules, they are added to the list, but are initially disabled.

You can find out more about this here.

Empty the Approved Download Directories List

↑ Back to top

This tool is used to delete the existing Approved Download Directory list entirely.

You can find out more about this here.

Convert Order Coupon Data to the Simplified Format

↑ Back to top

This tool converts older coupon details stored on order items to the simplified format used by WooCommerce. The conversion process runs in the background using Action Scheduler.

This tool will only be enabled if there are coupon entries that can be converted (eg: it will show a notice in the description like “There are currently no entries to convert”)

For technical details, see Changes in Order Coupons Line Item Storage.

Schedule Expired Transient Files Cleanup

↑ Back to top

This tool is used to schedule the action to delete expired transient files for running immediately. The expired transient files are cleaned every 24 hours.

HPOS Tools

↑ Back to top

If High Performance Order Storage (HPOS) is enabled, some further tools become available.

Clean Up Order Data From Legacy Tables

↑ Back to top

The Clean Up Order Data from Legacy Tables tool is designed to clear old order data from legacy tables once HPOS is fully operational. This process optimizes database performance by removing outdated order information from legacy tables, provided that HPOS is set as the authoritative table for order storage and compatibility mode is turned off.

This tool clears eligible order data from the legacy tables in the background. It checks each order before removing its legacy copy.

Before removing a legacy copy, WooCommerce checks that the matching HPOS order is at least as recent as the order data in the posts table.

NOTE: After cleanup, each migrated order still has a placeholder entry in the posts table.

Delete the Custom Orders Tables

↑ Back to top

The Delete the Custom Orders Tables tool allows for the complete deletion of custom orders tables, freeing up database space if you decide to revert from HPOS to legacy order storage.

This tool should be used when HPOS is not set as authoritative order storage and sync between HPOS and legacy tables is disabled.

WooCommerce System Tools From Other Plugins

↑ Back to top

Some extensions will add extra tools to this tab that are specific to their function:

• WooCommerce Square
  • Background Processing test
  • Clear Square Sync
• WooCommerce Smart Coupons
  • WooCommerce Smart Coupons Cache
• WooCommerce Bookings
  • Clean unused Person Types from DB
  • Clear expired In Cart bookings
• WooPayments
  • Clear WooPayments account cache
• WooCommerce Subscriptions
  • Generate Related Order Cache
  • Delete Related Order Cache
  • Generate Customer Subscription Cache

Questions and support

↑ Back to top

Do you still have questions and need assistance? 

• If you’re looking to extend the core functionality shown here, we recommend reviewing available extensions in the WooCommerce Marketplace.
• Need ongoing advanced support or a customization built for WooCommerce? Hire a Woo Agency Partner.
• Are you a developer building your own WooCommerce integration or extension? Check our Developer Resources.

If you weren’t able to find the information you need, please use the feedback thumbs below to let us know.