Multilanguage Import from a .CSV file

[nikitas]

hi.congrats again for the awesome work.
i've spent hours trying to figure out how do you import multilanguage .csv files into prestashop and still nothing.
i read this thread to [ http://www.prestashop.com/forums/viewthread/7720/general_discussion/csv_import ] hoping for a answer but still nothing.Can u please inform me or give a hint on how do i fix this?
i mean i've read and understand how to import .csv files but it just works for 1 language only.
thanx in advance.

[The Ge]

It should work by making an csv file per language and changing the default language to whatever you need before importing (eg. changing to french before importing import_fr.csv). Be sure to have a backup!

Mind you, i did not have time to try this, but i will do it and report back.

[vezy]

Hey ggedamed!
You didn't report back on this!
I just tried it and Nope! it doesn't work...The second lge csv overwrites the first despite changing the default lge.

Anyone got the secret key to unlock this door?

[The Ge]

Sorry, man!
You're right, it doesn't work that way.

The fastest solution I know is this:
1. backup the `product_lang` table from your database using phpMyAdmin or something equivalent
2. order your products by `id_lang` and select the ones you want to change
3. press the pencil simbol to start editing names as you like
4. once you finish press the 'Go' button to save it

An alternative way is to export a csv and to edit it in Excel or something alike. It's easier if your descriptions don't include line end characters (CR or LF).

All the best.

[vezy]

THanks ggedamed for such a prompt response!
I'll try out your suggestion as I have hundreds of products and really don't fancy editing the descriptions one by one...even if I do copy and paste, it'll take hours!
It's odd that there is not a language ID field for CSVing.... but I'm not complaining, managing to get CSV's to work is quite a challenge and I have succeeded which is a victory in itself, n'est ce pas?

All the best to you too.

[Lisa G]

Hi there,

unsure which version of PrestaShop you are using but there seems to be a bug in v.1.3.2 when importing products in a language other than English. The bug has been corrected in the v.1.4 alpha.

The forum member "uddhava" has noted the problem and posted a quick and easy fix here:
http://www.prestashop.com/forums/viewthread/63014/P30/configuring___using_prestashop/guide_import_csv_files__part2__importing_of_products_and_combinations__ps_1_dot_3_dot_x

Found on page 3, Post #37 of the above forum topic.

Hope that helps.

Regards,
Lisa

[vezy]

Thanks Lisa!
I'm still using 1.2.5 and have no time to upgrade for the moment - I was looking to import products in multiple languages - does 1.3.2 or 1.4alpha support that?

Kindest regard
Veronique

[Lisa G]

Hi Veronique,

I am very new to PrestaShop in that I am having our custom designed front end templates integrated into v.1.3.2 currently and have only been using a basic download of 1.3.2 as a "test" shop on my server to learn how everything functions. When the programmers complete the programming of my custom shop I hope to be up to speed and can start using our custom shop immediately. I say all this to let you know that I have no real experience with online commerce as of yet.

From what I have read, it appears that v.1.2.x (x can be whatever version) is very buggy when it comes to importing files into the database.
Regarding the latest versions - 1.3.2 and 1.4 alpha it appears that many of these bugs have been worked out and people have much success with either a workaround of some sort, buying a custom module, developing a custom module or learning how to properly create a csv file to import.

So in short to answer your question, yes the newer versions work to import multi language files.

I recommend reading these 2 threads if you have not had a chance to yet to get more information about this topic.

http://www.prestashop.com/forums/viewthread/49825 (Part 1)
http://www.prestashop.com/forums/viewthread/63014 (Part 2)

Kind regards,
Lisa