Setting "Priced by Attributes" on multiple products

[Lopton]

Hi all,
I used Easy Populate STD to add 195 products to my database. But now I am running into the issue that I would like to set all of them to "Priced by Attributes" yes, but I can not seem to find a way to do this to all of them at once.

Is my only option to click a billion times to get each product to have the priced by attributes flag? or am I missing something, I am tired

Thanks in advance for the help.

Matt Emerson
http://www.mattemerson.com/Gallery

[Ajeh]

Using the Tools ... Install SQL Patches ...

UPDATE products SET products_priced_by_attribute = 1;

NOTE: Backup your database first ...

NOTE: if you have Product Prices, you probably do not really want to do this ...

[Lopton]

You are my hero!!!!

Thank you so much, did exactly what I wanted I did have product prices in there, but that was an attempt to fix the no starting at price, easy to update those 0 with Easy Populate. Not so easy to figure out how to set them all like you showed me.

Matt Emerson
http://www.mattemerson.com/Gallery

[Ajeh]

Glad that this worked for you ... thanks for letting use know ...