Product Url not translated completely

Hi,

If I switch between Italian/English versions of my website, the product url of some items changes regulary but in other cases the url don't change completely.

Here an example:

Italian URL
www.hidesign.it/it/catalogo/product/show...-3344/poltrona-sacco

English URL
www.hidesign.it/en/catalogue/product/sho...3344/sacco-armachair

The URL I get switching from Italian to English is
www.hidesign.it/ en/catalogue/product/show/cid-3344/poltrona-sacco

This problem generate duplicated contents. :/

I'm sorry but for me that is not normal...
In fact in some case the URL change in other case not...

That cause much problems of duplicated contents. This is not normal at all!!!

What is the file that generate the URL?

Hi,

I was having the same problem. The Falang Module was only translating the /es /en part of the URL, leaving the rest in english / spanish, depending on what language I was using when viewing a product.

e.g.

madecostarica.com/en/shop/p/141-handbag-with-clasp-closure

madecostarica.com/es/catalogo/p/141-handbag-with-clasp-closure

I managed to get the correct URL by modifying the Falang Module, when translating from Spanish to English but, when I attempt to translate from English to Spanish, I can't get the correct product Name in SPANISH.

I use the HS helper to bring the product name in Spanish but, it seems it return the english produyct name, based on the language I'm using.

In the DB, the spanish name is in the hikashop_product table, while the englishg translation is in the falang_content table.

When I navigate in Spanish, it works because I get the english name from teh falang table and the spanish name from the HS table, but when I switch to english, HS brings the english name only.

How can I get the Spanish name using the HS Helper when navigating in English?

Thanks in advanced.

nicolas wrote: You can't use the HikaShop class for that because the query that is done by HikaShop is automatically converted by Falang so that you get the name in the current language.

You will have to do the query yourself:
$db = JFactory::getDBO();
$db->setQuery('SELECT * FROM #__hikashop_product WHERE product_id='.$product_id);
$product = $db->loadObject('stdClass', true,'es-ES');
echo $product->product_name;

Hi there,

The es-ES parameter is for the language (spanish there).
Thanks for the file

Thanks Eliot,

I know it is the international language code for Spanish-Spain, my question was, why did you send it as a parameter to the loadObject Method?

I see the method only asks for 1 parameter:

public function loadObject($class = 'stdClass')

                $db = JFactory::getDBO();
                $db->setQuery('SELECT * FROM #__hikashop_product WHERE product_id='.$vars['cid']);
		$product = $db->loadObject();
	        $lkname = $product -> product_name;