Product listing by name - with Falang

Hi,

You can select how HikaShop do the ordering of the listing with the "ordering column" of the menu item/module. If you select "product_name", then it will use the data in product_name for the ordering and thus only take into account the untranslated value as the other languages are not stored there but in Falang.
There is no system to do the ordering based on the translation. That would require a left join to be added to the MySQL query on the falang_content table. While that's possible, it will really slow down the MySQL query so I don't really recommend it.
That could potentially be added as a plugin implementing the onBeforeProductListingLoad trigger for your website:
www.hikashop.com/support/documentation/6...reProductListingLoad

Hi,

That's what it does on my end. Are you sure that you selected "product_name" in the "ordering column" setting under the "products options" tab of your menu item ? Are you sure that you set the correct product name in each product of the listing ?
Because I don't see any other reason it would not work.

Hi,


Can you turn on the debug mode of the Joomla configuration and provide the MySQL queries on the table hikashop_product for both links (you can find then in the debug area at the bottom of the page when that option is activated) ?

Hi,

As you can see, the problem is that the language_id in the queries are the same in both case.
Normally, the language_id there should change when you change the language.
That's actually what I have on my end with I try to reproduce the problem.
So all I can think of is that there is a problem with the current language set in Joomla.
We use this code to get the current language id there:

	$language = JFactory::getLanguage();
	$language_id = (int)$translationHelper->getId($language->getTag());

Hi,

Ahh, yes, I had missed that. Then, I reread the whole thread and I understand what's going. I thought that your problem was that the products were not ordered properly, but they do, it's just that the data is not consistent.

Yes, when you have Falang, and you order the listing on the product_name column, the system will order the listings by first ordering the products by their translation and then by their original text. So if you don't fill all the translations, then you'll have strange orderings. We do that so that you can still have the ordering properly when you just have falang but didn't translate the product names at all (because you don't need to).

Try replacing the code:

	$on .= ' LEFT JOIN #__'.$trans_table.' AS trans_table ON trans_table.reference_table=\'hikashop_product\' AND trans_table.language_id='.$language_id.' AND trans_table.reference_field=\''.$match[3].'\' AND '.$match[2].'.product_id=trans_table.reference_id';
	$order = $match[1].'trans_table.value '. $match[4].', '.$match[2].'.'.$match[3].' '.$match[4].$match[5];

	$select2 .= ', CONCAT(trans_table.value, '.$match[2].'.'.$match[3].') AS translation_for_orderby';
	$on .= ' LEFT JOIN #__'.$trans_table.' AS trans_table ON trans_table.reference_table=\'hikashop_product\' AND trans_table.language_id='.$language_id.' AND trans_table.reference_field=\''.$match[3].'\' AND '.$match[2].'.product_id=trans_table.reference_id';
	$order = $match[1].'translation_for_orderby '. $match[4].$match[5];

Hi,

It might be because of the NULL values since translations are missing.
Try changing CONCAT to CONCAT_WS in the code of my previous message. That should skip the NULL values instead of screwing the ordering. Let us knwo how it goes.

Hello,

Can you please activate temporally the debug mode in your Joomla global configuration ?
The goal is to get the result query and have more details about it.
In the Joomla debug console, you should find the query for the loading of the products and be able to copy-paste it in PhpMyAdmin to watch the result.
By having the value you got for "translation_for_orderby" and the full "order by" rules, we would better understand the situation.

Regards,