Product in another language creation (WMPL)

Hi there,

When you use WPML the import takes the default language. Importing other languages is not supported right now.

I wrote a script for a customer that uses WPML….but it’s a pain in the ….

Feel free to contact me to discuss more

Hi Allaerd,

Thank you very much for the quick answer, much appreciated !

Are you talking about this script https://pastebin.com/bngjJHff
(from this post https://wpml.org/forums/topic/translation-is-not-there-yet-when-importing-product/#post-146218 ) ?

A- If so, could I just add lines 50->60 of https://pastebin.com/bngjJHff into your csv importer plugin somewhere so that everytime you create a new product, it is also duplicated in every other language ?
Duplication should not be happening when you update an existing product of course.

If we test for WPML presence before calling those lines (with something like “if (function_exists(icl_register_string)) { do this wpml specific code }”) it should be quite robust (and for the future you could even add a “Create product in every language if WPML is used” checkbox in the csv importer plugin settings to toggle this)

B- For now, the process I’d like to achive would be the following:

1- Batch-create all products in main language using your csv importer (let’s say English)
2- Have your csv importer duplicate those products for each other language and link them with main language product with modification from A-
(at that point, duplicated products in other languages would have a title in English, I assume)
3- Use you csv importer to batch-rename products in each other language.

But for 3- to happen I’m not sure how to target duplicated products to update them with your csv importer (I’m not sure what field your csv importer use to assess a product exists and only needs to be updated ? In this case SKU will be the same as the original product, so this couldn’t be used to target the duplicated product)

What do you think about A- and B- ? Do you reckon this could work ?

Hi Allaerd,

After a bit more investigation on WPML it turns out that I do not need duplicated product but product translated independently.
So code on lines 50->60 of https://pastebin.com/bngjJHff wouldn’t work as it would create duplicated product in other languages in WPML.
I would then have to manually click on “translate independently” button for each of the duplicated products.

So, rather than having your csv importer plugin be dependent on WPML, I think the following approach would be easier for everyone :

1- Batch-create all products in main language using your csv importer plugin
2- Use WPML plugin to create independent translations for each product in each language
3- Use you csv importer to batch-rename products in each language by using the merge function

But for this 3- to happen, as independent translations have the same SKU as the main language post but a different post ID, we would need your plugin to match a product for merge based :
– on post_ID if in the csv file
– if no post_ID specified, use SKU
(note that “WP All Import” and “Product CSV Import Suite” plugins let you do this and this is the only big feature I havent found in your plugin)

What do you think ? Would you be able to update yoru plugin to have it use post_ID before SKU if present in the spreadsheet for a product merge ?

In the meantime I’m going to request WPML to provide a way to batch-translate-independently a list of products, which would make step 2- a breeze.

Thanks !

Hi there,

ahh, you found my struggle with WPML ;-).

Still it has some strange things, WPML uses some hooks to create translations, etc. So when you import many products, and translate (or duplicate) them they are not there.

The script you found is a test script i send them and the solution they gave is not rock solid. Customers i have still have problems with WPML.

So yes, you can use that script to translate / duplicate it, but it’s not 100%

Hi. We’re using your plugin (great job on the ajax approach, BTW) and bought a few of your extensions for it.

We are also struggling with WPML, and building WooCommerce stores with a few thousand products means a lot of pain for us.

I’d be glad to financially donate to the cause, if it can help ??

Do you have an update on the issue discussed in this thread?

For one of my cli?nts I’m migrating their webshop from PrestaShop to WooCommerce. I’ve found a way to export the products out of their current website and import it through CSV Import to the new website.

So far, so good, but their webshop is available in four languages.

I’m using WPML for the translations on the new website and I’d like to import the products in all four languages. At the moment it is only importing the products in one language.

i am still working on a solution. I have one, but i am not satisfied yet. The people at WPML are helping a lot and even contacted me to help out.

So there will be a solution sooner or later

Ok, thanks for your reply.

Can you share the solution you have with me? I’m desperately looking for a solution to add the translation automatically for 1300 products..

Hi,

I have the same problem and wrote to WPML Support several times.
It seems impossible to import products in different languages with WooCommerce and WPML. I’ve tried several CSV import plugins but I haven’t yet found one doing the job.

I have separated CSV file for each language but I can’t import one language and the others as translations.

The best thing should be to have a special column in CSV with language informations, so if it detect same SKU but different language it understands it’s a translation and doesn’t skip it as “duplicate”.

Did you manage to add this feature (even a PRO version would be great to support this hugely requested but apparently impossible feature)?

Thanks

I am currently working with the WPML guys on making the plugin WPML compatible.

Hi,
We are importing using wpallimport with the WPML addon. A very expensive option and still a nightmare to work with. The imports are so slow. We are importing in smaller chunks of data. csv with about 1500 lines. That file usually takes about 30 minutes. We have hundreds of products with about 300 variations each in 6 languages. Over 300,000 lines of data in total due to the way we have to import with wpallimport.

How many lines of data were in the 10,000 + products in your max import?

We are very interested to see more from you plugin and it’s premium features. There is serious need to language support.

thanks

Hi,

I just finished an import job with 60.000 products. So there is no real limit. But the more you want in, the more time it takes. And especially with WPML. Some times it is easier to duplicate content in the DB and connect all the dots in the db and not import!

Or do it in smaller part. First create the products and meta, than create variations of them and later make the languages copies.

Do not forget, every save triggers lots of actions and hooks in wordpress, woocommerce, wpml, all your plugins……so the less you save the faster it goes ??

I’m very interested in your solution and to me WP All import is too expensive. I have a very small site. 200 products with two languages.. if you want I can test my email is: [email protected]