Attribute question/assistance needed.

[johnnyJag]

I love OSCommerce. It is great. I am looking to see if there are any contributions that streamline attributes. Kind of hard to explain, but in the following example.

 

I make 2 product options SIZE and COLOR

For option values I add

RED BLUE and GREEN under COLOR. Each with a unique id in products_options.

LARGE MEDIUM and SMALL under SIZE. Each with a unique id in products_options_values.

 

 

In the table products_options_values_to_products_options, Product options are tied to product option values each with a unique id as products_options_values_to_products_options_id. In my test case as shown below.

color is tied to red

color is tied to blue

color is tied to green

size is....

etc....

 

This makes sense

 

When I apply an attribute to an item it is applying products_options_id and products_options_values_id rather than products_options_values_to_products_options_id. Not sure why this is but it opens up my question.

 

The way it is, it is possible for me to add an attribute of size red to a product. There is no checking of the unique products_options_values_to_products_options table to ensure that the attribute association is valid. I might be missing something but shouldn't that be checked? Any insight or pointing to a contribution that does this check is appreciated as always.

Thanks

John

 

Only bad thing is that anf fix for this might break the

Sort Product Option values v1.01

That I am using.