Why does a manufacture whose name starts with a small letter 'a', get shown after the manufacturers whose names start with capital letter 'V' in the Extras block at the bottom of the website pages.
In the brand scroller, the listing is not case-sensitive, and "aFe Power" shows up between "Active" and "AKG". But in the link in the Extras block in the Default Page, the brand "aFe Power" is shown after the "Vorshlag" manufacturere.
This line is in the Extras block that displays them in a case-sensitive order.
Our brands
See the problem here...
https://www.harrisonmotorsports.com/index.php?dispatch=product_features.view_all&filter_id=14
Your cscart_product_features_descritpions table may have a collation that is binary versus case-insensitive (Ie. utf8_general_bin versus utf8_general_ci). You can alter the query in a hook and force it by using
ORDER BY COLLATE description ASC
COLLATE means use case-insensitive sort.
Or if you want to force it to be case sensitive,change COLLATE to BINARY
And further, if you want the grouping of things to be insensitive but want to force it to have upper before lower then you can just do a secondary sort like:
ORDER BY COLLATE description ASC, description ASC
The mySQL man pages or stackoverflow are great references for this kind of thing.
Your cscart_product_features_descritpions table may have a collation that is binary versus case-insensitive (Ie. utf8_general_bin versus utf8_general_ci). You can alter the query in a hook and force it by using
ORDER BY COLLATE description ASC
COLLATE means use case-insensitive sort.
Or if you want to force it to be case sensitive,change COLLATE to BINARY
And further, if you want the grouping of things to be insensitive but want to force it to have upper before lower then you can just do a secondary sort like:
ORDER BY COLLATE description ASC, description ASC
The mySQL man pages or stackoverflow are great references for this kind of thing.
I'm just using the CS-Cart 4.6.2 as it came out of the box, so to say...
I haven't grouped anything.
Is there a simple way to change it on the Admin side, because I'm not a developer.
In reviewing the code, it is simply sorted by 'description' with a secondary sort on 'postion'. I'm going to guess that your manufacturers all have unique position values So to get this to order in a case insensitive manner you will either have to change the 'postion' to all zeros (which you can do from the cs-cart admin panel under Products/Features) or you will have to get some help from a developer.
In reviewing the code, it is simply sorted by 'description' with a secondary sort on 'postion'. I'm going to guess that your manufacturers all have unique position values So to get this to order in a case insensitive manner you will either have to change the 'postion' to all zeros (which you can do from the cs-cart admin panel under Products/Features) or you will have to get some help from a developer.
I've always let the brands sort themselves, all the Manufacturers positions are set to zero. However, mis-spelling the manufacturer with a capital A solved the issue, without showing up on the front of the website. The alt text to the image doesn't affect the sort.
Thanks for the hint about how it sorts, it lead me to a good work around....