Easy Populate 1.2.5.4 support

[dealbyethan.com]

Found the solution:

when you move a master product using EPA it should reset the master category id to the new category. IF not, please try the "Reset ALL Products Master Categories ID" button in Admin -> Tools -> Store Manager.

[monkeytown]

When I run Easy Populate, the results page never loads. It just spins until it either 1) displays a blank page or 2) asks me to open or save the file easypopulate.php (similar to if you have clicked a download file link). Everything works as in the products get inserted/updated as they should, but I like to see the summary page to easily check that the items were handled right (i.e. my data file was formatted correctly)

Anything I can do to fix this or anyone know what the problem may be. I'm not sure when this started or why. Not a huge deal if I can't resolve it I guess.

[monkeytown]

When I run Easy Populate, the results page never loads. It just spins until it either 1) displays a blank page or 2) asks me to open or save the file easypopulate.php (similar to if you have clicked a download file link). Everything works as in the products get inserted/updated as they should, but I like to see the summary page to easily check that the items were handled right (i.e. my data file was formatted correctly)

Anything I can do to fix this or anyone know what the problem may be. I'm not sure when this started or why. Not a huge deal if I can't resolve it I guess.

I did a fresh install after a server crash corrupted my cart (it wasn't live yet fortunately) and I noticed this issue start when I had around 22000 items loaded in the cart. Now the results page never shows if I load 5k or 200 items from a .txt file. Any tips or an explaination appreciated.

[awhfy99]

I did a fresh install after a server crash corrupted my cart (it wasn't live yet fortunately) and I noticed this issue start when I had around 22000 items loaded in the cart. Now the results page never shows if I load 5k or 200 items from a .txt file. Any tips or an explaination appreciated.

That sounds about right. Mine went into that mode after I passed the 20K products also. This has been mentioned a time or two in this forum but it doesn't look like there is a fix for it (at least no one has suggested one yet). I just reconciled myself to the fact that I don't need to know the details of my uploads, as long as they all get there in one piece. I tried a one line upload just to verify that file size wasn't an issue. It wasn't, as I timed out there, too.

Good luck in finding out anything more about this quirk!

[Scrat]

Hi monkeytown - What Version of EP are you using? (Hopefully 1.2.5.4, if not use it or EPA)
Otherwise it could be a hosting issue if you are still having the issue on a new install as in theory you have done a clean install again. Contact you host and seek their advice if anything has changed on you account/server.

Wow - 22000 products I wouldn't like to do a stock-take, I would only upload 300-400 products at once as php does have a very big memory...

Also have you tried saving to \temp and ftp the file, as with bigger db's this can be a better option?
I was having similar problems with my old host EP would not update and hang, or take 'hours' to update or download. It may be a case that there are too many accounts on your server and its just too slow, I know I used to have only 10 connections to my database so if you have 9 users on your site as you upload you file that becomes 10 users and then think you could have 2000 other accounts on that server, well what do you think things begin to become very slooooow.
If this may be the case you may what to look for another host?

[Scrat]

awhfy99 & monkeytown - Have you tried this on your test site on your localhost to see if you get the same results? If you don't it may be an issue that you need a dedicated server to get this to work with this many products.
Guessing, on a shared server, you will be limited to a shared amount of memory for each account?

[chadderuski]

When I run Easy Populate, the results page never loads. It just spins until it either 1) displays a blank page or 2) asks me to open or save the file easypopulate.php (similar to if you have clicked a download file link). Everything works as in the products get inserted/updated as they should, but I like to see the summary page to easily check that the items were handled right (i.e. my data file was formatted correctly)

Anything I can do to fix this or anyone know what the problem may be. I'm not sure when this started or why. Not a huge deal if I can't resolve it I guess.

Monkeytown: May I ask where your hosting your site at and store? Very interested to see how your performance is with zencart and a store of that size.

For your issue: do you have access to php.ini? I do at bluehost.com and was able to up my memory size to 32meg and execution time. Most basic installs are only 8meg. Ask your hosting what these setting are and if you can get more. You can also check in phpMyAdmin under "variables" for you max user connections. Mine is 30 which is pretty generous for shared hosting.

During an update, you should definitely put the store on "maintenance" so no one is poking around while during upload.

For me, I can upload about 2,300 products and it takes about a minute to upload > process > output results.

Perhaps you can break the file up into 5k chunks?

I also wish the output was sent to a text file on the server.

Hope this was helpful.

chaddro.

[monkeytown]

Yes, I am using EP 1.2.5.4. and actually, the store has around 36K items total :/

We are currently hosting with a local company. I don't have access to the php.ini file, but they are pretty good about editing setting etc upon request but unless I knew specifically what to ask them to do, I think they would tire of me constantly asking them to tweak things to try and come up with a solution. We may in the future move to IPOWER and get on a Virtual Private Server.

I broke down my upload files into categories which are usually a couple hundred lines, although some are approx 1500. Then I have around 30K items that I broke into 5K files to upload in sections.

I am pretty sure I have the same problem on localhost, but I haven't loaded on it recently so I may not be remembering correctly.

Our store isn't really live yet we are building it. Technically it is, but no one knows about it so I haven't put it on maintenance mode for that reason. Regarding performance, it seems a bit slow in some places. In Admin, loading the top level categories takes probably 20 seconds, and while browsing, product detail pages take several seconds, and searching takes 10-15 seconds probably, but it doesn't seem too terribly long.

Under max user connections, on my phpmyadmin it says 0

I agree that a text file would be nice at least in this case. I will maybe try to troubleshoot this sometime, but I guess for now it isn't a big deal.

[Doodlebuckets]

Hello! I am using EP to upload attributes for products on a new site (taking attributes from an existing site. Model #'s have been made to match up). I have opened the attributes download and don't see all of the attributes for my products there. I thought to look because the attributes are not showing up on the products I am trying to add them to on the new site. So the "chocolate" attributes are nowhere in the file but they are a part of my attributes from the products on my current site. The file is 8.25 MB. Does the file size get limited and not all the info download when it gets too big? What else do I need to try? Please help!

Example product from current site:
http://www.doodlebuckets.com/store/n...kie-p-328.html

Example from same product on new site with same model #:
http://www.giftsofcharacter.com/cata...kie-p-605.html

I have successfully added attributes to other products but don't understand why these aren't working and why the option values aren't showing up in the file..

Thanks! Amy

[Doodlebuckets]

Never mind! I figured it out...