Home›Support›English Support›[Waiting for user feedback] Fix for issue with WPML WooCommerce and the plugin YITH WooCommerce Multi Vendor / Marketplace
[Waiting for user feedback] Fix for issue with WPML WooCommerce and the plugin YITH WooCommerce Multi Vendor / Marketplace
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Background of the issue:
I am trying to resolve an issue with WPML WooCommerce and the plugin YITH WooCommerce Multi Vendor / Marketplace. I referred to a closed support ticket: https://wpml.org/forums/topic/fix-for-issue-with-wpml-woocommerce-and-the-plugin-yith-woocommerce-multi-vendor-marketplace/. I contacted YITH developers again as suggested, and they communicated with WPML developers again. However, YITH reported no further feedback from WPML. YITH suggested contacting WPML again to check the status of a fix. The issue persists. According to YITH, the proposed filter was only used for debugging and not for solving the issue: add_filter( ‘wcml_should_translate_order_items’, ‘__return_false’);
Symptoms:
The problem with WPML WooCommerce and YITH WooCommerce Multi Vendor / Marketplace still exists.
Questions:
Is there still a fix planned from WPML?
Is the use of the proposed filter the solution to the issue?
What is the overall impact of enabling the filter?
I'm trying to figure out the real issue here, although, when I remove that filter I can see the Orders page taking ages to load (with very high number of queries).
But probably that's not totally on WPML or WCML. Since there are dozens of plugins, including custom plugins to support your custom theme, this is an expected scenario.
Because, if I check with standard Beaver Builder theme, WooCommerce, WPML plugins and YITH WooCommerce Multi Vendor Premium plugin, it takes significantly less time and load.
I'll request you try the following to determine when exactly the issue starts happening:
Take a full backup of your site and database before proceeding. It is highly advised to try these on a dev or staging site first, so your live site isn't compromised.
1) Deactivate all plugins except WPML, String Translation, WooCommerce, WCML and YITH WooCommerce Multi Vendor Premium plugin.
2) Switch to a standard theme like 2024 or 2021.
3) Check for the issue if it still happens.
4) Then start activating plugins (other than your custom plugins) one by one while keep checking for the issue.
5) If after activating all plugins you see that it still works fine, then switch to your theme and see if that's causing it.
6) Lastly, start activating your custom plugins one by one while keep checking for the issue. This way you 'll be able to pinpoint a conflict when & where it starts creating the problem.
Please let me know your findings and I'll try my best to further help you on the matter.
Thank you for your feedback. It is of course to be expected that the large number of plugins would increase the number of DB queries. But the number only really skyrockets when YITH Multivendor and WCML are activated at the same time. Although I have already carried out various tests with standard themes and plugin deactivations earlier, I have run through the whole procedure again as desired.
I am happy to share the results with different configurations (standard theme, deactivated/activated plugins) here. The information on the DB queries comes from the Query Monitor plugin: hidden link
Findings
- It does not matter whether the custom plugins are activated or deactivated.
- It does not matter which theme is used.
- It does not matter which other plugins are activated or deactivated.
- No problems are visible if either YITH Multivendor OR WCML are active
- The jump in DB queries only occurs if YITH Multivendor and WCML are active at the same time.
Conclusion
Everything still clearly indicates that the problem only exists if both YITH Multivendor and WCML are activated and the combination of these two plugins leads to a massive increase in the number of DB queries.
Otherwise, the number of DB queries does increase when other plugins are activated, but within an expected range.
I assume that this illustrates once again that the problem arises in the interaction between YITH Multivendor and WCML. I would appreciate it if you could investigate the problem further. Many thanks in advance!
I've reported the matter for some advise and information to our 2nd tier team and I'll update you accordingly.
However, in the meanwhile I may need to take a backup of your site by using Duplicator or All-in-one-migration plugin. This may be needed for our 2nd tier team to investigate the issue locally and/or in another environment.
I just wanted to ask if this is OK for you? If you'd like, you can remove any sensitive data from the site prior to allowing for the above mentioned.
Thank you for the permission, I'll create a package soon and 'll escalate accordingly.
In the meanwhile, I've installed WCML 5.4 beta 1 and did some tests (as recommended by the team). Can you please take a look and check as per your tests and see if that helps improving the situation?
