This thread is resolved. Here is a description of the problem and solution.
Problem: The client wants to import Italian product translations into their site, which already contains products in the main language, German. They have a CSV file with the Italian translations, including columns for SKU, name, short description, and description.
Solution: Here are the steps to follow:
Export your default language content using WP All Export.
Edit the exported CSV to add a column for the unique identifier.
Delete the original content from the site.
Import the default language CSV file with the unique identifier column as New items.
After importing the default language content, proceed with importing your secondary language file.
If you need to connect translations programmatically, you can use the
wpml_set_element_language_details
hook. However, we do not provide custom coding services. For examples and explanations, check out our documentation on wpml_set_element_language_details and related support forum discussions. If you require further assistance with custom coding, consider hiring a professional from our list of WPML contractors.
Please note that this solution might be outdated or not applicable to your case. If the provided solution does not resolve your issue, 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 you still need help, please open a new support ticket in our support forum.
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 want to import product translations to my site using your new import plugin.
My products are on the site in main language german, and no product translations are on the site.
I have a csv with the italian product translations of the products, with columns SKU, name, short description and description
For your case I would advise using WP All Export and WP All Import and follow the procedure from our docs, you do not need WPML Import export in that case:
To add translations when default language content already exists on the site:
- Export your default language content using WP All Export.
- Edit the newly created CSV to add a column for the unique identifier.
- Delete the original content from the site.
- Import the default language CSV file with the unique identifier column. Make sure to import it as New items.
- Once the default language file has been imported, you can continue with your secondary language file as previously explained.
I understand, but I am afraid there is no easy way to import translation to already existing content. One way would be translating them manually or via automatic translation:
you could import a product in 2nd language like that, but still, it will not be connected as a translation with your default language. You would have a product in the default language and a product in 2nd language, and still would need to connect them manually or via our hook.
I am afraid there is no other way than the one I already suggested above.
so what if I export my products with the woocommerce export tool, replace the title, short desc, and description columns with the translation data and import them back with the extra columns needed for the wpml import export plugin? Would that work?
Do I need to export/ import all product data for this to work or is title, short desc and desc columns enough?
you can export only title/content, but it still won't work as far as I know, since you need to have an import in the default language also for it to work correctly and connect translation correctly.
So it needs default language import, 2nd language import, and connection field/key for it to work. From my perspective, the best would be to connect them via our hook, suggested above, after you have imported 2nd language product.