zencart Easy Populate CSV 插件

easy_populate_csv_for_zencart下载：http://pan.baidu.com/s/1o67ngnw 支持Zen Cart® Versions v1.5.0, v1.5.1, v1.5.3, v1.5.4

公告：easy_populate_csv_for_zencart_v1.5.x_v1.2.6此版本是官方下载，在v1.5.4中安装测试了不能用

注意：easy_populate_csv_for_zencart 数据库安装时请把sql代码放在数据库中操作，不要在后台Tools->Install SQL Patches下执行,否则后台执行会出现 “WARNING: An Error occurred, please refresh the page and try again.” 错误

zencart 安装后easy_populate_csv插件后上传批量表上传不了，查看日志出现下面错误
[sql]
MySQL error 1364: Field ‘categories_description’ doesn’t have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 1, ‘1’, ‘Canada Goose Dame’ )
MySQL error 1364: Field ‘categories_description’ doesn’t have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 2, ‘1’, ‘Camp Down’ )
MySQL error 1265: Data truncated for column ‘products_weight’ at row 1
When executing:
INSERT INTO products SET
products_model = ‘CGSE_Parka_32314’ ,
products_price = ‘4295.43’ ,
products_image = ‘cgse/jakke-canada-goose-toNg6FUL-tilbud.jpg’ ,
products_weight = ‘1.5lbs’ ,
products_tax_class_id = ” ,
products_date_available = ” ,
products_date_added = ‘2015-07-07 23:55:00’ ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = ‘227’ ,
master_categories_id = ‘2’ ,
manufacturers_id = ‘NULL’,
products_status = ‘1’,
metatags_title_status = ‘1’,
metatags_products_name_status = ‘0’,
metatags_model_status = ‘0’,
metatags_price_status = ‘1’,
metatags_title_tagline_status = ‘0’

[/sql]
这也许是STRICT_TRANS_TABLES模式，严格模式，进行数据的严格校验，错误数据不能插入
查看下mysql模式
[sql]
mysql> select @@sql_mode;
+—————————————————————-+
| @@sql_mode |
+—————————————————————-+
| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+—————————————————————-+
[/sql]
如果有STRICT_TRANS_TABLES，在mysql目录下my.ini中查找STRICT_TRANS_TABLES.
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
去掉STRICT_TRANS_TABLES
sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

在Zen Cart 1.5.4 版本中上传出现WARNING: An Error occurred, please refresh the page and try again.错误，在admin\includes\extra_configures\enable_error_logging.php中找到 @ini_set(‘display_errors’, 0);
把里面的0改为1，查看错误报表

错误报表显示zencart Unknown column ‘EASYPOPULATE_CONFIG_CUSTOM_FIELDS’这个的话应该缺少一个’EASYPOPULATE_CONFIG_CUSTOM_FIELDS’字段
在表中添加字段
[sql]alter table products add EASYPOPULATE_CONFIG_CUSTOM_FIELDS char(10);[/sql]