WooCommerce Attribute Lookup Table Regeneration Stuck and Failing with Large Pro

Hi @talope ,

I understand how frustrating it can be when the regeneration process gets stuck, especially with a large product catalog like yours. Based on what you’ve shared, it sounds like the default settings in WooCommerce may not be optimized for your store’s size. Let’s break this down and explore some solutions together.

First, the fact that the tool is stuck at Filling in progress (300) for days is likely because of the batch size being too small for your 30,000 products. This can overwhelm the system, slowing things to a crawl. To speed it up, you can increase the batch size by adding a simple code snippet to your theme’s functions.phpfile or by using a code snippet plugin. This will let you set a larger batch size, allowing WooCommerce to handle more products at a time and help clear the backlog faster. Here is the snippet:

add_filter('woocommerce_attribute_lookup_regeneration_step_size', function() {  
    return 100;  
});

For more information, please refer to this guide:
https://developer.woocommerce.com/2022/02/02/new-product-filtering-by-attributes-rolling-out-in-woocommerce-6-3/

The errors in the Action Scheduler Managing Queued and Failed Actions indicate that the server might be struggling with the workload. To monitor and manage these tasks, you can use the WP Crontrol plugin. It allows you to:

• Retry failed actions.
• Manually clear stuck tasks.
• Review scheduled events for any bottlenecks.

Additionally, increasing your PHP memory limit (to at least 512MB) and execution time (e.g., 300 seconds or higher) in your server configuration can prevent timeouts during the regeneration process.

The error you’re seeing about dependency injection Alias (Automattic\WooCommerce\Internal\ProductAttributesLookup\LookupTableDataRegenerator) is not being managed by the container is often related to file integrity or conflicts with plugins/themes. Since you’ve already reinstalled WooCommerce and checked for missing files, the next step is to ensure no plugins or custom code are interfering.

You’ve mentioned trying this already, but I’d recommend a second pass by switching to a default theme like Storefront and disabling all plugins except WooCommerce to see if the issue persists.

Lastly, if these steps don’t completely resolve the problem, it would also help us to review your current System Status Report to gain more insight into your setup. You can find this report in your WooCommerce dashboard by going to WooCommerce > Status. From there, please select Get system report and then Copy for support.

Once you’ve gathered this information, please paste it into a code block in your reply or use Pastebin and share the link with us.

Please give these steps a try and let us know how it goes. We’re here to assist you further if needed!

Hello, thank you very much for the reply.

We added the script you suggested we will see how it goes. For the past 2 hours it’s still stuck at (filling in 300). I think this is stuck in general to be honest.

We also installed crontrol plugin, do we have to configure it or we just let it active and it will do it’s job?

Keep in mind that our woocommerce store is connected to an ERP with the Woocommerce API, every few hours the EPR is updating also our products with new prices which triggers this hook “woocommerce_run_product_attribute_lookup_update_callback”. this runs about 90k times per day.

I also paste you our woocommerce status:

WordPress Environment

WordPress address (URL): - removed for safety -
Site address (URL): - removed for safety 
WC Version: 9.4.1
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ? 3.8.2
Log Directory Writable: ?
WP Version: 6.7
WP Multisite: –
WP Memory Limit: 12 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ? Server Environment

Server Info: LiteSpeed
PHP Version: 8.3.13
PHP Post Max Size: 80 MB
PHP Time Limit: 1200
PHP Max Input Vars: 15000
cURL Version: 8.5.0
OpenSSL/3.0.13

