Problems with Sort by Price

[JohnBoyCR]

Linda,

I don't know if this is significant, or not, but when I am in the
admin, the sort by price works correctly. It is only in the store that
it does not.

Also, as I stated earlier, some categories do sort correctly in the store. Seems to be categories that have very few products that
work, but not ALL categories with only a few products. Seems a bit strange to me.

Also, I did a check on the two MySql tables that I thought would be relevant to the problem ( zen_products and zen_products_to_categories ) and I do not see anything out of order.

It would seem to me that if it were a database corruption issue that the problem would also manifest itself in the admin.

I really appreciate your taking the time to help me on this.

John