Variable products aren’t sorting correctly
-
I have many products on my site and can’t get sorting to work correctly with price.
All of the items in my store at present are variable products.
I have read dozens of other people posting about this and have tried everything I found suggested. I have tried all of these which didn’t work:
* Deactivating all plugins and switching to the Storefront theme
* Regenerating lookup tables
* Manually updating the quantity/price of each item to get the system to recognize/update itThis happens on the overall store and on category pages. It’s not just sorting by the first number or string-sorting which was one other issue I found on another thread.
Any help would be most appreciated!
The page I need help with: [log in to see the link]
-
For reference, the system status report:
(Please note the root of the site is not currently visible because the site isn’t launched, but the category page above is visible)### WordPress Environment ### WordPress address (URL): https://swccgcards.com Site address (URL): https://swccgcards.com WC Version: 6.1.1 REST API Version: ? 6.1.1 WC Blocks Version: ? 6.5.2 Action Scheduler Version: ? 3.4.0 WC Admin Version: ? 3.0.3 Log Directory Writable: ? WP Version: 5.9 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.0.13 PHP Post Max Size: 32 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.6.51-cll-lve Max Upload Size: 32 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.1.1 WC Database Prefix: wp_ Total Database Size: 365.11MB Database Data Size: 268.81MB Database Index Size: 96.30MB wp_woocommerce_sessions: Data: 0.08MB + 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.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.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: 6.02MB + Index: 9.81MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 5.52MB + Index: 5.02MB + Engine InnoDB wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_braapf_product_stock_status_parent: Data: 1.52MB + Index: 0.23MB + Engine InnoDB wp_braapf_product_variation_attributes: Data: 1.52MB + Index: 1.13MB + Engine InnoDB wp_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_braapf_variable_attributes: Data: 0.25MB + Index: 0.34MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletters: Data: 0.03MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 9.05MB + Index: 2.11MB + Engine InnoDB wp_pcpro_html_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pcpro_latestwooprices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pcpro_scraperconfig: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pcpro_scrape_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pcpro_scrape_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pcpro_urls: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_pcpro_verbose_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 193.59MB + Index: 54.45MB + Engine InnoDB wp_posts: Data: 20.45MB + Index: 10.58MB + Engine InnoDB wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 10.50MB + Index: 7.48MB + Engine InnoDB wp_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.06MB + 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.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 13.52MB + Index: 0.00MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 2.47MB + Index: 2.84MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB 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_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### attachment: 44961 blocks: 9 br_filters_group: 1 br_product_filter: 31 custom_css: 1 customize_changeset: 17 elementor_library: 1 featured_item: 8 mailpoet_page: 1 nav_menu_item: 38 page: 82 post: 11 product: 4719 product_variation: 8939 revision: 96 shop_order: 4 shop_order_refund: 2 wp_global_styles: 1 wpcf7_contact_form: 5 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (21) ### CoBlocks: by GoDaddy – 2.21.5 Code Snippets: by Code Snippets Pro – 2.14.3 Contact Form 7: by Takayuki Miyoshi – 5.5.4 Custom Fonts: by Brainstorm Force – 1.3.3 Elementor: by Elementor.com – 3.5.3 Excel-Like Product Manager for WooCommerce and WP E-commerce: by Holest Engineering – 2.1.87 Jetpack: by Automattic – 10.5 Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.23.2 MailPoet 3 (New): by MailPoet – 3.78.0 Nextend Social Login: by Nextendweb – 3.1.3 Price Comparison Pro: by Dave Hilditch – 3.75 Regenerate product lookup table for WooCommerce: by Suman Bhattarai – 1.0.1 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 2.22.1.25 Woocommerce Variations Table - Grid: by Spyros Vlachopoulos – 1.4.9 WooCommerce AJAX Products Filter: by BeRocket – 3.1.1.3 WooCommerce Payments: by Automattic – 3.6.0 (update to version 3.7.0 is available) WooCommerce PayPal Payments: by WooCommerce – 1.6.4 (update to version 1.6.5 is available) WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.46 WooCommerce Shipping & Tax: by WooCommerce – 1.25.20 (update to version 1.25.23 is available) WooCommerce: by Automattic – 6.1.1 (update to version 6.2.0 is available) YITH WooCommerce Wishlist: by YITH – 3.5.0 ### Inactive Plugins (4) ### Cards Price Comparison 1.0 (alpha): by – 1.0 alpha Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 WooCommerce Better Variations: by Plugin Republic – 1.2.3 WooCommerce Product Table: by Barn2 Plugins – 2.9.3 ### Must Use Plugins (1) ### WordPress automation by Installatron: by – ### Settings ### API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) Taxonomies: Product Visibility: exclude_from_catalog (exclude_from_catalog) exclude_from_search (exclude_from_search) 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: ? ### WC Pages ### Shop base: #120 - /shop/ Cart: #119 - /cart/ Checkout: #78472 - /checkout/ My account: #78471 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Flatsome Child Version: 3.0 Author URL: Child Theme: ? Parent Theme Name: Flatsome Parent Theme Version: 3.15.2 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 ### Subscriptions ### WCS_DEBUG: ? No Subscriptions Mode: ? Live Subscriptions Live URL: https://swccgcards.com Subscription Statuses: – WooCommerce Account Connected: ? Yes Active Product Key: ? No ### Store Setup ### Country / State: United States (US) — Indiana ### Payment Gateway Support ### PayPal: refunds ### WooCommerce PayPal Payments ### Onboarded: ? Shop country code: US WooCommerce currency supported: ? PayPal card processing available in country: ? Pay Later messaging available in country: ? Webhook status: ? Vault enabled: ? Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – ### WooCommerce Payments ### Version: 3.6.0 Connected to WPCOM: Yes Blog ID: 201173780 Account ID: - ### Action Scheduler ### Canceled: 8 Oldest: 2022-01-20 01:24:43 -0600 Newest: 2022-02-07 19:48:05 -0600 Complete: 21,661 Oldest: 2022-01-17 11:46:18 -0600 Newest: 2022-02-15 15:08:26 -0600 Pending: 1 Oldest: 2022-02-15 17:08:26 -0600 Newest: 2022-02-15 17:08:26 -0600 ### Status report information ### Generated at: 2022-02-15 15:32:59 -06:00
Hi @e22pii,
Thanks for sharing your system status.
There is an update to version 3.15.3 for your Flatsome theme that could help fix the issue. You can see the theme’s changelog:
Oftentimes, clearing the cache also helps. This article walks you through how to effectively clear WordPress cache:
Thanks Mirko, I appreciate your support! Terseness here does not indicate a negative tone; I very much appreciate the help.
I just updated the theme to the latest version, and this did not help. This is not altogether surprising since the same issue appeared on the Storefront theme, unfortunately.
That cache-clearing link talks about many different kinds of caches. I didn’t previously have any caching plugins installed. I tried from other browsers/devices to make sure it wasn’t a client cache. I tried deleting every cache in the Status page (even unrelated ones like analytics cache). This did not help.
I tried installing the caching plugin recommended most highly on that link, WP Super Cache. I then deleted the cache (though presumably it was empty since I hadn’t installed it before). It didn’t seem to do anything. I installed the Breeze plugin, another one recommended on the link, and cleared it as well. It didn’t help.
Are there any other suggestions for how to get this to work?
Hello,
To better understand the context of this issue, you can provide the following:
Error Log: Share a copy of any fatal error log found under
WooCommerce > System Status > Logs
(if available).Let us know thanks.
Interesting, thanks! I don’t see anything obviously related when I load the site, but there are a number of these going back in time.
Every day seems to have one of these:
`2022-02-14T23:18:42+00:00 CRITICAL Uncaught Error: Undefined constant “WP_ENVIRONMENT_TYPE” in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Schedulers/MailchimpScheduler.php:90
Stack trace:
#0 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Schedulers/MailchimpScheduler.php(90): constant()
#1 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Schedulers/MailchimpScheduler.php(58): Automattic\WooCommerce\Admin\Schedulers\MailchimpScheduler->make_request()
#2 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Events.php(113): Automattic\WooCommerce\Admin\Schedulers\MailchimpScheduler->run()
#3 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(307): Automattic\WooCommerce\Admin\Events->do_wc_admin_daily()
#4 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#5 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/plugin.php(522): WP_Hook->do_action()
#6 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-cron.php(138): do_action_ref_array()
#7 {main}
thrown in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Schedulers/MailchimpScheduler.php on line 90`I’m guessing this was from trying to regenerate the lookup tables, images, etc. all at once a few days ago hoping that’d help:
`2022-02-13T17:52:19+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 8388616 bytes) in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/wp-db.php on line 2129
2022-02-13T18:10:40+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-term.php on line 198
2022-02-13T18:30:55+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 8388616 bytes) in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/wp-db.php on line 2129
2022-02-13T18:45:49+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-term.php on line 198`
I have a few of these back on 2/7:
`2022-02-07T19:47:08+00:00 CRITICAL Uncaught InvalidArgumentException: Unidentified action 24502 in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:451
Stack trace:
#0 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(120): ActionScheduler_DBStore->cancel_action()
#1 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/class-wc-payments-action-scheduler-service.php(128): as_unschedule_action()
#2 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/class-wc-payments-account.php(1119): WC_Payments_Action_Scheduler_Service->schedule_job()
#3 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/class-wc-payments-account.php(836): WC_Payments_Account->schedule_account_cache_refresh()
#4 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/class-wc-payments-account.php(804): WC_Payments_Account->cache_account()
#5 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/migrations/class-update-service-data-from-server.php(42): WC_Payments_Account->get_cached_account_data()
#6 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(303): WCPay\Migrations\Update_Service_Data_From_Server->maybe_migrate()
#7 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters()
#8 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/plugin.php(470): WP_Hook->do_action()
#9 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce-payments/includes/class-wc-payments.php(697): do_action()
#10 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(303): WC_Payments::install_actions()
#11 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters()
#12 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-includes/plugin.php(470): WP_Hook->do_action()
#13 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-settings.php(578): do_action()
#14 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-config.php(105): require_once(‘/home/urxej9ec6…’)
#15 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-load.php(50): require_once(‘/home/urxej9ec6…’)
#16 /home/urxej9ec6uj7/public_html/swccgcards.com/wp-blog-header.php(13): require_once(‘/home/urxej9ec6…’)
#17 /home/urxej9ec6uj7/public_html/swccgcards.com/index.php(17): require(‘/home/urxej9ec6…’)
#18 {main}
thrown in /home/urxej9ec6uj7/public_html/swccgcards.com/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 451`That’s all i see going back to the beginning of February. Would going back longer help?
I appreciate the level of support you’re providing. While I indicated I’d already disabled all the plugins and themes I was not doing it again because it can be a lot of work to get everything working again, but since you’ve really been digging into this I’d like to remove other possible issues that could interact with the solutions you’re providing. So I’ve now again disabled all the plugins (except WooCommerce) and set my theme to Storefront. And some things needed updated since I started debugging this, including WooCommerce, so I did that as well.
Again, this particular site is a good one to see the price sort not working (front page is blocked by an index.htm saying “Coming Soon” taking precedence over index.php):
https://swccgcards.com/product-category/singles/singles-japanese/singles-japanese-hoth/?orderby=price-descSince I just changed the theme/plugins, I’m also including a new system report in case it’s helpful.
`
### WordPress Environment ###WordPress address (URL): https://swccgcards.com
Site address (URL): https://swccgcards.com
WC Version: 6.2.0
REST API Version: ? 6.2.0
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –### Server Environment ###
Server Info: Apache
PHP Version: 8.0.13
PHP Post Max Size: 32 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1dSUHOSIN Installed: –
MySQL Version: 5.6.51-cll-lve
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?### Database ###
WC Database Version: 6.2.0
WC Database Prefix: wp_
Total Database Size: 368.25MB
Database Data Size: 271.78MB
Database Index Size: 96.47MB
wp_woocommerce_sessions: Data: 0.05MB + 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.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.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: 6.02MB + Index: 9.81MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 5.52MB + Index: 5.02MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_braapf_product_stock_status_parent: Data: 1.52MB + Index: 0.23MB + Engine InnoDB
wp_braapf_product_variation_attributes: Data: 1.52MB + Index: 1.13MB + Engine InnoDB
wp_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_braapf_variable_attributes: Data: 0.25MB + Index: 0.34MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletters: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 12.05MB + Index: 2.28MB + Engine InnoDB
wp_pcpro_html_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pcpro_latestwooprices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pcpro_scraperconfig: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pcpro_scrape_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pcpro_scrape_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pcpro_urls: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pcpro_verbose_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 193.59MB + Index: 54.45MB + Engine InnoDB
wp_posts: Data: 20.45MB + Index: 10.58MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 10.50MB + Index: 7.48MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + 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.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 13.52MB + Index: 0.00MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 2.47MB + Index: 2.84MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
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_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB### Post Type Counts ###
attachment: 44960
blocks: 9
br_filters_group: 1
br_product_filter: 31
custom_css: 1
customize_changeset: 17
elementor_library: 1
featured_item: 8
mailpoet_page: 1
nav_menu_item: 38
page: 82
post: 11
product: 4719
product_variation: 8939
revision: 96
shop_order: 4
shop_order_refund: 2
wp_global_styles: 1
wpcf7_contact_form: 5### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?### Active Plugins (1) ###
WooCommerce: by Automattic – 6.2.0
### Inactive Plugins (24) ###
Cards Price Comparison 1.0 (alpha): by – 1.0 alpha
CoBlocks: by GoDaddy – 2.21.6
Code Snippets: by Code Snippets Pro – 2.14.3
Contact Form 7: by Takayuki Miyoshi – 5.5.5
Custom Fonts: by Brainstorm Force – 1.3.4
Elementor: by Elementor.com – 3.5.5
Excel-Like Product Manager for WooCommerce and WP E-commerce: by Holest Engineering – 2.1.87
Jetpack: by Automattic – 10.6
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.23.2
MailPoet 3 (New): by MailPoet – 3.81.0
Nextend Social Login: by Nextendweb – 3.1.4
Price Comparison Pro: by Dave Hilditch – 3.75
Regenerate product lookup table for WooCommerce: by Suman Bhattarai – 1.0.1
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
UpdraftPlus – Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.22.1.25WooCommerce AJAX Products Filter: by BeRocket – 3.1.1.3
WooCommerce Better Variations: by Plugin Republic – 1.2.3
WooCommerce Payments: by Automattic – 3.7.0
WooCommerce PayPal Payments: by WooCommerce – 1.6.5
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.46
WooCommerce Product Table: by Barn2 Plugins – 2.9.3
WooCommerce Shipping & Tax: by WooCommerce – 1.25.23
Woocommerce Variations Table – Grid: by Spyros Vlachopoulos – 1.4.9
YITH WooCommerce Wishlist: by YITH – 3.6.0### Must Use Plugins (1) ###
WordPress automation by Installatron: by –
### Settings ###
API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)Taxonomies: Product Visibility: exclude_from_catalog (exclude_from_catalog)
exclude_from_search (exclude_from_search)
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: ?
### WC Pages ###
Shop base: #120 – /shop/
Cart: #119 – /cart/
Checkout: #78472 – /checkout/
My account: #78471 – /my-account/
Terms and conditions: ? Page not set### Theme ###
Name: Storefront
Version: 3.9.1
Author URL: https://woocommerce.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: 8
Oldest: 2022-01-20 01:24:43 -0600
Newest: 2022-02-07 19:48:05 -0600Complete: 21,698
Oldest: 2022-01-17 11:46:18 -0600
Newest: 2022-02-17 10:33:03 -0600Pending: 1
Oldest: 2022-02-17 11:06:17 -0600
Newest: 2022-02-17 11:06:17 -0600### Status report information ###
Generated at: 2022-02-17 10:50:24 -06:00
`Hi @e22pii,
Thanks for sending over this additional information.
At this point, it could be something related to your hosting environment. Have you tried to duplicate your site and migrate it to another hosting service? There are also free hosts which are ideal to perform tests.
You can create a staging site cloning your current site with the WP Staging plugin.
With your current hosting (GoDaddy) you could try to increase the
WP Memory Limit
to at least 512 MB as there is an error in your logs about memory exhaustion, raise thePHP Max Input Vars
value to at least 5000 and also lower the PHP Version to 7.4.Also, ask your host if any server-side caching is enabled and let them disable it. Any must-use plugins like
WordPress automation by Installatron
should also be disabled by your host.Before doing this with the help of your host support team please make a full backup of your site and database using the UpdraftPlus that you have installed.
Let us know how it goes.
I updated the settings for WP Memory Limit and PHP Max Input Vars, though I was having this sorting issue repeatedly throughout the day and the respective errors that correspond to those suggestions hadn’t occurred for many days. It also did not change anything on the site. So, I don’t think those are it.
It took a long time for me to get back to you because I used WP Staging to create a clone of the site on a subfolder. This took over a day to copy. Unfortunately, it has the same issue:
https://swccgcards.com/swccg-cards/?product_cat=singles-japanese-hoth&orderby=price-desc&product_cat=singles-japanese-hothIt appears to produce the same incorrect ordering as the parent site:
https://swccgcards.com/product-category/singles/singles-japanese/singles-japanese-hoth/?orderby=price-desc
(I haven’t checked all the way to the bottom but many rows appear the same)I could not find a free hosting provider that I could copy the site to automatically that supports the massive number of products / files I have on mine (10s of thousands of products, including variations, and hundreds of gigabytes of images).
I am not using Managed WordPress on GoDaddy, but rather their standard linux server hosting. I have WordPress installed on top of that using Installatron. So, their standard Flush plugin thing doesn’t apply on my site since it’s not in their managed hosting environment. I cannot be sure there’s no caching somewhere, but I have searched around in cpanel and don’t see anything relevant to disable. I have their Optimize feature disabled in case that could include caching (was already true before making this thread). I don’t see anything else that looks even vaguely like it might be caching on the server, but I can login to the command line or ssh in and run commands if there’s anything I can do there.
When I search for these issues on Godaddy’s forums I only find issues related to their managed wordpress hosting. Their support does not seem to know about any related issues on their end.
Do you have any more suggestions on what to try?
Hello,
Thanks for performing the additional checks.
Please contact us at WooCommerce.com > My Account > Support.
You may need to create an account before you can access that page. Please include a link to this forum thread, so that we can keep track of what’s already been done.
We will be able to help you further there.
Thanks, I have submitted the support request. They do not appear to be actually reading this thread to see what has been done as they’re suggesting the same things, but at least it’s a helpful place for me to reference to demonstrate I’ve tried that. ??
Hello,
I have submitted the support request.
Thank you. Our team is aware and will reach out to you as soon as they can.
I’m going to mark this thread as closed. If you have any further questions, I recommend creating a new thread.
- The topic ‘Variable products aren’t sorting correctly’ is closed to new replies.