L
L
Lana2020-06-16 08:23:37
opencart
Lana, 2020-06-16 08:23:37

Which Export/Import module for ocStore is relevant for 2020?

Now the site has the Export/Import Tool (OpenCart 3.x) module installed.
But there were errors that did not allow unloading goods from the site:

PHP Exception:  Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''','','','','','','',7,'04439-12020',0,'',1,2493,0,'2020-06-02 13:31:279','2020-' 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 (4811,50+,'','','','','','','',7,'04439-12020',0,'',1,2493,0,'2020-06-02 13:31:279','2020-06-02 13:31:279','2020-06-276',0,1,1,0,0,0,0,0,'1','1','1','1'); in /home/bhx20710/public_html/system/library/db/mysqli.php on line 40

PHP Fatal Error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20971520 bytes) in /home/bhx20710/public_html/system/library/export_import/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 177

The first is more likely due to the fact that there were errors in the product with id 4811, the second due to lack of memory.
I solved the problem by increasing the memory, but I'm not sure how long it will last.
I would like to find a good module, because. There are 11 thousand goods on the site and I would not want to unload everything and re-upload every time. Nothing too complicated is needed, the store only works with its own price list, adding products and changing prices.
Or maybe leave this module, because. the functionality is almost satisfactory, but will there be problems with memory with a large number of goods?
Registered in htaccess - php_value memory_limit 512M, in php.ini - memory_limit = 512M; and the memory problem disappeared and it turned out to upload the file from the site. Maybe someone will help.
Thank you.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question