Quote Originally Posted by double-happiness View Post
Now attempting to purge my entire inventory and start from scratch by deleting categories, but it seemed to be too much for the server as the admin page became inaccessible and eventually my site went down altogether for a time, with 'WARNING: An Error occurred, please refresh the page and try again.' Tried to work around by creating extra database users in MySQL and editing /includes/configure.php to the rotating users tweak as on http://www.zen-cart.com/showthread.p...728#post144728 but that didn't work either so I had to switch back. It seems my shop works fine so long as I never try to update the inventory. There has to be an easier way than this... :sighs:
Hi,

If you want to clear out your inventory, but the admin delete is timing out, then you need to do a search for the SQL commands that you can run via the SQL patch feature to remove them.

Note that when you delete an item from the admin, it also deletes the associated photo. You may not want that.

Adding a custom field is a two part process... first you need to add the field to the data base via phpMyAdmin from within your cpanel, once you've done that, then you need to enter it in the EP4 configuration page.

Also note: Database field name CANNOT have spaces in them, which is what you look to have done.

EP4 DOES handle file upload and downloads. But it doesn't STREAM the file at run time, meaning the data is exported to a file in your temp directory, and then from there you can download it.

Also, if you have a large import file, and a low end shared server/hosting environment, then you should use the SPLIT feature after you upload the file to break your import file into manageable chunks. Much work when into improving the performance of EP4, and I have tested with with another user importing 900,000 records... in this case we broke the file into 50,000 chunks and those import in about 200 seconds. He had a dedicated server which is much more powerful that the typical shared hosting. So try for the default of 2,000 record breaks when you split.

Note that this version is not an "upgrade" to the other out there, but a rewrite with many core changes to the code.

Hope this helps...