Export/Import too many products

Hi,

I have increased my product database to about 14,000 and wanted to have it up to over 20,000. But the module won't allow me to export a copy of my products and so rather than changing via my spreadsheet I will have to manually type in the products and adjust prices.

I have been looking on the forums but can't find a solution. Does anyone know how to fix this?
Thanks

There is no error in my logs after receiving this page and my host said I have the following memory
Memory Limit 4GB
Post Max Size - 100m
Upload max file size - 100m

memory_limit = 512M;
max_execution_time = 36000;
post_max_size = 999M;
upload_max_filesize = 998M;

Note that post exceeds upload, that is required.

Try phpinfo.php to see what the server thinks is going on. The tiny one-line utility phpinfo.php (here: http://forum.opencart.com/download/file.php?id=18153) can be uploaded into OC (or your account, public) and addressed in the browser. Put it in both your OC root and your /admin/. Address it as usual, but after domain/whatever/phpinfo.php (and domain/whatever/admin/phpinfo.php).

You do NOT need to wade through these just to set the foregoing, but they'll give you your bearings.

On php.exe and php.ini:
http://forum.opencart.com/viewtopic.php ... ni#p426535
On master php.ini:
http://forum.opencart.com/viewtopic.php ... 80#p444711
http://forum.opencart.com/viewtopic.php ... r+#p445305

erm... does that ... not sure what that means. Sorry, but is there any chance I could pay you to get it going again?

PM sent.

Using PHPExcel library cache mechanism would solve the problem as phpexcel save method inherently has a bug that when it timeouts there is no error thrown

That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.

Solved. Thank you so much. It works!!

butte wrote:That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.

Sorry for putting it in different way
I meant without caching it only works till 14K rows and throws no errors and no warnings when it times out
Not sure if error can still be thrown

That is good, southernbusiness, go ahead and edit your opening title Solved.