Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Setting "Priced by Attributes" on multiple products

Setting "Priced by Attributes" on multiple products

Locked

Views: 1,215

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
22 Jul 2008, 1:14 AM
#1
lopton avatar

lopton

New Zenner

Join Date:
Jul 2008
Posts:
5
Plugin Contributions:
0

Setting "Priced by Attributes" on multiple products

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 :shocking: 

Thanks in advance for the help.

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

22 Jul 2008, 1:24 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Setting "Priced by Attributes" on multiple products

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 ... :unsure:

22 Jul 2008, 1:28 AM
#3
lopton avatar

lopton

New Zenner

Join Date:
Jul 2008
Posts:
5
Plugin Contributions:
0

Re: Setting "Priced by Attributes" on multiple products

You are my hero!!!! :clap:

Thank you so much, did exactly what I wanted :D 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

22 Jul 2008, 1:29 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Setting "Priced by Attributes" on multiple products

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