Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts

: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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...