How do I update all products to 'Product Priced by Attributes'

[kcb410]

Hello all!

I have recently uploaded 900 new products to my web site.
They are all priced by attributes. Does anyone know how to change "Product is Priced by Attributes" to yes?

I would like to avoid having to do it one product at a time.

Any help is appreciated.

Thank you!

[kuroi]

Provided you haven't added an products since, you could back up your database, then run something like the following from the Admin > Tools > Install SQL Patches screen

UPDATE products SET products_priced_by_attribute = 1 WHERE products_date_added >= "2009-07-25";

[kcb410]

Provided you haven't added an products since, you could back up your database, then run something like the following from the Admin > Tools > Install SQL Patches screen

UPDATE products SET products_priced_by_attribute = 1 WHERE products_date_added >= "2009-07-25";

That worked perfectly!
Thank you.

[Ajeh]

NOTE: when manually altering anything that changes the Price of a Product, you will want to also run from the Tools ... Store Manager ...

Update ALL Products Price Sorter
to be able to sort by displayed prices: Update

This will allow sorting by Price, which is actually using the products_price_sorter for sorting prices, to work properly ...

[kuroi]

Excellent point. Thanks for the clarification.