Home›Support›English Support›[Resolved] Split: I use WP Sheet Editor to copy the product from the main language
[Resolved] Split: I use WP Sheet Editor to copy the product from the main language
This thread is resolved. Here is a description of the problem and solution.
Problem: You are using WP Sheet Editor to copy products from the main language to a secondary language, and sometimes images do not appear in the secondary language. Solution: First, ensure you have followed the correct steps as outlined in our documentation: Transfer WPML Translations with WP Sheet Editor Quickly Translate Posts with WPML and WP Sheet Editor The issue might be due to the custom field _product_image_gallery being set to "Don't translate". This setting prevents the image gallery from being copied to the secondary language. To resolve this, change the setting of this custom field to "Copy" by following these steps: 1. Go to WPML → Settings → Custom Fields Translation. 2. Check the option to show system fields. 3. Set the _product_image_gallery custom field to "Copy". After making this change, make minor updates to the product in the original language and try duplicating it again.
If this solution does not resolve your issue or seems outdated, we 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.
I still have a question. I read your official documentation that WPML and WP Sheet Editor are compatible, but I use WP Sheet Editor to copy the product from the main language to the secondary language and sometimes images appear, but sometimes the picture will not appear in the secondary language, what is the reason for this?
I can confirm that WP Sheet Editor is compatible with WPML, and I don't see any known issues related to it at this time. However, I cannot say for sure what might be causing the problem you described. Have you followed the guides below to ensure all the steps are correct?
I followed the second link you sent me, and found that no product images were available in other languages. I asked the WP Sheet Editor for technical support, and they said it was your WPML plugin problem, but I don't know how to send my website background information to you, you can enter the background operation once again to understand.
I have created a new fresh site. Could you please try to replicate the issue there and, if possible, make a short screencast showing me the steps you took?
The link to the site is in the following private link.
This is no problem, in fact, I found that the main reason for this problem is the language of the media to add information to the problem led to the picture can not be displayed properly.
I also have a question. Does WPML have a WP-CLI command to quickly synchronize properties and update product variants? Updating this content from a PHP page is too slow and easily interrupted.
If I record a video, how should I send it to you? Which web site can store videos? What about Google Drive?
I'm glad you were able to identify the reason for the issue. Yes, please upload the video to Google Drive and share the link with me. I will activate the private field where you can place the link.
We currently have limited support for WP-CLI. However, you can run troubleshooting options by going to WooCommerce → WooCommerce Multilingual & Multicurrency → Status and then clicking on the Troubleshooting link.
Thank you for your explanation and the testing you conducted on the sandbox site.
I have thoroughly reviewed your video and believe I may know why the product gallery is not being copied to the secondary language. It appears that the custom field called _product_image_gallery is set to "Don't translate". As a result, it is not copied to the translations when you duplicate or translate the product. The field keeps the media IDs.
I suggest changing this setting to "Copy". After making this adjustment, make minor updates to the product in the original language and then try to duplicate it again.
To activate this field to copy, please follow these steps:
1. Go to WPML → Settings → Custom Fields Translation.
2. Check the option to show system fields.
3. Set the _product_image_gallery custom field to "Copy"
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
