You should follow below steps:
- Create the simple product rows
- Create configurable product row
- Assign child products to the configurable product
Below is the very basic csv sample;
sku,_store,_attribute_set,_type,_category,_root_category,_product_websites,color,cost,description,meta_keyword,name,price,short_description,size,_super_products_sku,_super_attribute_code,_super_attribute_option,_super_attribute_price_corr
F0000077.03,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,3,,,,
F0000077.04,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,4,,,,
F0000077.05,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,5,,,,
F0000077.06,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,6,,,,
F0000077.07,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,7,,,,
F0000077.08,default,Default,simple,High Heels,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,8,,,,
F0000077,default,Default,configurable,New In,Default Category,base,Black,10.99,Product description,"New in, heels, heeled sandals",Product name,25,Product Shot description here,,F0000077.03,size,3,0
,,,,High Heels,Default Category,,,,,,,,,,F0000077.04,size,4,0
,,,,High Heels/Heeled Sandals,Default Category,,,,,,,,,,F0000077.05,size,5,0
,,,,High Heels/Strappy Heels,Default Category,,,,,,,,,,F0000077.06,size,6,0
,,,,Sandals,Default Category,,,,,,,,,,F0000077.07,size,7,0
,,,,High Heels,Default Category,,,,,,,,,,F0000077.08,size,8,0
Best Answer
The issue is the order. You need to add simple products first, then configurable products in excel.