outblast Posted January 30, 2012 Share Posted January 30, 2012 How can i change the layered block features sort by the value of the feature and not by the id? If i have: 11mm 12mm and i make one new feature 10mm this will appear afther 12, i whant to appear in front of 11 TXS Link to comment Share on other sites More sharing options...
outblast Posted February 11, 2012 Author Share Posted February 11, 2012 no one knows? Link to comment Share on other sites More sharing options...
doubleD Posted April 1, 2012 Share Posted April 1, 2012 How can i change the layered block features sort by the value of the feature and not by the id? If i have: 11mm 12mm and i make one new feature 10mm this will appear afther 12, i whant to appear in front of 11 TXS Hi, To sort features by name: In blocklayered.php find $sqlQuery['group'] = 'GROUP BY fv.id_feature_value '; Replace with $sqlQuery['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; And it works ) That's for prestashop 1.4.7 and block layered 1.8 I guess it'll work for 1.4.6.2 also Link to comment Share on other sites More sharing options...
outblast Posted April 1, 2012 Author Share Posted April 1, 2012 Hi, To sort features by name: In blocklayered.php find $sqlQuery['group'] = 'GROUP BY fv.id_feature_value '; Replace with $sqlQuery['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; And it works ) That's for prestashop 1.4.7 and block layered 1.8 I guess it'll work for 1.4.6.2 also Txs, works fine Link to comment Share on other sites More sharing options...
outblast Posted April 5, 2012 Author Share Posted April 5, 2012 I just made the update to version 1.4.7.2 block layered v1.8.2 and the modification are not working, if u find the solution when u make the update pls. post here.\ TXS Link to comment Share on other sites More sharing options...
doubleD Posted April 5, 2012 Share Posted April 5, 2012 I just made the update to version 1.4.7.2 block layered v1.8.2 and the modification are not working, if u find the solution when u make the update pls. post here.\ TXS Well, I have v1.8.2 blocklayered and prestashop 1.4.7.0 and it works fine lines 2633,2644 of blocklayered.php. $sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; Link to comment Share on other sites More sharing options...
outblast Posted April 10, 2012 Author Share Posted April 10, 2012 Well, I have v1.8.2 blocklayered and prestashop 1.4.7.0 and it works fine lines 2633,2644 of blocklayered.php. $sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; Now its working, TXS Link to comment Share on other sites More sharing options...
Mike Kranzler Posted April 10, 2012 Share Posted April 10, 2012 Thanks DoubleD! I'll go ahead and mark this thread as solved for you. Happy selling! -Mike Link to comment Share on other sites More sharing options...
outblast Posted May 23, 2012 Author Share Posted May 23, 2012 (edited) For blocklayered v1.8.5 the corect code is: $sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; $sql_query['group'] = 'GROUP BY fv.id_feature_value ORDER BY fvl.`value`, fl.`name` ASC'; Edited May 23, 2012 by outblast (see edit history) Link to comment Share on other sites More sharing options...
buhajus Posted July 16, 2013 Share Posted July 16, 2013 I got problem with feature value name sorting... Any got a solution PS 1.4.9.0 blocklayer 1.9.1 Link to comment Share on other sites More sharing options...
YellowDuck Posted August 1, 2015 Share Posted August 1, 2015 Please How change the layered block features sort by the feature by the id? ver 1.6.1 default by alphabet Link to comment Share on other sites More sharing options...
Recommended Posts