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
Magento doesn't like importing files that are too large. You may be better off separating them into different files. Do 2000 at a time?
To upload images you need to create a separate Dataflow Profile. System > Import/Export > Dataflow – Profiles
Name it Image upload (or whatever you like) and map the sku & image fields. Also image labels if you want to do so.
Save the new profile.
The import image csv now need to be in a separate spreadsheet with only the columns that you have mapped (must have sku & images). For the images column include JUST the file name. No slash required. I.e image01.jpg
If product needs multiple images just duplicate the row with the same sku & put in the next images name.
FTP & go to your media folder and create new folder called import. Upload your images in there (make sure files have the same name!)
And upload like you did the products. Make sure under data format that Original Magento attributes in first row is set to No.