SUHOSIN Installed: –
MySQL Version: 10.11.8-MariaDB-0ubuntu0.24.04.1-log
Max Upload Size: 80 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 9.4.1
WC Database Prefix: cKoWHT_
Total Database Size: 7904.68MB
Database Data Size: 4075.90MB
Database Index Size: 3828.78MB
cKoWHT_woocommerce_sessions: Data: 16.02MB + Index: 2.08MB + Engine InnoDB
cKoWHT_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
cKoWHT_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_actionscheduler_actions: Data: 74.59MB + Index: 97.41MB + Engine InnoDB
cKoWHT_actionscheduler_claims: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
cKoWHT_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_actionscheduler_logs: Data: 53.58MB + Index: 39.11MB + Engine InnoDB
cKoWHT_alphabank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_braapf_custom_post_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_braapf_product_post_meta: Data: 0.34MB + Index: 0.75MB + Engine InnoDB
cKoWHT_braapf_product_stock_status_parent: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
cKoWHT_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_braapf_term_taxonomy_hierarchical: Data: 0.14MB + Index: 0.19MB + Engine InnoDB
cKoWHT_braapf_variable_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_comments: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
cKoWHT_db7_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
cKoWHT_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
cKoWHT_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_facetwp_index: Data: 7.52MB + Index: 7.55MB + Engine InnoDB
cKoWHT_icl_background_task: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_icl_languages_translations: Data: 0.19MB + Index: 0.09MB + Engine InnoDB
cKoWHT_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_icl_mo_files_domains: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_strings: Data: 0.47MB + Index: 0.64MB + Engine InnoDB
cKoWHT_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_string_positions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_string_translations: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
cKoWHT_icl_translate: Data: 1.52MB + Index: 0.05MB + Engine InnoDB
cKoWHT_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_icl_translations: Data: 53.59MB + Index: 221.97MB + Engine InnoDB
cKoWHT_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_icl_translation_status: Data: 24.55MB + Index: 21.55MB + Engine InnoDB
cKoWHT_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_litespeed_crawler: Data: 2.52MB + Index: 3.94MB + Engine InnoDB
cKoWHT_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_litespeed_img_optming: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
cKoWHT_litespeed_url: Data: 3.14MB + Index: 4.23MB + Engine InnoDB
cKoWHT_litespeed_url_file: Data: 4.11MB + Index: 13.20MB + Engine InnoDB
cKoWHT_mclean_refs: Data: 11.52MB + Index: 0.00MB + Engine InnoDB
cKoWHT_mclean_scan: Data: 10.52MB + Index: 1.52MB + Engine InnoDB
cKoWHT_options: Data: 30.48MB + Index: 6.05MB + Engine InnoDB
cKoWHT_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxe_posts: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxe_templates: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxi_geocoding: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_pmxi_hash: Data: 2.31MB + Index: 1.52MB + Engine InnoDB
cKoWHT_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxi_images: Data: 0.09MB + Index: 0.16MB + Engine InnoDB
cKoWHT_pmxi_imports: Data: 0.33MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pmxi_posts: Data: 2.52MB + Index: 3.48MB + Engine InnoDB
cKoWHT_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_postmeta: Data: 1524.97MB + Index: 918.95MB + Engine InnoDB
cKoWHT_posts: Data: 247.80MB + Index: 287.02MB + Engine InnoDB
cKoWHT_pys_stat_landing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_product_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_rank_math_analytics_inspections: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
cKoWHT_rank_math_analytics_objects: Data: 6.52MB + Index: 2.95MB + Engine InnoDB
cKoWHT_rank_math_internal_links: Data: 2.52MB + Index: 1.84MB + Engine InnoDB
cKoWHT_rank_math_internal_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
cKoWHT_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_scalability_pro_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_scalability_pro_post_count_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_scalability_pro_transient_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_sib_model_lang: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_spro_slow_query_log: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
cKoWHT_termmeta: Data: 0.20MB + Index: 0.25MB + Engine InnoDB
cKoWHT_terms: Data: 0.27MB + Index: 0.45MB + Engine InnoDB
cKoWHT_term_relationships: Data: 5.50MB + Index: 8.02MB + Engine InnoDB
cKoWHT_term_taxonomy: Data: 0.20MB + Index: 0.23MB + Engine InnoDB
cKoWHT_usermeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
cKoWHT_users: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
cKoWHT_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wc_category_lookup: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
cKoWHT_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
cKoWHT_wc_orders_meta: Data: 0.14MB + Index: 0.20MB + Engine InnoDB
cKoWHT_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
cKoWHT_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
cKoWHT_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
cKoWHT_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wc_product_meta_lookup: Data: 3.52MB + Index: 8.03MB + Engine InnoDB
cKoWHT_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wpcode_revisions: Data: 2.52MB + Index: 0.02MB + Engine InnoDB
cKoWHT_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cKoWHT_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_actionscheduler_actions: Data: 5.02MB + Index: 2.16MB + Engine InnoDB
wpstg0_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_logs: Data: 155.70MB + Index: 116.28MB + Engine InnoDB
wpstg0_alphabank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_braapf_product_stock_status_parent: Data: 1.52MB + Index: 0.45MB + Engine InnoDB
wpstg0_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_braapf_term_taxonomy_hierarchical: Data: 0.09MB + Index: 0.19MB + Engine InnoDB
wpstg0_braapf_variable_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_comments: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wpstg0_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wpstg0_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wpstg0_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_facetwp_index: Data: 6.52MB + Index: 9.55MB + Engine InnoDB
wpstg0_icl_background_task: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_icl_languages_translations: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
wpstg0_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_icl_mo_files_domains: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_strings: Data: 0.47MB + Index: 0.64MB + Engine InnoDB
wpstg0_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_string_positions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_string_translations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_icl_translate: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_icl_translations: Data: 41.58MB + Index: 176.64MB + Engine InnoDB
wpstg0_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_icl_translation_status: Data: 21.56MB + Index: 19.55MB + Engine InnoDB
wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_litespeed_img_optming: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
wpstg0_litespeed_url: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
wpstg0_litespeed_url_file: Data: 0.11MB + Index: 0.25MB + Engine InnoDB
wpstg0_mclean_refs: Data: 11.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_mclean_scan: Data: 9.52MB + Index: 1.52MB + Engine InnoDB
wpstg0_options: Data: 8.48MB + Index: 1.17MB + Engine InnoDB
wpstg0_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxe_posts: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxe_templates: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_geocoding: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_pmxi_hash: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wpstg0_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_images: Data: 0.11MB + Index: 0.19MB + Engine InnoDB
wpstg0_pmxi_imports: Data: 0.33MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_posts: Data: 2.52MB + Index: 3.52MB + Engine InnoDB
wpstg0_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_postmeta: Data: 1456.00MB + Index: 1019.55MB + Engine InnoDB
wpstg0_posts: Data: 211.75MB + Index: 785.39MB + Engine InnoDB
wpstg0_pys_stat_landing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_product_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_rank_math_analytics_inspections: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpstg0_rank_math_analytics_objects: Data: 6.52MB + Index: 4.00MB + Engine InnoDB
wpstg0_rank_math_internal_links: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
wpstg0_rank_math_internal_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_scalability_pro_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_scalability_pro_post_count_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_scalability_pro_transient_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_spro_slow_query_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_termmeta: Data: 0.22MB + Index: 0.33MB + Engine InnoDB
wpstg0_terms: Data: 0.30MB + Index: 0.56MB + Engine InnoDB
wpstg0_term_relationships: Data: 4.52MB + Index: 9.03MB + Engine InnoDB
wpstg0_term_taxonomy: Data: 0.22MB + Index: 0.72MB + Engine InnoDB
wpstg0_usermeta: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
wpstg0_users: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_category_lookup: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wpstg0_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_product_attributes_lookup: Data: 2.52MB + Index: 3.52MB + Engine InnoDB
wpstg0_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_product_meta_lookup: Data: 3.52MB + Index: 11.47MB + Engine InnoDB
wpstg0_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wpcode_revisions: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
wpstg0_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpmelon_advbedit_temp: Data: 1.52MB + Index: 0.00MB + Engine InnoDB Post Type Counts

