Update Attribute on All Product, Without Messing up with other attribute in product?

[vilvas]

I have a problem, where i would like to add one update to all of my product attribute whiteout changing any other attribute. example:

All my Product have this attributes:

ColorBlack

Sizes52- 16- 140

Lens TypeBifocal (With Line)
Progressive Lens (No Line)
Single Vision (Far/Close-up)

Change to:


ColorBlack

Sizes52- 16- 140

Lens TypeBifocal (With Line) $49.99
Progressive Lens (No Line) $89.99
Single Vision (Far/Close-up) 99.99

without changing the Size of all product and color.

How is this possible?

[vilvas]

I would like to update pricing on one attribute for all my product, without touching other attribute setting of all product . for example, if you follow this URL, you can see Lens type (attribute) don't have price
http://observevision.com/index.php?m...&products_id=8
but if you follow this link the lens type have Price right by it.
http://observevision.com/index.php?m...&products_id=4

my problem is i wanna put price on "lense Type" attribute without changing Sizes, Colors, or any other attribute of the product.

i know i can do this if i go and add it to the each product manually, but i was wondering if there is a way i can do this faster?

[Ajeh]

Are you trying to change ALL Products that have the Attributes:

Lens TypeBifocal (With Line)

to ALL be:

Lens TypeBifocal (With Line) $49.99

on *every product* in your shop if they already have the attributes:

Lens TypeBifocal (With Line)

and then ...
change ALL Products that have the Attributes:

Progressive Lens (No Line)

to ALL be:

Progressive Lens (No Line) $89.99

on *every product* in your shop if they already have the attributes:

Progressive Lens (No Line)

and then ...
change ALL Products that have the Attributes:

Single Vision (Far/Close-up)

to ALL be:

Single Vision (Far/Close-up) 99.99

on *every product* in your shop if they already have the attributes:

Single Vision (Far/Close-up)

[vilvas]

Yes, how is it possible?

[vilvas]

And i don't want any other attribute to be effected of all product.

[Ajeh]

To replace an Attribute Price, which is the options_values_price, for a specific Attribute on ALL Products regardless of the original Price of the options_values_price ...

You need to find the:
options_id

for the Option Name Lens Type ...

You need to find the:
options_values_id

for the Option Values:
Bifocal (With Line)
Progressive Lens (No Line)
Single Vision (Far/Close-up)

Backup your database ...

Did you backup your database? (very important step)

Then you can use this in the Tools ... Install SQL Patches ...

For the Bifocal (With Line) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=16 with the options_values_id for the Bifocal (With Line) use:

UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE options_id= 1 and options_values_id = 16;

For the Progressive Lens (No Line) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=17 with the options_values_id for the Progressive Lens (No Line) use:

UPDATE products_attributes SET price_prefix='+', options_values_price = 89.99 WHERE options_id= 1 and options_values_id = 17;

For the Single Vision (Far/Close-up) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=26 with the options_values_id for the Single Vision (Far/Close-up) use:

UPDATE products_attributes SET price_prefix='+', options_values_price = 99.99 WHERE options_id= 1 and options_values_id = 26;

[vilvas]

Where can i get the options_id=1, and options_values_id=16 for example. I check my phpmyadmin but i dont see lenses type.

[vilvas]

for example this is what type in

UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE products_options= 4 and products_options_values = 124;

[Ajeh]

In your Zen Cart Admin in the Catalog ... Option Name Manager ... the ID next to the Lens Type is the options_id ...

In your Zen Cart Admin in the Catalog ... Option Value Manager ... the ID next to the:
Bifocal (With Line)
Progressive Lens (No Line)
Single Vision (Far/Close-up)

are the options_values_id ... that you are looking for ...


WARNING: you need to use the code that I gave you ... if the Lens Type ID is 4 and the is Bifocal (With Line) ID is 124, then you need to use:

UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE options_id= 4 and options_values_id = 124;

NOTE: Again, be sure to backup your database before attempting this ...

[vilvas]

Thank you for all your help, now i have one more question how can i make everything in order? for example i want my attribute to shoe in order for all products, now is a mess. I want to be order for all product, like in this order

Color & Size Section:
1 (color)
2 (Sizes)

Lenses Section:
1 (Lens Type)
2 (Right (OD) - Sphere, Right (OD) - Cylinder, Right (OD) - Axis, Left (OS) - Sphere, Left (OS) - Cylinder, Left (OS) - Axis, PD)
3 (Lens Thickness)



and is it possible to write short description on top of each section?