Hmm... I just (yesterday) helped someone with a hostgator install. They had 11,000 records which I split into breaks of 4,000. These ran in about 20 seconds each. Not bad.
Here is something you may want to do: When importing LARGE amounts of data, go to Configuration -> Easy Populate 4 and set VERBOSE to OFF.
You DO NOT need EP to tell you that a record successfully imported. No sense in filling the HTML page with 4,000 lines of this. HOWEVER, even with VERBOSE OFF, you will still get ERROR printed to the screen so you'll know what they are.
Doing this will save you a VAST amount of memory and CPU time.
Let me know if this helps. Oh, also check your script execution time on the configuration page. Give it 60 seconds. You may need to check your php.ini setting for memory and execution time. A lot depends on how PHP is configured by your host.
Run time over-rides (like the one in configuration), and PHP.INI can still be trumped by core level php settings. You'd need terminal access to the server and an intimate knowledge of PHP to change settings here. I went through that with a person with 900,000 records... we broke these into 50K chunks and import went pretty smoothly after that.
-chadd
I see this is still being classed as in 'Beta' testing but has been for about 1.5yrs... Do you think a 'final' version will be released and put on to the add-on's site??
Forums are for helping people!! if you don't want to help people then shut up and get off the forum!
Howdies!
I'm currently using Zencart 1.5.0 and Easy Populate 4.0.22 - Beta 6-10-2012 to handle a CSV feed from a supplier, we've had issues in the past that're fixed now (for example, the first column in the CSV was read incorrectly fairly frequently), but a problem has arisen that I just can't fix.
The issue is that some products simply have no price listed despite the supplier providing them, though I did find that the offending products that I checked out weren't contained within the most recent CSV. This leads me to believe that during the importing the prices are being overwritten, and the products no longer in the CSV feed are obviously not receiving a v_products_price input with which to populate the database.
We'd be happy just having the products dropped if they're not on the feed, but the ideal solution would be to have stock set to 0 as opposed to price.
-Nathan