Mass Uploading Images for Attributes

Hello!

Is there any way to sort of, mass upload attribute images and have them automatically know which attribute to associate themselves with? Or is this just wishful thinking? >.>

We sell paint and pencils etc, and as you can image, there's hundreds of freaking different colours. >.<

Thanks for any help. :)

If you were to say, for example:
Option Name Color (options_id 1) and Options Value Red (options_values_id 16) would that always be the same image name?

Ajeh:

If you were to say, for example:
Option Name Color (options_id 1) and Options Value Red (options_values_id 16) would that always be the same image name?

Mmmm. I think not. But it could be.

ie. Instead of "Colour: Red, White, Green." I'd just change to, "Pastel Colour: Red, White, Green." and "Pencil Colour: Red, White, Green." etc. in which case every Pencil Colour: Red would be the same image.

What do you think?

I was trying to find a pattern to the Option Name and Option Value so that if the same they could then have the images updated easily with the values being the two fields that could be tested for on updating the image names ...

I think I get what you mean...

I don't know if the ID tag would be much use, as it's kind of a mess - does zen-cart work with the actual name of the Option Value/Name in any way?

I really haven't seen any kind of php or css or anything before a week or so ago, so doing my best to interpret what I've seen so far. <.< >.>

The text on the Option Name ID and Option Value ID is not really relevant ... it is the value that means anything ...

If the values were known and all options_id ## and options_values_id ## had the same image, then something could be made to speed up adding the images if they were always the same for each pair ...

Otherwise, you are back to one by one ...

Ajeh:

If the values were known and all options_id ## and options_values_id ## had the same image, then something could be made to speed up adding the images if they were always the same for each pair ...

Okay, that can be done. I think the extra effort made into worrying about IDs would be a lot less than one by one anyway.

How were you thinking we could do this?

An example would be for the demo data to set all attributes that use the Option Name Color (options_id 1) and Options Value Orange (options_value_id 25) to use the image color_orange.jpg in the /images/attributes directory:

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