Home›Support›English Support›[Resolved] How to safely import variable products with WPML active using WP All Import
[Resolved] How to safely import variable products with WPML active using WP All Import
This thread is resolved. Here is a description of the problem and solution.
To safely import variable products with WPML and WP All Import, you need to create separate CSV files for each language with a Unique Identifier column. This allows WP All Import to connect the product translations to the default language products. For this to work properly, you need to add an ID number. You cannot use the SKU or other custom fields.
Then, you can move on to importing your taxonomies, the import settings, and importing your products. For a step-by-step guide, please see the page about importing variable products in multiple languages.
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.
Hi, I duplicated marinalari.com to marinalari.revenuesden.com in order to improve the website. The duplicate was made a while ago, and during this time new products have been added and the stock has changed on the live website marinalari.com.
How do I safely import variable products (688 for IT/EN languages) without messing anything up, using WP All Import? I've had some bad experiences previously with another plugin.
Following your documentation:
The taxonomy terms and translations were already created when the site was duplicated, so this step is not needed I assume.
For the export from live website marinalari.com I should have 2 seperate exports. One export by filtering the base language IT separately, and then the second language EN separately?
In your documentation it says I have to add a new column 'unique identifier', but the product ID's are all unique. This means that I don't have to add a new column, right?
As per your documentation - first import base language, then secondary language. Is there anything you advise me, because its a bit confusing since a lot of info is not repeated for the product part. Do we assume is basically the same as importing posts?
Thank you for contacting WPML support, I'd be happy to help you with this issue.
1. For the export from live website marinalari.com I should have 2 seperate exports. One export by filtering the base language IT separately, and then the second language EN separately?
Yes, correct. For anything you want to export from your live site in the default/original (IT) language, you need to export the corresponding things in the second language (EN) to import later.
2. I have to add a new column 'unique identifier', but the product ID's are all unique. This means that I don't have to add a new column, right?
You need to have the "unique identifier" column with the unique number. But you can use the column WPML Translation ID as the "unique identifier" column when importing the product.
Please read more on the documentation https://wpml.org/documentation/plugins-compatibility/export-multilingual-websites-using-wp-all-export-wpml/
3. Is there anything you advise me, because its a bit confusing since a lot of info is not repeated for the product part. Do we assume is basically the same as importing posts?
Yes, it works like importing/exporting posts but with more fields.
There is one note: If you want to import any changes in the default/original language for the products, you need to import the changes for the products in the second language also.
The tests for product imports went well. Is updating stock the same process (first base language, then second language etc), but then select import existing products and only update the stock field?
Hi Long, so far thanks for your help. All imports seem to go well.
Instead of the manual way, what is the best way to bulk edit attributes of newly imported products? On the new website we are working with new attributes such as color, season, brand, material etc.
Can we use WP All Export and run an export to Excel, and then add new attributes there, then import again? Are there any things we should take into account here, considering WPML?
Looking forward to hearing your reply about best practices.
I think yes, the attribute of WooCommerce actually a custom taxonomy like category, tag. You can export them to a file, edit the file and re-import attributes to your site. What WPML does here is to connect the language of attributes, for original and second languages.
