This thread is resolved. Here is a description of the problem and solution.
Problem: You have a multilingual website and are using WP All Import to manage WooCommerce products in multiple languages. You've successfully imported images for products in the default language (German) but face issues when trying to assign these images, with their respective metadata, to the products in the second language (English). The metadata for the German images gets overwritten by the English texts during the import process.
Solution: First, ensure that your CSV files include a column with the product title, as missing titles can cause the WP All Import Pro plugin to skip product imports. When setting up your import, in the WPML > Settings, check the option to duplicate images if your workflow requires it. For the English import, this setting will import the images and English texts and assign them to the English products. These settings will also duplicate the media to the Spanish products but with English texts. Subsequently, perform a second import for the Spanish version using the option "Use images currently in the Media Library" to update the existing Spanish media with the correct texts. Ensure that the WPML language options are set to connect this Spanish import to the original English import.
We recommend checking the related known issues and verifying the version of the permanent fix. Confirm that you have installed the latest versions of themes and plugins. If this solution does not resolve your issue or seems outdated, 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.
Can you please ask your support to take a look at this!
The staging site is currently blocked. I can't work on it because I don't know if I need to reset the database.
Thanks!
Here are our second-tier findings so far. They suspect the problem might be that you rely on the SKU for record matching; we don't provide anything else in the CSV file to target the product.
Ordinarily, the SKU should be unique for each product. But in a WPML multilingual world, the original language product has an SKU, and the translations have the same SKU, so querying by SKU can find more than one result, possibly the wrong result. This could mean the texts for the translation are wrongly assigned to the default language, which is what happens here with the media.
They suggest testing by updating the CSV files to include either the product title or ID and matching those as a unique identifier instead of the SKU, then repeating the import process to see if it correctly assigns the text to the correct language media.
Thank you. That's what I expected.
I think this is a bug in your plugin “WPML All Import”. I expect the plugin to perform the query for SKU AND the specified language.
It would at least be helpful to enable this option for the identifier.
Where can I report this problem so that your developer can work on this fix?
The use of ID and title is not an option. The ID is unknown and the title is not unique.
I would expect that as a WPML employee you would know how your import plugin works and what is missing.
After all, importing images with metadata does not work in multiple languages. This is something I would expect from a paid plugin for multiple languages. Since WPML is a paid product, I would say that I can expect this issue to be fixed.
If you need further testing, you or your development team could have done that. This should be your daily work.
You and/or your 2nd tier support have had enough time to do all the testing. So all the information you need were available. I am not paid by WPML to do your work. It's your job to fix problems on your website!
I can no longer keep the staging site ready for you. I have to get on with my work and finish the website. My client is very upset that so much time has been wasted on this fruitless communication.
I therefore demand that you take the problem seriously and that your 2nd tier support does what it is paid to do. Find a solution for an issue that is caused by your plugin.
Thanks for your patience. Please log in to this hidden link and import only the German file to assign the images to the German product.
After that, please let me know if the images are assigned correctly with the correct title and caption.
I tried to do so, but the import fails to update existing products, and checking the WP All Import Pro logs for the import, the reason is that the product has no title, content, or excerpt (description):
[12:38:05] Record #1
[12:38:05] ACTION: pmxi_before_post_import ...
[12:38:05] WARNING: title is empty.
[12:38:05] Combine all data for post ``...
[12:38:05] Find corresponding article among database for post ``...
[12:38:05] Duplicate post was found for post ``...
[12:38:05] Deleting attachments for ``
[12:38:05] Deleting images for ``
[12:38:05] Applying filter `pmxi_article_data` for ``
[12:38:05] UPDATING `` `Product`
[12:38:05] ERROR: Content, title, and excerpt are empty.
[12:38:05] ACTION: pmxi_after_post_import
[12:38:05] ---
Many thanks, Osama, for your efforts.
First of all, the WPML All Import plugin was missing. I have installed it.
I then created an import task for UPDATEING the products. One for German, one for English. German ran first, English afterwards. You can see in WPML > Media Translation that the German images now have the English text.
You can delete the media files and run the tasks again. When you run just the German task, the "German" images will have the German title. Running the English overwrites the titel of the German image with Englisch text.
You can analyze the tasks and settings.
You can also check the logs to see where there is no error.
I would like to add the following:
In my case, when I add an image to an English product or post, I expect the metadata of that image to be linked to English as well. Just for clarification.
