Magento – “Product with specified super products SKU not found in rows:…” when reimporting just exported products to empty database

exportimportimportexportsku

I exported all my single and configurable products to .csv and emptied my database of all products afterwards. I am now trying to reimport those same products using the just created .csv file. Unfortunately, I am getting the message:

Product with specified super products SKU not found in rows:...

followed by the list of skus, and followed by another message below:

Orphan rows that will be skipped due default row errors in rows

and then another list of skus. What does this mean, considering I have JUST created that same .csv from the currently working and functioning Magento? I also tried to completely empty the database from products and making only one configurable product with one associated simple product, with the same result (the error message Product with specified super products SKU not found in rows) What can I do to mend this?

Best Answer

You must import the simple product first and the configurable product after that. It sounds like the simple product cannot be find when the configurable product is imported.

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 – Importing product weights when multiple rows in CSV per product

The file you generated through Magento Export (whether this is default import/export module or default dataflow profile) is NOT going to work if you import it back, because it doesn't preserve the format.

If you want to update weights, I would recommend this:
1) filter your CSV in Excel, filter only those which have "sku" field assigned
2) copy-paste the filtered rows into new spreadsheet
3) leave only 2 columns - "sku", "weight"
4) import it back.

I'm pretty sure it's the easiest flow to solve your concrete task.

For those who are looking for tool for Magento that allows both export and import while having similar format for both routines, check out this one.

Best Answer

Related Solutions

Magento – Assign several simple products at once

Magento – Importing product weights when multiple rows in CSV per product

Related Topic