I have created an attribute "bestsellers" integer, and I have assigned values to that attribute in many products, only numbers.
I have enable the attribute to sort by in the front end, but, when I try to sort by bestsellers, they are not correctly ordered by bestsellers attribute, some products with value = 0 are showing between the first.
Should I do something else?, somethink like reindex?, or is cache issue.?
I've print the sql and test it on my mysql and the order is correct, but in the front end doesn't.