Magento adding Super Attribute to configurable products
Drag it to appropriate attribute set
Go to phpmyadmin, table ‘catalog_eav_attribute’ and look at the last one, note the ‘attribute id’, also note the product id -> go to catalog_product_entity and look for the configurable product you want, and note entity_id -> this is the product_id
Go to catalog_product_super_attribute and insert new record with product_id and attribute_id, note of the product_super_attribute_id
Go to catalog_product_super_attribute_label and insert new record with product_super_attribute_id and the value of your new attribute, like ‘Color’ or ‘Size’ which you used when adding the attribute in the admin
Go back to admin and click the configurable product, you will notice none of your child products is associated to your configurable product.
Click one of the child products, and select appropriate attribute value, you may also change the sku.
Export all child products and add the new attribute and sku values to it, import it back and you are done or you may have to manually change all in the admin without using the dataflow.