Easy Populate 1.2.5.4 support

Hi again....

schoolboy, many thanks I'll let you know the outcome.

ckosloff, no sir no plugging here, but I see you are in the same boat as me for attributes (from another post in this forum) from my weeks worth of reading on all EP vs, I am confused about them and merely poking and hoping to end in the right direction even if I have to trial that comm vs.

My needs as previously are to try and decipher what my supplier sends me as some sort of Jumbled up CSV daily file which has a heap of products most I sell some I don't.
My cart has already loaded by hand around 500 products only about 25 with attributes....

What vs do you have currently? Have yo had any luck with Attributes?
Thanks R

Renz, take a look at this as it may help with your attribute issue if they are straight forward. I only came across this, and have not tested it:

http://www.zen-cart.com/forum/showthread.php?t=134245

EP Advanced does do attributes to some degree but I have not test it much. I have begun picking at a solution for attributes, but this may take some time (paid work prevails). I do not think the logic in even Langer's advance version is "correct". Needing 100+ columns to do attributes? I exaggerate only a little. I think my solution may work much better, but time will tell.

-cj

Hi Chadderuski and thanks for that, so you think EP 1.2.5.4 is the way to go or shall I give the one of the later vs a go, it appears that they do the same but the code has been cleaned up, pls correct me if I am wrong.

I guess the best way for me to get going is to do full back ups and start to play with one of the EP's.

In reading various sites I have come across the following can you or anyone tell me if this is possible in EP, as I get a jumbled mess of a CSV (with a listing of only what they are offering on that day) from supplier and this would sort my problem.

All the Best RR and I thank you for any advice

On Upload

Mark unlisted products as "Out of Stock" ( in Zen Cart this is "In Stock" property of a product) - all products that were not affected by import will be marked as unavailable, but will not be deleted.

Import Method

Add and Modify - will add new product if it is not available in database yet and modify those products that were found
Add Only - only add new products
Modify Only - only update existing products and do not add new entries, even if current product was not found
Just Add - this option may produce product duplicates, since

Renz:

Those all look like basic switches that could be incorporated into the code.

I've sent you a PM.

-cj

Just wanted to know, is there a maximum file size for Easy Pop? I have about 4000 items on my site, but I upload them them in different feeds. When I try to download them all at once it gives me a blank page, with one of the last words in the url stating: "full". I just would like to know how to get around this.

byrd813:

Just wanted to know, is there a maximum file size for Easy Pop? I have about 4000 items on my site, but I upload them them in different feeds. When I try to download them all at once it gives me a blank page, with one of the last words in the url stating: "full". I just would like to know how to get around this.

"full" in the URL refers to the download type you are performing. Have you tried "Create Easy Populate Files in Temp Directory"? You could then pull the file down with ftp software.

Also, you may want to check your server's settings. If you are on a shared host with limited resources, you may need to increase some of your memory and time limits in your php.ini file - provided your host allows this - because many are set to the most basic needs out-of-the-box.

Renz:

ckosloff, but I see you are in the same boat as me for attributes (from another post in this forum)
In the coming days I am going to try new version of Improved Attributes Controller (have been using Bulk Attributes Controller, so far).
There is another (very old) mod out there:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=469
gonna try that one too.
I think that I will need to get hands on with the code eventually.
Nothing that I have seen so far is satisfactory and I cannot afford to throw money down the drain with the commercial version.
Easy Populate 1.2.5.6 works OK for products but that is not my main concern.

ok, I hope no one gets angry from me posting something that has been posted a bunch in this thread.

But... there are simply too many pages in this thread, and the 60 or so I actually read didnt give me the answer I needed, and search doesnt do justice in this support thread lol

That being said, Here goes...

I am getting an Internal server 500 error. I even tuned it down to split the file at 100 records, it will do the first 20 files fine when trimmed down to a mere 100 records, then about file 21 or so will internal server error.

I contacted my Host and asked them to check everything I saw people on here stating that they checked or changed on their servers, and their reply was:

I took a look at the server logs. It doesn't appear that the process killer on the server is stopping zencart. The easypopulate.php script seems to be dieing on it's own. Unfortunately this is all the log shows.

logs/mywatchstore.org/http/error.log.2009-09-23:[Wed Sep 23 17:59:39 2009] [error] [client (ip address edited out for security)] Premature end of script headers:
easypopulate.php, referer:
http://www.mywatchstore.org/%28admin folder name edited out for security)/easypopulate.php

Not much help there. Also it doesn't appear to be mod_security or any hack prevention software stopping it either. I'm not really sure why you are getting these internal server errors, but maybe the info above will help the zencart forums track down the correct action. If you have any more questions or info then please let me know.

So, any ideas as to why it is still erroring out? I have tried reinstalling the mod as well.

Thanks ahead of time for your help -Eric

