How do I mass edit sql values for product attributes

[Guest]

Hi All,

 

I have been looking for an answer earlier for OsCommerce to ignore the tax value for my product attributes (as I entered over 2000 by gross value, OsCommerce sees it as net, so in the front end it adds 10% ontop). Well, now I want to edit all the values, as most are +$10.00 in the back-end (and displaying as $11.00 at the front), I want to change all $10.00 entries to 9.90 (or whatever) in one massive batch edit.

 

Can someone give me the code to pull this off swiftly using my SQL?

 

Your help is greatly appreciated.

 

Cheers,

 

Richard