Magento : How to apply special price for all the products?

In my store nearly 12,000 products was there. Now i want to apply 10% special price to all my products. Is there any way to imple开发者_开发技巧ment easily without doing it product by product manually?

Create a Catalog Price rule and apply to all user groups. I think that will work...

Take a look at http://www.beperpetual.com/2009/04/how-to-setup-customer-pricing-in.html

there are two way to apply

1.create promotion for product 2.update all product

the price attribute Id is 99

update catalog_product_entity_decimal set value=$price where attribute_Id=99