Overview of the Issue
When using WPML Multilingual & Multicurrency for WooCommerce with a multivendor plugin as YITH WooCommerce Multi Vendor, the WooCommerceOrders 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 behavior may be noticed with other multivendor plugins.
Workaround
This issue is fixed in WPML 5.2.0. Updating solves it on your site, so you only need this workaround if you can’t update yet.
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:
PHP
add_filter( 'wcml_should_translate_order_items', '__return_false');