I am using easy populate and I want to have one main image but I also want to add a second image to the site like this site as in the listing how do I add that to my csv or XL sheet to upload?
Printable View
I am using easy populate and I want to have one main image but I also want to add a second image to the site like this site as in the listing how do I add that to my csv or XL sheet to upload?
As far as i am aware, you can not add additional images with the basic version of EP, i think this is a Advanced EP feature.
Failying that, it just as quick to ftp up the additional images, as you dont need to go into each product and add each one... all you need to do is a make sure they are named correctly
I was just wondering if anyone knows if it's possible to hack EP to be able to upload a customer database?
Quote:
Originally Posted by touchclothing
Use FTP to add your images.
You need to name your images correctly so they show properly in the product info pages.
IE: Main image = 1001.jpg
additional images
1001_01.jpg
1001_02.jpg
1001_03.jpg
etc etc
You only need to add the main image in your EP file the rest will automaticly show on the product info page.
Hope it helps :)
I use EP to import my products but as I am VAT registered I need the prices that import to be the price including VAT.
When I check the prices after importing all my products the VAT is added on top of the price I imported.
IE: Price incl VAT = €10
If I set the price in csv file to €10 and import it will show in the site as €12.15 (Adding 21.5% VAT)
What I need is when I add an item at €10 it shows in the cart as €10 (including VAT)
I have tried to calclate the price before VAT in excel but it doesnt add up properly when reverse engeneering VAT calculations. The percentages are different and it uses about 6 or 7 decimal places to get the exact pricing right. And when I put it back to 2 decimal places the doesnt add up right.
As these values will be used in my bookkeeping they need to be spot on or the tax man will on to me LOL.
Has anyone done this or can someone maybe point me in the right direction.
Thanks a mil in advance for any help.
I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results
File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635
Upload Complete
But nothing shows up in my store what am I doing wrong
The way that I handled a batch import of customers was this...I took my existing customer datasheet (which I had exported from phpMyAdmin), and exported a customer datasheet from the "customers" database in the Zen Cart database. I cut and pasted the necessary data, imported the data (again, via phpMyAdmin) and then ran a script that I found on this forum that batch processes all unencrypted passwords into encrypted passwords and then, voila...I had all my customers in my new site. The only problem that I can think of with this methodology is that it doesn't address order histories. I hope this helps.
:blush:
~Dale
Dale, thanks for the direction. I've got it partially working. I've tried adding a single customer to check by phpMyAdmin. I've added them to the following tables: customers, customers_info and address_book.Quote:
Originally Posted by jdw1979
When I do a search for them in admin, I find them, however I have the following errors:
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/actforms/public_html/cart/admin/customers.php on line 1035
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/actforms/public_html/cart/admin/customers.php on line 1037
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/actforms/public_html/cart/admin/includes/classes/object_info.php on line 29
Warning: Variable passed to each() is not an array or object in /home/actforms/public_html/cart/admin/includes/classes/object_info.php on line 30
And when I click on "edit" none of the information is filled out. Any idea what table I am missing?
Thanks for the awesome help though!!
any ideas I will take anything
I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results
File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635
Upload Complete
But nothing shows up in my store what am I doing wrong
touchclothing is offline Report Post Reply With Quote
I'm not sure about this but, don't the import files have to be in a .csv format? Not .txt? I know they're very similiar (often considered to be the same thing, in fact) but that might be where the problem lies.Quote:
Originally Posted by touchclothing
This is quoted from page 236 by Scrat,Quote:
Originally Posted by Scrat
It really looks like this thread should be seperated. There seems to be too many problems and questions refering to different versions of Easy Populate.
So far I have only used 1.2.5.4 on 5 stores, added and changed some field names, deleted unused download lines in the easypopulate.php file and uploaded anywhere from 52 products on one store to over 14,000 on other stores and have never had a problem uploading.
Perhaps someone will continue to a new thread for 1.2.5.5.csv.2 and keep it seperated from 1.2.5.4
I still consider 1.2.5.4 from Modhole to be the easiest and best version to use.
Quote:
Originally Posted by jdw1979
yea we have done it with both and nothing happens
Hi Zenners,
Preface, EPv1.2.5.4 from modhole.com
I had originally installed Easy Populate CSV v1.2.5.6 and then decided to go with EP v1.2.5.4 because it seems to be much more supported here in the forums and it has been mentioned that it is the most stable version.
So I contacted schoolboy because he seemed to have an in-depth knowledge of v1.2.5.4 and wanted his opinion on the matter. I liked his response and proceeded to uninstall EP CSVv1.2.5.6. Everything went well except for an MySQL error! So I contacted schoolboy, briefed him on the situation and he gave me the following advice/instructions to solve the error and it worked like a charm!
I told schoolboy that I was going to post this for anyone else who has done the same as I have done. So here it is, hope it helps.
Thanks schoolboy, worked like a charm. Your step by step was was absolutely excellent. Thank you!Quote:
Originally Posted by schoolboy
Quote:
Originally Posted by touchclothing
Can I get some help on this !!!!!!
I'm not sure what your file (txt) looks like, but does it have EOREOR on the end and each item has a unique product model number.Quote:
Originally Posted by touchclothing
Also what about seperate catagories?
Have you used EP successfully in the past with your website?Quote:
Originally Posted by touchclothing
1) What version of EP are you using? REALLY important to know this!Quote:
Originally Posted by touchclothing
2) Did you have any products in your store to start with?
3) Each product MUST have a unique v_products_model AND you must have at least 1 master category.
4) What is your default language? If it is not english = 1, people have had problems.
5) Have you checked you databases using phpMyAdmin? You can browse the products database to see if anything loaded.
6) Did you set up your temp file location to be writeable?
There are a lot of things that can go wrong with EP (all the versions), but most of them are simple to fix, and generally user error.
However, if you are populating a new empty store database for the first time, you often need to go into Admin -> Tools -> Store Manager and run "Update All Products' Attribute Sort Orders" and "Update ALL Products Price Sorter".
You should really do that after every upload anyway. I have found cases where it seems the indexes do not update correctly (I also use quick updates, and this is very evident when checking new data after upload as the Master Category id's get jazzed up for some reason.)
Seriously: First time EP users need to enter a few products with categories throught the Zencart Admin and THEN do a first download. You can then use this as your template for your other products. You'll still need to manually upload your images too.
Hope this helps.
Find the EP FAQ ... it is quite well written and very helpful.
One other thing! If you have not installed the Admin Backup MySQL tools, you should! And you should have a backup before any attemps at uploading products from any version of EP.
Through no fault of EP, it is quite easy to jazz up your store with mistyped category names, funky dates, etc. etc.
Oh, forgot one! Also in Admin -> Tools -> Store Manager run "Reset ALL Products Master Categories ID"!
Am I missing something?
bought the advanced easy populate a few days ago from the zencartbuilder site but not received anything - was expecting to be sent a direct download link or something?
Is the big man away or someat? I don't want to sound impatient but I've a week of being laid up sick ahead of me and would like to have a good crack at finishing my zen cart build
He has been AWOL for a while.Quote:
Originally Posted by Rob-adrenalfuel
Oh dear, I could be waiting a while for my mod then?Quote:
Originally Posted by ckosloff
Is the free (standard) version of easy populate stable enough for use on a live site?
Maybe like 10,000 years. :smile: Ask for your money back, or maybe a kind soul in this forum will send it over to you. I don't have it.Quote:
Originally Posted by Rob-adrenalfuel
Yes, I have used the latest successfully, however don't expect it to handle your attributes entirely well.
It is rumored that the paid version can do this, but I don't think so, I have very complex settings and have to do that manually.
Right new problem,
After installing Easy populate my zen cart back end starts playing up. after installation I'm no longer able to use the back end as it prompts me to log in after every attempt to navigate around the admin area.
The server I am using uses a .htacess set up, I think this has something to do with it as it the only big difference between this server config and the various locally installed test stores I've made. Does anyone know how I can get around this problem? or if this is indeed my problem at all
Rather Lost
Rob
Last contact I had with Langer was two (2) years ago this month! Modhole is down. No telling how long zencartbuilder.com will be up ... ?Quote:
Originally Posted by Rob-adrenalfuel
I did notice that CreLoaded for OsCommerce has Easy Populate Advanced included with it. I have not tested this myself, however, and don't know if the attributes work correctly, or what version it is.
ZenCart's attribute system is very flexible. This in turn translates into some rather complex logic if one were to automatically populate their store with attributes FULLY supported. This is probably why it has not been fixed for zencart.
We'll see what the near future holds ;p
I have the newest zencart and the 1.2.5.4 version of EB and when I load my inventory file using their template everything works fine. However when I load the update file from the model/price/quantity file all of my pricing disappears. I tried to load it with the normal template and then again taking out the special pricing sections but neither worked.
I’m stuck bad the last thing I need to do is get the updates to take and I’m done with the thing.
Any help please?
Quote:
Originally Posted by motobuddy
Motobuddy: Go into your Tools > Store Manager and run both "Update All Products' Attribute Sort Orders" and "Update ALL Products Price Sorter"
You may also want to run "Reset ALL Products Master Categories ID" as EP is a bit buggy getting this correct.
-cj
Hi All! Just blowing off steam here >> Just wanted to say the that the Model/Attributes code and exported data is absolutely worthless! <<
Now... let's see if I can write something better ;p
BTW. I have taken all three (er 4 if I include my own modded EP) and properly "forked" them into their own discrete modules. What does that mean? That I can run all easy populate mods (TAB, OSC and CSV) side by side. Was easy to do. Been "fixing" stuff too (translate as chainsaw vs code) ... not sure what the outcome will be at this point ... but the goal is to FINALLY have a stable working EP for 1.38 core without all the guff.
-cj
Hey Everyone,
So glad to have found this for Easy Populate. I've got a distributor sending me EasyPopulate files. The products have MULTIPLE CATEGORIES ... and they are not "sub-categories" of one another. If I put each category in v_categories_name_1 - 7 ... they appear as sub-categories of category 1, correct?
Is there any way to designate separate categories for a single product? (like, a case that fit and iPod and an iTouch, etc) ... and do so so WITHOUT having to have the product listed multiple times in the feed?
In other words - do I have to put the product as a separate row in the file for each "separate" category i want it displayed under?
Hope that makes sense.
Fred
No luck though, either I do apertiate the help though. the "Update ALL Products Price Sorter"Quote:
Originally Posted by chadderuski
always locks up with the "Internet Explorer cannot display the webpage" error I get when I upload files. Maybe I am doing somthing wrong with the form sheet. Do I leave the special priceing sections in or remove them, or put in a field to show they are not used?
I reload my original inventory file and all the priceing comes right back.
1) Download and use FireFox and throw IE in the trash :PQuote:
Originally Posted by motobuddy
2) Could you either link your problematic model/price/qty file or PM it to me? I seem to remember an issue in EP with this when I was making model/price/breaks work.
Are you specifying dates or data for the v_specials_price, v_specials_date_avail, and v_specials_expires_date? IF NOT, delete these columns. AND
Are you ending EVERY line with EOREOR? AND
Have you made sure you have NO data in any column after the EOREOR column? Hilight a dozen or so columns after EOREOR and delete them for good measure.
-cj
Update on my issue, hopefully someone can help.
Whenever I attempt to download a file from the easy populate console the admin prompts me to log in, and won't actually allow me to log in until I clear my zen cart cookies. I wonder if this is something to do with my store using .htaccess files?
Similar things occur when I tried to uninstall easy populate using the YOUR_ADMIN/easypopulate.php?langer=remove address in my browser
Really am stuck with whats causing this
I apertiate your time, after I deleted the two rows after and started using firefox it started working.Quote:
Originally Posted by chadderuski
Everything is looking good.
Hey Gang,
I'm using the newer Easy Populate CSV 1.2.5.6.csv.2 version, so I hope there is help here, I didn't see thread for that specific version.
When I upload my file, it seems to be accepted fine, but the products that I upload aren't showing up anywhere - not as active or inactive, and then when I export from EasyPopulate, it's not there.
I'm uploading the .csv and after hitting "insert into db" I get the following response:
File uploaded.
Temporary filename: /tmp/phppIRoVJ
User filename: gsn-epfile.csv
Size: 1652
Upload Complete
This is a link to my file I'm uploading - can anyone give me any idea why this isn't showing up? Even the category I put in there (ie. MacBook 13", etc) doesn't show up ... the manufacturer "Abbi" is a brand new one for our store, and it doesn't show up ... basically, even though the response above suggests the file uploaded properly, it doesn't seem to be going into the database.
Link to my file:
http://www.getskinsnow.com/gsn-epfile.csv
I'm running the latest, updated version of ZenCart, 1.3.8 A
WOW sounds like a God Send....has this happened or any part there of.....I know it would certainly make my life a lot easier. :yes:Quote:
Originally Posted by flatlanderoutfitters
This Zenner Could Really Use Some Help Please!!!
I have read every single one of these 254 pages of posts, but I am in somewhat of a confused state about which one of the EP modules to install and from where to download it.
I have Zen 138a..On PHP 5.2.1
My supplier sends me some sort of Jumbled up CSV file daily which has a heap of products most I sell some I dont.
My cart has already loaded by hand around 500 products only about 25 with attributes....
This appears the hot favourite Version 1.2.5.4 namely Langer's version from Modhole....
Also someone mentioned the following a few pages back..............Does anyone know anything about this? I am a little nervous about getting it.....at $ 149.00 and dont know what the benefits are vs the free versions.
Any help and opions would be really appreciated.
Thanks
Renz
------------------------------------------------------------------------
Store Manager for Zen Cart is a Windows application
That is a client-side management interface from MagneticOne. I have "test-driven" it and I liked it very much. This does not constitute an endorsement for the product, but is just my opinion of their software.Quote:
Originally Posted by Renz
Store manager is a commercial product, and I have seen some disguised advertising in this forum for it.
I am not saying this last post is, but certainly others were.
I don't think that they offer trial periods.
Unable to say if it handles complex attribute structures properly.
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.
"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.Quote:
Originally Posted by byrd813
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.
In the coming days I am going to try new version of Improved Attributes Controller (have been using Bulk Attributes Controller, so far).Quote:
Originally Posted by Renz
There is another (very old) mod out there:
http://www.zen-cart.com/index.php?ma...roducts_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:
So, any ideas as to why it is still erroring out? I have tried reinstalling the mod as well.Quote:
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/(admin 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.
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.
I have tried to create & upload via ftp, but the file never shows up in the TempDir. Where exactly is the php.ini file?Quote:
Originally Posted by chadderuski
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 :(Quote:
Originally Posted by margecc
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?
Eric,Quote:
Originally Posted by eric47905
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
Look to this thread for the solution:Quote:
Originally Posted by xtreme-exhibits
http://www.zen-cart.com/forum/showthread.php?t=134290
The lastest CSV mod (not phazies) has some introduced bugs.
Hi Eric,Quote:
Originally Posted by eric47905
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
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.Quote:
Originally Posted by chadderuski
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
Eric,Quote:
Originally Posted by eric47905
Recently someone purchased the paid advanced version and never received the link for downloading the package. It seems Langer has completely gone absent, so if you buy his version, you risk not getting what you paid for.
Per the Internal 500 Server Error: I have never received this from EP, and I have working EVERY version of EP together - isolated as their own tools options. No 500 errors.
I'd suggest doing a quick fresh install of zencart in a different sub directory, then upload a freshly upacked ver 1.2.5.4 - unmodded - and MAKE SURE you verify that each file has uploaded. Set up your temp directory with writable permissions. Who is your host?
It is possible you have a corrupted file on upload. Also verify that your .htaccess file is intact. Do you have access to your php.ini file? Not all shared hosts allow this.
Note: the most recent version of EP CSV is buggy. Use phazei's version. It's not perfect either, but did work out of the box for me.
-cj
Please elaborate.Quote:
Originally Posted by chadderuski
What bugs did you find?
I am thinking of doing some work on the attributes part of that, if you could save me some work I would be most grateful.
FYI, I did test latest version of Improved Attributes Controller, I'm gonna keep it, works better than Bulk Attributes Controller.
Attributes modelnumbers definitely does not work, this mod is in Beta stage, to put it gently.
I am currently working on the attribute import. The code in 1.2.5.4 tab and the CSV for attributes is basically useless. So I've tossed that and am working from scratch with my own concept.Quote:
Originally Posted by ckosloff
There are several bugs in 1.2.5.4, sorry if I am not specific. I've worked on this over some lengthy time doing my own patches and improvement in addition to adding fields for the PRODUCTS table that are useful to me. Most notably are errors in logic when updating an existing product. EP would not pull the existing data to use as default, and you often get the PRIOR item's data. Manufacturer comes to mind first. Bad things happen when your default language code is not 1. Dead code from OSC. Funkiness in the date management. I pulled the MUCH better code for dates from phazie's CSV version. All of these have been discussed if you were to read this entire thread and some of the sub threads.
Let me also say that Phazie's CSV version is a much better concept, and EP should end up as a CSV only product-mind that you can still use TABs to seperate data. That really is the standard. Using EOREOR is at best a clunckly solution compared to readily available functions in PHP. However, I've been modding my own TAB version for some time, and will first solve this attribute issue there before combining the two.
Here is an open question to EP users: Does the froggle code really need to be in this? It seems there are several google feeders that perform this function just fine.
Anyway, I really want to see a solid core product come out of this, and attribute has been the most oft requested feature to see fixed. Given a week or two, I should be able to post some beta code for the community to poke at.
-cj
still have not received a reply to my question. I just recently installed my php.ini file, and was wanting to know how I can upload all 4000 of my products without the server timing out. Someone ,mentioned changing the settings in the php.ini file for this problem, I would like to know which settings I have to change in order for all of my downloads to process properly
I am also receiving the 500 Internal Server Error when I upload a file (I broke the inventory down into 500-item lists, in tab deliminated tex files, so I don't think that's it.) I get the same result when I ftp to my temp file and try from there. Feh. Oddly, the files seem to have uploaded, anyway... I don't know what to make of that.Quote:
Originally Posted by eric47905
http://www.zen-cart.com/forum/showpo...&postcount=104Quote:
Originally Posted by chadderuski
Please take a look at this post and subsequent as I have already summarized my issues in that other thread.
You seem to like phazei's 1.2.5.5, and that's fine, but why not base your work on 1.2.5.6 which is basically the same but gives you the ability to create custom fields from admin?
Regarding froogle: I don't think that is necessary as there is a very mature mod out there that does that: Google Base Feeder.
Let's keep Easy Populate lean and mean, let it do the work it is supposed to do in a reliable manner.
Regarding attributes: I have a lingering issue, which has been described in the post I mention.
I think this can be solved by an Attributes Combination Table.
Suppose that you have the AttributeID as the primary key in that table.
Then come all the other fields for each record.
Thus, if you only load the AttributeID, Easy Populate will look at that record and load all the other fields in one pass, including images.
So far, I could use Improved Attributes Controller to load all the attributes for one product, but only with the same Option Name.
Then another pass for a different Option Name.
Finally, associate images for each attribute.
This table could include Option Name, sort order, etc.
Of course, each user would have to build their own table according to their needs, or a template could be downloaded for users to modify.
You get the idea, right?
Take a look at this thread per the 500 Internal Server Error:Quote:
Originally Posted by ilsita
http://www.zen-cart.com/forum/showthread.php?t=128520
As for what to edit in your php.ini ... look for these variables and adjust to taste:
max_execution_time = 60 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 64M ; Maximum amount of memory a script may consume (10MB)
Firstly because 1.2.5.6 CSV is prone to errors. Although it is a good idea and has potential, it is incomplete because of the lack of treatment of data types when inserting data into the database. This was my assessment on casual inspection of code (and may be inaccurate), but like I said, I've already spent much work on improving the tab version and don't wish to switch up in mid-stream, or fix yet another mod of a mod of a mod of a mod....Quote:
Originally Posted by ckosloff
Like I said above, I should have some working code to test in a week or two for attributes and it should be pretty fleshed out. I'll be sure to give you first crack at it. :)
-cj
I'll hold you to your word.Quote:
Originally Posted by chadderuski
Thanks, chaderuski... Turns out I didn't even have the php.ini, but I got that in. Still no go, so my host is in the case. I will update with any information they give me.Quote:
Originally Posted by chadderuski
It seems odd that despite the error msg, the files seem to be uploading just fine, and are appearing in my cart. I'm tempted to ignore the error message, but I don't know the rules well enough to know when to break them.
Best,
ilsita
Hi there guys. I've looked through this section and could not find an answer to my question. Though the search function isn't one of the best so I can't really search within the Easy Pop section. So if it is here somewhere, please let me know :(
Ok, ZenCart 1.3.8a
Easy Populate 1.2.5.4
Other addon I'm using is Admin Tools 1.0.7.1
I got everything working 110% to be honest. I had no problems what so ever until +- last wednesday.
I could download the csv's to either a directory or to the /temp, which is fine. I could upload 100%.
But all of a sudden, with no major changes before or after the problem for longer than 2 or 3 days, when I click to download the file in IE7 it shoots me back to my admin page asking me to login. It does this over and over again no matter what I try. I have tried to "play" with the cookie settings with no avail.
When I do it via FireFox (latest) I can get in fine, upload and download fine. No different settings except for Firebug 1.4.2. That is the only addon I installed to FF that is not standard.
I like using IE as I use FF for other reasons. But I'm changing to FF now on my shop.
Is there anything that I did wrong or a bug that poped up maybe?
If you need any other info, let me know please.:frusty:
Hi byrd813, I'm obviously no expert, but perhaps you ought to use the split file option on the Easy Populate upload page. In the EP control panel, you can set it to split the file into whatever size chunks you want.Quote:
Originally Posted by byrd813
ilsita
Guys, I'm still waiting on an answer from my host regarding the 500 error page I keep hitting during the upload, but I'm so antsy to get things going, and since it seems that, despite the error page, the files are uploading, would it be stupid of me to carry on with the process, or wait for an answer?
Thanks,
ilsita
Who is your host? How is php funing? CGI? FASTCGI? PHP? This really sound like a server configuration error.Quote:
Originally Posted by ilsita
-cj
Hi CJ, well I just heard back from my host, and they sent me this message:Quote:
Originally Posted by chadderuski
My host is namecheap. I've been really happy with them, because their tech support has been extremely responsive, and immediate. I'm so sorry that I don't know how to answer the other question... I know I'm working with PHP.Quote:
I can confirm that it's error with software, because the following error is generated:
Script timed out before returning headers: easypopulate.php, referer: http://shop.tuntienterprises.com/admin/easypopulate.php
While this script is still working in the system. About 10 second more after the error arise.
No other error is logged by the system
If, despite the response I received from my host, you still think it's a problem on their end, they will be responsive to my giving them more details, and will continue to work on it. I swear, it's like I'm their only customer!
I have been going over the Easy Populate wiki, and it seems that I have everything configured properly. My files are broken down into 500 entry chunks, and all headings are accounted for. I have no values in the url column, but it is there.
But, as I said, despite the error message, it still seems to be uploading and displaying properly - I think.
Sorry to keep with the updates, but it seems that I am now having the same problem on my website. If I make a change to the css file -- a simple little change, like a color -- I get the same 500 error when I refresh my website to see the change.
Consistent with the fact that my EP txt files seem to have uploaded properly, despite the error page, when I get back to my website, the changes seem to have taken effect properly.
So, I guess I should continue to conclude that this is a host issue? I wrote to them about it, with the error text, and hear back from them that they do no provide debugging.
ilsita
oh fahcryingoutloud, I just clicked on my Easy Populate configuration on the zen cart, and it comes up blank... Empty!
The whole page is not blank. I'm still in zen-cart, but under the header, where it says, Title Value Action, it's blank.
Que paso?
I gotta tell ya, I'm at a complete loss as to what is causing your problem. At this point some good and proper nerd needs to look at your installation. You need to check your .htaccess and php.ini files. On top of this there are many server side issues that can generate these proplems. But this is outside the scope of this thread's support.Quote:
Originally Posted by ilsita
The only other possible cause of this is - and it's a stretch - is what line break you are using. I have Dreamweaver set to LF for unix. But I'm on a mac. Check your editor. Use OpenOffice for your text files, not excel.
I have seen this issue make funkiness in .htaccess files that would cause a site to crash.
If you have CPANEL, most will have the ability to install zencart automatically. Do a clean install then PM me and I'll let you try my TAB version to see if you get errors.
Best I can do..
Hi Eric,Quote:
Originally Posted by eric47905
I wouldn't touch the Easy Populate Advanced paid version. I bought it in July. There's no response for any support requests and I ended up not being able to use it. I believe there is also an issue with it not being compatible with the recent security patch.
Paul
Does anyone know what could cause this error message?
Fatal error: Call to undefined function ep_datoriser() in /home/xxxxxx/public_html/store/backup1/easypopulate.php on line 1747
I am using excel to modify the tab-delimited text file that I downloaded from easy populate. I originally noticed that I had the date formatted incorrectly, mm-dd-yyyy. I changed the format of the date available field in the file to yyyy-mm-dd and am still getting the above error message.
I have spent several hours searching this forum but still can't figure out how to correct this.
Any help is appreciated.
Refer to previous post.
Line 1747 in easypopulate.php
$v_date_avail = zen_not_null(trim($v_date_avail,"\"")) ? '"' . ep_datoriser(trim($v_date_avail,"\"")) . '"' : "NULL";
I'm thinking this error might be the date format. ZC product date available displays as yyyy-mm-dd.
What is the correct date format for the EP csv file?
Also is the EP csv file tab delimited or comma delimited, or doesn't it matter?
Thanks!
I am getting this error trying to get a copy to my temp directory.
Never seen this one before, Any ideas how to fix?
Quote:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 14559 bytes) in /home/nothingb/public_html/admin/easypopulate.php on line 892
Milo,Quote:
Originally Posted by milobloom
How many items in your store? Are you using the TAB or the CSV version? Does this occur just on the full download, or all downloads?
This error is cause when you run out of memory on the server. The server terminates the script and kicks you out.
If you have access to your php.ini file, you can find and change this line:
memory_limit = 64M ; Maximum amount of memory a script may consume (10MB)
Your memory limit is set to 32M. You can try and up it to 64 and hopefully that will work. You may also want to change these lines to increase script execution time:
max_execution_time = 60 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
Note that if you are on shared hosting, they may still override these entries...
Hope this helps!
please I have to install a version of easy populate, I guess 1.2.5.6 but I would have before the uninstall.sql file, in way that if it is wrong or I have some critical error, I can uninstall.
So please, can I have a uninstall.sql?
please
I should install within today, it is urgent :blush::smile:
I read in install.txt that to remove easy populate it needs
?langer=remove after /easypopulate.php
is that also uninstall sql setting?
And re go on the initial settings without easy populate?
thanks
:smile:
sorry I am again.
I installed this addon.
All is all right but
when I download full EP
I open the file and I see for the same product (1 unique code product)
5 rows with same product and same unique code.
On my site instead is correct and I see only 1 product.
Why I see 5 rows for many products?
Please
same problem with 1.2.5.4
Thanks!Quote:
memory_limit = 64M ; Maximum amount of memory a script may consume (10MB)
Your memory limit is set to 32M. You can try and up it to 64 and hopefully that will work. You may also want to change these lines to increase script execution time:
max_execution_time = 60 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
They bumped my memory to 128 and it works great!
greeeeeat now I understand, for any strange cause the precedent version of EP caused linked products, that manually I have delete thanks to this thread
http://www.zen-cart.com/forum/showthread.php?t=62977
now I don't try to set price with vat (I set on configuration on true but it doesn't go)
but I'm happy
:laugh:
uff it created linked products when I reimported.
So I bought advance 3.0.3 but I have this error
Easy Populate Advanced 3.0.3
Categories Data Error Detected
Easy Populate has detected missing default language names for your store categories. This is the result of some kind of database corruption or administration oversight.
Easy Populate requires that these errors are repaired in order to function correctly, & can make the required repairs, naming your missing category names "CATEGORY X" where X is the database id for the repaired category. You will then be able to edit/manage/delete these categories in Zen Cart admin.
A list of the categories can be downloaded using Easy Populate to investigate what categroies contained these errors.
To proceed with this repair, click on the link in the message alert above.
How I have to do?
I paid to solve my problems and nothing...
Please if someone has an idea :frusty:
solved, finally
I guess it was a problem of a previous version of EP, bad installed.
:clap:
I need to insert html_entity_decode() on product description, because my data feed's product description contains <p> instead of <p>.
Where exactly in the code I should do that ? :shocking:
@langer
I paid your advanced version, but noone responds at my questions...
I opened a ticket
I try to send to you a message via pm (full pm)
and I try to write also on forum of yoursite.
What's????
please answer to me
:mellow:
Giuly,Quote:
Originally Posted by giuly
Langer has been "gone" now for about 2 years now. You'll need to see if someone with his 3.0.3 can help you. Generally, because he made this a paid version, people have been resistant to offering help/support. But with him gone, perhaps some knowledeable user will be kind enough to help..
Best of luck!
thank to you I didn't know the fact.
Ok, they would tell to who paid, but ok.
So please someone gentle please any idea for my problem?
I upload correctly but the product is duplicated creating linked product
this appeared also with version 1.2.5.4 and 1.2.5.5
and obviously with 3.0.3 advanced
please
:frusty::blush:
I could not find a support page for Version 1.2.5.5. Could you please let me know where that is?
In the mean time, I'll post my problem here. I installed the 1.2.5.5 (previously had 1.2.5.4, which worked mostly fine). I'm using ZenCart v1.3.7.1. With 1.2.5.5 I could download the products. But when I tried to upload, I got this error:
Warning: array_flip(): The argument should be an array in /home/content/v/i/c/vickilapp/html/updatedadminname/easypopulate.php on line 1284
On line 1284 it reads:
} else if($filelayout = array_flip(fgetcsv($handle, 0, $csv_deliminator, $csv_enclosure))) {
I'd appreciate any help that you could give me. Thanks!
Vicki Lapp
http://beadinspirations.com
I am also receiving this error when trying to download the CSV. I built all my categories, so I can add products via easy populate.Quote:
Originally Posted by rge
I am also getting this error when I go to the Easy Populate area
I click where it says 'click here' but it doesn't work and the debug log says to delete it in phpMyAdmin:cry:Quote:
Warning 1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.
Is it possible to change the way Easy Populate sort the products in the csv file? When i import the csv product file to zen cart and download it again, it changes :\ I want to sort everything by v_date_added.
If anyone know how to do this I would be very grateful, it saves me a lot of work!!!
I just installed EasyPopulate on my new zencart and I am trying to upload a datafile to it. I get the following errors when I try to upload "An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer" I dont have an easypopulate errorlog in my Temp folder and I dont really know what to do, it said that the file itself may be causing the issue so I will post that as well. Any info would be a great help, thank you!
My website is v12autoparts.com
This is the link to the CSV file I am using -
http://www.yourfilelink.com/get.php?fid=514114
This is what it looks like when I try to upload....
Upload Results
Filename: diablosport.csv
ADD NEW PRODUCT FAILED! - Model: U7777 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7135 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7193 - SQL error. Check Easy Populate error log in uploads directory
UPDATE PRODUCT FAILED! - Model: U7194 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7198 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7145 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7778 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7370 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7130 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7137 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7191 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7170 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7159 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7186 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7154 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7153 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7156 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7157 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: B0017Q50A6 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7324 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7164 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: D7155 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7383 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7336 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7396 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M2010 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: FLX7193 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M1000 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M3010 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M2020 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: F7373 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M3000 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P1030 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: M3020 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P1000 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P1010 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P1020 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P2010 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P2000 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: T1000 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P3010 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P3020 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P1040 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7195 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7134 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7136 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7141 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7131 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7140 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7142 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7150 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7144 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7146 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7157 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7147 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7151 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7152 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7158 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7155 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7153 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: UD7131 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: UD7132 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7185 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7165 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7192 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: UD7133 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: UD7134 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: U7180 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: FLX7198 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: P2020 - SQL error. Check Easy Populate error log in uploads directory
NickPCs I would guess from the error message you are receiving that you are using version 3.x.x of EP (Langer Commercial Ver.) as you will see this version is not supported hear, but some one may help via pm.
If you are not using this version state the version you are using as there are several and it would help people sole the error?
I'm getting some of the Manufacturers duplicated but not all. It's very weird. I'm using ZC 1.38a and EZ Pop 1.2.5.6 I verified that all variations of the Manafacturer's names were eliminated so there was only one for each. Nothing else has been duplicated. Help please. :frusty:
I've looked up and down this support thread. If the answer to this already exists I apologize but my eyes are starting to bleed now. :wacko:
Use version 1.2.5.4 which has is supported in this thread together with WIKI atQuote:
I'm using ZC 1.38a and EZ Pop 1.2.5.6 I
http://www.zen-cart.com/wiki/index.php/Easy_Populate