Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save fitimvata/09b177f8c822c8a2ffedf987058f0fe3 to your computer and use it in GitHub Desktop.

Select an option

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

odirlon commented Jul 16, 2021

Copy link
Copy Markdown

Very good! It worked.

@hwperkins

Copy link
Copy Markdown

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

@jlbeltrana

Copy link
Copy Markdown

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

@fitimvata

Copy link
Copy Markdown
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
Copy Markdown

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

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

Thanks

@ThrudUK

ThrudUK commented Jul 20, 2021

Copy link
Copy Markdown

Can this just go in functions.php?

@fitimvata

Copy link
Copy Markdown
Author

@ThrudUK yes

@ThrudUK

ThrudUK commented Jul 20, 2021

Copy link
Copy Markdown

@ThrudUK yes

Many thanks!

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

@fitimvata

Copy link
Copy Markdown
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

ThrudUK commented Jul 20, 2021

Copy link
Copy Markdown

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
Copy Markdown

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