Woocommerce – how to round up all prices to end in .99

You should try to use _regular_price meta key in your SQL query.

Regular price from the admin use the value of _regular_price key while the price shown at the frontend use the value of _price key. Keep in mind that _price is the active price of the product, if the product is currently on sale then the _price will use the value of _sale_price. The value of _price will be updated daily by default WC hook cron.

Related Posts:

  1. Change WooCommerce product and variation prices programatically without affecting performance
  2. Save large WP_Query to transient === false
  3. Woocommerce – Add a product to cart programmatically via JS or PHP [closed]
  4. ( Woocommerce) How to get the user belonging to an order? [closed]
  5. Get the product list of a given Category ID
  6. How does object caching work?
  7. List of JS events in the WooCommerce frontend
  8. get woocommerce My account page link
  9. Should I use Transient API to store HTML String, or Object?
  10. WooCommerce: How to edit the get_price_html
  11. Get woocommerce product price by id [closed]
  12. Product categories don’t appear as option to build menu
  13. WooCommerce Variable Product Price not showing on single product page
  14. How to override WooCommerce template files?
  15. Is get_option() faster than accessing get_transient()?
  16. Woocommerce add extra field to variation product
  17. Cache remote (HTTP) request with Transients API
  18. Is there any danger in deleting all transients?
  19. Getting the gallery images from products in woocommerce?
  20. How to get current product category ID in product archive page
  21. Get url of product’s images (woocommerce)
  22. WooCommerce prices location in DB
  23. Best practices for using the transients API
  24. Order by rating not works in wp_query
  25. Woocommerce: How to remove page-title at the home/shop page but not category pages
  26. Woocommerce show cross sells on singe product page [closed]
  27. How to add a new endpoint in woocommerce
  28. Are there any hook or filter when refund is done through admin -woocommerce
  29. Using transients in conjunction with memcached
  30. How to check if is in cart page? [closed]
  31. Display single product attribute value on Shop page (Woocommerce)
  32. WP/WooCommerce REST API cart/checkout/order [closed]
  33. how to use wc_create_order with subscription product
  34. WooCommerce: Webhook disabled on its own
  35. Storing posts social counters by using transient api
  36. Using a wildcard with delete_transient()
  37. Share users and WooCommerce memberships between two installations
  38. Slow Loading Attribute Select – WooCommerce Backend
  39. WooCommerce: Can’t use wc_get_products for custom REST API endpoints
  40. How to change or add Woocommerce thank you page URL key content?
  41. How can I define a custom template for woocommerce [products] shortcode? [closed]
  42. How to remove an action within a class with extends
  43. single-product.php template not working for single products [closed]
  44. Insert variations via woocommerce api [closed]
  45. WooCommerce get physical store address
  46. Is it possible to add custom fields to a WooCommerce attribute term? [closed]
  47. wc_get_template_part( ‘content’, ‘product’ ) | Where is this file located?
  48. how to get woocommerce product attribute slug
  49. Correct function to get the user’s latest Woocommerce Subscription?
  50. Move payment options at checkout in WooCommerce [closed]
  51. add_filter to modify woocommerce_cart_item_name hyperlink
  52. Where do the cart details are stored in database?
  53. How to display product price of the product in loop
  54. How to disable Woocommerce password recovery and use the default WordPress password reset page?
  55. Display order items names in WooCommerce admin orders list [closed]
  56. Fragment caching increasing database queries
  57. Is it safe to delete from db orphaned posts i.e. whose post_parent no longer exists?
  58. Add custom variable to cart content [closed]
  59. Get product details by url key in WordPress woocommerce
  60. Get product link
  61. WooCommerce – Hook after Loading Variation in Admin Edit page?
  62. How to delete woo commerce order pragmatically? [closed]
  63. WordPress transients for a shortcode
  64. WooCommerce changes lost password reset link
  65. Process checkout using WC REST API
  66. How to get rid of the hover zoom in WooCommerce single products
  67. How do I display certain products via their category on a section of a page using PHP?
  68. How to turn off WooCommerce user registration and manually create accounts?
  69. What’s the difference between WC() and $woocommerce
  70. Display orders instead of woocommerce my account dashboard for logged in users [closed]
  71. Limit users to one active subscription in WooCommerce Subscriptions? [closed]
  72. Detect whether a page is a product subcategory page?
  73. Hidden woocommerce products still showing up in search results [closed]
  74. Menu not show woocommerce product category
  75. Orders being sent to wrong admin email in WooCommerce [closed]
  76. WooCommerce: add different order item meta for each item in order
  77. Remember page before login page, redirect to that page after login
  78. Woocommerce 3.1 Add product image to order confirmation email not working
  79. How to purge all transient caches?
  80. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  81. Woocommerce My Account Endpoint – how to get ID parameter from URL?
  82. Hook and send Woocommerce data after click Place Order button
  83. Woo-commerce | Disable proceed to checkout button in cart page if total in cart less than 15 [closed]
  84. Fatal Error when installing woocommerce despite upgrading
  85. Adding an action within a function that is being called by add_filter
  86. WooCommerce conditional meta query
  87. Default woocommerce placeholder image
  88. How to build a plugin that supports authenticated POST requests to the REST API from external servers?
  89. Hide certain tags on Product Edit tag cloud
  90. WooCommerce: Add New Report Tab
  91. WooCommerce Change Product Global Attribute Value via CRUD for Simple Product [closed]
  92. How to get values from woocommerce admin input fields?
  93. Is priming a Transient Cache possible?
  94. Show only geolocated user country into Woocommerce checkout country fields
  95. Search results don’t show products
  96. Optimizing Woocommerce order items query
  97. What is the right hook to use in WooCommerce for handling the post of the sale price?
  98. Should the caching of WordPress menus be specific to each page?
  99. Add a custom button with custom link after add to cart for every product
  100. How to add Woocomrce cart page shipping calculator to my country state list
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)