acf-field: 15
acf-field-group: 4
acf-post-type: 2
acf-taxonomy: 4
attachment: 772672
br_filters_group: 1
br_product_filter: 4
collection: 1
custom_css: 1
elementor_library: 27
fs_cm_ruleset: 4
html_block: 32
nav_menu_item: 21
our-collections: 28
page: 54
pi_dpmw_rules: 3
post: 9
product: 29111
project: 52
revision: 38
shop_order: 29
shop_order_placehold: 8
shop_order_refund: 1
sylloges: 2
wp_navigation: 1
wpcf7_contact_form: 4
wpcode: 23 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (41)

Advanced Custom Fields Multilingual: by OnTheGoSystems – 2.1.4.2
Advanced Custom Fields PRO: by WP Engine – 6.3.6
Advanced Database Cleaner PRO: by Younes JFR. – 3.2.10
AutoConvert Greeklish Permalinks: by Dimitris Mavroudis – 4.2.0
Classic Editor: by WordPress Contributors – 1.6.5
Contact Form 7: by Takayuki Miyoshi – 6.0
Contact Form CFDB7: by Arshid – 1.2.9
Disable payment method / COD fees for Order for WooCommerce (PRO): by PI Websolution – 1.0.60.0
Duplicate Page: by mndpsingh287 – 4.5.4
Elementor Pro Activ@tor: by moh@medhk2 – 1.4.0
Elementor Pro: by Elementor.com – 3.24.4
Elementor: by Elementor.com – 3.25.6
Facebook for WooCommerce: by Facebook – 3.3.0
Filenames to latin: by webvitaly – 2.7
Conditional Shipping Methods: by Octolize – 1.2.0
Flexible Shipping PRO: by Octolize – 2.19.0
Flexible Shipping: by Octolize – 5.0.5
Font Icons Loader: by parkofideas.com – 1.10
Moderno Core: by parkofideas.com – 1.27
LiteSpeed Cache: by LiteSpeed Technologies – 6.5.2
Newsletter, SMTP, Email marketing and Subscribe forms by Brevo: by Brevo – 3.1.88
Meta Box: by MetaBox.io – 5.10.3
Perfmatters: by forgemedia – 2.3.4
PixelYourSite PRO: by PixelYourSite – 11.0.1
Payment Plugins for PayPal WooCommerce: by Payment Plugins
[email protected] – 1.0.53

