[Solved] Attributes alphabet order

[jeff8899]

anyone knows to change the attributes sort order to alphabet????

Edited February 14, 2017 by jeff8899 (see edit history)

[JeredBolton]

You could override the getAttributesGroups function in classes/Product.php so you can change how the attributes are ordered:

 

At present it orders by:

ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC'

You could change this to:

ORDER BY ag.`position` ASC, agl.`name` ASC'

so that it ignores the position of the attributes in a group and just orders them by name.

[jeff8899]

Hi, JeredBolton

 

the order has changed but it still not in alphabet order.

any idea???

 

thanks

[jeff8899]

Thanks JeredBolton given me the idea!

 

after play around with the sort function, i finally got what i need.

 

ORDER BY ag.`id_attribute_group` ASC, al.`name` ASC';

 

the attribute group name sort by id, and its value sort by alphabet.