Layered Navigation Features

[rseigel]

I've added several new features, populated with feature values, that appear in the layered navigation block.

 

Problem is that they're not sorted alphabetically - just in the order they were created.

 

I'm sure it must be somewhere in /modules/blocklayered/blocklayered,php that I need to add an "ORDER BY ??? ASC'" - I just can't pin down where.

 

Any and all help is very much appreciated.

[Mike Kranzler]

Hi rseigel,

Please try the suggestion posted here and let us know if that works for you.

 

-Mike

[rseigel]

Tried this:

 

2724:

 

changed

 

$sql_query['group'] = 'GROUP BY fv.id_feature_value';

 

to

 

$sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.value';

 

and

 

2744:

 

changed

 

GROUP BY fv.id_feature_value';

 

to

 

GROUP BY fv.id_feature_value ORDER BY fvl.value';

 

No dice but it seems like it should work.

 

Any more ideas?

 

Ron

[Mike Kranzler]

Have you already cleared your browser cache and activated Force Compile and deactivated Cache through your Back Office under Preferences > Performance?

 

-Mike

[rseigel]

I have now.

 

Still no go.

[Mike Kranzler]

What version of PrestaShop are you using, and what theme? Can you please post a link to your site so that we can see this for ourselves?

 

-Mike

[rseigel]

1.4.8.2

 

The standard prestashop template that comes with it,

 

The easiest place to see it is http://a1webshopping.com/344-folding-knives

[rseigel]

I should add that I'm using the core mod that allows you to select more than one feature item per feature.

[Mike Kranzler]

I should add that I'm using the core mod that allows you to select more than one feature item per feature.

 

If you made core modifications, I can't guarantee that any solution I could offer will work.

 

-Mike

[rseigel]

I've gone through the changes and there aren't any database calls in the mod at all so it should be irrelevant.

[rseigel]

Sorry for all the confusion Mike. It appears like this mod may actually affect this so I've asked the question in that thread.

 

Thanks for your help.