I am importing a large csv file(about 5.5 MB). Whenever I try to import it gives error

Product with specified super products SKU not found in rows

I have googled this issue and found that it is something related to configurable products. But I was unable to find exact solution for this. Please help.


Below is the screen shot of first product in my CSV. enter image description here

And the following screen shot have the products that just came after first product enter image description here

  • I think this is to do with the order of products in the csv. Make sure that the parent product is first in the csv. – David Manners Nov 17 '14 at 16:28
  • If this doesn't help, could you post an excerpt of your csv file with one configurable and all assigned simple products? – Andreas von Studnitz Nov 17 '14 at 16:31
  • Hello David. By parent did you mean configurable product. If is so they already in parent child order. I mean first configurable product comes then its associated products. – Ak Jn Nov 17 '14 at 16:42
  • Hey Andreas, please see my edit. – Ak Jn Nov 17 '14 at 16:52
  • Same problem here. Even exporting from Magento and then trying to import the same CSV back into the system can produce this error. – zigojacko Jan 27 '15 at 13:16

I had the same error. I have changed the order of products in the CSV file. I have put the associated products (simple products) first and then the configurable product and the problem was solved!

  • Thanks! Why does Magento export like this? – johnsnails Nov 3 '15 at 4:29
  • Didn't work for me though. I have by default first associated products and then the configurable one, in the csv, for each group of configurable product and its associated products. Still, the error shows. – Vladimir Despotovic Nov 30 '16 at 1:22

It's old, but I struggled over it multiple times. :-)

To solve this Problem I manipulated the _prepareEntityCollection of Mage_ImportExport_Model_Export_Entity_Abstract

in an own module Extension of Mage_ImportExport_Model_Export_Entity_Product

like this:

 * Rewrite of Mage_ImportExport_Model_Export_Entity_Abstract::_prepareEntityCollection
 * for the purpose of getting the configurable products to the end of CSV file:
 * Problem was:https://magento.stackexchange.com/questions/44368/magento-import-error
 * Apply filter to collection and add not skipped attributes to select.
 * @param Mage_Eav_Model_Entity_Collection_Abstract $rCollection
 * @return Mage_Eav_Model_Entity_Collection_Abstract
protected function _prepareEntityCollection(Mage_Eav_Model_Entity_Collection_Abstract $oCollection)
    $rCollection= parent::_prepareEntityCollection($oCollection);
    $rCollection->addAttributeToSort('type_id', Mage_Eav_Model_Entity_Collection_Abstract::SORT_ORDER_DESC);
    return $rCollection;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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