Order posts by price

You are storing your “price” (apparently) as human readable formatted currency. That makes it a string. And that means it is going to be sorted alphabetically, more or less, and not numerically as you need it to be. If you can store those values without the punctuation, and use meta_value_num— your second query above (but I am not sure you need the “+0”) — I think you will have what you want.

Related Posts:

  1. Sort on meta value but include posts that don’t have one
  2. Using Orderby and meta_value_num to order numbers first then strings
  3. multiple orderby in pre_get_posts action
  4. get_the_terms in descending alphabetical order
  5. next and previous post link ordered alphabetically
  6. Order posts by meta_value even if meta_key is not filled
  7. Order by first name
  8. How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?
  9. the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
  10. Sorting Attributes order when using get_the_terms
  11. How to order posts by meta value?
  12. How Do I Order Posts by Modified Date? [duplicate]
  13. Orderby Post Views
  14. How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
  15. How to order posts by alphabet with numbers at the end
  16. Best Plugin to Reorder Post Types
  17. Ordering system through WordPress
  18. Issue with multiple orderby values
  19. get_query_var returns wrong default value
  20. Use pre_get_posts to sort meta_key by an array of values
  21. Show first the posts from 1 specific tag
  22. All, published and pending order
  23. get_adjacent_post() returning weird results
  24. Get_Users Orderby Page
  25. Sort order of next/prev sibling page
  26. Order char by post title
  27. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  28. next_post_link and previous_post_link order not working properly
  29. query pages by a childs publish date
  30. List most recently added posts (with a twist)
  31. Check post_date in pre_get_posts
  32. pre_get_posts shows posts in random order sometimes
  33. Featured-Content/Featured Posts With Random Order
  34. Orderby in Query Posts affected by operating system?
  35. Ordering posts by title containing numbers
  36. Stylesheet Enqueue Order and Best Practices
  37. wp_list_pages sort order by top nav menu order and child of
  38. How to display taxonomy terms the way they are hierarchical
  39. wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
  40. Order by ASC, DESC, Title, Date from URL on custom page template post
  41. Offset posts with random order
  42. view subcategories order by id
  43. Sort query output on taxonomy term archive by post type using pre_get_posts
  44. ASC and DESC separately from orderby
  45. Order WP_Query by The Order of an Array in Tax_Query
  46. struggling to order by title
  47. Order by two meta values – one is a number and the other is text
  48. Last post sorting get_categories
  49. Sort by DESC works, ASC doesn’t?
  50. Shop sends Mail with order cancellation
  51. List of terms in alphabetical order under the respective initial letter and within columns
  52. update_post_meta saves data but does not show in Order backend
  53. Changing cache update rate
  54. how to complete order status automatically after paypal payment received
  55. Order management including recurring orders on woocommerce
  56. Orderby Title not working
  57. Sort loop by title doesn’t sort single digits like human would
  58. Sort posts by meta value with get method
  59. How to order custom user list columns by datetime?
  60. Creating a post that contains a list of other posts like a table of contents
  61. Want to order by Meta Values (tweaking Post Order Widget)
  62. Changing posts order on a page
  63. Ordering Subcategories
  64. How to order posts by parents?
  65. single post navigation order (NOT chronological)
  66. Problem with meta_value order after update
  67. Random order of posts on each request
  68. How can I make have_posts() return posts ordered DESC by id?
  69. Add post order like page order
  70. Woocommerce Pre Orders view order link wrong [closed]
  71. How to make WordPress orderby work with post_excerpt column?
  72. Orderby with menu_order and title
  73. Sort wordpress posts by facebook likes [closed]
  74. Sorting by date not working?
  75. WP_Query – Order results by meta value
  76. Adding ‘menu order’ column to custom post type admin screen
  77. Is it possible to paginate posts correctly that are random ordered?
  78. Custom post type – order field
  79. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  80. WP_Query orderby post__in remains ineffective in the Loop [closed]
  81. How to Change Order of Posts in Admin?
  82. WP_Query orderby date not working
  83. Get current menu_order
  84. ORDER BY custom field value
  85. Order by optional meta key?
  86. Sorting: custom query with orderby meta_value_num THEN by title
  87. Order by DESC, ASC in custom WP_Query
  88. Order get_terms using a Custom Field
  89. WP_Query order by multiple meta keys & fields
  90. Displaying a custom post type alphabetically
  91. alphabetically order role drop-down selection in dashboard
  92. Order tags, but not alphabetically
  93. Different post sort order within different categories
  94. Order by & include array by specific post ids
  95. Sort posts by Date (DESC) and by Title (ASC)
  96. Order get_terms() By Custom Field
  97. How to Change the Categories Order in the Admin Dashboard?
  98. what types of order can I pass to get_posts() via orderby?
  99. Secondary Sort (fallback) for WP_Query
  100. Query Posts in a Predefined Order
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)