Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Attribute set instance id on product

Developers
2012-03-02
2013-03-08
  • Hi

    Can a product have different m_attributesetinstance_id in the m_transaction table. If so what is the purpose then of the field.

    Thanks in advance.

     
  • Hi,

    Can a product have different m_attributesetinstance_id in the m_transaction table. If so what is the purpose then of the field.

    Yes. Product can have different M_AttributeSetInstance_ID in M_Transaction table.
    Purpose of M_AttributeSetInstance_ID column in M_Product table is to store NON instance atributes. This means attributes which are the same for all products belonging to this M_AttributeSet. Please note that M_Product table also has M_AttributeSet_ID column. This column defines which is the Attribut Set of the product.
    M_AttributeSetInstance_ID in M_Product table allows users to search for product by statis attributes.

    Regards,
    Trifon

     
  • Michael McKay
    Michael McKay
    2012-03-03

    A good example of how an attribute set instance is used in the product table is with electronic components.  Each component is identified by a part number and description but there are so many specifications for each part that the details of what differentiates one part from another is best coded in the attribute set instance.  The product instance is not a serial or lot number instance - it applies to all items of that part.  See http://components.arrow.com/part/search/%5E6/11/863 for some examples.  Each part has 16 elements in its attribute set instance that defines the specifications for the part.

    Once all that info is coded in the ASI, parts can be found based on specifications - for example, all surface mount resistors with values of 470 ohms.

    Mike.

    Mike.