#112 Trouble Importing Bundle Product

[Mauro BigBlack]

Hi guys,
i’ve a problem when i’m importing bundle product. I put in the column those data:
bundle_options :
Misure:drop_down:1:0
——————–
bundle_skus (the | i’ve tryed to substitute with ; but is the same):
Misure:tavolo-senza-ripiano-700-l-x-700-p-x-850-h:1:0:0:0:343:0|Misure:tavolo-senza-ripiano-800-l-x-700-p-x-850-h:1:0:0:0:370:0|Misure:tavolo-senza-ripiano-900-l-x-700-p-x-850-h:1:0:0:0:386:0|Misure:tavolo-senza-ripiano-1000-l-x-700-p-x-850-h:1:0:0:0:399:0|Misure:tavolo-senza-ripiano-1100-l-x-700-p-x-850-h:1:0:0:0:415:0|Misure:tavolo-senza-ripiano-1200-l-x-700-p-x-850-h:1:0:0:0:427:0|Misure:tavolo-senza-ripiano-1300-l-x-700-p-x-850-h:1:0:0:0:442:0|Misure:tavolo-senza-ripiano-1400-l-x-700-p-x-850-h:1:0:0:0:458:0|Misure:tavolo-senza-ripiano-1500-l-x-700-p-x-850-h:1:0:0:0:472:0|Misure:tavolo-senza-ripiano-1600-l-x-700-p-x-850-h:1:0:0:0:490:0|Misure:tavolo-senza-ripiano-1700-l-x-700-p-x-850-h:1:0:0:0:507:0|Misure:tavolo-senza-ripiano-1800-l-x-700-p-x-850-h:1:0:0:0:526:0|Misure:tavolo-senza-ripiano-1900-l-x-700-p-x-850-h:1:0:0:0:541:0|Misure:tavolo-senza-ripiano-2000-l-x-700-p-x-850-h:1:0:0:0:557:0|Misure:tavolo-senza-ripiano-2100-l-x-700-p-x-850-h:1:0:0:0:575:0|Misure:tavolo-senza-ripiano-2200-l-x-700-p-x-850-h:1:0:0:0:681:0|Misure:tavolo-senza-ripiano-2300-l-x-700-p-x-850-h:1:0:0:0:701:0|Misure:tavolo-senza-ripiano-2400-l-x-700-p-x-850-h:1:0:0:0:716:0|Misure:tavolo-senza-ripiano-2500-l-x-700-p-x-850-h:1:0:0:0:736:0|Misure:tavolo-senza-ripiano-2600-l-x-700-p-x-850-h:1:0:0:0:750:0|Misure::1:0:0:0::0|Misure:tavolo-senza-ripiano-700-l-x-600-p-x-850-h:1:0:0:0:325:0|Misure:tavolo-senza-ripiano-800-l-x-600-p-x-850-h:1:0:0:0:350:0|Misure:tavolo-senza-ripiano-900-l-x-600-p-x-850-h:1:0:0:0:365:0|Misure:tavolo-senza-ripiano-1000-l-x-600-p-x-850-h:1:0:0:0:380:0|Misure:tavolo-senza-ripiano-1100-l-x-600-p-x-850-h:1:0:0:0:394:0|Misure:tavolo-senza-ripiano-1200-l-x-600-p-x-850-h:1:0:0:0:405:0|Misure:tavolo-senza-ripiano-1300-l-x-600-p-x-850-h:1:0:0:0:418:0|Misure:tavolo-senza-ripiano-1400-l-x-600-p-x-850-h:1:0:0:0:433:0|Misure:tavolo-senza-ripiano-1500-l-x-600-p-x-850-h:1:0:0:0:448:0|Misure:tavolo-senza-ripiano-1600-l-x-600-p-x-850-h:1:0:0:0:466:0|Misure:tavolo-senza-ripiano-1700-l-x-600-p-x-850-h:1:0:0:0:480:0|Misure:tavolo-senza-ripiano-1800-l-x-600-p-x-850-h:1:0:0:0:498:0|Misure:tavolo-senza-ripiano-1900-l-x-600-p-x-850-h:1:0:0:0:513:0|Misure:tavolo-senza-ripiano-2000-l-x-600-p-x-850-h:1:0:0:0:527:0|Misure:tavolo-senza-ripiano-2100-l-x-600-p-x-850-h:1:0:0:0:545:0|Misure:tavolo-senza-ripiano-2200-l-x-600-p-x-850-h:1:0:0:0:645:0|Misure:tavolo-senza-ripiano-2300-l-x-600-p-x-850-h:1:0:0:0:665:0|Misure:tavolo-senza-ripiano-2400-l-x-600-p-x-850-h:1:0:0:0:678:0|Misure:tavolo-senza-ripiano-2500-l-x-600-p-x-850-h:1:0:0:0:698:0|Misure:tavolo-senza-ripiano-2600-l-x-600-p-x-850-h:1:0:0:0:711:0|Misure::1:0:0:0::0
——
Categories:
Inox/Tavoli
I retrieve for each bundle product line this error:
SKU tavolo-senza-ripiano – 1 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (inox.catalog_product_bundle_selection, CONSTRAINT FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ) –
SKU tavolo-senza-ripiano – 2 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (inox.catalog_product_bundle_selection, CONSTRAINT FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ) – ERROR ON RECORD #2
also this for some lines:
SKU tavolo-armadiato-neutro – 53 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (inox.catalog_product_bundle_selection, CONSTRAINT FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ) –
SKU tavolo-armadiato-neutro – 54 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (inox.catalog_product_bundle_selection, CONSTRAINT FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ) – ERROR ON RECORD #706
or this:
SKU lavatoio-senza-ripiano-1-vasca-con-1-gocciolatoio-destro-1000-l-x-700-p-x-850-h – 1753 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘entity_type_id’ cannot be null –
SKU lavatoio-senza-ripiano-1-vasca-con-1-gocciolatoio-destro-1000-l-x-700-p-x-850-h – 1754 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘entity_type_id’ cannot be null – ERROR ON RECORD #2873
and this warning:
3762 warning(s) found Hide Details
SKU tavolo-senza-ripiano-700-l-x-700-p-x-850-h – Weee Tax importer v0.0.5 – No weee data found
SKU tavolo-senza-ripiano-700-l-x-700-p-x-850-h – Invalid category ids found for sku tavolo-senza-ripiano-700-l-x-700-p-x-850-h:43,44,45
Can you help me where I’m wrong?
Thank you!

[Mauro BigBlack]

No one? If I substitute the bundle_skus title column with bundle_selection, I succed to import all bundle product but there are no bundled articles inside them.