Помогите с модулем импорта/экспорта.

[start579]

До субботы работал нормльно, надо было на выходных цены поменять, выгрузилось нормально, а загружаться не хочет.

В магазине около 7 тыс товара.

Грузит в магазин максимум 100 товаров. перепробовал много модулей все глючат.

Журнал ошибок.

2015-10-20 13:40:24 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 13:40:33 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 13:41:44 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 13:54:15 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:43:14 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1',' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (28,10,'501064','','','','','','',7,'Urban',11,'data/Parker/501064.jpg',1,,0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1','1','1','1'); in /home/ikos/1000suvenirov.com.ua/www/system/database/mysql.php on line 50
2015-10-20 14:43:26 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:45:34 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:50:53 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1',' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (28,10,'501064','','','','','','',7,'Urban',11,'data/Parker/501064.jpg',1,,0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1','1','1','1'); in /home/ikos/1000suvenirov.com.ua/www/system/database/mysql.php on line 50
2015-10-20 14:53:10 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:57:12 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:57:21 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:57:28 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 14:58:43 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1',' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (28,10,'501064','','','','','','',7,'Urban',11,'data/Parker/501064.jpg',1,,0,'2015-09-14 13:36:07','2015-09-14 13:37:11','2015-09-13',0,1,1,0,27,0,0,0,'1','1','1','1'); in /home/ikos/1000suvenirov.com.ua/www/system/database/mysql.php on line 50
2015-10-20 15:15:41 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 15:46:17 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 17:13:32 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 17:13:37 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 17:45:44 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 19:48:55 - PHP Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 95 bytes) in /home/ikos/1000suvenirov.com.ua/www/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 1218
2015-10-20 19:49:05 - PHP Warning: Invalid argument supplied for foreach() in /home/ikos/1000suvenirov.com.ua/www/catalog/controller/module/product_tab.php on line 33
2015-10-20 19:49:43 - PHP Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 94 bytes) in /home/ikos/1000suvenirov.com.ua/www/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 1218

[deim]

 

 

 Allowed memory size of 134217728 bytes exhausted (tried to allocate 95 bytes) in /home/ikos/1000suvenirov.com.ua/www/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 1218

Вы используете для загрузки товаров формат XLS. Вам не хватает оперативной памяти.

Выход - использовать xlsx и/или другой модуль для импорта/экспорта

[afwollis]

еще надо будет доработать модуль, учитывая

...jpg',1,,0,'2015-09-14 13:3...