cancel
Showing results for 
Search instead for 
Did you mean: 

Importing configurable Error

Importing configurable Error

Im trying to upload my configurable products, some are working fine and some giving me following error: 

General system exception happened

Additional data: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`lcsbybd_mg2`.`mg_catalog_product_website`, CONSTRAINT `MG_CAT_PRD_WS_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `mg_catalog_product_entity` (`entity_id`) ON DELETE CAS), query was: INSERT INTO `mg_catalog_product_website` (`product_id`,`website_id`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) ON DUPLICATE KEY UPDATE `product_id` = VALUES(`product_id`), `website_id` = VALUES(`website_id`)
 
and this my csv file:
sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,additional_attributes,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,related_skus,crosssell_skus,upsell_skus,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,configurable_variations,configurable_variation_labels,associated_skus
01-039-001,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 2-8,24,1,0,Not Visible Individually,1203,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=250 Kg,lifting_speed=8 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-003,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 2-18,25,1,0,Not Visible Individually,1588,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=250 Kg,lifting_speed=4 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-005,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 5-4,25,1,0,Not Visible Individually,1295,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=500 Kg,lifting_speed=4 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-007,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 5-8,26,1,0,Not Visible Individually,1508,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=500 Kg,lifting_speed=8 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-009,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 5-18,26,1,0,Not Visible Individually,2082,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=500 Kg,lifting_speed=18 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-013,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 10-4,28,1,0,Not Visible Individually,1667,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=1000 Kg,lifting_speed=4 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-015,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 10-8,58,1,0,Not Visible Individually,1958,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=1000 Kg,lifting_speed=8 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
01-039-017,,WLLLS,simple,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,CPV 20-4,63,1,0,Not Visible Individually,2282,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,"wll=2000 Kg,lifting_speed=4 m/min",1500,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,0,0,0,1,,,,,,,,,,,,,,
Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,WLLLS,configurable,Products/Hoists/Electric Chain Hois-SS/CPV-CPVF,base,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,,,,1,0,"Catalog, Search",,,,,,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,Electric chain hoist with suspension hook - 1 Lifting Speed - 400V,CPV_L.jpg,,,,,,,,,,,,Block after Info Column,,,,,,,,,,,,,,0,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,0,0,0,0,1,,,,,,,,,,,,"sku=01-039-001,wll=250 Kg,lifting_speed=8 m/min | sku=01-039-003,wll=250 Kg,lifting_speed=4 m/min | sku=01-039-005,wll=500 Kg,lifting_speed=4 m/min | sku=01-039-007,wll=500 Kg,lifting_speed=8 m/min | sku=01-039-009,wll=500 Kg,lifting_speed=18 m/min | sku=01-039-013,wll=1000 Kg,lifting_speed=4 m/min | sku=01-039-015,wll=1000 Kg,lifting_speed=8 m/min | sku=01-039-017,wll=2000 Kg,lifting_speed=4 m/min","wll=WLL,lifting_speed=Lifting Speed",
 
i could not find the problem.