Magento – Importing configurable products having super product attributes

You'll first want to cache all of your attribute sets and their configurable attributes, so that you'll know what all of the configurable attributes are when you're processing a simple product. Pseudocode below. Not tested.

1. Get all of the attribute set IDs, $attributeSetIds, and loop through each: foreach ($attributeSetIds as $attributeSetId)

2. In each iteration, get all of the set's configurable attributes and cache them. The reason for those 3 filters is due to the very definition of a configurable attribute.

   $collection = Mage::getResourceModel('catalog/product_attribute_collection')
       ->setAttributeSetFilter($attributeSetId)
       ->addFieldToFilter('is_configurable', 1)
       ->addFieldToFilter('frontend_input', 'select')
       ->addFieldToFilter('is_global', 1);
   
   foreach ($collection as $attribute) {
       $cachedCpAtts[$attributeSetId][] = $attirbute->getAttributeCode();
   }
   
   // $cachedCpAtts will have all of your attribute sets' configurable attributes 
   // at the end of outer loop for `$attributeSetIds`.
   

3. When you're processing a simple product, simply use its attribute_set_id and look up its config. attributes IDs. For example:

   $cpAttId = $cachedCpAtts[$product->getAttributeSetId()][0];
   

4. Now it's only a matter of looking up the frontend label using the attribute ID. I believe there are a lot of resources on that front. You should probably cache all of the possible frontend labels for all configurable attributes as well.

You have to Follow below step for creating Configurable product.

1. Create Simple Product with require attribute.
2. Create Configurable Product with configurable_variations with contain SKU and attributes like sku=sku_of_simple_product,color=RED,size=XXSof Simple Product and one another column like configurable_variation_labels which contain color=Color,size=Size.
3. After perform this step you can import configurable product.

It may help you.