product specials

[Guest]

Could anyone please help me here.

 

i would like to discount my products by a certain %-is there any way this can be done across the board for all products.It gets a bit tedious doing it all one by one in the special page and then adding each item seperately.

 

would appreciate any help

 

Thanks :D

[shadow007]

Try this model:

http://addons.oscommerce.com/info/4135

You can set discount for all categories.

And backup your store before you install it.

[nimz]

another way would be to run this sql statement in phpmyadmin or any other database manager:

 

UPDATE products
SET products_price = products_price * 0.75

 

the above discounts all products prices by 25% so change the 0.75 to whatever you want accordingly.

 

BACKUP FIRST!

[Guest]

Try this model:

http://addons.oscommerce.com/info/4135

You can set discount for all categories.

And backup your store before you install it.

hi

 

thanks for that

 

what file do i put this into .when you select the add to icon it comes up with details etc..

 

i am not sure how to do this

 

thanks for your help