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. posts_results filter – additional sort, with a meta value, to move posts to the end of the results, with pagination working
  33. Disable emojicons introduced with WP 4.2
  34. How to remove a filter that is an anonymous object?
  35. WordPress hooks/filters insert before content or after title
  36. How to add defer=”defer” tag in plugin javascripts?
  37. add_action(), add_filter() before or after function
  38. apply_filters(‘the_content’, $content) vs do_shortcode($content)
  39. How do filters and hooks really work in PHP
  40. Trouble understanding apply_filters()
  41. What is the very earliest action hook you can call?
  42. How would one modify the filtering Gutenberg applies to pasted content?
  43. How can I modify the WordPress default widget output?
  44. Add custom options to the wplink dialog
  45. Remove classes from body_class
  46. what is __return_false in filters
  47. Explanation for apply_filters function and its variables
  48. Gutenberg: Is there a way to know if current block is inside InnerBlocks?
  49. How to reorder billing fields in WooCommerce Checkout template? [closed]
  50. Insert HTML just after tag
  51. the_content and is_main_query
  52. Changing WooCommerce Display Price Based on User Role & Category [closed]
  53. How to add a custom CSS class to core blocks in Gutenberg editor?
  54. How to show page content in feed?
  55. wp_headers vs send_headers. When to use each?
  56. Filter any HTTP request URI?
  57. How to Pass External Variables to Filters/Actions
  58. How to filter users on admin users page by custom meta field?
  59. Filter by one custom field, order by another?
  60. Not able to change wp_title using add_filter
  61. How to appending to the_content using add_filter with custom post type?
  62. Query WP REST API v2 by multiple meta keys
  63. No filter of code on switch from html to visual editor, how?
  64. Sanitize and data validation with apply_filters() function
  65. How to modify posts_where filter only for the search query
  66. How to hook a filter to catch get_post_meta when alternate a custom field output?
  67. How to get shortcode’s input values inside a filter?
  68. Removing Image and Caption Dimension Attributes
  69. How to wrap oEmbed-embedded video in DIV tags inside the_content?
  70. How to bulk delete all users with no posts?
  71. How many filter/action hooks are healthy?
  72. WordPress 3.9 – Trouble Editing TinyMCE 4.0
  73. Changing JPEG compression depending on image size
  74. How to add filter with 2 args?
  75. Why is javascript allowed in my post content?
  76. How to use update_{$meta_type}_metadata filter to modify meta value
  77. How to wrap an element around an iframe or embed in content automatically?
  78. Filter specific shortcode output?
  79. WordPress Internal @ Mentions
  80. How to add headers to outgoing email?
  81. Earliest hook to reliably get $post/$posts
  82. Insert new element to array with add_filter
  83. LESS CSS enqueue_style with add_filter to change rel attribute
  84. Is it possible to filter comments in a post so a user can only see the comments they have written?
  85. Remove Editor From Homepage
  86. How to modify Contact Form 7 Success/Error Response Output [closed]
  87. Where to hook into post content?
  88. What does (10, 2) mean when used with add_filter
  89. Filter translations (gettext strings) on specific admin pages
  90. Filter username field on registration for profanity and unwanted words
  91. Clarification on filters and hooks
  92. remove_filter( ‘the_content’, ‘wpautop’ ); only for certain post types
  93. At what priority does add_filter overwrite core functions?
  94. Valid characters for actions, hooks and filters
  95. is it possible to add “extra” table nav to edit-tags.php screens?
  96. Advanced Custom Fields and Yoast SEO keyword analysis [closed]
  97. Adding a filter to qTranslate to change display of language chooser
  98. Custom sortable columns ordered by meta-value?
  99. Insert Custom HTML After Shortcode
  100. Modify links when inserted by WYSIWYG editor
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)