Re: Easy Populate support for Version 1.2.5.4
I've skimmed much of the 300+ pages of this thread and haven't found this problem. There isn't any mention of it I can find in the faq. There is one other thread with the exact same problem, but there were no replies. If it has been addressed, can someone please post a link?
I just used EP 1.2.5.4 (downloaded from langer's modhole) to upload nearly 15k products to my site. I used the split function, but kept getting a "no product number" loading error. So I opened the .csv file and broke it up myself. I found that somewhere between downloading the file from my distributor, changing it from comma-delimited to tab-delimited, and uploading it to my site, I must have screwed up because products with a price that included a comma had an extra field, causing the upload problem. So, I fixed the field length problem, and uploaded all the products, in 300-field files, with no problems.
Problem is, when I try to access the product/category function in admin, I now get the error:
Fatal error: Maximum execution time of 60 seconds exceeded in (mydomain)zencart/renamed admin)/includes/functions/general.php on line 220
Server Information
Server Host: host308.hostmonster.com
Database Host: localhost
Server OS: Linux 2.6.32-25.8.BHsmp
Database: MySQL 5.1.47-community-log
HTTP Server: Apache
PHP Version: 4.4.9 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 8,949 kB Database Index Size: 6,480 kB
Zen Cart 1.3.9f
Patch: 1::
Database Patch Level: 1.3.9a
Did I just overload the capacity of zencart, or is there a solution to this?
edit: I should mention I've had the site up and running with a hundred or so products for a couple years with few problems.
Re: Easy Populate support for Version 1.2.5.4
Not sure about alot of the problems as I haven't encounted them, however the overloading the capacity of Zen-cart, I have about the same number of products and no issues.
I did have issues using the slpit function too the first time I used EP, but now I do it all manually and have never had another issue.
Good luck.
Re: Easy Populate support for Version 1.2.5.4
hi, anyone know of how to include the product sort order? I am listing 1000s of products but finding that i am having to go threw manually and set each sort order to display in the desired way. :(
Re: Easy Populate support for Version 1.2.5.4
I have added Sort Order to products. I have done minimul testing.. uploading here for others to play and test. Please let me know if it works or not for you.
Download file, rename to easypopulate.php, upload to test webspace, use. Thanks
1 Attachment(s)
Re: Easy Populate support for Version 1.2.5.4
ffs - forgot to add file!
1 Attachment(s)
Re: Easy Populate support for Version 1.2.5.4
:censored: windows 7 :censored: crap
Re: Easy Populate support for Version 1.2.5.4
forestfrogsllc Its looks like you are trying to up load too many products at once (300 is the ma I would upload at once),also your hosting company looks to have limits on php memory and script running time, which is set to 60 seconds so as soon as the .php file runs over 60 seconds the import will fail.
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Scrat
forestfrogsllc Its looks like you are trying to up load too many products at once (300 is the ma I would upload at once),also your hosting company looks to have limits on php memory and script running time, which is set to 60 seconds so as soon as the .php file runs over 60 seconds the import will fail.
I did break up the file, and got it uploaded. The problem occured later, when I was timing out when trying to view the category/product page after I uploaded everything.
The problem was entirely my fault.
At some point, when I was converting from the comma-delimited file provided by the distributor to the tab-delimited file for EP, I must have allowed BOTH commas and tabs to be delimiters. Any product with a price of more than $999 had a comma in it, so those records ended up with additional fields. This bumped all the fields beyond the new fields out of synch with the field labels. So, the V_category1 field in those records had data from the v_quantity field in it. This caused EP to create a new category for each record which had a different number of products in inventory (using the number of products as the category name). I had so many categories that loading them timed out the server.
I finally managed to get the extra categories deleted, and the ISP reset me to version 5 PHP so the website would load, and we are back up and running.
Re: Easy Populate support for Version 1.2.5.4
Hi all I have now been trying to get this working an d now have ended up on my admin under configuration 4 easy populate names and trying to get it updated when going undr tools to easy populate i now get this error, Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /misc/19/180/507/995/7/user/web/australian-solar-traders.com/steffen/easypopulate.php on line 979
Parse error: syntax error, unexpected $end, expecting ']' in /misc/19/180/507/995/7/user/web/australian-solar-traders.com/steffen/easypopulate.php on line 979
Can anyone please help me or tell me how to delete it of my Shop i have been nutting this out for ages and im going :lamo:
any help would be super :dontgetit
Re: Easy Populate support for Version 1.2.5.4
I'm having a problem with EP 1.2.4.5
I am stocking a second site with products and using the same versions of ZC 1.3.9 and EP. I have no problem uploading to my first site, but for some reason the second one is not loading the files.
I have tested this on my first site and they load just fine, then I take the same unaltered file and try to upload to the second site, and it won't take. I have tried many different types like txt, csv, tsv, xml, etc
Any Ideas?
The only difference I can think of is that my first site is hosted on godaddy (crappy host, I know), and my other one (still in test phase), is hosted on some free site (Once I get everything set up right, I plan to transfer to a good host.)
The permissions of the temp folder are set to 755, just like the one godaddy (or the 755+ equivalent)
Also, the first site has a few add-ons like Image handler (though it is disabled at the moment), EP, etc nothing really extravagant.
Any help would be appreciated.
Thanks
Matt