I want to change all my prices at once

[ilsita]

Hi, I have a feeling that what I want to do can't really be done without just doing it in my csv, but thought I'd ask first...

My distributor's retail prices are figures like, "$13.17, $29.24, etc" and I'd like to round these figures off, to $14, $30, etc... It's just an aesthetic thing, I guess. For some reason, I just want to see nice clean numbers.

Can I do this in mysql somewhere, so that I don't have to open each product, change, save, open.... 12,000 times?

Thank you!

ilsita

[peytonrm]

Sure. In SQL, you can do something like this:

UPDATE products SET products_price = FLOOR(products_price);

That will always round down. You can do:
UPDATE products SET products_price = CEILING(products_price);

To round up. If you have any table prefixes, you will have to add that to the name of the table in the query obviously.

I didn't test this, so you should run it locally to check before doing it in production.

Hope that helps.

[ilsita]

Oh that's awesome. Yeah, I want to do a ceiling function... I'll give it a shot and report back.

[RodG]

It's just an aesthetic thing, I guess. For some reason, I just want to see nice clean numbers.

Can I do this in mysql somewhere

Tough question.

If you only want to *see* "nice clean numbers" then you are best off identifying *where* you want to see them and modifying the page(s) responsible for the display.

If you want to *change* the numbers, then mysql is certainly the way to go.

Personally, I'd be leaving the database itself alone, and modifying the display where needed instead. In fact zencart has code to format currencies, and rounding can be considered as just another currency 'format', No need to mess the 'accuracy' of the database for aesthetic reasons.

Just something to think about.

Cheers
Rod

[ilsita]

Personally, I'd be leaving the database itself alone, and modifying the display where needed instead. In fact zencart has code to format currencies, and rounding can be considered as just another currency 'format', No need to mess the 'accuracy' of the database for aesthetic reasons.

Just something to think about.

Cheers
Rod

Thank your for this suggestion, Rod. I'm going to look into this right now...