Skip to content

Instantly share code, notes, and snippets.

@fitimvata

fitimvata/fix_woocommerce_admin_performance_for_query_low_in_stock.php

Created July 16, 2021 10:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save fitimvata/09b177f8c822c8a2ffedf987058f0fe3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save fitimvata/09b177f8c822c8a2ffedf987058f0fe3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fix_woocommerce_admin_performance_for_query_low_in_stock.php
<?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);
@ThrudUK
Copy link
Copy Markdown

ThrudUK commented Jul 20, 2021 •
edited
Loading

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

rickdroio commented Jul 21, 2021

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