Created
August 28, 2015 09:05
-
-
Save coderofsalvation/3d0b0f01f567f164b004 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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