Attribute images?

[terryparley]

I have a gazillion colors that I am adding color swatches to, is it possible to have the default option value for that color apply to all products that use that option value? Example: I have a t-shirt that uses the color black, I add that option value to the product, but the swatch does not appear, right now I have to to each product and add the swatch color. Hope that makes sense.

Terry

[Ajeh]

You need to know from the products_attributes table the values of:
options_id
options_values_id
attributes_image

you can see these if you browse the table:
products_attributes

via phpMyAdmin ...

Then, to make, for example, all Color (options_id 1) Orange (options_values_id 25) with the Attributes image color_orange.gif (attributes/color_orange.gif) you could use:

UPDATE products_attributes SET attributes_image = 'attributes/color_orange.gif' WHERE options_id = 1 and options_values_id = 25;

in either the SQL of the phpMyAdmin or the Tools ... Install SQL Patches ... of your Zen Cart Admin ...

[terryparley]

I am sorry to say that your more than excellent suggestion is far above my understanding of SQL...

[Ajeh]

Are you familiar enough with phpMyAdmin that you could find your database and browse the database table products_attributes to look at your Attributes?

If so, you want to find the contents of the fields:
options_id
options_values_id
attributes_image

wherre the attributes_image is the correct image that you have already added manually in the Zen Cart Admin with the Attributes Controller to one of your products ...

The example I showed has the options_id 1 (for Color) and options_values_id 25 (for Orange) and the image file, that I have in the directory /images/attributes/color_orange.gif

that in the database is stored as:
attributes/color_orange.gif

[terryparley]

Oh great and wise one! I found the attributes you spoke of, so here is what I found:

Gildan 5000 tshirt, the ash attribute id is 83313
Gildan 2000 tshirt, the ash attribute id is 83654

What am I doing wrong? Shouldn't the colors attributes be the same for Ash?

[Ajeh]

You need to be more specific ...

The products_attributes table has fields:
options_id
options_values_id
attributes_image

You need to see if these are, or should, be the same on each product when they appear together ...

Example:
options_id 1
options_values_id 25
attributes_image attributes/color_orange.gif

Should all of those be the same when options_id is 1 and options_values_id is 25 and you want an image for that Attribute?

[terryparley]

There's that whole "be specific thing" lol...
Ok.. here is what I found for the color of ash

Gildan 2000 Shirt
Product Attribute id = 83654
Prod Id = 26
Options ID = 1
Options Value ID = 13

Gildan 5000 shirt
Product Attribute id = 83655
Prod Id = 27
Options ID = 1
Options Value ID = 13

Attributes_images = ash.gif for both shirts

So whenever I have a product that uses that color the attribute image is placed on the page, hope that makes sense? So when I apply the colors to a product, that color/attribute image then displays on the web page automatically.

Hope that is what you are asking for...

[Ajeh]

To set all images on the attribute to ash.gif (where ash.gif is in the /images directory) for Options ID 1 and Options Values ID 13 you can use:

UPDATE products_attributes SET attributes_image = 'ash.gif' WHERE options_id = 1 and options_values_id = 13;

This can be run in the Tools ... Install SQL Patches ... of your Zen Cart Admin ... or in the phpMyAdmin SQL ...

NOTE: Backup before you try to do this ...

[terryparley]

I am guessing that I would have to do that for all the colors? do I just take the text you sent me and make a .txt file to run in the ZC to run the script?

[Ajeh]

I would end it in .sql so there is no confusion ...

Make sure that each statement ends in a semi-colon as I wrote this one ...

That will allow you to update them any time you need to ...