I have a question to community how to organize my catalog with grouped products. Following my situation:
1. I have more than 30K unique simple products (not visible in catalog). 2. I have more than 5K grouped products (visible in catalog) 3. Every grouped product contains of combination of simple products on point 1. 4. One simple product can be included to 1-5 grouped product.
That is not to hard to organize my catalog, but problem is:
Product "SA" is child product for "GA", "GB", "GD". And "SA" has unique value for every group, for example polygon, order, image attributes are differentiated for every parent group. But it is one simple product with unique sku and price. In the catalog there are many such products given like this.
If the situation is clear can you help me how to organize simple and grouped products. Thanks.
Products comes in .csv file and I should write custom module to organize products. One variant is to save every unique combination as new product and link them to group product appropriately. For example if "SA" product has 3 parent product I will save "SA" as 3 new product and so on. By the way if I have 30K unique products in .csv file the result of import will produce more than 80K products in magento db. And database size will overloaded. Currently I haven't another optimal way.