I want to upload 100+ configurable products to Magento 1.9, I choose to import using CSV.
I had created one config product and its associated products manually, then I had exported that data and used the format for my import.
In the same format, when I am importing new SKUs, I am getting issues like this "Product with specified super products SKU not found in rows: 1, 2, 3
Orphan rows that will be skipped due default row errors in rows: 2, 3"
When I skip that issue and import the data means, only associated simple products get imported. But, the configurable products do not get imported.
This is the CSV:
sku,_store,_attribute_set,_type,_category,_root_category,_product_websites,name,description,short_description,price,special_price,special_from_date,special_to_date,cost,weight,manufacturer,meta_title,meta_keyword,meta_description,image,small_image,thumbnail,media_gallery,color,news_from_date,news_to_date,gallery,status,url_key,url_path,minimal_price,visibility,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,options_container,required_options,has_options,image_label,small_image_label,thumbnail_label,created_at,updated_at,country_of_manufacture,msrp_enabled,msrp_display_actual_price_type,msrp,tax_class_id,gift_message_available,slider,neck_type,sleeve_type,fabric,size,washing_ironing_instructions,size_new,qty,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,notify_stock_qty,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,_links_related_sku,_links_related_position,_links_crosssell_sku,_links_crosssell_position,_links_upsell_sku,_links_upsell_position,_associated_sku,_associated_default_qty,_associated_position,_tier_price_website,_tier_price_customer_group,_tier_price_qty,_tier_price_price,_group_price_website,_group_price_customer_group,_group_price_price,_media_attribute_id,_media_image,_media_lable,_media_position,_media_is_disabled,_super_products_sku,_super_attribute_code,_super_attribute_option,_super_attribute_price_corr
Style-267-8,,Modesty,configurable,Women/Dresses/Casual Dresses/Her Modesty Style-101,Default Category,base,Style-267-8,,,500,,,,,,,,,,/2/7/2783_2.jpg,/2/7/2784_1.jpg,/2/7/2785_1.jpg,,grey,,,,1,Style-267-8,Style-267-8.html,,4,,,,,,Product Info Column,1,1,,,,9/27/2016 12:56,9/27/2016 12:59,,Use config,Use config,,0,,No,Crew,Elbow,Ramie,,WASHING AND IRONING INSRUCTIONS - WHEN YOU WASH 1. Wash below 40 degrees C. 2. Do not use excessive detergent 3. Do not use any detergent which contains bleach or liquid bleach 4. Rinse thoroughly,,0,0,1,0,0,1,1,1,0,1,1,,1,0,1,0,1,0,1,0,0,,,,,,,,,,,,,,,,,88,/2/7/2783_2.jpg,,1,0,Style-267-8-S,size_new,S,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,88,/2/7/2784_1.jpg,,3,0,Style-267-8-L,size_new,L,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,88,/2/7/2785_1.jpg,,4,0,Style-267-8-M,size_new,M,
Style-267-8-S,,Modesty,simple,,,base,Style-267-8-S,,,500,,,,,,,,,,,,,,grey,,,,1,Style-267-8-s,Style-267-8-s.html,,1,,,,,,Product Info Column,0,0,,,,9/27/2016 12:56,9/27/2016 12:56,,Use config,Use config,,0,,No,Crew,Elbow,Ramie,,WASHING AND IRONING INSRUCTIONS - WHEN YOU WASH 1. Wash below 40 degrees C. 2. Do not use excessive detergent 3. Do not use any detergent which contains bleach or liquid bleach 4. Rinse thoroughly,S,1000,0,1,0,0,1,1,1,0,1,1,,1,0,1,0,1,0,1,0,0,,,,,,,,,,,,,,,,,,,,,,,,,
Style-267-8-L,,Modesty,simple,,,base,Style-267-8-L,,,500,,,,,,,,,,,,,,grey,,,,1,Style-267-8-l,Style-267-8-l.html,,1,,,,,,Product Info Column,0,0,,,,9/27/2016 12:57,9/27/2016 12:57,,Use config,Use config,,0,,No,Crew,Elbow,Ramie,,WASHING AND IRONING INSRUCTIONS - WHEN YOU WASH 1. Wash below 40 degrees C. 2. Do not use excessive detergent 3. Do not use any detergent which contains bleach or liquid bleach 4. Rinse thoroughly,L,1000,0,1,0,0,1,1,1,0,1,1,,1,0,1,0,1,0,1,0,0,,,,,,,,,,,,,,,,,,,,,,,,,
Style-267-8-M,,Modesty,simple,,,base,Style-267-8-M,,,500,,,,,,,,,,,,,,grey,,,,1,Style-267-8-m,Style-267-8-m.html,,1,,,,,,Product Info Column,0,0,,,,9/27/2016 12:57,9/27/2016 12:57,,Use config,Use config,,0,,No,Crew,Elbow,Ramie,,WASHING AND IRONING INSRUCTIONS - WHEN YOU WASH 1. Wash below 40 degrees C. 2. Do not use excessive detergent 3. Do not use any detergent which contains bleach or liquid bleach 4. Rinse thoroughly,M,1000,0,1,0,0,1,1,1,0,1,1,,1,0,1,0,1,0,1,0,0,,,,,,,,,,,,,,,,,,,,,,,,,
Best Answer
You should follow below steps:
Below is the very basic csv sample;