change query products-list

[freelance84]

Hello,

 

where can i change query where products-list.tpl iterate on it?

 

Thanks

[Paul C]

It really depends on what you want to do.....

 

Which version of Prestashop are you using?

 

In 1.5 There's a hook in the CategoryController called in assignProductList():

 

actionProductListOverride($params)

 

The keys to the $params array are: nbProducts(integer), catProducts(product array) and hookExecuted(bool)

 

Or you could look at the Product class and override the getProductProperties() method.

[freelance84]

It really depends on what you want to do.....

 

Which version of Prestashop are you using?

 

In 1.5 There's a hook in the CategoryController called in assignProductList():

 

actionProductListOverride($params)

 

The keys to the $params array are: nbProducts(integer), catProducts(product array) and hookExecuted(bool)

 

Or you could look at the Product class and override the getProductProperties() method.

 

Hello Paul,

 

I want only add a condition in query for extract distinct value for column "name".

I'm using version 1.5 and i will try your suggests.

[Tung at RockPOS.com]

Hello,

 

There are 2 options:

1. Override class Category::getProducts()

2. Create a new module, and add hook "actionProductListOverride". In this hook method, just copy function Category::getProducts() and apply your change.

 

It depends on you to select one of them.

Cheers,