What should it do?

Check the WooCommerce version and the correct database prefix, run the db-optimize command for each table. Especially relevant to check the version because of the HPOS update.

non-HPOS

wp_posts
wp_postmeta
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta
wp_woocommerce_sessions
wp_woocommerce_api_keys
wp_woocommerce_tax_rates
wp_woocommerce_tax_rate_locations
wp_woocommerce_shipping_zones
wp_woocommerce_shipping_zone_methods
wp_woocommerce_payment_tokens
wp_woocommerce_payment_tokenmeta
wp_woocommerce_log

HPOS

wp_wc_orders
wp_wc_order_addresses
wp_wc_order_operational_data
wp_wc_orders_meta
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta

Example user queries

• "optimize the WooCommerce tables"
• "optimize the WooCommerce database tables

Type

New ability (single operation)