Open
Reported for: WooCommerce Multilingual & Multicurrency 5.3.9
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');
Hello there
The workaround with the YITH Multi Vendor Plugin works as far as the reduction of DB queries is concerned, but it produces the problem that the items in the orders are no longer translated (and the vendor names are not translated either). This is of course to be expected if the filter mentioned is set to false.
Can you provide insight into whether the issues (non translated items) are reversible, i.e. will be resolved with a release/fix, or whether the existing orders that were placed with the workaround activated will stay non-translated after the fix is implemented and the workaround is deactivated?
And is there already an ETA on when a fix can be expected?
Many thanks in advance!
Hello there,
This issue has been escalated to our Compatibility team. However, we can’t provide you an ETA and it may probably involve working with YITH team in order to get a definitive solution.
We will keep this erratum updated once we have any news.
Regards