I am trying to associate 2000 simple products with one configurable product.

The problem is Excel has a limitation on the length of a cell. I can not put all the SKUs of simple products in one cell.

I am using Magmi to import my products. Magento version is CE

Associating simples with using two seperate files is also not working since the second update overrides the first one!

Is there a way to handle that? Or do I need to change my logic? Instead of using that many simples should I do something else?

Thanks in advance.


  • Why do you want 2000 simple products in a single configurable product?
    – Mukesh
    May 5, 2015 at 9:04
  • I have 6 dropdown options per config, every dropdown has 6 options which can be selected. After all options are selected there is one simple product which matches with all selected options. That is why I have 2000 simples for that config.
    – CntkCtn
    May 5, 2015 at 9:56
  • 2
    Use a plain text editor to edit your data instead of Excel. May 5, 2015 at 10:51
  • I did try that too, I exported the data directly to a CSV file instead of excel and I saw that limitation did not apply on that file. But when I imported it via magmi it still associated only 910 simple products to the configurable. So I thought there is an other limitation but what I understand from your comment is there is no other limitation on Magmi or Magento. If this is the case then that CSV file should have worked.
    – CntkCtn
    May 5, 2015 at 14:24

1 Answer 1


I solved my problem via removing the simples_skus field from the import file and using the automatic association logic which depends on the SKUs of configs and associated simples. This worked pretty well since our SKUs are already designed with that logic. Simples first Configs after.


  • after the time limit is passed I will!
    – CntkCtn
    May 6, 2015 at 16:57
  • Sorry, I didn't even know there was a time limit :)
    – Imanuel
    May 6, 2015 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.