Ps 1.4.6.2 Layered Navigation: Sort Manufacturers Alphabetically

[Tom_Rufener]

Hi all,

 

I'm using PS 1.4.6.2 and looking for a possibility to have the manufacturers sorted alphabetically in the Layered Navigation block. At the moment, the layered navigation sorts the manufacturers according to their ID (manufacturer id), not alphabetically, which can be confusing and time-consuming for visitors and customers ...

 

Does anyone of you know a way to solve this?

 

Any help is appreciated!

~ Tom

[charlie123]

Hi all,

 

I'm using PS 1.4.6.2 and looking for a possibility to have the manufacturers sorted alphabetically in the Layered Navigation block. At the moment, the layered navigation sorts the manufacturers according to their ID (manufacturer id), not alphabetically, which can be confusing and time-consuming for visitors and customers ...

 

Does anyone of you know a way to solve this?

 

Any help is appreciated!

~ Tom

 

Hey, I'm also looking of the way to sort everything alphabetically instead of ID. Did you find out how to do this? Cheers

[JoseXXL]

Hey, I'm also looking of the way to sort everything alphabetically instead of ID. Did you find out how to do this? Cheers

 

in: /modules/blocklayered/blocklayered.php

 

replace this line:

$sql_query['group'] = ' GROUP BY p.id_manufacturer';

with:

$sql_query['group'] = ' GROUP BY p.id_manufacturer ORDER BY m.name';

 

prestashop 1.4.7.2 + blocklayered 1.8.5

[janthemanson]

Also works with PS 1.5.3.1, thanx for sharing!

[emvoo]

i can confirm it also wotks on 1.5.4

 

so its a very good job

 

thanks

[borko]

Hello! I have similar situation - http://www.onoff.rs/8-dslr

I would like to sort Megapixel filter (

Rezolucija Mpix)

by its value... Presta version is 1.4.3.

 

Thanks in advance!

[DropNix.com]

in: /modules/blocklayered/blocklayered.php

 

replace this line:

$sql_query['group'] = ' GROUP BY p.id_manufacturer';

with:

$sql_query['group'] = ' GROUP BY p.id_manufacturer ORDER BY m.name';

 

prestashop 1.4.7.2 + blocklayered 1.8.5

 

I have a problem, when I do this changes..it works on the store fine, but in back end in module tab it says:

El siguiente módulo(s) no se pudo cargar:
blocklayered (parse error en /modules/blocklayered/blocklayered.php)
blocklayered (la clase que falta en /modules/blocklayered/blocklayered.php)

 

In english:

The following module (s) failed to load:
blocklayered (parse error in / modules / blocklayered / blocklayered.php)
blocklayered (the missing class in / modules / blocklayered / blocklayered.php)

 

What I have to do?

[buhajus]

sorting by alphabet and numeric

 

$sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY ABS(fvl.value),fvl.value ASC ';

 

you are welcome

[buhajus]

I have a problem, when I do this changes..it works on the store fine, but in back end in module tab it says:

El siguiente módulo(s) no se pudo cargar:
blocklayered (parse error en /modules/blocklayered/blocklayered.php)
blocklayered (la clase que falta en /modules/blocklayered/blocklayered.php)

 

In english:

The following module (s) failed to load:
blocklayered (parse error in / modules / blocklayered / blocklayered.php)
blocklayered (the missing class in / modules / blocklayered / blocklayered.php)

 

What I have to do?

 

best way that's re-install

[Juan_Suarez]

It´s work fine at 1.5.2! Thank u

[zina]

Hi, how can I sort by position?