Hi, I need to figure out how to relate products based on attribute or partial attribute (e.g. chunk of the sku). I think I’ll need to do this in code, perhaps adding a module extension. I know how to make modules and write code, but I need a jump start on how to best solve the specific problem.
Example of what I need to do in Magento:
See at the bottom, the additional colors for the same product. Each color/size leads to the simple product for that options.
1) I thought about using a configurable product. But the client really wants it to work like it currently does, which is basically only simple products. So I’m going to have build the relation on the fly.
2) Next I thought about using related products for this, though that’s really not their purpose for this I think. It also seems a pain to relate products this way. In the admin when I relate product A to product B, it doesn’t automatically relate product B to product A. Perhaps this is intentional, but I think it’s wrong. If two things are ‘related’ they should be related both ways, no???
3) So to save my self from an admin nightmare of relating thousands of products, I thought there maybe is a way that I could grab a style number from an attribute field and have Magento fetch me a list of products with the same style number. Question is: How deep do I have to dig. Are there any functions I can use to run a custom query like this or do I need to move to the SQL level? Where should I tie into the code?
I welcome any and all suggestions on how to best solve this.