CODEWITHSUNDEEP
phpmysqlwordpresswoocommerce
gargi
gargi

Reputation: 259

Round up prices in woocommerce

I have a Woo-commerce site, in which there are lots of products with 95 / 99 cents in the price (like 3.99). I need to round up all of the 95 and 99 cents (like 3.99 => 4.00).

Is there a way to bulk update it all in once with sql function?

tnx ahead

Upvotes: 0

Views: 5078

Answers (2)

AndreVitorio
AndreVitorio

Reputation: 930

You can easily do that by setting the number of decimals to 0 at WooCommerce > Settings > General > Number of decimals

Upvotes: 2

Mark Miller
Mark Miller

Reputation: 7447

UPDATE table SET col=CEIL(col)

Upvotes: 2

Related Questions