Magento – Magento 2 : Import product from csv configurable product error

csverrorimportmagento-2.1magento2

I am working on Magento 2.1.3 product import with CSV.

I am getting a error while using following CSV file.

Error is "General system exception happened"

Best Answer

I imported your file on my Magento 2 system and had a couple data incompatibility issues, but once I fixed those, I started digging into the code for you and here's the error that is being thrown:

Notice: Undefined index: required in /var/www/sites/classic_parts/docs/vendor/magento/module-catalog-import-export/Model/Import/Product/Option.php on line 1114

After digging further, I realized that it's because you don't have a store_view_code for the product. Magento 2 requires a store view code when importing product options.

Also, your option data seems to be missing a name value, which Magento 2 will look for. This also causes errors. Also, after you fix that, you will likely encounter another error because you don't have a required value specified on the option, so you should set that as well.

Please let me know if you have any other questions!

Related Solutions

How to Import Product Images from CSV

I have set up a documentation of the product import format of Mage_ImportExport at http://www.integer-net.de/download/ImportExport_EN.pdf which describes in detail how to import for example images.

Regarding your problem: you need a few extra columns to add the image to the media gallery, otherwise it won't get imported:

"sku","image","small_image","thumbnail","_media_image","_media_attribute_id","_media_is_disabled","_media_position","_media_lable"
90048,"test.jpg","test.jpg","test.jpg","test.jpg",77,1,1,"Image 1"

Notes:

The _media_attribute_id column requires the ID of the product attribute media_gallery. It can be obtained either from the admin panel or your custom modules using the expression Mage::getSingleton('catalog/product')->getResource()->getAttribute('media_gallery')->getAttributeId();
The typing error _media_lable is intentional and hard-wired into Magento.

Magento – Import csv issue (product.php on line 1407)

Repeat the Attribute set value in all rows (keep the header : _attribute_set), it fixed the issue for me.

Best Answer

Related Solutions

How to Import Product Images from CSV

Magento – Import csv issue (product.php on line 1407)

Related Topic