50% off on all items quickly?

[mmier]

I currently have 1500 products on my webstore. What I want to do to help move inventory is mark everything down by 50%. Does anyone know of a fast way to apply a markdown on price across all the items without having to re upload everything.

:huh:

[Winterchild]

quickprice update contribution

 

here

[mmier]

ok let me rephrase that, how about an SQL statement that could be entered in my phpmyadmin utility?? :blink:

 

I?m looking into the contribution, but I would think it could be done via SQL.

[♥Monika in Germany]

ok let me rephrase that, how about an SQL statement that could be entered in my phpmyadmin utility?? :blink:

 

I?m looking into the contribution, but I would think it could be done via SQL.

<{POST_SNAPBACK}>

 

 

update `products` set products_price = products_price / 2

[mmier]

Monika,

 

thanks i actually tried

UPDATE products SET products_price=products_price*0.50

before i received your message and got it to work.

 

thanks for your help

[Guest]

You can also use MySQL's built-in ROUND() function as well.

 

-------------------------------------------------------------------------------------------------------------------------

UPDATE `products`

SET `products_price` = ROUND(`products_price` + ((`products_price` / 100) * percentage), 2);

-------------------------------------------------------------------------------------------------------------------------

 

Replace percentage with the desired percentage value. Then execute it against your database using phpMyAdmin.

 

 

Example:

 

Hey, the sales season is on! 50% off all products.

----------------------------------------------------------------------------------------------------------------

UPDATE `products`

SET `products_price` = ROUND(`products_price` + ((`products_price` / 100) * -50), 2);

----------------------------------------------------------------------------------------------------------------

[Guest]

Install the sale maker contribution...however, be warned it is server intensive. Other than that it works nicely...

 

Bobby