e22pii

Forum Replies Created

Viewing 11 replies - 1 through 11 (of 11 total)
  • 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. ??

    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?

    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
    `

    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?

    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
    Thread Starter e22pii

    (@e22pii)

    Here, I think I have a way of demonstrating this bug without relying on my theme’s interface. Here I record a screencast video of looking at my Products list, where the (parent) products show Out of Stock. Then I bulk edit and Update without changing anything, and when it reloads they are all In Stock.

    I assume it isn’t desirable behavior that doing an Update without changing anything would change something, right? That couldn’t plausibly the the theme doing it I should think.

    [video src="https://swccgcards.com/wp-content/uploads/2022/01/variation_stock_bug.webm" /]

    Thread Starter e22pii

    (@e22pii)

    I would not call the issue fixed. It doesn’t make sense to me that after importing thousands of items to the store in bulk, I need to do a bunch of clear/regenerate and then go through in batches of 100 or so items and edit/”update” each item without actually changing anything for it to work.

    Maybe the best way to describe it would be an apparent bug with a mildly painful workaround.

    If the default themes don’t show stock status on the product category pages, maybe that’s why this bug hasn’t been identified and fixed?

    Thread Starter e22pii

    (@e22pii)

    Note to anyone else encountering this problem who is frustrated because the bulk edit doesn’t work for them, but for whom that might be an acceptable solution if it worked:

    I just uploaded a large new batch of items to my site since at least there’s some feasible solution without updating every single item…still probably half a day of clicking, but at least I know it’s solvable. Well, the bulk edit didn’t work on the new uploads. I think it works because of some of the other troubleshooting steps I did. So, I repeated running all the tools on WooCommerce->Status->Tools(Tab) that seemed to clear/regenerate product info that could be relevant:
    clearing both transients at the top
    delete orphaned products
    regenerate product lookup tables
    recount terms

    I don’t know which of those did it, but after doing those the bulk edit works again. I think my products table also only included like 20 items or something small, so I switched it to 100 using Screen Options on the Products page. I found if I did a much larger set it would produce an error when I went to submit the change, but this was a good balance for me (it does slow each edit / page load down to have a larger number there, but saving 4 cycles helps a lot)

    Thread Starter e22pii

    (@e22pii)

    I tried using Storefront. Indeed there were no Out of Stock messages on the category pages there, but in the demo for that theme I don’t see any Out of Stock messages on the category page so I’m not sure if that functionality is being tested properly with this theme.

    Here is my site’s system status. Please note I’ve re-enabled all my plugins and such since disabling it didn’t affect the issue.

    `
    ### WordPress Environment ###

    WordPress address (URL): https://swccgcards.com
    Site address (URL): https://swccgcards.com
    WC Version: 6.1.0
    REST API Version: ? 6.1.0
    WC Blocks Version: ? 6.5.1
    Action Scheduler Version: ? 3.4.0
    WC Admin Version: ? 3.0.3
    Log Directory Writable: ?
    WP Version: 5.8.3
    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.0
    WC Database Prefix: wp_
    Total Database Size: 241.88MB
    Database Data Size: 167.66MB
    Database Index Size: 74.22MB
    wp_woocommerce_sessions: Data: 0.02MB + 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: 3.52MB + Index: 3.91MB + 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: 2.52MB + Index: 3.03MB + Engine InnoDB
    wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_braapf_product_stock_status_parent: Data: 0.17MB + Index: 0.11MB + Engine InnoDB
    wp_braapf_product_variation_attributes: Data: 0.17MB + Index: 0.38MB + Engine InnoDB
    wp_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_braapf_variable_attributes: Data: 0.09MB + Index: 0.16MB + 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.02MB + 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: 19.05MB + Index: 7.05MB + Engine InnoDB
    wp_postmeta: Data: 115.45MB + Index: 45.34MB + Engine InnoDB
    wp_posts: Data: 17.52MB + Index: 7.59MB + 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.06MB + Index: 0.06MB + Engine InnoDB
    wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 3.50MB + Index: 3.50MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + 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_meta_lookup: Data: 1.52MB + Index: 1.03MB + 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: 30907
    blocks: 8
    br_filters_group: 1
    br_product_filter: 29
    custom_css: 1
    customize_changeset: 26
    elementor_library: 1
    featured_item: 8
    mailpoet_page: 1
    nav_menu_item: 48
    page: 83
    post: 11
    product: 1368
    product_variation: 2234
    revision: 89
    wpcf7_contact_form: 5

    ### Security ###

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

    ### Active Plugins (15) ###

    CoBlocks: by GoDaddy – 2.19.1
    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
    Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.23.2
    MailPoet 3 (New): by MailPoet – 3.77.0
    Nextend Social Login: by Nextendweb – 3.1.3
    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 PayPal Payments: by WooCommerce – 1.6.4
    WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.46
    WooCommerce: by Automattic – 6.1.0 (update to version 6.1.1 is available)

    ### Inactive Plugins (4) ###

    Jetpack: by Automattic – 10.5
    WooCommerce Payments: by Automattic – 3.6.0
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
    YITH WooCommerce Wishlist: by YITH – 3.5.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: ? Page visibility should be public
    My account: ? Page visibility should be public
    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

    ### 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: –

    ### Action Scheduler ###

    Canceled: 9
    Oldest: 2021-12-28 21:02:53 -0600
    Newest: 2022-01-20 01:24:43 -0600

    Complete: 12,045
    Oldest: 2022-01-01 20:39:38 -0600
    Newest: 2022-01-21 09:13:26 -0600

    ### Status report information ###

    Generated at: 2022-01-21 09:17:32 -06:00
    `

    Thread Starter e22pii

    (@e22pii)

    Interestingly, I manually changed the stock of this item, so that some are in-stock and others out, and it now doesn’t show the Out of Stock:

    https://swccgcards.com/product/anh-bb-ds-advosze/
    …which is the 2nd item on this category page:
    https://swccgcards.com/product-category/singles/singles-limited/singles-limited-anh/

    I then went to this item, clicked Edit Product, and then saved it without changing anything, and it started working correctly:
    https://swccgcards.com/product/anh-bb-ls-chewbacca/

    I have thousands of items to import, which is why I’m using the csv importer, so it’s not feasible to go save each one individually.

    If I go to products and update 100 at a time (bulk edit), and make no changes but press Update, it also removes the Out of Stock error. That may be feasible though it’s a lot of work. Do you know what’s going on here and/or have better suggestions? Should I expect this issue to return later?

    Thread Starter e22pii

    (@e22pii)

    I contacted support and after several back-and-forths, including sharing the CSVs I was using to import, they have determined it’s not an issue with the import plugin.

    I even uploaded their demo variable product with children (a “Tea Shirt”) and that had the same issue. I disabled all plugins except WooCommerce and that didn’t fix it.

    I’ve deleted and re-imported a set of items for testing purposes and they are all showing this issue:
    https://swccgcards.com/product-category/singles/singles-limited/singles-limited-anh/

    These items show as out of stock even though some of the variable items underneath have stock.

Viewing 11 replies - 1 through 11 (of 11 total)