I imagine you are bringing all of these in through a spreadsheet and the import/export module? That's quite an import. I am curious how OpenCart will even handle that, let alone the queries afterward.OpenFan wrote:OK I will try it and give you link.
Is this going to be available as a tool for OpenCart site owners?Qphoria wrote:yea i dont think it will work with that import/export
I am working on an XML import script. I have it working for importing RSS feeds.. but trying to make it so that it can import custom fields and be dynamic.
Export: up to 12,320,768 bytes
Import: up to 354,942,976 bytes
Which works fine with the following PHP settings:
The XLS file size is 9MB.
The high memory usage of the Import is due to the fact that the underlying PHPExcelReader parses the whole file into RAM memory first before being able to access the spreadsheet cells.
I have also run some tests with the ods-php and the PHPExcel, both of them use even more memory for reading and parsing the XLS and/or ODS file. Probably the only way to ever support larger amounts of products would be by using CSV files or plain text files which could be read serially, one line at a time, using far less memory. I have done something similar for several customers who needed their Opencart database to be populated by datafeeds from special suppliers. Of course, the suppliers have their own formats for their product catalogs, so it can only be done individually for each Opencart customer as needed.
MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig
Yes, I was thinking right away that it should be CSV files, which is totally acceptable for distribution to the site owner from the webmaster. The site owner (the business owner) would likely have MS Excel or OpenOffice installed and ready to use. The CSV files, inside these two programs, don't act much different than an Excel (.xls) spreadsheet.JNeuhoff wrote:Probably the only way to ever support larger amounts of products would be by using CSV files which could be read searially one line at a time, using far less memory.
After looking at the php.ini file with open cart, it says
Code: Select all
memory_limit = 64M;
Code: Select all
fread() [<a href='function.fread'>function.fread</a>]: Length parameter must be greater than 0 in /home5/rogerss1/public_html/store/system/library/cache.php on line 25
Users browsing this forum: Bing [Bot] and 13 guests