• Resolved e22pii

    (@e22pii)


    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 it

    This 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]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter e22pii

    (@e22pii)

    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
    
    Mirko P.

    (@rainfallnixfig)

    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:

    https://themeforest.net/item/flatsome-multipurpose-responsive-woocommerce-theme/5484319#item-description__change-log

    Oftentimes, clearing the cache also helps. This article walks you through how to effectively clear WordPress cache:

    https://learnwoo.com/wordpress-cache/

    Thread Starter e22pii

    (@e22pii)

    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.

    Thread Starter e22pii

    (@e22pii)

    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-desc

    Since 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.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.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.25

    WooCommerce 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 -0600

    Complete: 21,698
    Oldest: 2022-01-17 11:46:18 -0600
    Newest: 2022-02-17 10:33:03 -0600

    Pending: 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
    `

    Mirko P.

    (@rainfallnixfig)

    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 the PHP 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.

    Thread Starter e22pii

    (@e22pii)

    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-hoth

    It 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?

    Plugin Support Paulo P – a11n

    (@paulostp)

    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.

    Thread Starter e22pii

    (@e22pii)

    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.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Variable products aren’t sorting correctly’ is closed to new replies.