variations problem After previous update

Hi @timmyy21,

Can you please try to go to WooCommerce > Status > Tools tab and select these options:

• Clear WooCommerce transients (clear Shop/ Product page Cache)
• Clear expired transients (Clear all expired transients from WordPress)

Then, check again if the product variations appear.

If the issue persist, to get a better understanding of your setup, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Best,

Hi
I tried but it did not work.
I have attached what you requested.

### WordPress Environment ###

WordPress address (URL): https://
Site address (URL): https://
WC Version: 6.5.1
REST API Version: ? 6.5.1
WC Blocks Version: ? 7.4.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 6 GB
WP Debug Mode: –
WP Cron: ?
Language: he_IL
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.29
PHP Post Max Size: 6 GB
PHP Time Limit: 3000
PHP Max Input Vars: 1500
cURL Version: 7.83.0
OpenSSL/1.1.1o

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.36-MariaDB
Max Upload Size: 6 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: wp_
????? ????? ?? ???? ???????: 60.49MB
???? ??????? ?? ???? ???????: 43.06MB
???? ??????? ?? ???? ???????: 17.43MB
wp_woocommerce_sessions: ??????: 0.06MB + ??????: 0.02MB + ???? InnoDB
wp_woocommerce_api_keys: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_woocommerce_attribute_taxonomies: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_woocommerce_downloadable_product_permissions: ??????: 0.02MB + ??????: 0.06MB + ???? InnoDB
wp_woocommerce_order_items: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_woocommerce_order_itemmeta: ??????: 0.06MB + ??????: 0.06MB + ???? InnoDB
wp_woocommerce_tax_rates: ??????: 0.02MB + ??????: 0.06MB + ???? InnoDB
wp_woocommerce_tax_rate_locations: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_woocommerce_shipping_zones: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_woocommerce_shipping_zone_locations: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_woocommerce_shipping_zone_methods: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_woocommerce_payment_tokens: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_woocommerce_payment_tokenmeta: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_woocommerce_log: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_actionscheduler_actions: ??????: 0.20MB + ??????: 0.22MB + ???? InnoDB
wp_actionscheduler_claims: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_actionscheduler_groups: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_actionscheduler_logs: ??????: 0.16MB + ??????: 0.13MB + ???? InnoDB
wp_blc_filters: ??????: 0.00MB + ??????: 0.00MB + ???? MyISAM
wp_blc_instances: ??????: 0.02MB + ??????: 0.01MB + ???? MyISAM
wp_blc_links: ??????: 0.12MB + ??????: 0.03MB + ???? MyISAM
wp_blc_synch: ??????: 0.00MB + ??????: 0.00MB + ???? MyISAM
wp_cartflows_ca_cart_abandonment: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_cartflows_ca_email_history: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_cartflows_ca_email_templates: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_cartflows_ca_email_templates_meta: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_commentmeta: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_comments: ??????: 0.06MB + ??????: 0.09MB + ???? InnoDB
wp_expm_hiiden_content: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_expm_maker: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_expm_maker_pages: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_find_and_replace: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_grp_google_place: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_grp_google_review: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_links: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_options: ??????: 7.14MB + ??????: 0.38MB + ???? InnoDB
wp_postmeta: ??????: 16.53MB + ??????: 8.88MB + ???? InnoDB
wp_posts: ??????: 12.06MB + ??????: 3.03MB + ???? InnoDB
wp_rank_math_404_logs: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_rank_math_analytics_gsc: ??????: 0.00MB + ??????: 0.00MB + ???? MyISAM
wp_rank_math_analytics_objects: ??????: 0.20MB + ??????: 0.11MB + ???? InnoDB
wp_rank_math_internal_links: ??????: 0.41MB + ??????: 0.13MB + ???? InnoDB
wp_rank_math_internal_meta: ??????: 0.05MB + ??????: 0.00MB + ???? InnoDB
wp_rank_math_redirections: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_rank_math_redirections_cache: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_social_users: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_termmeta: ??????: 0.16MB + ??????: 0.14MB + ???? InnoDB
wp_terms: ??????: 0.08MB + ??????: 0.11MB + ???? InnoDB
wp_term_relationships: ??????: 0.23MB + ??????: 0.13MB + ???? InnoDB
wp_term_taxonomy: ??????: 0.14MB + ??????: 0.11MB + ???? InnoDB
wp_usermeta: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_users: ??????: 0.02MB + ??????: 0.05MB + ???? InnoDB
wp_wc_admin_notes: ??????: 0.06MB + ??????: 0.00MB + ???? InnoDB
wp_wc_admin_note_actions: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_wc_category_lookup: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wc_customer_lookup: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_wc_download_log: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_wc_order_coupon_lookup: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_wc_order_product_lookup: ??????: 0.02MB + ??????: 0.06MB + ???? InnoDB
wp_wc_order_stats: ??????: 0.02MB + ??????: 0.05MB + ???? InnoDB
wp_wc_order_tax_lookup: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_wc_product_attributes_lookup: ??????: 1.16MB + ??????: 1.60MB + ???? MyISAM
wp_wc_product_download_directories: ??????: 0.00MB + ??????: 0.01MB + ???? MyISAM
wp_wc_product_meta_lookup: ??????: 0.33MB + ??????: 0.58MB + ???? InnoDB
wp_wc_rate_limits: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_wc_reserved_stock: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wc_tax_rate_classes: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_wc_webhooks: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_wpforms_tasks_meta: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_circles: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_maps: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_nominatim_geocode_cache: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_polygon: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_polylines: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpgmza_rectangles: ??????: 0.02MB + ??????: 0.00MB + ???? InnoDB
wp_wpr_rucss_resources: ??????: 0.00MB + ??????: 0.00MB + ???? MyISAM
wp_wpr_rucss_used_css: ??????: 0.00MB + ??????: 0.00MB + ???? MyISAM
wp_yith_wcwl: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_yith_wcwl_lists: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_yoast_indexable: ??????: 2.52MB + ??????: 0.39MB + ???? InnoDB
wp_yoast_indexable_hierarchy: ??????: 0.06MB + ??????: 0.08MB + ???? InnoDB
wp_yoast_migrations: ??????: 0.02MB + ??????: 0.02MB + ???? InnoDB
wp_yoast_primary_term: ??????: 0.02MB + ??????: 0.03MB + ???? InnoDB
wp_yoast_seo_links: ??????: 0.13MB + ??????: 0.06MB + ???? InnoDB

