order by cheapest price!

Hi again i use the starter edition and i need to show my products order by cheapest (lower price)
i do not want to be a choice - filter i just want to show my products from cheapest to more expensive.
Thank you again!

Hi papaleksi,

To change the ordering, you have to edit the file: YourSite/components/com_hikashop/views/product/view.html.php
And in the "listing()" function edit the ordering in the SQL Request.

Thank you for your answer do you mean to change ....
if($this->params->get('product_order')=='ordering'){....


and change "ordering" with "product_price"?

Hi papaleski,

You can add this line:

		$order = ' ORDER BY c.price_value ASC';

		if(!empty($pageInfo->filter->order->value)){
			$order = ' ORDER BY '.$pageInfo->filter->order->value.' '.$pageInfo->filter->order->dir;
		}

		$query = $select2.' FROM '.$b.$a.$on.' WHERE '.implode(' AND ',$filters).$order;

		$query = $select2.' FROM '.$b.$a.$on.' LEFT JOIN '.hikashop_table('price').' AS c ON c.price_product_id=b.product_id WHERE '.implode(' AND ',$filters).$order;

Hi xavier i will try your solution thank you for you precious time and help

Hello guys!
I think that not good solution overwrite files of core

I have suggestion.

we have event 'onBeforeProductListingLoad'. And just need add more parameters that we can send in plugin.
Now we have only this:
$dispatcher->trigger( 'onBeforeProductListingLoad', array( & $filters, & $order, &$this) );

and if we add also '$select,$select2, $a, $b, $on,' then we could make this changes in plugins without changes core files

Best regards,
Alex