Setting "Priced by Attributes" on multiple products

**Lopton** · 22 Jul 2008, 02:14 AM

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** · 22 Jul 2008, 02:24 AM

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

Code:

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** · 22 Jul 2008, 02:28 AM

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