Magento has this db table:
catalog_product_link_attribute. What is the purpose of this table. I researched some and it relates to associated products. Who has some examples to advanced use of this feature?
catalog_product_link_attribute is used to store attributes for product relations.
For example when adding a product as an upsell for an other one, you also fill in a 'poistion' field. in order for Magento to allow you to fill in that field it must exist in the table
The product relations are kept in
catalog_product_link, but only as references to the ids of the products. (product_id, 'related_id' and 'relation_type'). The rest of the values are kept in the tables:
that have a reference to the
catalog_product_link_attribute table. It's an EAV approach, somehow similar to how the products & categories are stored in the database, but on a smaller scale.