-
-
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); |
Excuse the question, but where should I put that file?
@jlbeltrana you need to add this file in
wp-content/mu-plugins
Thanks
Can this just go in functions.php?
@ThrudUK yes
@ThrudUK yes
Many thanks!
So much weird Woo behaviour around product info generally with this security update!
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)
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
Thanks!! worked like a charm!! low stock query was blocking my website!!
@jlbeltrana you need to add this file in
wp-content/mu-plugins