### Post Type Counts ###

attachment: 2824
blocks: 12
nav_menu_item: 68
oembed_cache: 5
page: 31
product: 833
product_variation: 2384
revision: 122
shop_order: 73
ux_template: 1
wp_global_styles: 1
wpcf7_contact_form: 7
wpforms: 1

### Security ###

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

### Active Plugins (11) ###

Call Now Button: ??? Jerry Rietveld – 1.1.8
???? ??? ??? 7: ??? ??????? ????? – 5.5.6.1
???? ??????: ??? ???? ?????? – 2.0.3
Rank Math SEO: ??? Rank Math – 1.0.90
TinyPNG - JPEG, PNG & WebP image compression: ??? TinyPNG – 3.3
Checkout Field Editor for WooCommerce: ??? ThemeHigh – 1.6.1
?????  - ????? ??????? ????????: ??? ????? ???? – 5.1.3
WooCommerce PayPal Checkout Gateway: ??? WooCommerce – 2.1.3
???????: ??? ???? ???????? – 6.5.1
WP Rocket: ??? WP Media – 3.8.8
Social Chat: ??? QuadLayers – 5.0.3

### Inactive Plugins (3) ###

Advanced WordPress Reset: ??? Younes JFR. – 1.5
Broken Link Checker: ??? WPMU DEV – 1.11.16
Tawk.to Live Chat: ??? Tawkto – 0.7.2

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php

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

installatron_hide_status_test.php: ???  –

### Settings ###

API Enabled: –
Force SSL: –
Currency: ILS (?)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
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: –

### WC Pages ###

???? ????: #55 - /shop/
?? ?????: #54 - /cart/
?????: #53 - /checkout/
?????? ???: #52 - /my-account/
???? ?????: #3 - /privacy-policy/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.15.5
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Action Scheduler ###

Complete: 579
Oldest: 2022-05-15 12:14:57 +0300
Newest: 2022-06-13 09:26:45 +0300

Failed: 3
Oldest: 2021-01-25 19:43:44 +0200
Newest: 2022-04-03 16:47:27 +0300

### Status report information ###

Generated at: 2022-06-13 09:32:49 +03:00

Hi @timmyy21 ,

Thanks for providing the System Status.

As a next step, could you please navigate to WooCommerce > Status > Tools and also delete Orphaned variations and see if that makes a difference?

If not, please could you share a copy of any fatal error logs by navigating to WooCommerce > Status > Logs.

Once you have this you can paste your response here.

Thanks!

Hello,

Failed: 3

To get more context, can you provide us with a screenshot of the failed scheduled actions? They are under WooCommerce> status > scheduled actions You can upload screenshots using https://snipboard.io – please follow the instructions on that page, then paste the URL in this thread.

Thanks.

Hi
Deleting Orphaned variations did not return the variations.
There were no fatal errors in the logs list.
I have attached screenshots of 3 failed scheduled actions

Thanks for the help!

https://snipboard.io/dPqE57.jpg
https://snipboard.io/fRMY4a.jpg
https://snipboard.io/7y1xsg.jpg

Hello,

Thank you for the screenshots. They don’t seem to be related to your current issue.

Can you also confirm if Enable table usage is checked in WooCommerce > Settings > Products > Advanced? If not, please check that, and then try regenerating the product attributes lookup table from WooCommerce > Status > Tools.

Please let us know how it goes.

yes “Enable table usage” is checked.

Hi @timmyy21

Thanks for checking that.

I am aware that you already tried to check for a conflict with plugins or the theme, but we recommend doing the full conflict test properly, just to be thorough. It involves switching to a default WP theme like Twenty Twenty-One or Storefront and deactivating all plugins except for WooCommerce then checking if the issue persists. If it doesn’t, the theme and plugins are reactivated, one by one, checking which one causes the issue to reappear. Here’s the conflict test guide – https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Please make sure that you remove any/all custom code added to the site.

If you’d prefer not to make any changes on your live site then you can create a duplicate/staging site. Many hosting providers offer site staging facilities, but if you don’t have such a feature, you can create one with the WP Staging plugin.

Let us know if the problem still persists or whether the culprit was caught.

yap.
its WP Rocket.
When I just turned off the plugin, with the rest of the plugins, then nothing changed.
But when I turned them all off, and rebuilt the table, and then I checked plugin after plugin what was destroying it, then I realized that was the cause.

I’m still not sure what in the settings of WP ROCKET is causing the problem, and I can not give up the plugin just like that .. I will try to understand it.

Hi @timmyy21 ,

I am glad that you have managed to find the culprit ??

Since WP Rocket is causing the issue, please reach out to the developers of that plugin directly for further help with this:

https://wp-rocket.me/support

Thanks!

Thank you all for your help!
Good Day!