Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Bulk Update Attribute Prices

Bulk Update Attribute Prices

Views: 2,218

Results 1 to 3 of 3
7 Apr 2011, 4:15 PM
#1
ricm avatar

ricm

New Zenner

Join Date:
Mar 2011
Posts:
51
Plugin Contributions:
0

Bulk Update Attribute Prices

I have download products that are priced solely by attribute. Is it possible to change product-attribute prices by a percentage or fixed amount? It is possible to update 1 product's prices and then copy to the Category or to selected products but the latter is tricky because the interface relies on highlighting products in what could be a very long list...

Thanks,
Ric

13 Dec 2011, 10:44 PM
#2
net3431 avatar

net3431

New Zenner

Join Date:
Dec 2008
Location:
Phoenix, AZ
Posts:
28
Plugin Contributions:
0

Re: Bulk Update Attribute Prices

As usual, the zenners get very quiet about things that are handled well in other carts and poorly in zen. The best way is to make sure each price attribute type is set with a unique price so that you can do a bulk update from phpmyadmin. If I know all my XXL sizes are set to +10, and that all other sizes and pockets etc have different prices, then all I need do is update the products_attributes table where options_values_price = 10.

13 Dec 2011, 11:14 PM
#3
net3431 avatar

net3431

New Zenner

Join Date:
Dec 2008
Location:
Phoenix, AZ
Posts:
28
Plugin Contributions:
0

Re: Bulk Update Attribute Prices

UPDATE products_attributes SET options_values_price = '15.0'
WHERE options_values_price = '10.0' AND options_values_id = '5'

UPDATE products_attributes SET options_values_price = '15.0'
WHERE options_values_price = '10.0' AND options_values_id = '6'

I looked in the table products_options_values for the options_values_id (products_options_values_id) and the corresponding products_options_values_name