[Resolved] Performance issues

Problem:
The client reported a performance issue with their multilingual webshop when logged in as an admin. The webshop, which has over 50,000 products and 15,000 categories, was experiencing a significant number of SQL queries on every page load due to the function

maybe_populate_cache

in

class-wpml-element-translation.php

. This issue was not present when not logged in as admin.
Solution:
We recommended the client to modify the Sharespine WooCommerce Connector plugin. Specifically, to edit the

wc-meta-update.php

file located in

wp-content/plugins/sharespine-woocommerce-connector/

and change the

$excluded_keys

array by adding

'_wcml_custom_prices_status'

to it. The code change should look like this:

$excluded_keys = array(
    '_edit_lock',
    '_wcml_custom_prices_status'
);

Additionally, we suggested that the Sharespine plugin developers join our Go-Global Program by filling out the form provided, to ensure better compatibility and support for multilingual sites.

Please note that the solution provided might be outdated or not applicable to your case. If the issue persists, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please do not hesitate to open a new support ticket with us.