Home›Support›English Support›[Resolved] Delivery times from WooCommerce Germanized showing incorrect values on English translations after sw...
[Resolved] Delivery times from WooCommerce Germanized showing incorrect values on English translations after sw...
This thread is resolved. Here is a description of the problem and solution.
Problem:
Experiencing issues with incorrect display of translated delivery times on English product pages for old products in WooCommerce Germanized, after changing the default site language from English to German. New products display correctly, but old products show a fallback delivery time of '3–4 business days' instead of the translated value.
Solution:
We recommend taking the following steps after ensuring you have a full site backup:
1) Navigate to WPML >> Settings >> Post Types Translation. 2) Set the Products post type to Translatable – only show translated items and save the changes. 3) In the Custom Fields Translation section, click on the Show system fields link and search for the delivery time custom fields using the
*_delivery*
keyword. 4) Set the fields _default_delivery_time and _delivery_time_countries to Translate, then save the changes. 5) Edit an old product created in English, make a minor change, and update it to refresh the translation settings. 6) Update the German translation of the product and translate the Delivery time custom fields using the German version of the Delivery time term’s slug.
Please note that this solution might be outdated or not applicable to your specific case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket.
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 display the correct translated delivery times from WooCommerce Germanized on English product pages. My site's default language was originally English, but I switched it to German. Since then, the delivery times on old products are not showing correctly in English. If I create a new product in German and translate it to English, the delivery times display correctly. This issue only affects old products that existed before the language switch. Link to a page where the issue can be seen: hidden link
Symptoms:
The delivery times on old products always display the fallback delivery time '3–4 business days' instead of the translated value. This issue persists despite attempts to re-save products, re-assign delivery time terms, clear caches, and duplicate products.
Questions:
Why are the delivery times on old products not showing correctly in English after switching the default language?
What steps can I take to ensure the translated delivery times display correctly for old products?
Welcome to the WPML support forum. I will do my best to assist you in resolving the issue.
Just to make sure, please open one of the English products that shows the issue and check if it shows the expected results in the backend or not.
Please try the following troubleshooting steps after a full site backup {mandatory} and make sure the issue exists or not.
1) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page)
2) On the Troubleshooting page, please click on the following options of the *Clean up* section. Wait for confirmation of processing after each one.
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Set language information
- Fix WPML tables collation
- Assign translation status to duplicated content
- Fix terms count
- Fix post type assignment
- Cleanup and optimize string tables
I did the troubleshooting steps you provided, but the issue still persists.
Additionally, I just created a new product for testing, and now even new products are not displaying the delivery time correctly on the English version.
Thank you for the updates. This may be a compatibility issue. So, it requires further checking. To help us troubleshoot the bug without affecting your live site, please follow the steps below if possible:
a) Create a staging/development site, a clone of your live site
b) Temporarily switch to a default WordPress theme, such as Twenty Twenty-Five
c) Deactivate all plugins except WooCommerce, WPML, WPML String Translation, WooCommerce Multilingual & Multicurrency, and WooCommerce Germanized
d) Check if the issue still exists
e) If the issue is resolved, reactivate the other plugins in small groups (3–4 at a time) to identify any conflict
f) Once testing is complete, switch back to your original theme
Please let us know the results. This will help us narrow down the cause and find a proper solution.
I just noticed from the error log that WPML/WCML is trying to query wp_qfnwnwayfh_icl_strings, but in my multisite setup, the correct table for this subsite should be wp_qfnwnwayfh_13_icl_strings.
Could this mismatch be the cause of the issue we’re experiencing?
Thank you for the updates. The first child site in the Multisite network uses the default table prefix "wp_qfnwnwayfh".
An easy way to track and compare is to visit WPML >> String Translation for both the first and the 13th child sites, and check if the strings and their translations are listed correctly.
To fix the "_icl_strings doesn't exist for query" error, please try the workaround suggested in the link below after taking a full site backup (which is mandatory).
a) Created a staging/development site cloned from the live site - I DID IT IN LIVE
b) Switched temporarily to a default WordPress theme (Twenty Twenty-Five)
c) Deactivated all plugins except WooCommerce, WPML, WPML String Translation, WooCommerce Multilingual & Multicurrency, and WooCommerce Germanized
d) Checked if the issue still existed
e) Reactivated the other plugins in small groups (3–4 at a time) to check for conflicts
f) Switched back to the original theme after testing
The issue still persists — old products do not display the correct delivery times, while newly created products display correctly.
Thank you for the feedback. This requires further testing and escalation. So, a couple of requests.
Please fill in the private details fields after a full site backup. I want to access the admin area of your site for further review. Refer to the following links for more details about our private information sharing policies.
Thank you for the updates and the login information. We will create a few test products as private posts to troubleshoot this bug.
One question: how are you tracking the visitor’s location on the product page? For example, the delivery time for countries such as France, Germany, Hungary, etc. Is it based on the IP address?
In case of escalation, please allow me to make a copy of your site using the Duplicator plugin so I can debug the issue on our local server. This will help us troubleshoot the problem without affecting your live site.
Sorry for the delayed response. The Duplicator copy wasn’t working correctly on my testing servers, likely due to the WordPress Multisite setup. However, I experienced the same result even after I tried installing it as a standalone site.
To verify further, I tested the issue on a fresh installation on our Sandbox server. There, everything worked as expected once I set the Delivery time custom fields to Translate and translated their values (using the German translation of the Delivery time term’s slug). Check the attached images for reference.
Kindly try the following steps after taking a full site backup (mandatory), and then confirm if the issue still occurs:
1) Go to WPML >> Settings >> Post Types Translation
2) For the *Products* post type, select *Translatable – only show translated items* and save the changes
3) Scroll down to the *Custom Fields Translation* section
4) Click on the *Show system fields* link and search for the delivery time custom fields using the *_delivery* keyword
5) Set Translate for the fields *_default_delivery_time* and *_delivery_time_countries*, then save the changes
6) Edit a product created in English, make a minor change, and update it to refresh the translation settings
7) Update the German translation of the product and translate the Delivery time custom fields using the German version of the Delivery time term’s slug
If the issue persists, please try to reproduce it on our Sandbox site. This will help us debug more effectively and escalate the ticket to our developers if needed.
Thank you for the detailed instructions. I followed the steps you provided (setting the delivery time custom fields to Translate and updating the products), but unfortunately the issue still persists on my site.
I will try to reproduce the problem in your Sandbox environment so you can investigate further.
Thank you for the feedback. It will be great if you can replicate the issue on the sandbox site. Please try it and let us know. We will wait for your updates.
