Orderby custom meta returns random order

I also added this here for someone else having same issue.

If your meta values are numeric then you should use orderby meta_value_num instead of meta_value.

As mentioned in codex.

  • meta_value – Note that a meta_key=keyname must also be present in the query. Note also that the sorting will be alphabetical which is fine for strings (i.e. words), but can be unexpected for numbers (e.g. 1, 3, 34, 4, 56, 6, etc, rather than 1, 3, 4, 6, 34, 56 as you might naturally expect). Use meta_value_num instead for numeric values.

  • meta_value_num – Order by numeric meta value (available with Version 2.8). Also note that a meta_key=keyname must also be present in the query. This value allows for numerical sorting as noted above in meta_value.

Related Posts:

  1. Meta_query compare operator explanation
  2. Exclude post ID from wp_query
  3. Can I force WP_Query to return no results?
  4. paginate_links() adds empty href to first page and previous link
  5. Get array of posts from the current archive page loop
  6. Custom query incorrectly returning everything [closed]
  7. Last post ordered by publish date using WP_Query on front page
  8. Meta Query with date and time on the same Day before given time
  9. In loop: posts have thumbnail AND other variables
  10. How to grab metabox value in wp_query meta_query key
  11. Add inline HTML to posts published within last 24hrs
  12. Add and in the header while looping over custom query in page template
  13. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  14. Single page theme
  15. Pagination not working on static page
  16. WordPress pagination link always leads to home page
  17. Query posts with more than 20 comments
  18. Can certain (site-crashing) limitations on WP_Query in shortcode be overcome?
  19. Get array of current post term ID’s
  20. Including only current user’s posts in search
  21. Implementing an OR statement to wordpress wp_query
  22. How can i simulate “taxonomy__in” in query?
  23. Refine search results using WP_Query
  24. query_posts: how to show all ‘meta_value’ containing a specific word?
  25. How to show subcategories using loop?
  26. Minimize database queries to user tables?
  27. add_filter() depending on search term
  28. Get all products which have both product category
  29. How to make Meta Query case sensitive?
  30. Populate tax_query terms parameter with post term
  31. Orderby the sum of several numeric custom meta fields
  32. Fastest way of counting posts of a custom post type in a specific taxonomy term?
  33. wp_query ‘s’, search filter with pagination is not working
  34. Why is wp_query causing an uncaught error to is_user_logged_in() not defined?
  35. Modify wp-query and sort by post meta key
  36. WordPress query with items from more than one selfdefined taxonomy as `term` argument
  37. How to display an other custom post type in a different custom post type’s archive?
  38. Replacing raw database query to WP_Query
  39. How to alter local query, not main query [duplicate]
  40. WP CLI can’t delete plugin related table
  41. Inserting HTML to close and open divs in WP_Query loops
  42. Change query from cat id to slug or name?
  43. Query only the posts with a post format of “audio”
  44. Display Current Post’s Position in Custom Taxonomy
  45. Using Wp_Query without the loop?
  46. WP Query with multiple tags by get the tags
  47. infinite loop in wp_query using simple query
  48. Custom WP_Query id
  49. Woocommerce pagination and result count after custom loop
  50. Parent and child categories
  51. Set post number to single posts
  52. Easy way to write complex queries in wordpress
  53. Error with function in functions.php?
  54. I am having problem sorting custom post type using WP_Query
  55. difference between querying database and using the loop
  56. Query_vars support in Rest API
  57. How to do logical OR in terms in WP Query?
  58. Continue or break the while loop
  59. Custom query filter by ACF date custom field
  60. Child pages not affected by orderby
  61. Write WP Query that selects posts that are part of the same two categories
  62. Error in meta_query not get result
  63. Sorting posts by Multiple custom fields in defined order
  64. Custom wp_query – I’m getting ‘all’ post, not the specific post in the query
  65. Phpmyadmin – post editing
  66. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  67. Query not sorting DESC
  68. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  69. Filter products on category AND tag
  70. create a custom query for posts managed by Restrict Content Pro
  71. meta_query – check for multiple meta values in key which holds an array of values
  72. How to sort wordpress posts already selected by WP_QUERY
  73. How do I stop the same post showing multiple times in a archive?
  74. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  75. WP_Query on custom key and value
  76. Set “editor” role to existing user
  77. how to get wp_query posts only first letter of alphabet A?
  78. How to mix two orderby-parameters into one ordered result
  79. Custom Post Type WP_Query with filters and search
  80. Merge wp-query and get_users
  81. Get posts by similar names and categories
  82. Query by meta value (add a dropdown of all values)
  83. WP Query issue for multiple values
  84. Calling a function with WP_Query only ever brings the first result
  85. get last child post by wp_query
  86. How To Query All Attachment Images Found In Post Galleries
  87. WordPress meta_query not working
  88. Create multiple sections for all categories and then queries all the posts for each of those categories
  89. Filter WP_Query output before it is accessed (pre_get_posts)?
  90. $wp_query when new WP_Query
  91. Divide WP_Query posts by date & post type
  92. Unable to pass variable
  93. WP Query get posts by specific author IDs if one of several logged in authors
  94. Edit WordPress loop, taxonomies, & filter
  95. WP query based on two meta queries
  96. WordPress website links redirect to homepage
  97. How to display posts from a specific term first then another posts from another terms using tax_query
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. List categories using WP_Query
  100. WP Query – Show custom posts only if user contain some user meta
tech