High Query Load on WooCommerce Orders Page When Using Multivendor Plugins

Overview of the issue

When using WooCommerce Multilingual with a multivendor plugin as YITH WooCommerce Multi Vendor, the WooCommerce > Orders admin page experiences excessive database queries, resulting in extremely slow performance or unresponsiveness as the number of orders grows.

Note: keep in mind that a similar behaviour may be noticed with other multivendor plugins.

Workaround

Please, make sure of having a full site backup of your site before proceeding.

• Open your theme’s functions.php file.
• Add the following line:

  add_filter( 'wcml_should_translate_order_items', '__return_false');