Quick way of reducing all product prices.?

[Mark-UK]

Just wanted to test somethings on my UK site and i was wondering is there a quick way to reduce all your products prices by a certain amount say 10%. Or even at checkout take off a percent of the total costs, I know theres a contribution for this but ive heard its quite big and takes a while and i don think im that advanced yet in oscommerce. I wanted to try and start something tonight perhaps.

 

?

 

Thankyou

[RyanSmith]

Just wanted to test somethings on my UK site and i was wondering is there a quick way to reduce all your products prices by a certain amount say  10%. Or even at checkout take off a percent of the total costs, I know theres a contribution for this but ive heard its quite big and takes a while and i don think im that advanced yet in oscommerce. I wanted to try and start something tonight perhaps.

 

?

 

Thankyou

<{POST_SNAPBACK}>

 

 

All products reduced by 10%: open up mySQL

 

UPDATE products SET products_price = products_price * .9;

[Mark-UK]

Sorr I DONT UNDERSTAND WHAT YOU MEAN i DO, SORRY.

[RyanSmith]

Sorr I DONT UNDERSTAND WHAT YOU MEAN i DO, SORRY.

<{POST_SNAPBACK}>

 

Open up the MySQL command line prompt. This should be located in the bin directory of where you installed mySQL. From there it will ask you for you password. Enter it and type:

 

USE oscommerce;

 

or whatever you named your oscommerce database.

 

Next type:

 

UPDATE products SET products_price = products_price * .9;

 

This should make all products 90% of what their previous price was.

[glamourfish]

this is more or less what I need to do as well but I don't know where to look for this.....? any advice?

 

or is there some contribution where one can apply a discount to EVERYTHING andinclude & start & end date & time?

[glamourfish]

sorry...how do you make it full price again?

[warleb]

sorry...how do you make it full price again?

 

* 1.10

[glamourfish]

thanks I just firgured that out! simple maths eh? ;-)

 

so just incase anybody else needs to do it with any other values - this might help...I HOPE!

 

UPDATE products SET products_price = products_price * .9;

 

 

 

to reset invert it.

 

 

eg:

 

new price = old price x 0.9

old price x 0.9 = new price

old price = new price / 0.9 ---------------------------> (0.9 = 90/100)

old price = new price x (100/90)

old price = new price x 1.111111

 

 

 

 

 

run new query as before but with new value:

 

 

UPDATE products SET products_price = products_price * 1.11111111;