Magento – Magmi Configurable Products Importation

magentomagmi

In Magmi v0.7.17, I can't manage to import configurable products.

Here is an example of the csv I've got (just fields related to problem here):

http://img198.imageshack.us/img198/8871/csvq.jpg

  • First of all, I need to put "_attribute_set" for the importation to work, otherwise I've got the error “cannot create product sku:xxx no attribute_set defined”. But in every online documentation and in the Dataflow Export this field is "attribute_set".

  • When I run the importation (using the Configurable Item processor v1.3.6), only the simple products are created and I've got theses errors :

    SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'attribute_id' cannot be null – INSERT INTO catalog_product_super_attribute(product_id,attribute_id,position) VALUES (?,?,?)

None of the attributes and attributes set exist in database, I want it to be created on the fly. But is it possible ? or do I miss some fields ?

Thanks !

Best Answer

Ok, it works now. After a little debugging in the plugin, I saw that the column "configurable_attributes" was empty. I move it at the beginning of the files (next to attribute_set) and it works fine. It's due to the fact that I didn't encapsulate my text with "" in csv, because Excel doesn't do it. So I modified my file with OpenOffice and let it at the end.

Suddenly attribute_set is working too.

Be sure to select "Magmi Magento Reindexer", otherwise the products won't appear in frontend.

Attributes and attribute sets have to be created in BackOffice before importation. Magmi can just create values of attribute.

Related Topic