Scalability Pro: by Dave Hilditch – 5.79
Rank Math SEO: by Rank Math SEO – 1.0.232
WPML Multilingual CMS: by OnTheGoSystems – 4.6.13
WooCommerce Cash On Pickup: by Marian Kadanka – 1.7.0
Timologio for Woocommerce: by Web Expert – 2.1.33
Web Expert Alpha Bank WooCommerce Payment Gateway (via Cardlink): by Web Expert – 2.0.1
WooCommerce Advanced Bulk Edit: by George Iron & Yas G. – 5.4.4.7.1
WooCommerce AJAX Products Filter: by BeRocket – 3.1.4.6
WooCommerce Multilingual & Multicurrency: by OnTheGoSystems – 5.3.8
WooCommerce: by Automattic – 9.4.1
WP Crontrol: by John Blackbourn – 1.17.0
WP Mail SMTP Pro: by WP Mail SMTP – 4.1.1
WP STAGING PRO - Backup Duplicator & Migration: by WP-STAGING – 5.7.1
WP STAGING WordPress Backup Plugin - Backup Duplicator & Migration: by WP-STAGING
WPStagingBackup – 3.9.0

WPCode Pro: by WPCode – 2.2.2.1
WPML String Translation: by OnTheGoSystems – 3.2.14 Inactive Plugins (7)

WP All Export - ACF Export Add-On Pro: by Soflyy – 1.0.5
WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.9
WP All Export Pro: by Soflyy – 1.9.1
WP All Import - ACF Add-On: by Soflyy – 3.3.8
WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 4.0.0
WP All Import Pro: by Soflyy – 4.9.0
WPML All Import: by OnTheGoSystems – 2.3.0 Dropin Plugins ()

maintenance.php: maintenance.php
object-cache.php: LiteSpeed Cache - Object Cache (Drop-in) Settings

Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
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: – Logging

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 85 KB WC Pages

Shop base: #297462 - /shop/
Cart: #297390 - /kalathi-agoron/ - Contains the [woocommerce_cart] shortcode
Checkout: #297461 - /checkout/ - Contains the [woocommerce_checkout] shortcode
My account: #297021 - /my-account/
Terms and conditions: #297399 - /oroi-chrisis/ Theme

Name: Moderno-Child
Version: 1.0
Author URL: https://parkofideas.com
Child Theme: ?
Parent Theme Name: Moderno
Parent Theme Version: 1.27
Parent Theme Author URL: https://parkofideas.com
WooCommerce Support: ? Templates

