Magento – Magento import error

importmagento-1.9sku

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.

EDIT

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

Best Answer

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!

Related Solutions

Magento – Assign several simple products at once

If $simples is an array that's not going to work, you'd need to create several rows:

$assignProducts[] = array(
    'sku' => $configurableProduct->getSku(),
    '_type' => '',
    '_attribute_set' => '',
    '_super_products_sku' => 'sku1'
);
$assignProducts[] = array(
    '_super_products_sku' => 'sku2'
);

There was an issue about this exact same problem yesterday, please have a look at: https://github.com/avstudnitz/AvS_FastSimpleImport/issues/9

Magento – Why is the csv file not importing successfully in the Dataflow Profile even when it was verified as valid in Check Data

Please check and make sure that you don't have extra carriage returns/line feeds on the end of your csv file. Open the file, and delete any blank lines/rows.

Often times, when you export from Excel, it will add extra rows to the export that are nothing more than blank lines.

Best Answer

Related Solutions

Magento – Assign several simple products at once

Magento – Why is the csv file not importing successfully in the Dataflow Profile even when it was verified as valid in Check Data

Related Topic