Help!!!! How to I set product prices to default in the website

[Abdul]

:huh: Please help...

 

I have a website from os commerce, and I was updating th prices of my products, one by one, when I realized I could do a fixed percentage on all the products, well........., I forgot I had gone and cahnged the prices of half of the product when I decided to change all the products by a fixed percentage which is when I realized that It messed up all the prices I had messed with already, so

 

Is there any way to set all the prices to default, because i don't know what they were to set them back to original price?

 

Any suggestion will help....thanks..because I'm in the dark right now

[Guest]

Go in to the SQL DB, and execute some code that replaces the value used for % method with value used for normal mode.

 

Such code:

 

update products

set description = replace(description,'the phrase','')

where description like '%the phrase%'

 

Note: This code currently updates certain text in the description, but change the table name maybe and column names and should work all the same!