Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fitimvata/09b177f8c822c8a2ffedf987058f0fe3 to your computer and use it in GitHub Desktop.
Save fitimvata/09b177f8c822c8a2ffedf987058f0fe3 to your computer and use it in GitHub Desktop.
<?php
/**
* Plugin Name: Fix woocommerce admin analytics performance issue
* Plugin URI:
* Description:
* Version: 1.0.0
* Author:
* Author URI:
* License: MIT
*/
add_filter('posts_where', function ($where, WP_Query $wp_query) {
if ($wp_query->get('low_in_stock')) {
$wp_query->set('low_in_stock', false);
}
return $where;
}, 9, 3);
@odirlon
Copy link

odirlon commented Jul 16, 2021

Very good! It worked.

@hwperkins
Copy link

Thanks. I had to bump priority up to 9999 for it to work, but this was what I was looking for.

@jlbeltrana
Copy link

Excuse the question, but where should I put that file?

@fitimvata
Copy link
Author

Excuse the question, but where should I put that file?

@jlbeltrana you need to add this file in wp-content/mu-plugins

@jlbeltrana
Copy link

Excuse the question, but where should I put that file?

@jlbeltrana you need to add this file in wp-content/mu-plugins

Thanks

@ThrudUK
Copy link

ThrudUK commented Jul 20, 2021

Can this just go in functions.php?

@fitimvata
Copy link
Author

@ThrudUK yes

@ThrudUK
Copy link

ThrudUK commented Jul 20, 2021

@ThrudUK yes

Many thanks!

So much weird Woo behaviour around product info generally with this security update!

@fitimvata
Copy link
Author

Weird why? I think that security update was not related with this issue. The issue with this query has been for a long time but was detected in latest release because the query is executed more frequently. See this comment woocommerce/woocommerce-admin#7358 (comment)

@ThrudUK
Copy link

ThrudUK commented Jul 20, 2021

Weird why? I think that security update was not related with this issue. The issue with this query has been for a long time but was detected in latest release because the query is executed more frequently. See this comment woocommerce/woocommerce-admin#7358 (comment)

Hmm... might not be the security update. But for example :

In any product....
Go to Quick Edit
Set Product as hidden
Update
Go To Quick Edit
Product is showing as hidden
Change to Catalog & Search
Update
Go to Quick Edit
Product is showing as hidden
REFRESH THE BROWSER
Go to quick edit
Product is showing as Catalog and search

I'm seeing this on multiple installs of Woo

@rickdroio
Copy link

Thanks!! worked like a charm!! low stock query was blocking my website!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment