Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Magento 1.6 Massive Import Configurable Products
 
eleuzzi
Jr. Member
 
Total Posts:  3
Joined:  2010-08-14
 

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

_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
,shirt_size,S
220548959305
,shirt_size,M
220548959503
,shirt_size,L
220548959505
,shirt_size,XL
220548959507
,shirt_size,XXL
220548959509
,shirt_size,3XL

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!

 
Magento Community Magento Community
Magento Community
Magento Community
 
hippoglollum
Sr. Member
 
Total Posts:  97
Joined:  2010-04-07
 

same issue here…
if you solved, please help me

 
Magento Community Magento Community
Magento Community
Magento Community
 
eleuzzi
Jr. Member
 
Total Posts:  3
Joined:  2010-08-14
 

I hope someone could you help us....

 
Magento Community Magento Community
Magento Community
Magento Community
 
hippoglollum
Sr. Member
 
Total Posts:  97
Joined:  2010-04-07
 

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!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagneticOneTeam
Sr. Member
 
Avatar
Total Posts:  253
Joined:  2008-04-02
USA
 

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

Hope it helps!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Chewbacca
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2012-11-14
 

hippoglollum - 24 January 2012 04: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 rolleyes

Happy 2013 and beyond everyone grin

Image Attachments
Visual for CSV file update.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
williambyrne
Jr. Member
 
Total Posts:  1
Joined:  2012-09-28
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
iLoveMage
Jr. Member
 
Avatar
Total Posts:  11
Joined:  2013-01-10
 

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

Import Configurable and Grouped Products

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top