How to fix slow WooCommerce 6.01 for wp-admin pages

I upgraded Foundthru to the latest WooCommerce and after onboarding (updating the database) it keeps checking if I need to update the database with expensive calls on wp-admin.

On foundthru with 1 million products, this increases wp-admin page load time from 3 seconds to 28 seconds.

My Foundthru site taking 55 seconds to load wp-admin

There’s no easy fix I can apply for this inside Scalability Pro so I had to edit a couple of WooCommerce files to fix this. That should be safe since the next WooCommerce update will overwrite the fixes which will mean onboarding can run again for the next update.

More info about the source files here on this facebook post:

https://www.facebook.com/groups/advanced.woocommerce/posts/5550114498336257/

Specifically, the files you need to edit are:

  • /woocommerce/packages/woocommerce-admin/src/Features/OnboardingTasks/Tasks/Products.php
  • /woocommerce/packages/woocommerce-admin/src/Features/OnboardingTasks/Tasks/Appearance.php

You’re looking for lines at the start of 5 different functions that look like this:

$task = new Task( self::get_task() );

Just put the command return; before that line so it becomes:

return;
$task = new Task( self::get_task() );

These edits will be overwritten on the next WooCommerce update when they’ve hopefully fixed this, and because the updates are overwritten it means any required onboarding for the next version will kick in again.

Tags:

6 Comments
Show all Most Helpful Highest Rating Lowest Rating Add your review
  1. Hi Dave,
    I am a WordPress and Woocommerce dev. Recently I have been working on a website where we have a large number of products.
    We have used woocommerce widgets on the blog page sidebar. It takes 8-10 seconds for woo-commerce slow queries to get widget HTML results. Please check this page https://www.kideno.com/en/what-memories-should-you-aim-to-create-for-your-child/
    This happens whenever we are accessing not cached page.
    Will your plugin help us to reduce query time?

    Regards
    Mahboob

    • You need my Super Speedy Filters plugin. I tried originally to bake everything into Scalability Pro but in the end Search and Filters had to be separate plugins. You’ll also need redis-cache.

  2. Spoke too soon again – 6.31 still has this issue. 27 seconds added to wp-admin. Maybe it will go away when the new Product Attribute Table has been created.

    https://i.imgur.com/oCs3IQq.png

    I’ll report back once that’s happened.

    • Did the issue go away after the Product Attribute Lookup Table was created?

      • It still hasn’t completed on my million product site – I increased the batch size to 10,000 – it should be done soon. I don’t like how they build these tables – they make them super reliable on every site but as a result, they take ages to build.

        My tables use MySQL 8 features (recursive CTEs) to make building and maintaining these tables really fast.

  3. My bad – I’d updated our demo sites where we test everything to WooCommerce 6.31 which is actually the latest version and this issue is already fixed.

    Foundthru was still on an older version which I’ve now updated and confirmed this issue is also fixed there.

Leave a reply

Super Speedy Plugins
Logo