Eric, this may sound really silly, but have you tried looking as your CSV file just in word pad. I had a problem with my file, after the first 18 rows, all of a sudden threw a comma out of place (gotta love Microsoft) and it gave me some crazy errors as well (don't remember what they were, but they had nothing to actually do with the server). I just had to manually fix the comma's in wordpad and it worked after that.

Just a thought.

chadderuski:

"full" in the URL refers to the download type you are performing. Have you tried "Create Easy Populate Files in Temp Directory"? You could then pull the file down with ftp software.

Also, you may want to check your server's settings. If you are on a shared host with limited resources, you may need to increase some of your memory and time limits in your php.ini file - provided your host allows this - because many are set to the most basic needs out-of-the-box.

I have tried to create & upload via ftp, but the file never shows up in the TempDir. Where exactly is the php.ini file?

margecc:

Eric, this may sound really silly, but have you tried looking as your CSV file just in word pad. I had a problem with my file, after the first 18 rows, all of a sudden threw a comma out of place (gotta love Microsoft) and it gave me some crazy errors as well (don't remember what they were, but they had nothing to actually do with the server). I just had to manually fix the comma's in wordpad and it worked after that.

Just a thought.

I tried this, opened it in notepad, and I couldnt see anything wrong, but with over 3000 lines that are not the same length I can't really tell if it is right or not :(

1 more question...

I have tried to find all the instructions I could on how to use this correctly.

I notice that if I import and leave the picture spot or any other spot blank, it empties it from the database. I.E. if I just leave the picture cell blank it removes the pic from the product.

If I delete this column will it not update the picture then?

Or do all of the headers have to be present for it to work correctly?

Thanks

can I make this to work with Group Pricing (per Item) mod?

eric47905:

1 more question...

I have tried to find all the instructions I could on how to use this correctly.

I notice that if I import and leave the picture spot or any other spot blank, it empties it from the database. I.E. if I just leave the picture cell blank it removes the pic from the product.

If I delete this column will it not update the picture then?

Or do all of the headers have to be present for it to work correctly?

Thanks

Eric,

This thread has turned into the "do all version EP" thread. So we need to know the specific version you are using: OSC, TAB, CSV! (though I'm assuming CSV).

Also, when using EP, you need to start with just a few lines! And better yet, post a sample for us to look at. Lots of things can go wrong if you are not careful.

Of note in excel: If you delete CELLs you can get orphane white space that will result in many lines of empty data. Always delete full rows, and be sure you do this at the end of your file. Also, bad "white space" data can end up in columns after your main data. Hilight a number of columns after your last column and delete those.

You don't need every header, but you do need v_products_model. You cannot use any of these versions of EP with a blank v_products_model.

-cj

when trying to import my .csv file downloaded from another site, i get this error:

Warning: array_flip() [function.array-flip]: The argument should be an array in /home/xtreme/public_html/online/admin/easypopulate.php on line 1284

it won't bring in any of the over 300 products. this is a brand new installation of zencart.

not knowing .php very well, i have not idea how to proceed from here.

thanks for your help!

RE: chadderuski

I am using a tab delimited .txt file for the import. the ep free version, and the newest zen cart

For instance in the below, If I update the other items, but leave the photo section empty it removes the photos from the products it updates

v_products_model v_products_image v_products_name
1234 test_1
2345 test_2
3456 test_3

But, if I remove the column for the image, like below, will it then leave the photos for the products and just update the columns I leave?

v_products_model v_products_name
1234 test_1
2345 test_2
3456 test_3

Thanks

xtreme-exhibits:

when trying to import my .csv file downloaded from another site, i get this error:

Warning: array_flip() [function.array-flip]: The argument should be an array in /home/xtreme/public_html/online/admin/easypopulate.php on line 1284

it won't bring in any of the over 300 products. this is a brand new installation of zencart.

not knowing .php very well, i have not idea how to proceed from here.

thanks for your help!

Look to this thread for the solution:

http://www.zen-cart.com/forum/showthread.php?t=134290

The lastest CSV mod (not phazies) has some introduced bugs.

eric47905:

RE: chadderuski

I am using a tab delimited .txt file for the import. the ep free version, and the newest zen cart

For instance in the below, If I update the other items, but leave the photo section empty it removes the photos from the products it updates

v_products_model v_products_image v_products_name
1234 test_1
2345 test_2
3456 test_3

But, if I remove the column for the image, like below, will it then leave the photos for the products and just update the columns I leave?

v_products_model v_products_name
1234 test_1
2345 test_2
3456 test_3

Thanks

Hi Eric,

This is actually the correct behavior since EP is assuming you want to update the v_products_image field with a null value. For your earlier issue, there are a number of columns that you need in langers 1.2.5.4 version, but I don't remember exactly which they are as I've modded my own version well beyond this. There are several bugs in 1.2.5.4, and you can get orphans master category id's too. So you should run the "resets" in tools->store manager. Hope this helps.

-cj

chadderuski:

Look to this thread for the solution:

http://www.zen-cart.com/forum/showthread.php?t=134290

The lastest CSV mod (not phazies) has some introduced bugs.

Thanks for the response! i read through the thread and tried commenting out the area they mentioned and it didnt work. i didnt get the error anymore but it didnt import the products.

Thanks chadderuski

Does anyone know if the paid version is better? Does it function better?

No one has answered about the program killing out with the internal server 500 error, does this happen in the paid version? If not it would well be worth the $65

Thanks