• Resolved Guy Chapman

    (@guychapman)


    Several WooCommerce page loading issues

    Page load times in WooCommerce Admin are generally a minimum of 30 seconds and sometimes fail to load.

    I have taken numerous usual steps to identify the root cause that I can explain as required.

    The initial issue that caused me to begin troubleshooting, is that Elementor page builder is slow to load a page when opened for editing, or more often, fails to load completely. On occasions this causes the whole site to become unresponsive for a few minutes before returning. When this happens, an increase in memory use is observed (on the recently upgraded infrastructure).

    After various attempts to identify the cause, I noticed the Elementor issue is significantly worse when WooCommerce is enabled. That is, without Woo, the page loads slowly (eg 30 seconds), with Woo it usually fails (eg page load of 90 seconds or greater or failure to load at all).

    This lead me to further review WooCommerce and related plugins (Payments, Shipping, Square) where the following issues have been observed.

    Theme in use is ‘Bridge’ by Qode Interactive – and yes, I can reproduce the error on twenty twenty-three. I’ve also checked in with them first to make sure there’s nothing obvious from a Theme point of view. They have cart.php page to update soon but say that will not be related to this issue. Issues can also be reproduced on a clean install of WP and minimal suite of plugins.

    I realise there may be some other underlying root cause for the slow performance, and that the various issues mentioned may be unrelated, but I’m starting here with WooCommerce as there are several broken items and the performance is significantly worse with it enabled.

    WooCommerce related issues

    Menu item: WooCommerce / Home
    “There was an error getting your inbox. Please try again.”
    Of course, trying again yields the same result

    Menu item: Customers
    Long page load time around 60-90 seconds, customer table outline renders then page fails with error “There was an error getting your stats. Please try again.”

    Menu item: Payments, Payments Tab, WooPayments, Manage
    Error briefly pops up in black box at lower left of screen
    “Error retrieving settings”
    Page renders but no settings are populated. Re-populating and saving them does not fix the error

    Menu item: Payments, Overview
    Page sometimes does not render or slowly renders with these errors
    Errors briefly pops up in black box at lower left of screen
    “Error retrieving all deposits overviews”
    “Error retrieving all deposits”

    Menu item: Analytics
    All charts fail with error
    “There was an error getting your stats. Please try again.”

    I’ve have a status report available and can load that up if required

    WP version 6.3
    PHP Version 8.1.19

    • This topic was modified 1 year, 3 months ago by Guy Chapman.
