Skip to content

Instantly share code, notes, and snippets.

@coderofsalvation
Created August 28, 2015 09:05
Show Gist options
  • Save coderofsalvation/3d0b0f01f567f164b004 to your computer and use it in GitHub Desktop.
Save coderofsalvation/3d0b0f01f567f164b004 to your computer and use it in GitHub Desktop.
importing products from csv-file: executing: DROP TABLE IF EXISTS sync_products_import;
executing: CREATE TABLE IF NOT EXISTS sync_products_import ( Id varchar(255),Name varchar(255),Ptype varchar(255),Price varchar(255),Stock varchar(255),IsInStock varchar(255),Category varchar(255),SubCategory varchar(255),SearchName1 varchar(255),SearchName2 varchar(255)
);
executing: INSERT INTO sync_products_import (Id,Name,Ptype,Price,Stock,IsInStock,Category,SubCategory,SearchName1,SearchName2) VALUES ('398','','simple','39.2','165890','0','Overige','Kegels/Kogels/Naalden','6.35BNZ','6,35MM BRONZE');
.OK
OK
comparing products executing: SELECT * FROM sync_products_magento as a, sync_products_import as b where a.Id = b.Id AND ( a.Stock != b.Stock )
1 updates found
updating products .SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`admin_ibs`.`catalog_product_entity`, CONSTRAINT `FK_CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN
KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON )
done (took 0 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment