cancel
Showing results for 
Search instead for 
Did you mean: 

Importing configurable Error

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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.