RE: Relationships Between Attributes

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=227342#227342
----------------------------------------------------------------

Linda,

I'm glad you answered - I was actually going to PM you about this - but thought I would throw it around out in the open for a little bit.

OK, to be honest this is something that I personally need, but I'm sure many could benifit from it.

I am in the clothing business so I will use clothing examples:

Just say I have one shirt. The shirt is availiable in two fabrics (fabric1 and fabric2). My also produce the shirt in 3 different colours. The problem is that the shirt is only made in fabric1 in colour1 and colour2. While the same shirt in fabric2 is available in colour3. 

Colour3 is not available in Fabric1.

Basically this would be attribute relationships (PRODUCT BASED HOWEVER). It would mean that I could sell the one shirt, in two different fabrics, but certain colours are only available in certain fabrics.

As I mentioned this would have to be product based, as in another product fabric1 and fabric2 might have all colours available (I hope everyone is still following).

The way I enviage it is that there is a new Product Attribute manager where (per product) you can specify which attributes belong to that product(s) and which attributes are related to other attributes. 

Then in product_info.php everything would remain the same, but once an attrivute is selected the other related attributes could be made available (either through an onchange in the primary attribute, or alternitevly you could make the attribute selection process step based. Ie. Select the primary attribute (in my case Fabric) and once the fabric is selected the available colours for THAT FABRIC become available).

Once again I hope I am making sence here - please let me know what you think Linda, or if you need any more information.

This may sound like it gets complicated if people had LOTS of attributes, however in the product attribute selection screen you could select an attribute as the primary/parent attribute (fabric) and then the available options stem from it (the available colours).

Looking forward to everyones responses, and I know everyone is glad to see you back Linda  :D