Cannot Disable Product Attributes Lookup Table in WooCommerce

Resolved

(@cindypaa)

I have a WooCommerce site with over 300,000 products. I want to disable Enable table usage to reduce server load, but the admin page shows: “These settings are not available while the lookup table regeneration is in progress.” I’m not sure if the process is still running normally or if it has stalled, which prevents me from disabling this feature. Could you please advise how to safely turn it off?

System Status Report

### WordPress Environment ###

WordPress address (URL): [Redacted]
Site address (URL): [Redacted]
WC Version: 10.3.5
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ✔ 3.9.3
Log Directory Writable: ✔
WP Version: 6.8.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: ✔

### Server Environment ###

Server Info: Apache/2.4.65 (Unix) OpenSSL/3.2.2
Server Architecture: Linux 5.14.0-570.41.1.el9_6.x86_64 x86_64
PHP Version: 8.2.10
PHP Post Max Size: 128 MB
PHP Time Limit: 0
PHP Max Input Vars: 3000
cURL Version: 7.76.1
OpenSSL/3.2.2

SUHOSIN Installed: –
MySQL Version: 10.5.27-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

[REDACTED]

### Post Type Counts ###

attachment: 137596
awb_off_canvas: 1
elementor_library: 3
fusion_element: 10
fusion_form: 4
fusion_icons: 2
fusion_tb_layout: 10
fusion_tb_section: 22
nav_menu_item: 111
oembed_cache: 1
page: 8
post: 274
product: 495219
revision: 2922
shopengine-template: 1
slide: 3
wp_font_face: 36
wp_font_family: 12
wp_global_styles: 1
wp_navigation: 1
wpb_wmca_shortcodes: 1
wpcode: 4
wpforms: 1
wppopups: 1

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (20) ###

AIOSEO - REST API: by All in One SEO Team – 1.0.9
All in One SEO Pro: by All in One SEO Team – 4.9.0
Avada Builder: by ThemeFusion – 3.11.15
Avada Core: by ThemeFusion – 5.11.15
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 9.9.0
Site Kit by Google: by Google – 1.165.0
GTranslate: by Translate AI Multilingual Solutions – 3.0.8
Index WP MySQL For Speed: by Oliver Jones
Rick James – 1.5.4

Product Category: by Kushang Tailor – 1.5.0
Recently Viewed Product for WooCommerce: by Mahesh Patel – 2.0.0
Redis Object Cache: by Till Krüss – 2.7.0
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6
Tawk.to Live Chat: by Tawkto – 0.9.2
Modern Image Formats: by WordPress Performance Team – 2.6.0
WooCommerce: by Automattic – 10.3.5
WP All Import Pro: by Soflyy – 4.8.5
WP Extra File Types: by Davide Airaghi – 0.5.2
WP Fastest Cache: by Emre Vona – 1.3.8
WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 4.0.0
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.17.2


### Inactive Plugins (10) ###

AIOSEO - Author SEO (E-E-A-T): by All in One SEO Team – 1.2.6
AIOSEO - Image SEO: by All in One SEO Team – 1.2.1
AIOSEO - IndexNow: by All in One SEO Team – 1.0.13
AIOSEO - Redirects: by All in One SEO Team – 1.4.14
Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.4.0.3
Autoptimize: by Frank Goossens (futtta) – 3.1.13
Broken Link Checker: by WPMU DEV – 2.4.6
HTML in Category Descriptions: by Arno Esterhuizen – 1.2.4
OptinMonster: by OptinMonster Popup Builder Team – 2.16.20
WP Mail SMTP: by WP Mail SMTP – 4.7.0

### Dropin Plugins () ###

object-cache.php: Redis Object Cache Drop-In

### Must Use Plugins (1) ###

Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by  – 1.5.4

### Settings ###

Legacy API Enabled: –
Force SSL: –
Currency: CNY (¥)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: ✔
HPOS feature enabled: ✔
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –
Enabled Features: marketplace
site_visibility_badge
blueprint
point_of_sale
custom_order_tables


### Logging ###

Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 18 KB

### WC Pages ###

Shop base: ❌ Page not set
Cart: ❌ Page ID is set
but the page does not exist

Checkout: ❌ Page ID is set
but the page does not exist

My account: ❌ Page ID is set
but the page does not exist

Terms and conditions: ❌ Page not set

### Theme ###

Name: Avada Child
Version: 1.0.0
Author URL: https://theme-fusion.com
Child Theme: ✔
Parent Theme Name: Avada
Parent Theme Version: 7.11.15
Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
Theme type: Classic theme
WooCommerce Support: ✔

### Templates ###

Overrides: Avada/woocommerce/cart/cart.php version 7.9.0 is out of date. The core version is 10.1.0
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php

Outdated Templates: ❌


                        Learn how to update                  |




                        Clear system status theme info cache

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: product-data-views
experimental-blocks
experimental-iapi-mini-cart
experimental-iapi-runtime
coming-soon-newsletter-template
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
use-wp-horizon
rest-api-v4

