I need to translate 4000+ products for that reason I've made a script to save some costs. But the import function does not work. It just keep stuck at the screen.
I just want to update the text with csv file of products. however I sees it as seperate files I never get the 2 files combined. it uploads it as sperate product and it never merges with the actual product.
I tried importing the products, and all items appear as drafts in the correct language. I can press “Import”, and it seems to perform the alignment process. However, when I check the imported products afterward, I do not see any changes. The imported products are still in the original language, and I cannot switch between the languages.
I am using the Product ID to align the products, and I am using WooCommerce Export together with WP All Import for the data import.
I would really appreciate a quicker response, as this is my live website. I purchased WPML because my previous plugin caused a major error, so I need to act fast. Is a video call available for quicker assistance? I am happy to pay extra. I just need this resolved as soon as possible, because my current website is not presentable and it is costing me money every moment it remains untranslated.
I see the product was added as a separate English-language product, but the current product itself was not updated. Because of this, I now have an extra English product that does not contain all the information.
I only want the product text and category to be updated on the existing product.
I would like to check the import settings once? Also I would like to know:
- Are you trying to update the existing post with content update?
- Are you trying to connect the existing post with new translations?
Can you send me the CSV file you are using for both languages so I can quickly check?
Further, To debug this issue further, I would need to check your site settings once, for this I would need temporary access (wp-admin and ftp) to your site.
So could you please provide me with those details, you will find the needed fields for this below the comment area when you log in to leave your next reply. hidden link
Let me know if you need anything else. I provided links to the CSV files. Due to the urgency, I don’t have a staging environment ready, but I do have backups available on SiteGround.
If you need any additional details or information, please let me know. This is my live website, so I trust that the changes will be handled carefully.
The provided details do not belong to an administrator account, so I was unable to perform the required checks. Could you please upgrade the account permissions to administrator level?
Also, the provided CSV appears to contain only categories. Could you please confirm if you are trying to import only categories?
For the import to work correctly, both the default language import and the current language import need to have the following field synchronized:
* _wpml_import_translation_group
I hope this field was not cleaned up on the site. If it was removed, we will likely need to re-import the English content first in order to synchronize the translations properly.
Additionally, I would need permission to install a database management plugin in order to verify whether these fields still exist in the database.
Very sorry this was indeed a normal user. just upgraded the permission to owner. You are allowed to install whatever is needed. I just reverted the categories the 80 sample products are still on the website. I indeed uploaded 2 categories csv. this is correct csv file containing all 4300+ products: hidden link
I see there are no changes or activity yet. In the meantime I got the German and French translation done aswell. Would be nice if you can help me out ASAP to get this sorted. as my website needs actual translation. Link to all the files: hidden link
Since there is a large amount of data, I checked one example to better understand why the import is not working.
For the import to work correctly, all language files must include the following fields:
_wpml_import_translation_group: A unique value used to connect the default language content with its translations.
_wpml_import_language_code: The language code for each item.
_wpml_import_source_language_code: The original language code of the content.
In the first CSV entry, the values are defined as:
_wpml_import_language_code: en _wpml_import_source_language_code: nl _wpml_import_translation_group: 3989
It also indicates this is translations of 3989 from translation of value.
However, after checking the site using a postmeta plugin, the required values do not exist for that post, which causes the connection to fail during import.
Based on this, I would recommend the following workflow:
- Export all existing products into a CSV file.
- Make sure the three WPML fields are correctly added and mapped in the CSV.
- Reimport both language files so WPML can properly connect the translations.
I also recommend testing this process with a single product first, as it makes debugging much easier.
Currently importing everything again. Is it possible to have a video call to handle things off quickly. I just downed the whole website to get this sorted. This costs me serious money and I would love to have this fixed today.
Just did the import the dutch translation does not work. And is not linked correctly. The German and english are connected for some reason. Please keep me posted. I'm not sure how to proceed right now and I dont wont the website offline for the rest of the day.
