I have a configurable product with multiple attributes.
I need to create every possible combination of associated products for this configurable product. The reason being that I do not have the option of using Custom Options (related to another question).
Since Magento takes these attributes in hierarchical order, and there are 5 configuration options each having 5 (let's say) values.
e.g.
Option A - with values A1, A2,A3,A4,A5
Option B - with values B1, B2,B3,B4,B5
…. and so on till E
So I will have to manually create 5^5 = 3125 options.
Is there a simple way to create these simple/associated products ? Can this also be done through a DB query ? The options would more or less remain fixed at the moment.
If it is simple to create these through a query, which all tables will be needed for this in Magento ?