brand order

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6.0

I created a Brand filter in my category pages. How can I arrange the brands alphabetically whithout doing it in admin?
I have hundreds of brands always changing it will take

Hi philip,
this is a page of my site.
if you click 'marca' filter you can see brands are not alphabetically ordered
www.uniontrade.info/prodotti-etnici-da-t...-il-mondo/alghe.html

if I arrange the brands in back end the order change in filter and all is ok but
since in admin there are something like 200 brands always changing I'm searchin a way the filter automatically order names alphabetically.
I hope I've been more specific now.

thank you!
elena

Hi,

You will have to edit the file "administrators/components/com_hikashop/classes/filter.php" and in the function "getManufacturers()" replace the line:

$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!=\'1\' '.$optionElement.' AND a.category_published=1 ORDER BY a.category_ordering ASC';

$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!=\'1\' '.$optionElement.' AND a.category_published=1 ORDER BY a.category_name ASC';

THANK YOU SO MUCH!!!!!!!!!!
THAT'S PERFECT FOR ME.

how to sort brands alphbetically in hikashop. i have show in this format whats the solution to sort in alphabetically.