Overrides: moderno/woocommerce/archive-product.php
moderno/woocommerce/cart/cart-empty.php
moderno/woocommerce/cart/cart-shipping.php
moderno/woocommerce/cart/cart-totals.php
moderno/woocommerce/cart/cart.php
moderno/woocommerce/cart/cross-sells.php
moderno/woocommerce/cart/mini-cart.php
moderno/woocommerce/cart/proceed-to-checkout-button.php
moderno/woocommerce/cart/shipping-calculator.php
moderno/woocommerce/checkout/form-billing.php
moderno/woocommerce/checkout/form-checkout.php
moderno/woocommerce/checkout/form-coupon.php
moderno/woocommerce/checkout/form-pay.php
moderno/woocommerce/checkout/form-shipping.php
moderno/woocommerce/checkout/payment-method.php
moderno/woocommerce/checkout/payment.php
moderno/woocommerce/checkout/review-order.php
moderno/woocommerce/checkout/terms.php
moderno/woocommerce/checkout/thankyou.php
moderno/woocommerce/content-product-cat.php
moderno/woocommerce/content-product.php
moderno/woocommerce/content-single-product.php
moderno/woocommerce/content-widget-product.php
moderno-child/woocommerce/emails/customer-completed-order.php
moderno-child/woocommerce/emails/customer-note.php
moderno-child/woocommerce/emails/customer-on-hold-order.php
moderno-child/woocommerce/emails/customer-processing-order.php
moderno-child/woocommerce/emails/customer-refunded-order.php
moderno/woocommerce/global/breadcrumb.php
moderno/woocommerce/global/form-login.php
moderno/woocommerce/global/quantity-input.php
moderno/woocommerce/global/sidebar.php
moderno/woocommerce/global/wrapper-end.php
moderno/woocommerce/global/wrapper-start.php
moderno/woocommerce/loop/loop-end.php
moderno/woocommerce/loop/loop-start.php
moderno/woocommerce/loop/no-products-found.php
moderno/woocommerce/loop/rating.php
moderno/woocommerce/loop/sale-flash.php
moderno/woocommerce/myaccount/dashboard.php
moderno/woocommerce/myaccount/downloads.php
moderno/woocommerce/myaccount/form-login.php
moderno/woocommerce/myaccount/my-account.php
moderno/woocommerce/myaccount/navigation.php
moderno/woocommerce/myaccount/orders.php
moderno/woocommerce/notices/error.php
moderno/woocommerce/notices/notice.php
moderno/woocommerce/notices/success.php
moderno/woocommerce/product-searchform.php
moderno/woocommerce/single-product/add-to-cart/grouped.php
moderno/woocommerce/single-product/add-to-cart/variable.php
moderno/woocommerce/single-product/product-image.php
moderno/woocommerce/single-product/rating.php
moderno/woocommerce/single-product/related.php
moderno/woocommerce/single-product/sale-flash.php
moderno/woocommerce/single-product/short-description.php
moderno/woocommerce/single-product/tabs/additional-information.php
moderno/woocommerce/single-product/tabs/tabs.php
moderno/woocommerce/single-product/title.php
moderno/woocommerce/single-product/up-sells.php 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
navigation
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
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
use-wp-horizon

Daily Cron: ? Next scheduled: 2024-11-19 18:17:39 +02:00
Options: ?
Notes: 57
Onboarding: completed Action Scheduler

Complete: 246,112
Oldest: 2024-10-19 13:36:42 +0300
Newest: 2024-11-19 12:29:27 +0200

Pending: 5
Oldest: 2024-11-19 16:28:41 +0200
Newest: 2024-11-20 11:30:07 +0200 Status report information

Generated at: 2024-11-19 12:33:16 +02:00
`

Hello Nowhere Web Management,

Thank you for your reply.

I understand the issue is still occurring and it’s stuck for the past 2 hours.
For more effective troubleshooting, I recommend creating a staging site.
There you can deactivate all the plugins and themes and also disable ERP connection via API.
At the staging site, I suggest reviewing the error logs under WooCommerce > System Status > Logs.

The WP Crontrol plugin does not need any configuration.
It should work once activated and show warnings or errors if any.

Looking forward to your response. ??