How to get product details with respect to language

English forums
1

hi All, I am here again :slight_smile:
I want to know that is there any way to get product detail with respect to language? For example a product say, “My Product” is available in 2 languages, in “English and German”.
In English it has name “My Product” and in German it has “My Product- DE” and same other details like, product link, images, short description, long description.

I have seen the database structure and I have seen structure like “OXTITLE, OXTITLE1, OXTITLE2”, :eek: no indication that which title is in which language. If I want to get the German title of the product then which column to fetch and same for other language specific columns?
Is there any way? How can I do this task?

2

check the language settings in backend and search for their language ID

3

[QUOTE=Hebsacker;83013]check the language settings in backend and search for their language ID[/QUOTE]

First where to search ids of the language? Second you mean that I put language id with title? if 0 them title, if 1 then title1…etc. Is it?

4

go to Backend -> Master Settings -> Languages and click on one of them

You will find the Language ID then in the details tab, right above the field “Sorting”.

And yes - language ID 0 ist oxtitle, language ID 1 ist oxtitle_1 and so on.