ordering products on listing page

-- HikaShop version -- : latest
-- Joomla version -- : 3.5

Hallo.

I want to order my products on the product listing page by:

1st criteria
product_created (first the newest product) --- Does not work because when i modify an old product i puts on first place

2nd criteria
product_quantity is not 0 --- if there is no item on stock i need on after all available products (i want them to be still in the listing but in the end)

is there a solution ?

Thanks for your reply

Hi,

You can potentially set the menu/module ordering option on "product_created" field and set an ascendant ordering.
Then use this kind of code to put the products with a 0 quantity at the end of the listing:

$emptyRows = array();
foreach($this->rows as $k => $row){
	if($row->product_quantity == '0'){
		$emptyRows[$k] = $row;
		unset($this->rows[$k]);
	}
}
foreach($emptyRows as $emptyRow){
	array_push($this->rows, $emptyRow);
}

foreach($this->rows as $row){

Thanks for your quick and detailed answer.
I will try your solution and come back to give detailed feedback.

Thanks for your quick reply and for the solution i will try it and get back to give feedback.

nicolas wrote: Hi,

First, regarding the product_created column, I don't see why that would happen. It definitely doesn't on our end. It's the product_modified column which is updated when you update the product information.

nicolas wrote: Hi,
First, regarding the product_created column, I don't see why that would happen. It definitely doesn't on our end. It's the product_modified column which is updated when you update the product information.

CONCAT(IF(`product_quantity`=0 ,'8','9'), CAST(product_created AS CHAR))