Variations not displaying
-
Hi,
Since a couple of months, I am not sure when it started, variations on many products don’t display in the frontend of my site. There’s no particular reason, no specific categories or type of products, it just seems to happen randomly.
The only way to solve this temporarily is saving the products again one by one, and it’s so time consuming.
I created a Staging copy of my site and disabled all the plugins (WPML included) and enabled default 2021 theme.
Nothing changed, the variations are still not appearing, they are present in the backend though! Here’s a couple of links to screenshots of both frontend and backend:
https://snipboard.io/fa3gCo.jpg
https://snipboard.io/KnvRM1.jpgI really don’t know what to do, anyone have some ideas on how to solve this?
The problem is that this issue is actually live on the site.Thanks
MatteoThe page I need help with: [log in to see the link]
-
Hi @boxwebdesign,
Could you please send us a copy of your site’s System Status? You can find this report by navigation to WooCommerce > Status on your website. Select Get system report and then Copy for support.?
Once you’ve done that, can you then paste the contents of the report into your next response for us?
Image Link: https://cloudup.com/cb44skOom6r
Thanks for your answer.
Here’s the report:### WordPress Environment ### WordPress address (URL): https://staging.fortuny.shop Site address (URL): https://staging.fortuny.shop WC Version: 5.1.0 REST API Version: ? 5.1.0 WC Blocks Version: ? 4.4.3 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 2.0.2 Log Directory Writable: ? WP Version: 5.7 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: ? WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.27 PHP Post Max Size: 64 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.64.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.27-MariaDB-0+deb10u1 Max Upload Size: 64 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.1.0 WC Database Prefix: wp_ Total Database Size: 796.81MB Database Data Size: 583.08MB Database Index Size: 213.73MB wp_woocommerce_sessions: Data: 0.17MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.34MB + Index: 0.13MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 4.52MB + Index: 4.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 32.42MB + Index: 6.80MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 26.05MB + Index: 11.20MB + Engine MyISAM wp_ac_abandoned_cart_history_lite: Data: 2.91MB + Index: 0.06MB + Engine MyISAM wp_ac_email_templates_lite: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_ac_sent_history_lite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 1.52MB + Index: 0.83MB + Engine InnoDB wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_cms_nav_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_languages_translations: Data: 0.20MB + Index: 0.13MB + Engine InnoDB wp_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_mo_files_domains: Data: 0.06MB + Index: 0.03MB + Engine MyISAM wp_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_strings: Data: 5.52MB + Index: 9.97MB + Engine InnoDB wp_icl_string_batches: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_string_pages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_string_positions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_string_translations: Data: 9.52MB + Index: 6.03MB + Engine InnoDB wp_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_translate: Data: 74.59MB + Index: 7.52MB + Engine InnoDB wp_icl_translate_job: Data: 1.52MB + Index: 0.28MB + Engine InnoDB wp_icl_translations: Data: 3.52MB + Index: 11.06MB + Engine InnoDB wp_icl_translation_batches: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_translation_status: Data: 145.56MB + Index: 1.52MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_mailchimp_jobs: Data: 0.06MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 21.39MB + Index: 2.86MB + Engine InnoDB wp_pmxe_exports: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_pmxi_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_postmeta: Data: 161.70MB + Index: 119.38MB + Engine InnoDB wp_posts: Data: 23.55MB + Index: 11.09MB + Engine InnoDB wp_po_plugins: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_redirection_404: Data: 3.99MB + Index: 0.59MB + Engine MyISAM wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_redirection_items: Data: 0.28MB + Index: 0.22MB + Engine MyISAM wp_redirection_logs: Data: 1.43MB + Index: 0.16MB + Engine MyISAM wp_rnoc_abandoned_cart_history: Data: 0.16MB + Index: 0.00MB + Engine InnoDB wp_rnoc_abandoned_email_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rnoc_email_sent_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rnoc_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rnoc_guest_abandoned_cart_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_termmeta: Data: 1.52MB + Index: 0.81MB + Engine InnoDB wp_terms: Data: 1.52MB + Index: 0.69MB + Engine InnoDB wp_term_relationships: Data: 4.52MB + Index: 4.52MB + Engine InnoDB wp_term_taxonomy: Data: 1.52MB + Index: 0.61MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_toolset_associations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_toolset_post_guid_id: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_toolset_relationships: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_toolset_type_sets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 2.52MB + Index: 0.84MB + Engine InnoDB wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wcsc_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.13MB + Index: 0.09MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.22MB + Index: 0.25MB + Engine InnoDB wp_wc_order_stats: Data: 0.14MB + Index: 0.16MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.13MB + Index: 0.14MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 2.52MB + Index: 3.61MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfblockediplog: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfconfig: Data: 0.50MB + Index: 0.00MB + Engine InnoDB wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilemods: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp_wfhits: Data: 0.45MB + Index: 0.25MB + Engine InnoDB wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wflogins: Data: 0.41MB + Index: 0.17MB + Engine InnoDB wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woobe_history: Data: 0.66MB + Index: 0.28MB + Engine MyISAM wp_woobe_history_bulk: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wpmailsmtp_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_yith_wcwl: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_ylc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ylc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ylc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ylc_offline_messages: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 22.34MB + Index: 1.99MB + Engine MyISAM wp_yoast_indexable_hierarchy: Data: 1.23MB + Index: 2.86MB + Engine MyISAM wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_primary_term: Data: 0.41MB + Index: 0.43MB + Engine MyISAM wp_yoast_seo_links: Data: 1.52MB + Index: 0.48MB + Engine InnoDB wp_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_ywrr_email_blocklist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ywrr_email_schedule: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### amp_validated_url: 1 attachment: 19999 blocks: 65 boxzilla-box: 5 customize_changeset: 1 featured_item: 146 flamingo_contact: 40 flamingo_inbound: 30 gfw_report: 1 jetpack_migration: 2 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 nav_menu_item: 811 oembed_cache: 44 page: 445 polylang_mo: 2 popupbuilder: 64 popup_theme: 6 post: 140 product: 5944 product_variation: 8412 rnoc_order_coupon: 4 shop_coupon: 64 shop_order: 1034 shop_order_refund: 53 spucpt: 25 wpcf7_contact_form: 35 wpforms: 2 ylc-macro: 1 ywrac_cart: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ?Error messages should not be shown to visitors. ### Active Plugins (1) ### WooCommerce: by Automattic – 5.1.0 ### Inactive Plugins (51) ### Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.8.8 Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.8 Antispam Bee: by pluginkollektiv – 2.9.4 Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.7.7 BEAR - Bulk Editor and Products Manager: by realmag777 – 2.0.7 Classic Editor: by WordPress Contributors – 1.6 Contact Form 7: by Takayuki Miyoshi – 5.4 Contact Form 7 Multilingual: by OnTheGoSystems – 1.0.2 Cookie and Consent Solution for the GDPR & ePrivacy: by iubenda – 2.4.3 Facebook for WooCommerce: by Facebook – 2.3.5 Hotjar: by Hotjar – 1.0.9 HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 7.52.143 HubSpot for WooCommerce: by MakeWebBetter – 1.0.7 Mailchimp for WooCommerce: by Mailchimp – 2.5.1 Media File Renamer: by Jordy Meow – 5.1.8 Meta Box: by MetaBox.io – 5.3.9 No CAPTCHA reCAPTCHA: by MailOptin Team – 1.3.4 No CAPTCHA reCAPTCHA for WooCommerce: by MailOptin Team – 1.2.6 Popup Builder: by Sygnoos – 3.81 Query Monitor: by John Blackbourn – 3.6.7 ReCaptcha v2 for Contact Form 7: by IQComputing – 1.3.3 Redirection: by John Godley – 5.0.1 Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.13 WC Multiple Email Recipients: by Con Schneider – 1.4.0 WooCommerce Conversion Tracking: by woopt – 1.8.28 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.1 WooCommerce Multilingual: by OnTheGoSystems – 4.11.3 WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.8.3 WooCommerce Sendinblue Newsletter Subscription: by Sendinblue – 2.0.12 WooCommerce Stripe Gateway: by WooCommerce – 5.0.0 WooCommerce Table Rate Shipping Pro: by PluginHive – 3.2.6 WooSidebars: by WooCommerce – 1.4.5 Wordfence Assistant: by Wordfence – 1.0.7 Wordfence Security: by Wordfence – 7.5.2 WordPress Users & WooCommerce Customers Import Export(BASIC): by WebToffee – 2.1.0 WP All Export: by Soflyy – 1.2.7 WP Mail SMTP: by WPForms – 2.7.0 WPML CMS Nav: by OnTheGoSystems – 1.5.5 WPML Media: by OnTheGoSystems – 2.6.4 WPML Multilingual CMS: by OnTheGoSystems – 4.4.10 WPML Sticky Links: by OnTheGoSystems – 1.5.4 WPML String Translation: by OnTheGoSystems – 3.1.8 WPML Translation Management: by OnTheGoSystems – 2.10.6 WP Rocket: by WP Media – 3.8.8 WP Rocket | Deactivate WooCommerce Refresh Cart Fragments Cache: by WP Rocket Support Team – WP Sheet Editor - WooCommerce Products: by WP Sheet Editor – 1.7.2 YITH WooCommerce Brands Add-on: by YITH – 1.4.2 YITH WooCommerce Wishlist: by YITH – 3.0.20 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.1.2 Yoast SEO: by Team Yoast – 16.1.1 Yoast SEO Multilingual: by OnTheGoSystems – 1.3.0 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php ### Settings ### API Enabled: ? Force SSL: – Currency: EUR (€) Currency Position: right 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) outofstock (outofstock-en_in) outofstock (outofstock-en_us) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ? ### WC Pages ### Shop base: #62 - /shop/ Cart: #61 - /cart/ Checkout: #60 - /checkout/ My account: #59 - /my-account/ Terms and conditions: #3975 - /terms-and-conditions/ ### Theme ### Name: Twenty Twenty-One Version: 1.2 Author URL: https://www.ads-software.com/ Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Canceled: 46 Oldest: 2021-03-08 12:14:46 +0100 Newest: 2021-04-06 12:40:50 +0200 Complete: 23,826 Oldest: 2021-03-12 11:07:13 +0100 Newest: 2021-04-07 17:43:42 +0200 Failed: 66,996 Oldest: 2019-06-25 12:33:15 +0200 Newest: 2021-04-07 10:09:33 +0200 Pending: 4 Oldest: 2021-04-07 17:58:42 +0200 Newest: 2021-04-12 18:17:39 +0200 ### Status report information ### Generated at: 2021-04-07 17:44:38 +02:00
Hey @boxwebdesign,
Looking at the system report I can see you’re using the latest version of WooCommerce v5.1.0 and the database version matches the WooCommerce versions etc.
Looking at the plugins which are installed there is nothing that immediately stands out which I could say for sure that could be the potential cause of this type of behaviour either.
When you say the behaviour happens randomly have you noticed it re-occurring on a product where you fixed the issue previously by saving/updating the product?
Yes it happened for sure in products that already were updated once to solve this same problem, but also to products that did not present the issue before.
I tried increasing the PHP time limit and PHP max input vars but the problem is still there.-
This reply was modified 3 years, 11 months ago by
Matt.
Any news on this? Woocommerce Email support is not helping at all!! This problem keeps happening over and over, variations are not displaying on the front end even though I resaved the products that had issues a couple of days ago. We are loosing sales due to this stupid issue, any idea? Any help from Woocommerce???
Hey @boxwebdesign,
That is strange and not behaviour which I can personally replicate on my test installations for us.
How many variations do the product have where you’re seeing this behaviour occur?
On the staging site you’re using if you deactivate all other plugins and leave only WooCommerce and the Storefront theme activated do you still see the behaviour happening on the products?
Hey?@boxwebdesign,
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can reopen it again if you need be.
-
This reply was modified 3 years, 11 months ago by
- The topic ‘Variations not displaying’ is closed to new replies.