Home›Support›English Support›[Resolved] Issues with wp all import+wpml woocommerce products import with 2 different languages
[Resolved] Issues with wp all import+wpml woocommerce products import with 2 different languages
This thread is resolved. Here is a description of the problem and solution.
Problem: You are experiencing issues importing products using WP All Import with the WPML Import Export plugin installed. Despite following all instructions, you end up with more products in English than in another language, even though your Excel file has equal products listed as translations. Solution: We found that the import setting 'Skip WooCommerce products if their data in your file has not changed' was enabled, which we disabled and ran another successfull import.
If this solution does not resolve your issue or seems outdated, please check related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. We highly recommend opening a new support ticket at WPML support forum for further assistance.
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'm having issues importing products with wp all import with wpml import export plugin installed, i followed all the instructions but when the import is finished i'm having more products in English than the other language, although i have equal products as right translations in the excel, please help with that i've tried everything and i can share the excel that i'm trying to import
WPML should correctly:
Create 962 products
Link each EN ↔ AR pair as translations
Before importing, I’d still suggest one final validation:
- Check if default language = en in WPML
- Ensure import runs in the correct language context (en default, second language ar)
- Confirm no pre-existing products with the same SKU (to avoid merge conflicts)
Please answer:
1) Does the site on which you import the products have the same language setup as your old site?
2) If so, could it be that there are already existing products on your new site that might use the same product ID or SKU as products on your import file?
I'd like to request temporary access (wp-admin and FTP) to the website to investigate the issue further.
You'll find the necessary fields below the comment section if you log in to leave the next reply. The information you provide will be private, meaning only you and I will be able to see and access it.
IMPORTANT
Please be sure to create a backup of the website and database before granting us access.
If you don't see the "wp-admin / FTP" fields, your login credentials for the post and website will be set to "PUBLIC." Do NOT publish the information unless you see the required wp-admin / FTP fields.
The private reply form looks like this: hidden link
When replying again, click "I still need assistance".
Video: hidden link
Please note that we are required to request this information individually on each ticket. We are not permitted to access any login information that was not specifically provided in the private reply form for this ticket.
Okay let me push it somewhere. because currently it's in my local. once i push i'll give you credentials. also please make it so if i reply next time it also asks me to share private data.
Thanks
This website already had 182 products, which I deleted, to make sure we are not running into issues with similar IDs or SKUs on import.
Then I ran the product category synchronization wizard at WPML > Taxonomy Translation > Hierarchy Synchronization, as on Arabic, at Products > Categories, only one product category showed up.
Further, here, only 11 product categories from 22 are translated into Arabic. Actually, it looks like you have duplicated entries in English, once in English and then in Arabic. I would suggest deleting those Arabic duplicates in the English language.
As you import the product together with its categories, it would be advisable to first translate the existing categories. To avoid any unexpected issues, I also deleted all product taxonomies before running the import again.
I then created a new import with a new file upload, using the file that you had send me.
I set up a new import template and left the unique identifier on the default value:
{title[1]} - {product_id[1]} - {sku[1]}{size[1]}
The import was completed with 1924 new records.
As the final step, I went to WPML > Export & Import and clicked "Run WPML Import".
I can not confirm any issue. The site now has 962 products, in each language, and they are connected. Please use my import template and settings as a reference.
Note that if you import products together with their categories or tags, it is recommended to import those taxonomies first with a separate import file and import method.
I see, but all the products are now imported as single products, i had a column for product type, in wp all import woo setting i'm setting xproduct type to that column. If i did that and imported categories separately also used your template for import will the import work correctly?
I see that you checked Link all variations option in the attributes section that's why product variations where not grouped. if i uncheck that and import again so my products are grouped will it work again?
