Copy Catalog Language

Hi,

someone has a sql script to copy language of products/categories in a second language?

In particular from standard to language.

Version 3.40

thanks

Not sure what you meant. I guess you want to export/import a language ?

To add new language, try this http://docs.nopcommerce.com/display/nc/Languages

there're some language pack available that you might want to try: https://www.nopcommerce.com/extensions-and-themes.aspx?category=1

You can get a language pack. But you have to translate manually and make the entries by yourself for those. I don't know any auto translater if there is one... That is what I did for 400 categories(including sub). Manually entered all for different languages :)

Hi,

maybe I explained myself wrong.

I'm talking about catalog: category and product.

I have done something like this:

INSERT INTO [LocalizedProperty]
(EntityId, LanguageId, LocaleKeyGroup, LocaleKey, LocaleValue)
SELECT c.id,@languageId,'Category','Name',Name FROM [Category] c

INSERT INTO [LocalizedProperty]
(EntityId, LanguageId, LocaleKeyGroup, LocaleKey, LocaleValue)
SELECT c.id,@languageId,'Category','Description',Description FROM [Category] c

Same for: MetaKeywords MetaDescription MetaTitle.

After that we can start with translation.

Thanks