[Plugin: WP-Property – WordPress Powered Real Estate and Property Management] sort issue

Visit your Settings page, Developer tab, find the “Price” attribute, and check “Sortable’.

You have to specify to WPP which attributes are sortable first, otherwise it won’t include them in the dropdown, as in your case.

I’ve made price sortable and searchable but have a problem when I sort by price. I think it might be the way my SQL is configured because when in phpmysql admin if I:

SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘price’ ORDER BY ABS(meta_value) ASC

it orders by a string comparison so the table will go:

245000
25000
280000

To get a sort by numeric value I need to cast the meta_value as ABS e.g.

SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘price’ ORDER BY ABS(meta_value) ASC

oops upgrade to latest version 1.14 and this is fixed

I am having a problem with price sort. When I select price sort, the screen updates and says 0 items found. I am going to look in the mysql and see if that helps. I will update when I know more.