Find/replace prices between certain values
Posted: Mon Dec 11, 2006 5:29 am
I am trying to figure out how to find and replace prices between certain values. A couple examples:
If product price is between (including equal to) $15.25 to $19.75 then change product price to $14.00.
If product price is between (including equal to) $.75 to $.99 then change product price to $.50.
These are just listed as an example. I appreciate someone finding a solution. This is an easy thing to accomplish in a database, but I have 1000's of static web pages to update and want to avoid having to rebuild them on the system I have now (workstation was stolen in October ).
Thank you!
If product price is between (including equal to) $15.25 to $19.75 then change product price to $14.00.
If product price is between (including equal to) $.75 to $.99 then change product price to $.50.
These are just listed as an example. I appreciate someone finding a solution. This is an easy thing to accomplish in a database, but I have 1000's of static web pages to update and want to avoid having to rebuild them on the system I have now (workstation was stolen in October ).
Thank you!