Daily Cron: ✔ Next scheduled: 2025-11-15 08:36:13 -08:00
Options: ✔
Notes: 101
Onboarding: skipped

### Action Scheduler ###

Canceled: 1
Oldest: 2025-11-13 21:00:03 +0000
Newest: 2025-11-13 21:00:03 +0000

Complete: 41,370
Oldest: 2025-10-14 10:09:51 +0000
Newest: 2025-11-14 09:15:03 +0000

Failed: 124
Oldest: 2024-07-02 03:18:41 +0000
Newest: 2025-11-14 04:43:32 +0000

In-progress: 1
Oldest: –
Newest: –

Pending: 23
Oldest: 2025-11-14 09:15:50 +0000
Newest: 2025-11-30 16:10:48 +0000


### Status report information ###

Generated at: 2025-11-14 01:15:15 -08:00

The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support Frank Remmy (woo-hc)
(@frankremmy)

5 months ago
Hi @cindypaa,

Thank you for sharing the details about your large product catalog and the lookup table regeneration issue. It’s great that you’re looking to optimize server load by disabling the table usage feature.

When WooCommerce displays “These settings are not available while the lookup table regeneration is in progress,” it means the system is busy building or updating the product lookup tables, which are essential for performance improvements. With over 300,000 products, this process can take quite some time and occasionally may appear stalled if server resources are limited.

Here are some steps to safely proceed:

1. Check if the regeneration process is still running:
- Look at your server’s CPU and PHP process activity to see if there is ongoing work related to WooCommerce or PHP that aligns with the lookup table process.
- You can also check your WooCommerce logs under WooCommerce → Status → Logs, filtering for any errors or long-running operations.
- If you have access, use tools like WP-CLI and run:
wp action-scheduler list --status=in-progress

to see if the action for lookup table generation is still active.

2. If the process seems stalled or stuck:
- Wait a bit longer if possible, as this operation is resource-intensive.
- If it appears definitely stalled, you may consider temporarily increasing your PHP max execution time and memory limits to facilitate the process completing.
- Alternatively, you can clear the stuck scheduled actions related to lookup table via WP-CLI:
wp action-scheduler clean
- After cleaning, the system should allow you to disable the setting.
3. Disable the Table Usage setting safely:
- Once the regeneration is either completed or the scheduled actions are cleared, navigate again to WooCommerce → Settings → Products → Advanced → Product Lookup Tables to disable “Enable table usage.”
- Save changes and monitor your site’s performance.
Given the size of your store, if you want to optimize for server performance further, consider looking into more powerful hosting solutions or managed WooCommerce hosting optimized for large stores. Also, leveraging caching and database optimization plugins could help.

I hope that helps. Let us know if you need anything else.
Thread Starter cindypaa
(@cindypaa)

5 months ago
Hi,

Thanks for your previous reply. I tried the recommended commands, but I ran into some issues:

When I run:
```
wp action-scheduler list --status=in-progress --allow-root
```
I get the error:

Error: ‘list’ is not a registered subcommand of ‘action-scheduler’

I also tried:
```
wp action-scheduler clean --allow-root
```
The command ran successfully, but the WooCommerce setting still shows:
“These settings are not available while the lookup table regeneration is in progress.”

It has already been more than two days since the regeneration started, and the message has not changed.
Plugin Support Frank Remmy (woo-hc)
(@frankremmy)

5 months ago
Hi @cindypaa,

Thanks for following up and sharing the results of the commands you tried. I understand how frustrating it must be to still see the “lookup table regeneration in progress” message after more than two days.

Did you also get a chance to test the other steps we suggested earlier, such as:
- Checking server CPU/PHP activity to confirm if the regeneration is still running
- Temporarily increasing PHP execution time or memory limits to help the process complete
- Disable the option at WooCommerce → Settings → Products → Advanced → Product Lookup Tables?
Regarding the “Enable table usage” setting, I forgot to mention that it controls whether WooCommerce uses an optimized lookup table for product attributes. The feature is an optimization designed to improve performance, particularly for stores with large product catalogs like yours.

If you disable this setting:
- WooCommerce will fall back to the traditional method of handling product attributes
- You may actually see increased server load rather than decreased load, especially with 300,000+ products
- Attribute-based queries and filtering could become slower
For your situation with 300,000 products: The lookup table is specifically designed to help stores like yours perform better. Disabling it would likely work against your goal of reducing server load.

The best optimization method would be to enable “Optimized updates”: https://share.zight.com/6qu4DxYm. For more information, see this blog post: https://developer.woocommerce.com/2024/06/20/an-optimization-for-the-product-attributes-lookup-table-is-coming/.

I hope that helps. Let us know if you need anything else.
Plugin Support thelmachido a11n
(@thelmachido)

4 months, 2 weeks ago

It’s been a while since we heard back from you for this reason we are closing this thread.

If WooCommerce has been useful for your store and you appreciate the support you’ve received, we’d truly appreciate it if you could leave us a quick review here:

https://wordpress.org/support/plugin/woocommerce/reviews/#new

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.