Sorting products by price ( regular + sale price )

When your are updating your product regular price is saved to _regular_price and sale price is saved to _sale_price meta_key. Also WooCommerce will figure out which is the current price sale or regular and will save it to _price meta_key. There is no need to sort products by two _regular_price and _sale_price meta_keys. Your current prices should be stored in _price meta_key and this key should be used to sort products by price.

Try to investigate your SQL $query->request and database records to figure this out.

Keep in mind that if your sale price is scheduled you have to make sure that WooCommerce cron jobs are working correctly to update _price meta_key.

Related Posts:

  1. How to pass/get data to/from the WooCommerce data-product_variations object?
  2. Filter hook before create order WooCommerce
  3. Display WooCommerce newest product reviews on top [closed]
  4. How to change Woocommerce breadcrumbs content?
  5. Add Dropdown menu using “add_filter => wp_nav_menu_items”
  6. Search results sorted by post types
  7. Why anything done on comments_array hook gets reset?
  8. Filter category in WooCommerce shop page to display related sub-category
  9. How to change currency programmatically on creating order action?
  10. Sorting and limitation with pre_get_posts
  11. Redirect to checkout woocommerce failed
  12. Filter the regular price of woocommerce products
  13. Filter Media by Featured on Admin
  14. WooCommerce sort products by the actual product width(not the shipping width)
  15. Adaptive product filters for WooCommerce
  16. Add default user field to WooCommerce checkout [closed]
  17. Link to Shop-Filter with .current-menu-item
  18. Adding a Clone link to product attributes – post_row_actions() filter, or how to override a Class question
  19. Woocommerce “added to cart” message on main(home) page
  20. Replacing a deprecated filter ‘woocommerce_get_price’ with ‘woocommerce_product_get_price’
  21. Woocomemrce order and registration fileds to UPPERCASE
  22. Redirect to woocommerce checkout after adding to cart – item already in cart
  23. WooCommerce coupon hook argument NULL when using filter woocommerce_get_shop_coupon_data
  24. How to access page variable inside action hook
  25. Drop down filter sort posts by latest, last 7 days and monthly
  26. how to develop a filter in wordpress to let the user filter the page content depends on the date (newest to oldest etc…)?
  27. Put data in my-account/view-order/id/ page
  28. Modify WooCommerce email shipping text value
  29. Filter and Search
  30. WooCommerce comments_template Filter Not Firing
  31. Woocommerce: Only one review per verified buyer [closed]
  32. How to remove a filter that is an anonymous object?
  33. No filter of code on switch from html to visual editor, how?
  34. How to modify posts_where filter only for the search query
  35. How to wrap oEmbed-embedded video in DIV tags inside the_content?
  36. How to add filter with 2 args?
  37. Adding revision support to WooCommerce product content
  38. Changing text within the Block Editor
  39. Search content for shortcodes and get parameters
  40. How Can I Have A URL Changed Based on the Originating URL?
  41. Is it possible to Hook/Filters Attachment Creation?
  42. Apply the_title filter to post titles AND backend auto social-sharing plugin, but not nav menu
  43. Hide some items from Screen options in dashboard for products
  44. How to hook some Unicode texts into calendar widget safely?
  45. How to add attributes to tag when template cannot be directly modified
  46. how to remove filter from wordpress shortcode output
  47. Change email from and display name with a filter action
  48. Reverse engineering of WooCommerce Storefront filters
  49. Edit pagination text in the get_the_posts_pagination function
  50. How to center oEmbedded content
  51. When adding buttons to the tinyMCE editor, how do I make them wrap to the next line and/or display in the “Kitchen Sink” area?
  52. Add Sortable Column For All Post Types
  53. How to change the order of HTML output of a core block?
  54. How to add ‘total’ value to custom column title on the posts list page
  55. When to use add_action when registering/enqueuing scripts
  56. Is it possible to use multiple spaces in title?
  57. add_filter(allowed_block_types) -> adding core/paragraph bugs Gutenberg editor
  58. How to remove medium size class in gravity form for input tag?
  59. Filter out comments with certain meta key/s in the admin backend
  60. HTML and custom field variable, inside variable
  61. WordPress custom admin notice still displays after wp_insert_post_data validation
  62. Custom wp_query time filter on meta_value
  63. get post id within add_filter()
  64. Run posts_where and posts_join only on the main query
  65. Media upload default title from file name
  66. run shortcode in excerpt of single custom post type
  67. Use of comment_reply_link_args filter
  68. Shortcodes within the sidebar text/html widget: How to preserve the raw HTML output of the shortcode?
  69. WordPress removing slashes from shortcode output
  70. when use function the_content break
  71. Filter page title (displayed in browser tab) of wp-login
  72. Adding html banner to posts
  73. How does wordpress add ‘style’ attribute to element
  74. output custom Posts on a Page
  75. Filter “Your latest posts”
  76. Hide certain product filters from specific product categories
  77. Hooked into wp_get_attachment_caption to add content to the default description; not working for jetpack slideshow. Why?
  78. How sort products by calculate value? ( custom post meta, price, option)
  79. Add an attribute to the root from functions.php with add_filter
  80. Would like to use hook or filters to customize email templates
  81. Removing menus from users other than the administrator
  82. Override woocommerce loop-start.php from theme using plugin?
  83. Can’t understand apply_filter logic
  84. Overriding Plugin function in your child theme
  85. Modify oembed code conditionally
  86. How can I add a prefix to titles displayed in sidebar using function.php?
  87. Modify Default URL for /wp-includes/js/wp-emoji.js?ver=4.6.1
  88. List all image sizes still getting disabled sizes
  89. Why this remove empty paragraphs from the_content does not works?
  90. wp_editor customization
  91. What problems could happen if I replaced add_filter and add_action with the function calling
  92. posts_results filter function memory errors
  93. Custom Search Template for Custom Post Types
  94. Adding to an array & passing it through do_action/apply_filters
  95. Loading a sidebar on an Ajax call
  96. the_excerpt() does not work with has_excerpt()?
  97. Custom excerpt_more filter not working when tag is present
  98. Taxonomy search filters
  99. How do you disable the verification process of user email changes?
  100. Modify the third (context) parameter in a filter?
tech