Viewing 15 replies - 16 through 30 (of 44 total)
  • Thread Starter Guy Chapman

    (@guychapman)

    Just to be sure, I double-checked with my host to see if they could identify a reason for the 503s at their end…

    I do not see any account-related problems that could be causing this. No connections to external hosts are being blocked from our end and the resource limits for your VPS have not been reached.

    Plugin Support Saravanan S, a11n

    (@simplysaru)

    Hi @guychapman,

    Could you please download an exact clone of your site to a local host (perhaps using a XAMP/MAMP /Local) and check if you are running into the same issues?

    Do keep us posted on how this works out?

    Thread Starter Guy Chapman

    (@guychapman)

    Hi @simplysaru,

    Thanks for picking this up.

    I’ve got some local instances running, of sorts, using Local. It’s a bit complex to get a good replica of prod running locally so I started with a vanilla local, added WooCommerce and have no json errors in the console there when loading Woo pages (other than a jetpack connection error and the usual warning that Woo is loading a lot of unused css cruft).

    Then I moved on to getting copy of my hosted test site running locally that has the the Theme, Elementor and Woo… all good there too, no errors.

    Next a bit of a hack job to get a production copy sort of working locally, but well enough to load Admin pages and see there are no errors when loading Woo pages

    I could burn a bunch more time getting these working better and looking more like the live version but perhaps this is enough to get you the info you are after?

    Cheers,
    Guy

    Thread Starter Guy Chapman

    (@guychapman)

    Hi?@simplysaru,

    Ignore that previous comment, I tried to edit it but just missed the window. I’ve got a better replica of production running locally now via Local and the WooCommerce errors are all still visible (my previous attempt wasn’t configured correctly).

    Cheers
    Guy

    Thread Starter Guy Chapman

    (@guychapman)

    Just a side note, while reviewing those console errors, I noticed these 30 or so warning coming up on every page…

    https://snipboard.io/hSiYs9.jpg

    Turns out they are generated by the WooCommerce Mini Cart Widget that was in the header. Removing that stopped those errors (I’ve replaced it with the plugin WP Menu Cart for now).

    I’ve also added the plugin Disable Cart Fragments as well in an attempt to reduce the impact of WooCommerce on every page load.

    Incremental improvement but not fixing the initial issues yet.

    Plugin Support Saravanan S, a11n

    (@simplysaru)

    Hi @guychapman
    Thanks for cloning it to the local environment and debugging further.

    It’s really odd that the WooCommerce mini cart widget that loads on the front end is complicating a page on the admin side of things.

    Could you please test the local copy of the WooCommerce store with all the extensions disabled (except WooCommerce) and share any relevant JS errors you see in the console for these admin pages?

    We look forward to your screenshots at your earliest.

    Thread Starter Guy Chapman

    (@guychapman)

    Hi @simplysaru,

    Apologies, I was unclear in that last comment, the Mini Cart warnings are indeed all in the front end, not admin. It was just an observation about another Woo-related component that seemed to be generating junk. More of a rant than a root cause for this issue.

    In the Admin area, when loading the WooCommerce home page, after initially getting the same console errors as production in local, they have now gone, which is good right, but I’m not sure why.

    These are the only two items showing, one a warning, the other some jetpack remnant.

    [Warning] position prop in wp.components.Dropdown is deprecated since version 6.2. Please use popoverProps.placement prop instead. Note: Note that the position prop will override any values passed through the popoverProps.placement prop. (deprecated.min.js, line 2)
    [Error] Failed to load resource: the server responded with a status of 403 () (data, line 0)
    https://guychapman-prd-local2.local/wp-json/jetpack/v4/connection/data?_locale=user

    I have been doing everything I can to make the local instance as close to the production one, not all settings are possible to get identical but it’s close. I had been making sure the php settings in local matched production but putting them back to vanilla on local didn’t cause the errors to return.

    Those two errors appear with all plugins enabled or with only WooCommerce enabled.

    Cheers,
    Guy

    • This reply was modified 1 year, 2 months ago by Guy Chapman.
    Plugin Support Sean O))) a11n

    (@seanomattic)

    Hi @guychapman,

    Thanks for the update! As an experiment, in conflict testing conditions (only WooCommerce extensions active and a default theme), please observe the speed of the admin/public facing site by clicking through a few pages.

    If you notice it’s still sluggish, please check your recent logs for any relevant fatal errors. WooCommerce > Settings > Status > Logs.

    It may also be helpful to see a System Status Report.
    You’ll find it at the top of the page under WooCommerce > Status > Get system report > Download for support (after you scroll down a bit).

    Thanks!

    Thread Starter Guy Chapman

    (@guychapman)

    Hi @seanomattic,

    I took the conflict testing idea to the extreme and created a clean install of WP 6.3.1 with a fresh database on my VPS host (same as production but no load coming from prod currently). I left the default theme Twenty Twenty-Three as is. Set Australian location and time. Deleted the preinstalled plugins ‘Hello Dolly’ (wtf?) and Akismet.

    Did some clicking around and can see no errors via the browser console. All good so far.

    Installed WooCommerce and immediately on the Welcome to Woo! page (which always fails on any installation) got a couple of errors. https://snipboard.io/BJsKkm.jpg Deselect data sharing and click ‘Skip guided setup’ as this is the only way to progress, select country. Hence the Onboarding: skipped status in the system report below.

    Clicked on the WooCommerce menu item in the Left Nav. Immediately get errors in the browser console. https://snipboard.io/JRXZbH.jpg

    Disabling WC Analytics seems to reduce the number of errors but not fully

    Analytics on https://snipboard.io/BhrSZO.jpg

    Analytics off https://snipboard.io/XC3BSz.jpg

    `
    ### WordPress Environment ###
    
    WordPress address (URL): https://tst.guychapman.net/wp
    Site address (URL): https://tst.guychapman.net
    WC Version: 8.0.3
    REST API Version: ? 8.0.3
    WC Blocks Version: ? 10.6.6
    Action Scheduler Version: ? 3.6.1
    Log Directory Writable: ?
    WP Version: 6.3.1
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_AU
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 8.0.28
    PHP Post Max Size: 512 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 5000
    cURL Version: 7.61.1
    OpenSSL/1.1.1k
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.30
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 8.0.3
    WC Database Prefix: wp_
    Total Database Size: 4.26MB
    Database Data Size: 2.60MB
    Database Index Size: 1.66MB
    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: 0.02MB + Index: 0.11MB + 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: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 1.52MB + Index: 0.03MB + Engine InnoDB
    wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_posts: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + 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_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + 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_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_operational_data: 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_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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
    
    ### Post Type Counts ###
    
    attachment: 1
    page: 7
    post: 2
    wp_global_styles: 1
    wp_navigation: 1
    wp_template: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (1) ###
    
    WooCommerce: by Automattic – 8.0.3
    
    ### Inactive Plugins (0) ###
    
    
    ### 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)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: ?
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –
    
    ### WC Pages ###
    
    Shop base: #7 - /shop/
    Cart: #8 - /cart/
    Checkout: #9 - /checkout/
    My account: #10 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Twenty Twenty-Three
    Version: 1.2
    Author URL: https://www.remarpro.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: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    product-variation-management
    settings
    async-product-editor-category-field
    
    Daily Cron: ? Next scheduled: 2023-09-10 04:40:33 +10:00
    Options: ?
    Notes: 59
    Onboarding: skipped
    
    ### Action Scheduler ###
    
    Complete: 3
    Oldest: 2023-09-09 04:41:45 +0000
    Newest: 2023-09-09 04:45:41 +0000
    
    Pending: 1
    Oldest: 2023-09-10 04:41:45 +0000
    Newest: 2023-09-10 04:41:45 +0000
    
    
    ### Status report information ###
    
    Generated at: 2023-09-09 15:32:26 +10:00
    `
    Plugin Support Sean O))) a11n

    (@seanomattic)

    Hi @guychapman,

    I took the conflict testing idea to the extreme and created a clean install of WP 6.3.1 with a fresh database on my VPS host[…] Deleted the preinstalled plugins ‘Hello Dolly’ (wtf?) and Akismet.

    Thanks for the update, a clean install like this should have zero problems. What, no love for Hello Dolly?! ??

    Installed WooCommerce and immediately on the Welcome to Woo! page (which always fails on any installation) got a couple of errors.?https://snipboard.io/BJsKkm.jpg?

    What do you mean when you say the ‘Welcome to Woo!’ page always fails on any installation? As in recently on your sites/server, or you’ve always found errors on this page?

    Clicked on the WooCommerce menu item in the Left Nav. Immediately get errors in the browser console.?https://snipboard.io/JRXZbH.jpg. Disabling WC Analytics seems to reduce the number of errors but not fully

    Interesting, thanks. The 503 error occurs when a site or server resource can’t be reached. This may be related to the localhost installation. Do you see those errors on your hosted site as well? Aside from these errors, what is your site speed like with this barebones setup?

    Thanks!

    Thread Starter Guy Chapman

    (@guychapman)

    Hi Sean,

    Thanks for the reply. Yes, I’ve never seen that welcome page work, ever. In perhaps 10 installations over time on this site. I’ve always had to use the skip link in the top right. Although today I went to the link to it in > Settings > Help > Set up wizard, and did manage to get it to work that way.

    Everything from my last post is from the hosted site where I did the clean install.

    In the local instance, when I first set it up I got the same errors but not since. Just this one error on the local instance ~.local/wp-json/jetpack/v4/connection/data?_locale=user

    Locally, page load time to open a page for editing is about 6 seconds, the local instance has the same setup as production with the Bridge Theme, Elementor and the suite of plugins. As expected.

    The fresh hosted Test instance is also fast to open a page for editing as it has none of the heavy theme and page builder stuff. Opening WooCommerce Home page is slow though. The blank page loads then it takes about 60 seconds for those console errors to come up. Once they appear some parts of the page render. Usually not the inbox, but it did fully render just now… so inconsistent

    Cheers,
    Guy

    edit to say just reloaded the WooCommerce page again on the hosted test site and got the full suite of console errors again :-{

    • This reply was modified 1 year, 2 months ago by Guy Chapman.
    Plugin Support wpnomad a11n

    (@wpnomad)

    Hi there,

    Thanks for providing further details. This doesn’t sound good — especially that the setup page isn’t working as expected on new installs and 60 second load time for WooCommerce.

    I’m wondering if this is a host specific issue. Have you tried setting up your site on a different host to confirm that?

    Thread Starter Guy Chapman

    (@guychapman)

    Hi @wpnomad,

    In the comments somewhere above I mentioned that I set up a local instance that at first had the errors but is fine now but local and useless.

    I don’t have another host to try a vanilla setup on but I’ve checked in a couple of times with the hosting team and they don’t see anything specific.

    So, what I have done since my last comment, in attempts to reduce load anywhere I can is…

    1. I have ditched the Qode Bridge Theme I was using as it was quite heavy with third-party plugins and replaced it with Kadence that is know to be more lightweight. A bit of rapid reworking of the site and have that in place. It’s more of an impact for the front end of course. It may have made things a bit more responsive but didn’t fix the admin slow pages or the WooCommerce console errors.
    2. So next I’ve upgraded hosting infra, again, Initially I went from shared hosting to a single CPU VPS and have just updated again to 2 CPU and double the RAM and storage available. This has made everything a lot snappier in front and back end and I’m able to at least get Elementor pages to open for editing without freezing. I’m also able to open WooCommerce admin pages without it taking down the whole site while all the console errors time out… so some progress

    Certainly seems there is a hosting capacity component to some of this that may be out of the picture now but there are still a rash of errors on Woo pages that take time fail, then show up in the console. There is a jump in memory use when this happens, less of an issue now but on the previous VPS, as soon as I clicked on a Woo page, memory use would jump from say 20% up tp 60% and hang everything for a few minutes, perhaps until something in json / rest or elsewhere, timed out, and the errors show up in the browser console.

    so current state is that I have a useable site, with lots of Woo console errors, and Elementor page edit times of about 30 seconds.

    From the cast of thousands who have dipped into this ticket, it sure would be good to talk to someone who understands the WC Ajax / rest / json stuff, how it hangs together and authenticates, what is calling what, where the timeouts may be…

    Cheers,
    Guy

    • This reply was modified 1 year, 2 months ago by Guy Chapman.
    • This reply was modified 1 year, 2 months ago by Guy Chapman.
    Thread Starter Guy Chapman

    (@guychapman)

    In the hosted test environment that is vanilla WP with only WC plugin installed, I updated WC to 8.1.0 that was just released and I get the same errors plus this new one (that doesn’t appear on every page load)…

    Error: Minified React error #130; visit https://reactjs.org/docs/error-decoder.html?invariant=130&args[]=undefined&args[]= for the full message or use the non-minified dev environment for full errors and additional helpful warnings.

    Good to see someone has spent time changing the big purple exclamation mark error icon to a small grey one. This is good, makes it easier to fit all the errors onto one tidy screen-shot now ??

    https://snipboard.io/OXPYos.jpg

    https://snipboard.io/czkiSf.jpg

    • This reply was modified 1 year, 2 months ago by Guy Chapman.
    • This reply was modified 1 year, 2 months ago by Guy Chapman.

    Hi,

    I experience the same issues too, fresh installation and get high CPU when accessing Woocommerce Home –> https://prnt.sc/fR6kLFkd4vu7

    When I try to inspect the browser, it has several link unable to be processed here –> https://prnt.sc/iOFGgRYHFfX4

    Hope this resolved without needing to upgrade the hosting package.

Viewing 15 replies - 16 through 30 (of 44 total)
  • The topic ‘WC Admin Pages slow, unresponsive and return “Error retrieving settings”’ is closed to new replies.