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. How to check if is in cart page? [closed]
  4. Display single product attribute value on Shop page (Woocommerce)
  5. Is it possible to add custom fields to a WooCommerce attribute term? [closed]
  6. Woocommerce 3.1 Add product image to order confirmation email not working
  7. Woocommerce: show default variation price is products list?
  8. Button to update order status Woocommerce with WC Marketplace
  9. WooCommerce add_to_cart url not working [closed]
  10. WooCommerce: display text instead of raw checkbox value email
  11. How to Add Product Variation with Multiple Images via WooCommerce REST API
  12. How to build wordpress site which will have location based services & products?
  13. How we can edit variations on cart page? [closed]
  14. new WC_Order(); Coming Back Empty
  15. Is there any way to find which action/hook is fired?
  16. Redirect user after login through woocommerce login page to page with his/her username?
  17. WooCommerce restore stock on order cancel
  18. Woocoomerce product category count including subcategories
  19. WooCommerce single products images doesn’t zoom on hover and doesn’t change clicking on gallery
  20. Get the category ID in checkout page woocomerce
  21. “Cannot read property ‘replace’ of undefined” Javascript error when trying to add attribute terms from add product page [closed]
  22. Order list woocommerce Orders based on meta for custom status
  23. WooCommerce product taxonomies and menu export
  24. Javascript / Ajax Error After Migrating To New Domain Name
  25. How can i stop woocommerce checkout event based on api request result?
  26. WordPress Twenty Seventeen header image size not responsive for mobile
  27. WooCommerce back-end very slow takes 10 seconds to load, slow queries
  28. Woocommerce custom meta fields, sort by date
  29. WooCommerce hide unexisting variations
  30. How can I change the functionality of breadcrumbs?
  31. Variation name in $product->get_name()
  32. jquery.validation.js is not working in woocommerce checkout page form
  33. How do I group product variations on cart page (Woocommerce)?
  34. multi-vender wooCommerce ability to separate products based on zip code [closed]
  35. Hide account tab to certain users
  36. How to Update the Order-Items While Editing an Order on the WooCommerce Admin Order Screen [closed]
  37. how to remove or disable woocommerce order review in checkout page?
  38. I want to run a script only once on a ‘thank you’ page
  39. search customers in front end by billing data
  40. Is it safe to have 2 mysql users?
  41. WooCommerce – Add product with image via REST API
  42. How to set a default value in a meta box
  43. Can I have one picture for all sizes in a product with Woocommerce?
  44. Adjust Price Display for Variable Product in Woocommerce [closed]
  45. Woocommerce password Reset
  46. Unable to pull in custom product attribute in shortcode [closed]
  47. Woocommerce redirect “add to cart” button to a contact form with product information to get a inquiry
  48. How to remove WooCommerce Plugin some specific features [closed]
  49. How to remove product attribute row woocommerce using code
  50. How it it possible to disbale all WooCommerce scripts and styles, but keep wc-ajax=get_refreshed_fragments working? [closed]
  51. override the default WooCommerce products search form
  52. How can I override wp_price woocommerce function in my theme
  53. Woocommerce : read [max_qty] using backorder
  54. Is there any way to pro-grammatically create product categories and assign thumbnails in PHP and WooCommerce?
  55. Append woocommerce category to product title globally? [closed]
  56. Conditionally run function based on custom meta value?
  57. Woocommerce checkout required field error
  58. Setting a default variation for each product on the child theme functions.php file
  59. Issue with WordPress customize
  60. Group product by Instance ID
  61. WordPress woocommerce new order email not working
  62. WooCommerce add extra price to products by each category
  63. HTTP API CALLS issue on Woocommerce WordPress
  64. Syncing WP Database Changes Between Environments: How To Handle Merging w/o touching database
  65. Show shipping class in admin order list
  66. One Time Access URL after purchasing subscription
  67. How to fetch WooCommerce products with 50% discount?
  68. Anonymous users can not access website
  69. Woocommerce digital download not working – database error Cannot add or update a child row: a foreign key constraint fails [closed]
  70. when product out of stock single page show button notify woo-commerce
  71. WooCommerce , Auto cancel orders status from processing after X days
  72. Change WooCommerce Word “Product” to Another Word
  73. How does a WooCommerce site integrate with the existing real world customer members?
  74. How can I send information when a order is completed to my own POS?
  75. How to save order item custom attributes save into custom table
  76. Manually create an order with a product ID woocommerce
  77. How to filter result set in custom metaboxes?
  78. How to change lost password email text using custom plugin wordpress?
  79. wc_mail in foreach loop is sending only the first email
  80. How to fix: “The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.” after malware cleaning
  81. How to hide / remove duplicated Woocommerce products from Shop page
  82. How to add product variations for large number of products in WooCommerce?
  83. Disable Woocommerce main shop page, but not the product category archive pages
  84. Woocommerce Languages Files
  85. How to adjust Related Page Thumb Sizes on single page?
  86. How to store ACF from product in user_meta?
  87. Changing second user role while updating/downgrading membership level – s2member [closed]
  88. How to edit the header banner in the search page in woocommerce?
  89. How can I display one product using WooCommerce
  90. How do I change the woocommerce product gallery to show all thumbnails instead of three at a time in a carousel?
  91. How to edit schema.org markup of WooCommerce?
  92. Turkish Character Problem on mailing
  93. WooCommerce: Order Details Table > Add Product Meta
  94. Override function
  95. How to change redirect code? [duplicate]
  96. How to disable schema from Wocommerce? [closed]
  97. error 500 in Back Office when using a woocommerce function in functions.php
  98. How to update all products with same SKU prefixes when updating stock with CSV?
  99. What is the best and cheapest way to generate dashboards about conversions data and store users? [closed]
  100. Sort by price when price is set in multiple keys