I have five hundred configurable products, all of them having five color options and five size options. In default importing style of magento, I would have to create 26 rows per product in my CSV import file, one row for configurable product and other 25 (1x5x5=25) for simple products. And for 500 products, creating 26 rows per product will take forever.
Is there any way, by which I could define both configurable and all its simple products in one row only in csv file, instead of 26 rows per product and be able to import into magento.
Can this task be done like that, I create 500 rows for all 500 configurable products and by some excel formula, all the combinations of simple products for all the 500 configurable products be generated in another excel sheet containing the resulted 12500 rows (500x5x5=12500) of simple products?
Any other way you experts can suggest to solve my problem?
P.S.- In Magmi also, I would have to create 25 rows for simple products manually with one configurable products. So, its also not solving my problem.
Basically, I need automation for creation of simple products rows in CSV Files.