Magento

Hi,

I’ve google and searched around with no lucky.

I’ve tested the massive import from System -> Import.

I’m trying to import configurable products with more than one attributes

The problem is that the configurable product is imported but only shirt_size attribute, the attribute color is ignored. So if I’ll open the configurable product from backend, I see only S-3XL, and anything about the attribute color

What am I doing wrong?

Thanks!

same issue here…
if you solved, please help me

I hope someone could you help us....

found!!!

see the example below

Assuming that your color attribute name is “color” and “red, “black” and “green” are values for “color”.

In pratice for each configured product you must define a row for each configurable attribute.

a simpler example is

Hope this help!!

As well you can try Store Manager for Magento. But it’s payed module.

Hope it helps!

hippoglollum - 24 January 2012 05:15 AM

found!!!

see the example below

_super_products_sku,_super_attribute_code,_super_attribute_option
220548664107,shirt_size,S
220548664305,shirt_size,M
220548664503,shirt_size,L
220548664505,shirt_size,XL
220548664507,shirt_size,XXL
220548664509,shirt_size,3XL
220548959107,color,red
220548959305,color,red
220548959503,color,black
220548959505,color,black
220548959507,color,green
220548959509,color,green

Assuming that your color attribute name is “color” and “red, “black” and “green” are values for “color”.

In pratice for each configured product you must define a row for each configurable attribute.

a simpler example is

_super_products_sku,_super_attribute_code,_super_attribute_option
tshirt-S-red,shirt_size,S
tshirt-S-red,color,red
tshirt-S-black,shirt_size,S
tshirt-S-black,color,black
tshirt-L-green,shirt_size,L
tshirt-L-green,color,green

Hope this help!!

@hippoglollum Thank you soo much for your contribution.

We are using Magento Version 1.7.0.2 and had some trouble importing the options for a previously exported configurable product;
we figured out that not all options are exported to the CSV file and that we had to manually add them as shown in the provided image (’Visual for CSV file update.png’).
Note though, on the same line (when viewing the CSV file with Open Office) as the options data there is data in a different column that is not associated with the option !!
Also, as mentioned in a different thread, we had to change the order of the products in the CSV file from simple products first, THEN configurable products

Happy 2013 and beyond everyone

Click thumbnail to see full-size image

I was also having the exact same issue. As it turns out, the problem is not in the import, but in the export file you are creating. When exporting configurable products that can be configured by more than one attribute, Magento will only export data for one of those attributes in the _super_attribute_code and _super_attribute_option columns. So when you try to import the file, you lose associations.

The good news is that I found an easy fix for this. It is outlined in my blog post here http://razoyo.com/main/?q=blog/magento-17-configurable-product-export-fix

It worked for me on both Community Edition and Enterprise Edition.

You need to use below listed magento extension for Import configurable products and everything will work exceptionally wonderful: -

Import Configurable and Grouped Products