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.

A transient is a type of caching where data is stored in the database for a fixed period before it gets automatically deleted. This data can be quickly accessed, helping to save time and enhance the performance of your website.

A common example is the shopping cart contents. These are stored using transients so that a customer can leave the cart page and return later to find their items still there.

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

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

Delete all WordPress transient data: Removes expired temporary data.

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.

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

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.

Reset product count cache: This updates the cache for the number of products in each category or attribute. This can help correct any inaccurate product counts displayed on the site after settings have changed.

Reset user capabilities to defaults: Use this to reset user roles and permissions to the default settings. This is helpful if these a plugin or custom code has changed these, which can cause issues such as users losing access to admin pages they should be able to see.

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

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

Create missing WooCommerce pages: Generate any missing default WooCommerce pages without overwriting the existing ones. This can be helpful if you find your cart of checkout pages are not assigned or are missing.

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

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.

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. Remember to always backup the database before running this update.

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

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.

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

Do you still have questions and need assistance? 

This documentation is about the free, core WooCommerce plugin for which support is provided in our community forums on WordPress.org. By searching this forum, you’ll often find that your question has been asked and answered before.

If you haven’t created a WordPress.org account to use the forums, here’s how.

• 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.