Problem: The client was experiencing a performance issue with a slow WPML query on their WooCommerce site, which took 3.5 seconds to complete. The query involved a
SELECT COUNT(...)
check that was identified as problematic.
Solution: We recommended the client to update all outdated WPML plugins and to revert the site to a minimal setup to ensure there were no performance issues. We then advised the client to activate only the plugin responsible for creating the Cars and Models to determine if the performance problem would reoccur.
If you're experiencing similar issues, we recommend you try the following steps: 1. Update all outdated WPML plugins. 2. Revert your site to a minimal setup and check for performance improvements. 3. Activate plugins one by one to identify the source of the problem.
Please note that the solution provided might be irrelevant due to being outdated or not applicable to your case. If the issue persists, we highly recommend checking related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. Should you need further assistance, please do not hesitate to open a new support ticket in the WPML support forum.
Problem: The client was experiencing an issue where all products were being skipped during an import from a Google Sheets file, even after replicating all import settings from the provided video and manual.
Solution: We investigated the issue and found that the problem persisted even when WPML (and/or WPML Export and Import) was deactivated. This indicated that the issue was unrelated to WPML. We suggested that the client should look into the WP All Import plugin or the import settings as the likely source of the problem.
If you're experiencing a similar issue with products being skipped during import, we recommend checking your WP All Import plugin and import settings. It's important to note that the solution provided here might be outdated or not applicable to your case. If the issue persists, we highly recommend checking 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 open a new support ticket with us.
Problem: The client wants to know if it's possible to import product descriptions in different languages from a single Google Sheet document, instead of using separate files for each language linked by a unique ID.
Solution: We recommend adding a unique identifier to your spreadsheet to connect the default language content with its translations. It's important to use an ID number and not other custom fields like SKU. Here are the steps to follow: 1. Ensure each product has a unique ID number in the spreadsheet. 2. Do not use the SKU as a unique identifier. 3. Refer to our documentation on how to add a unique identifier to your spreadsheets for detailed guidance. 4. Consider our new Add-On, WPML Export and Import, which has reached version 1.0 and offers additional solutions for importing content. You can find more information in our recent newsletter or on the compatibility announcement page.
If this solution doesn't seem relevant to your situation, please open a new support ticket in our support forum.
Problem: The client is experiencing issues with automatic translation of products in bulk through Translation Management. The products added for translation are stuck in the queue and not being processed. Solution: We recommend the following steps to resolve the issue: 1. Go to WPML > Support > Troubleshooting in your WordPress dashboard. 2. Scroll down and click on the button labeled "Cancel in-progress Automatic translation job." 3. Then, navigate to WPML > Translation Management > Jobs. 4. Delete any Jobs that are marked with an "in progress" status.
After completing these steps, clear both the site and browser caches, and then try to resend the Jobs for Automatic translation.
Problem: The client is trying to replace the word "Starpsumma" with "Summa" in the PDF invoice generated by WooCommerce. Despite adding the translation in the String Translation, the issue persists. The correct word appears when downloading the invoice directly from WooCommerce, but not when the customer receives the PDF via email.
Solution: 1. We suggested deactivating the WPML plugin to check if it affects the issue. 2. If the problem remains, we recommended contacting the support team of the PDF Invoice plugin for further assistance. 3. If deactivating WPML resolves the issue, we asked the client to replicate the problem on a provided sandbox site to allow us to investigate further. [Client reported that updating the PDF invoice plugin seems to solve the issue.] If this solution doesn't look relevant, please open a new support ticket.
