Jump to content
aquaanimation

Names in Product List appear as N/A

Recommended Posts

I have an issue with the product list.

All the product names seem to have no name (N/A) [see the screenshot].

They were uploaded using either Greek language as profile language or English but their names are not visible if the profile language is english and not Greek.

 

How may I fix that so that in all of the profile languages the names will be the correct strings and not N/A??

 

Thanks in advance for the help

post-1033305-0-51770500-1488396659_thumb.png

Share this post


Link to post
Share on other sites
I would guess the English translations are missing for those products. You can try editing each product, entering a translation for English and then clicking the "Save" button.

Share this post


Link to post
Share on other sites

 

I would guess the English translations are missing for those products. You can try editing each product, entering a translation for English and then clicking the "Save" button.

 

In case I don't want to maintain the English version too, since I will be using just the Greek Version,

how could I have the products display the same strings that the Greek version has?

Share this post


Link to post
Share on other sites

You'd have to run an SQL query like the following using phpMyAdmin:

DELETE FROM `ps_product_lang` WHERE `id_lang` = 2;
INSERT INTO `ps_product_lang` SELECT `id_product`, `id_shop`, 2, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later` FROM `ps_product_lang` WHERE `id_lang` = 1;

This will delete all the product translations for language 2 and then copy the product translations for language 1 over to language 2. Change 1 to the language ID of Greek and 2 to the language ID of English.

 

Remember to back up your ps_product_lang table first so you can restore it if something goes wrong.

Share this post


Link to post
Share on other sites

You'd have to run an SQL query like the following using phpMyAdmin:

DELETE FROM `ps_product_lang` WHERE `id_lang` = 2;
INSERT INTO `ps_product_lang` SELECT `id_product`, `id_shop`, 2, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later` FROM `ps_product_lang` WHERE `id_lang` = 1;

This will delete all the product translations for language 2 and then copy the product translations for language 1 over to language 2. Change 1 to the language ID of Greek and 2 to the language ID of English.

 

Remember to back up your ps_product_lang table first so you can restore it if something goes wrong.

It did NOT help me... Does any one have working solution? it looks stupid when all your items title are displayed N/A.

Share this post


Link to post
Share on other sites

ok, I fount the solution on my own. 

I made my site again in english language, checked titles and it was just perfect. Then changed the language back it was before, for me it was Lithuanian language and it worked. All titles display nice and search is working too on admin panel to find the product. 

Share this post


Link to post
Share on other sites

I have the same issue in version 1.7.5.0

In the English language I see N/A but when I change to Dutch language in the back office all is ok.

We need to have it in 2 languages working, because not all people working on the site speak/read Dutch properly so we have to use English as well.

 

Is there an easy fix for this found already for this issue?

 

PS. When I import the product all is ok in both languages

 

UPDATE:

When I change the product name in the default language (English) nothing happens and name stays as the old name, but when I change the back office language to dutch then you see the change you have made in the name field.

Edited by Michel_1911

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More