Issues With Sorting Products By Custom Fields

  • Posts: 2
  • Thank you received: 0
8 years 10 months ago #254477

I have a custom field I need to sort by which is a number with a decimal. I am unable to get any products to display. See link below:
www.juicy.deals/hot-deals

Please Log in or Create an account to join the conversation.

  • Posts: 84424
  • Thank you received: 13720
  • MODERATOR
8 years 10 months ago #254503

Hi,

The sorting is done alphabetically by MySQL.
If you want to change that, you need to go in your MySQL, edit the table hikashop_product and change the type of the column corresponding to your custom field to a "decimal" instead of a text.

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum