Wow - I just downloaded the "lite/free" version. WOW - exactly what I was thinking... and to think I was prepared to code it all myself!!!! Awesome.
Thanks guys.
Printable View
Wow - I just downloaded the "lite/free" version. WOW - exactly what I was thinking... and to think I was prepared to code it all myself!!!! Awesome.
Thanks guys.
It even create Subcatagories that did not exist before!!! Talk about sweet.
now all I have to do is automate the whole process!!! Take my new images, run "convert" against them, put them in the images directory, create the tab file for easy populate... and throw it all into a cron!!! hahaha
alright - call me lazy
:clap:
OK I know I should do a search but I don't feel like poking through this 121 page thread. Was wondering what Easy Populate does when it finds a duplicate record - overwrite, skip, delete, add new? If it does check for duplicates, it does so on the basis of what? Description? Model number?
Thanks!
Hey - you know what would be cool??
Make this into an HTML page (or PHP most likely) that displays everything in a table like fashion... to allow you to make updates right on the page!!
and complete with little thumbs of the products, too...
so you navigate around through your stuff in like a mini webpage or something - but one YOU can make changes to...
Does that make sense?
Hmmm - good point...Quote:
Originally Posted by kbalona
I'm playing with it right now - I'll let you know...
(SO far, it UPDATES descriptions)
Oh - and not on v_products_name_1
Because I used the same name for all of them!
i bet it's Model: v_products_model
Alright - TEST DONE
I put a duplicate in my TXT file... but change Description, Price, Qnty...
IT OVERWROTE the previous one...
So my assumption is that its based on the model number you assign (which makes perfect sense) and it takes the LAST occurance of your model as the record...
HOWEVER - what if you change the category or subcategory??
Well - this is good if you want cross posting of your product in several categories because it will create copies... but this might be bad because ZenCart already has this sort of feature, which allows you to have one product shown in multiple places... but that when you edit it, it will change EVERYWHERE it is shown.....
With this one, it seems it might make copies everywhere... be sure to SORT in Excel to detect duplications...
Well - I'm not entirely sure about that last part and the duplications...
I tried deleting my "new" product (the dup) and it used the "real" line...
However, it did NOT remove the multiple entries in othe categories...
BUT - big but - it DID change the other information like desc, price, qty EVERYWERE it occurred...
SO... carefully edit your TAB delimited file, eh!!! :)
Hey - nice site dude!Quote:
Originally Posted by kbalona
I need me a Shindaiwa or Stihl ~6hp chainsaw... I have a Stihl Farmboss - but its too slow for ripping lumber on my chainsaw mill (Logosol)
Thanks very much,Quote:
Originally Posted by Scrat
I'll try these out tomorrow. All products definatly have a unique item number on them.
I cant remeber what comes up when the new products are loaded. it certainly wasnt any kind of error message. Problem I have is if i upload new products to try this I cannot then delete them
I'm thinking the delete will have to be done the "old fashion" way!Quote:
Originally Posted by Eddie Irvine
When i did this - I went to clean up the mess I had made. I used the Catalog and Categories/Products page under ADMIN... when I chose the X, I was presented with check boxes where it existed - shown as:
Product Master Category:
With check boxes next to each...
So it does seem to know that they are cross Linked...
COOL!
And from the LESSON, i will always sort my file on the "v_products_model" column
I am wondering how I can delete discontinued products. I get a csv file from my distributor that has nearly 8000 products. I try to upload this once a week. During that time, there are several products that have been discontinued. The products that are discontinued obviously are not on the csv file, but are still in my database.
Is there a way to have EP automatically delete them from my database (other than manually - as this would take hours to find/cross reference/delete)? Or can I wipe my products out, and redo a fresh product install every time?
Any help is appreciated.
Quote:
Originally Posted by tgotch
There are programs that will let you compare text files (the old cvs to the new one) but if I were doing it, I would keep a copy of the old upload, change the status column from a 1 (Active) to a 9 (which will delete the product) and then upload it. Then do the new list. Be sure to backup your database first in case it does no go according to plan.
Dennis, Thanks for your reply.
Do you know what programs may compare csv files?
I am not sure what you are advising will work for me. As I mentioned, I have over 8000 products. In one weeks time, there may be 10-20 NEW products, and 5-10 discontinued between uploads to my db. So unless I am misunderstanding you, I would have to manually check everyone of the 8000 line items to see if a product has been dropped or added.
Well I finally got round to trying it, I changed the seperator from /t to | and it seems to work perfectly. Hopefully it won't cause problems further down the road but just wanted to let everyone know it does work.Quote:
Originally Posted by Phil020782
I am not sure on this. But you might try using winmerge. Don't know how if it would examine the contents of the CVS file.Quote:
Originally Posted by tgotch
The other option is to turn the product off by changing the status setting from "1" to "0" instead of "9" and deleting it. Then upload the new files with the status column of the new file set to "1". Similar to awhfy99's process, but without deleting the items from the database. over time this may make you database rather large and you will to maintain that aspect.
I can't see a answer to this question but there are over 120 pages..
Is there a version of Easy Populate that will work with;
Quote:
Zen Cart v1.3.8
New Release with PayPal Website Payments Pro support
Darkwander - Yes - Version 1.2.5.4 and all the other versions at present but this is the best stable version so far that is free!
See the original posters signature for the download link
hi,
is it possbile to load a tsv file via ftp using this mod?
would the file have to be reformatted?
I've never used the mod before.
Hi, I found this quote below in another thread for my problem, but no word as to whether or not it was any help.
First my issue:
When trying to create an EP file in temp (it is already too big to just download) I got the following message:
Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 96019431 bytes) in /home2/pccalca1/public_html/elocin/easypopulate.php on line 1041
A browse through the EP support thread led me to the quote below, but I was hoping someone else might be able to shed further light, as there was no response from the person that originally posted the issue.
Thank you!
Quote:
Originally Posted by awev
tbrides - ftp your file to the /temp folder in Admin and then enter the file name in the : Import from Temp Dir (temp/) box in EP main page.
bifficus - Not an expert at PHP but it doesn't have a very big memory so I would suggest your file is too big,How many/ how big is your file/ qty of products? I would only up load max. 500 products at a time, maybe a few less for good measures.
Is there any interest for a file filter program to filter csv - tab etc (possibly future plans xml if any interest) files from Suppliers (csv/tab) catalogues or epos database exports to the Easypopulate Product import format, so no more cutting/pasting in excel or OO.
It is a python/glade application with the ability to pick whole or part field valves of the csv file and add additional valves globally.
As I see the only issue I have at present is the categories and the weight as these would need to be put in by hand, I am looking at possibly key words in the description to get around the categories issue.
Hi Scrat,
I am definitely interested in some supplier related features for zen-cart. What exists is few and far between. Ironically, I caused my problems in EP by adding some supplier related fields to the product (cost and supplier). My intention was to use this to easily generate price sheets for resellers.
With respect to my PHP issue, you are right, as was the other recommendation to increase memory. Guess how much I had to increase my PHP.ini memory to?
512mb... yes, 512mb. My database is tiny, but contains many catagories with linked products. A few of them also have rather lengthy descriptions. The net is that while my SQL database backup is 520kb, the EP file generated in the temp directory was over 500mb in size.
EP works really well, but it seems I have surpassed its capabilities.
I may still be able to use it, as you say, to add products bit by bit. I was already having to split files and add them that way. After a little trial and error I did get that working. Not sure now if it would work, due to the memory issues.
I am going to try and learn how to work with SQL directly to pull the reports out that I need like that. I know next to nothing about sql, but I think that would be the way to go.
I need help with this pleassee...it does it on all downloads if I try to get it to download to my computer or to temp dir?Quote:
Originally Posted by Mack32
Any help would be appreciated
Does anyone know how to move products into from an old category to a new category correctly? I did move them but the master category id is still the same as the old one whereas the new category becomes the linked category of the old category. This doesn't make sense because there is now nothing in the old category after moving. Please advise.
Mack32 - You really need to do some fault finding, I would remove EP and reinstall and see if that works, is your product database every big? Check your database for errors, partially delete products, it may be a hosting issue, has it ever worked properly if so what was the last thing you installed and remove that and see if that works!, again has it worked properly before contact your host to see if they have changed/upgraded anything php,mysql etc as this can affect things.
I have had a similar issue when I was with another hosting company since I have moved to Camelot Hosting things are so much better.
dealbyethan.com - I haven't tried this myself but if looks if it is leaving references in the database , I would delete the original record by using '9' in the status column and on the next row insert again the new record in the new category, under the usual status of '1'. Therefore it will completely delete the record and not leave any refs.
Thanks for your suggestion. If I don't want to delete the category but only to move them, do you have any other suggestion?
The main reason I asked to do this is because the old category is still the master category after its products are moved to the new category. So if I delete the old category, the new category will be deleted as well.
dealbyethan.com - Sorry I did not explain that clearly, you would not be deleting the whole catergory you are only deleting the product and then re-posting that product in the new catergory, this should not delete any catergories, just that product.
Yes, I get the idea. Some of my pages have ranking. I prefer not to lose them if possible.
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.
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.Quote:
Originally Posted by monkeytown
Quote:
Originally Posted by monkeytown
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!
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?
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?
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.Quote:
Originally Posted by monkeytown
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.
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 :huh:
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.
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
Never mind! I figured it out...
Hi,
When I try to download complete file from zencart using easypopulate I get this.
I'm not at home to be able to log in on ftp to download the file if to create it in /temp folder. Can I somehow work around and get it to download properly?
I do get the download window and everything. But this is the only this that is in it..
please shed some light here :cool:Code:<b>Fatal error</b>: Allowed memory size of 16777216 bytes exhausted (tried to allocate 9216001 bytes) in <b>/customers/$MYADRESS/$MYADRESS/httpd.www/webshop/$MYADMIN/easypopulate.php</b> on line <b>1081</b><br />
would be awesome if ZC had a miniature filebrowser that you can do simple things with such as download files, chmod and upload
adding some info;
since I want to get hold of the complete EP products file, but the only thing I can do is to make it to create in /temp directory.
now my problem is that is does not have the proper chmod rights for me to access it and download it..
can I somehow by logged in as admin in my webshop change the rights on the file or get it downloaded somehow? for example by using sql patches or something and entering some code to chmod or make it accessible in some way.
let me know
thanks
dedj:
If you use firefox, there is a plug-in call FireFTP that works VERY well. It even has syching abilities and chgmod.
-chaddro
thanks for tip chaddro; but how can this program help me with my problem?
I'm, not at home and only password i remember is the zencart admin password.
So can't access the ftp where my webshop is since I can't remember the password and I'm not at home to look at the papers.
If I would remember the ftp password it would be no problem, but since I don't I need to see if there's a way to get the easy populate file downloaded or chmod'ded via zencart admin pages somehow.
leet me know if anyone has a clue.
thanks
Check this out:Quote:
Originally Posted by dedj
http://www.zzee.com/forgotten-ftp-password/
after installing the module, there are some error appears on the top of the page.
ine('EASYPOPULATE_FILE_SPLIT_COMPLETED', 'Upload done of '); define('EASYPOPULATE_FILE_SPLITS_DONE', 'All done!
'); define('EASYPOPULATE_FILE_SPLIT_PENDING', 'Pending Upload of '); define('EASYPOPULATE_FILE_SPLIT_ANCHOR_TEXT', 'Upload '); // misc define('EASYPOPULATE_FILE_SPLITS_PREFIX', 'Split-'); /** * $specials_print defines */ // results of specials in $specials_print define('EASYPOPULATE_SPECIALS_HEADING', 'Specials Summary
'); // open paragraph define('EASYPOPULATE_SPECIALS_PRICE_FAIL', 'SKIPPED! - Model: %s - specials price higher than normal price...
'); define('EASYPOPULATE_SPECIALS_NEW', 'NEW! - Model: %s | %s | %s | %s |
'); define('EASYPOPULATE_SPECIALS_UPDATE', 'UPDATED! - Model: %s | %s | %s | %s |
'); define('EASYPOPULATE_SPECIALS_DELETE', 'DELETED! - Model: %s | %s |
'); define('EASYPOPULATE_SPECIALS_DELETE_FAIL', 'NOT FOUND! - Model: %s - cant delete special...
'); define('EASYPOPULATE_SPECIALS_FOOTER', '
'); // close paragraph // error log defines - for ep_debug_log.txt //define('EASYPOPULATE_ERRORLOG_SQL_ERROR', 'MySQL error %s: %s\nWhen executing:\n%sn'); ?>
Warning: Cannot modify header information - headers already sent by (output started at /home/myozshop/public_html/admin/includes/languages/english/easypopulate.php:86) in /home/myozshop/public_html/admin/includes/init_includes/init_templates.php on line 36
I am trying out the Easy Populate taken from OS
(Getting a EP System with Attributes is a dream to me!)
I have it installed on 2 systems.
1 a fresh install (Which works fine)
the 2nd is my Heavily modified site.
On the 2nd site, It seemed to work perfect.
I get this message after importing 1 Record.
Which looked like it was going to work, however. The Product listing never shows up. It was if I never uploaded the file.Quote:
File uploaded.
Temporary filename: /tmp/phpTmwADx
User filename: Handbag.txt
Size: 14807
| 29007WT | bridesmaid | Bridesmaid | Bridesmaid | | 7.5 | 0 | 0 | 0 | | 0000-00-00 | 9999 | 1 | Color | 1 | Red | | 0 | 0 | | 0 | 0 | 2 | Blue | | 0 | 0 | | 0 | 0 | 3 | Green | | 0 | 0 | | 0 | 0 | 4 | Purple | | 0 | 0 | | 0 | 0 | 5 | Navy Blue | | 0 | 0 | | 0 | 0 | 6 | Light Blue | | 0 | 0 | | 0 | 0 | 7 | Hot Pink | | 0 | 0 | | 0 | 0 | 8 | None | | 0 | 0 | | 0 | 0 | 9 | Light Pink | | 0 | 0 | | 0 | 0 | 10 | Black | | 0 | 0 | | 0 | 0 | 2 | Personaliz | 11 | None | | 0 | 0 | | 0 | 0 | 12 | Name | | 4.99 | 0 | | 0 | 0 | 13 | Initials | | 4.99 | 0 | | 0 | 0 | 14 | Monogram | | 4.99 | 0 | | 0 | 0 | 3 | Personaliz | 0 | TEXT | | | | | | | 4 | Tags Shape | 25 | Circle | | 0 | 0 | | 0 | 0 | 26 | Diamond | | 0 | 0 | | 0 | 0 | 27 | Heart | | 0 | 0 | | 0 | 0 | 5 | Tags Desig | 28 | Baroque | | 0 | 0 | | 0 | 0 | 29 | Classical | | 0 | 0 | | 0 | 0 | 30 | Contempora | | 0 | 0 | | 0 | 0 | 31 | Cosmopolit | | 0 | 0 | | 0 | 0 | 32 | Cupid | | 0 | 0 | | 0 | 0 | 33 | Garden | | 0 | 0 | | 0 | 0 | 34 | Grecian | | 0 | 0 | | 0 | 0 | 35 | Victorian | | 0 | 0 | | 0 | 0 | 6 | Tags Color | 15 | Red | | 0 | 0 | | 0 | 0 | 16 | Blue | | 0 | 0 | | 0 | 0 | 17 | Green | | 0 | 0 | | 0 | 0 | 18 | Purple | | | | | | | 19 | Navy Blue | | | | | | | 20 | Light Blue | | 0 | 0 | | 0 | 0 | 21 | Hot Pink | | 0 | 0 | | 0 | 0 | 22 | None | | | | | | | 23 | Light Pink | | | | | | | 24 | Black | | 0 | 0 | | 0 | 0 | 36 | Periwinkle | | 0 | 0 | | 0 | 0 | 37 | Pale Yello | | 0 | 0 | | 0 | 0 | 38 | Ballet Pin | | 0 | 0 | | 0 | 0 | 39 | Burgundy | | 0 | 0 | | 0 | 0 | 40 | Lavender | | 0 | 0 | | 0 | 0 | 41 | Pink | | 0 | 0 | | 0 | 0 | 42 | Sage | | 0 | 0 | | 0 | 0 | 43 | Mint | | 0 | 0 | | 0 | 0 | 44 | Pearl Grey | | 0 | 0 | | 0 | 0 | 45 | Deeplilac | | 0 | 0 | | 0 | 0 | 46 | Coral | | 0 | 0 | | 0 | 0 | 7 | Add Person | 47 | Yes - (Min | | 0 | 0 | | 0 | 0 | | Favors2 | | | | --none-- | 1 !Updated!
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No products_id field in record. This line was not imported
Any Suggestions??
Sorry Dedj, perhaps I misunderstood what you needed. NO way to use chmod from within zencart admin that I know of (or ever heard). This would be done through your web publishing software, website admin panel, or using an ftp program like the plugin for firefox.Quote:
Originally Posted by dedj
You must have a /temp folder on your site for EP to work and it must be writable. If this is correct, and your still not getting the file, it is likely a server config problem... how many items in your store?
-chaddro
Milo:
Make sure every line including the header has EOREOR otherwise EP doesn't know how differentiate between each record. And you must have a product_id for each item.
-chaddro
ghopper:
This looks like your either missing a file or did not patch the sql for the admin. Verify that all your files have uploaded. Also don't forget to add a /temp folder with write permissions.
-chaddro
For trying to shoot my problem....
I had "temp" as the folder not tmp.Quote:
File uploaded.
Temporary filename: /tmp/phpTmwADx
User filename: Handbag.txt
Size: 14807
So I created a folder named "/tmp"
But that did not work.
Then I am thinking. Perhaps if I change that part to go to "temp" that might solve it. Where would I make that edit?
folder for easy populate 1.2.5.4 should be/tempQuote:
I had "temp" as the folder not tmp.
So I created a folder named "/tmp"
and must have owner permissions to read/write/execute
Your previous post states
Are you using EasyPopulate version 1.2.5.4?Quote:
I am trying out the Easy Populate taken from OS
Easy Populate Advance2.76d-mod3a Zen-Cart 1.3.x - Default Language English(1)
http://www.zen-cart.com/index.php?ma...roducts_id=460
I set temp/ to 777
I also changed all the items in that folder to 777 as if that would do anything.
I made a folder named tmp/ and chmod it to 777
(nothing ever goes into there)
I also tried uploading the file to the temp directory. EP saw that it was there.
But when I processed the file it gave me the same thing. No errors. Looked like it went in perfectly, yet the product was nowhere to be found.
I tried downloading all the products to the temp folder.
To try to download the products and move them to my other site...
I would start fresh if I could get all my products in... (With Attributes means that much to me..)
But I get this error when I tried.
If I try downloading the complete file to my hard drive I get 75 listings and this error (Inside my file)Quote:
Fatal error: Maximum execution time of 60 seconds exceeded in /public_html/admin/easypopulate.php on line 540
Quote:
<b>Fatal error</b>: Maximum execution time of 60 seconds exceeded in <b>public_html/admin/easypopulate.php</b> on line <b>558</b><br />
:no:Quote:
Easy Populate Advance2.76d-mod3a Zen-Cart 1.3.x - Default Language English(1)
USE version quoted from this url below
http://modhole.com/modhole/index.php...084a1bbfd60365
EP_v1.2.5.4.zip
Oh. Forgot to mention.
I had Easy Populate v1.2.5.4 previously installed.
I compared the files and file structure is exactly the same as this one...
However Easy Populate v1.2.5.4
has a SQL Patch when this one does not...
I dont know if I have to modify my database...
Milo,Quote:
Originally Posted by milobloom
To make this easier on yourself, be sure to completely remove all the old files you uploaded (manually verify these)... because of the way zencart works, an older non-compatible (or even newer) file will auto load.
Run the un-installer for EP. Do a search for uninstall to get exact instructions.
Once you've done that, reload 1.2.5.4 and install the patch. Open the sql patch with a plain text editor and paste this directly into the SQL patch window. Some systems seem to botch the file upload.
Then download your Full file ... this should work. If it isn't, reread the install document. I've done this dozens of times and when it doesn't work, it is nearly 100% user error... missing file, missing temp folder (from root mind you) or people not properly formating the text files.
-chaddro.
Ok. Ill try that...
Lots of work to do now...
Did you get this mod working??
Uninstall. Ok Ill try that first...
I am trying to load Easy Populate Advance2.76d-mod3a Zen-Cart 1.3.xQuote:
Once you've done that, reload 1.2.5.4 and install the patch. Open the sql patch with a plain text editor and paste this directly into the SQL patch window. Some systems seem to botch the file upload.
Because... It supports attributes.
I had that file working (And probably could once again...)
But that version does not support attributes.
If you rely heavy on Attributes... As we do... The thought of making this work would be very important.
I think what I might be doing wrong is asking for support for separate mod then this thread is about...
I saw this Easy Populate in the downloads section and thought it was from langer...
I will start my questions in another thread...
Thanks for the help.
milobloom - Easy Populate 2.76d-mod3a is a new version, which seem to be buggy, unless you are good a php to de-bug it I would use v1.2.5.4.
I would think your issue is that not many people are presently using this version as EP 1.2.5.4 or EPA are the most popular as they are proven with very little bugs.
Try to contact the porter of this mod (2.76d-mod3a) is see if he is able to add light to your issues, he/she may be helpful.
Thanks.
I have been using 1.2.5.4 for a long time now.
Problem I have is trying to move items from site to site that are
very heavy with Attributes...
But I am sure in time... This will be solved...
Well, if you need the advanced version, then you'll need to buy it from langer on his site... not expensive considering the time you've lost already. However, this forum won't support you with EPA.Quote:
Originally Posted by milobloom
If you are moving data between sites, better to use phpMyAdmin to export the file as sql. Open the sql file with a plain text editor and remove site specific data and then import that into your new site's with phpMyAdmin. Quite easy to do. The only trouble you may run into is MySQL versions ... but these are not insurmountable.
There has been some discussion of writing an update... but currently no one is taking up THAT flag.
-chaddro
Hi
I'm using ep1.2.5.4 but my problem are in specias price format different from "regular price product". When I download ep to my server then the format of special prices change to other. EXAMPLE: I upload 13.55 and all it's ok in zencart shop special product, but when I do a download of my products using fullep then in dthe row of specials change to 1.350.000.
Thanks in advance
If I could somehow get a little more detail on how to do that it would be worth a try.Quote:
If you are moving data between sites, better to use phpMyAdmin to export the file as sql. Open the sql file with a plain text editor and remove site specific data and then import that into your new site's with phpMyAdmin. Quite easy to do. The only trouble you may run into is MySQL versions ... but these are not insurmountable.
Thanks for reply asap. I download the sql specials. Also in this sql the format are different for example 8.00 appears 8.0000
Thanks
Hey, all. New to Easy Populate. Looks like this will save me countless hours. Haven't explored it much, but in theory, my gosh... this will be incredible for me.
Here's the deal... I'm having trouble finding how to link my downloadable products via Easy Populate. In otherwords, in Zen-Cart, I link my .zip file that is in my downloads folder in the attributes section. But how do I link it in Easy Populate. I can't seem to find this function.
Thanks for any help.
Cris
Nakris (or anybody)... have you found an answer to this question? I'm in the same boat, needing to be able to associate the downloadable file within EP.Quote:
Originally Posted by nakris
Thanks! This would be a great help if you know the answer.
Nicholas,Quote:
Originally Posted by langer
Hi. I just caught this quote, but it was made in July of '06. I'm searching high and low to see if EP now manages downloadable files. This would be incredible for me if so. Let me know...
Many thanks for this!
EasyPopulate doesn't handle attributes, and the details of downloadable files are ... attributes.
As far as I can tell there was no update done to handle downloadable products in EP before Nicholas stopped developing the mod.
Thanks for the response. This may be a semantics issue and a lack of understanding on my part, but I just purcased the Advanced version yesterday and it does handle some attribute stuff. Like the options name and value name. Only thing it's really lacking for me is linking the downloadable product. Again, it may be my lack of understanding as to what you mean by saying it "doesn't handle attributes." I am able to use EP to provide the option and value names though.... for whatever that's worth.Quote:
Originally Posted by DrByte
Regardless, hopin' they add that feature. It's a really great contribution!
Cris
I tried to use the contact form on the mod hole website and I don't know if it has been replied to and maybe my junk folder ate it or it hasn't been replied to (i sent it a few days ago) anyways I'm trying to find out if anyone is using the advanced version? I just need to know if it has the ability to set the sort order of products? that is the main thing i need and if it does I will purchase the script from modhole but I hate to pay the price and then it not be there.
Thxs for listening and thxs in advance if anyone can help.
Noneya
Noneya,Quote:
Originally Posted by Noneya99
You don't need the Advanced Version to set product sort order. Standard EP will do that, or you can install Quick Updates ( a very different product that lets you change a page's worth of products at once ) and set the sort order very easily with it. I use both products depending on what I need to do.
Hope that helps.
Chad,
Could you possibly tell me how I would do it in the Standard EP? I have used the EP on various sites for a few years and I never recall seeing that as an option though on all previous sites it was not an issue this site i'm using it on .. is... I have to have the products sorted in a certain way. I searched the forums for ep sort order but came up with hundreds of empty leads that were not related. if you could tell me how .. or point me to a thread that tells me so i can read up on it .. I would greatly appreciate it ..
Now you got me wondering .. what else does it do that I am not aware of and have been missing out on. Is there a page / forum / or anything that gives detailed info on what all CAN be done with the standard.. I've been all over mod hole the other day looking but maybe I wasn't looking in the right spot. Any help or info that anyone is willing to offer I'd greatly appreciate it.
Thank you,
Noneya
Noneya,
When you do:
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
You don't get a field header called: v_products_sort_order ??
If not, then I must have added it myself... I did add qty_order_min and qty_order_units and documented that in my code, but I thought sort_order was already in there??
I still find Quick Updates better for sorting products. You can filter products by their sub category and easily see what their sort order is.
-Chadd.
Chadd,Quote:
Originally Posted by chadderuski
Are you saying there is a mod called "Quick Updates"?
Thanks
John
Hi all
Easy Populate looks like a great idea.......but I am really confused.
It just doesn't seem to work, yet there are more than 100 pages in this thread. I guess some of you know how to make it work....
Sorry if this is old stuff, but the .txt files Easy Populate allows you to download don't then work on the upload. I'm talking about 'Download Complete tab-delimited .txt file to edit (Attributes Not Included) ' in the Tools > Easy Populate.
I thought it would be really simple to create 2 products, download this file, then upload to test. It didn't work. No v_products_model was or category was included in the downloaded file, yet both these are required for upload.
If this tool doesn't work, fair enough, it's free, I'll just do it manually. But if that's the case, then over 100 pages in the thread would be weird........ :)
or am I just being stupid?
I'm not going to call you stupid, but I will say the tool works as advertised, so something must be up with your setup. Perhaps a file was missed in the upload?
I just installed this on a 1.3.8 site and uploaded 16000 (yes sixteen thousand) products using EP. It effectively split the file and then walked me through installing all 52 split files it made. During testing I also added just a few dozen files as a test.
Sorry I can't help you troubleshoot. This is my first go round with EP so I haven't had to troubleshoot.
Quote:
Originally Posted by Mike123acc
Ok.......
I think I've got it.
I added a unique model description and 'v_categories_name_1' to the .txt file (I'm using Excel and saving it as a .tab delimited .txt file)
Basically the file available for download is missing the above.
Hi John,Quote:
Originally Posted by elkbow
Yes, a different product than EP.
For EP you can add fields with out too much trouble. This is all I've done. Do YOU have sort order in the complete download... I suppose I could have added that myself.
I added quantity_min and quantity_units to EP and Quick Updates cause that is how this company sells stuff, and these weren't in the official releases.
-chaddro
Noneya,Quote:
Originally Posted by Noneya99
Here is a post on adding sort order. I guess I did it without documenting it:
http://www.zen-cart.com/forum/showth...der#post309463
Very easy to do! Just back you databases up first before any testing.
-chaddro
Mike,Quote:
Originally Posted by Mike123acc
Re-read the install instructions again carefully. Make sure ALL files have been uploaded to the server. You also must have permissions 777 to the temp directory that you will also have to create on the server.
No temp directory sounds like your problem.... note that this is off the ROOT of your site and must have write permissions to work ---> 777
Your test scheme is correct: add a couple products manually, then download them and check the file. You must give a product_model to every product or else EP will not work since this is the key used to identify products. They must also be unique --> this is NOT required by Zencart, but it is to use EP.
If you can download products and it look okay, but cannot upload, be sure to have EOREOR copied down. EP fails without this at the end of each line!!!
Hope this helps...
-chaddro
I'm using zen cart 1.3.7 and EP 1.2.5.4.
I click the "Download Complete tab-delimited .txt file to edit" and it downloads a text file with only these columns:
v_products_model v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_quantity EOREOR
The last column has "EOREOR" for every row. Is this a bug? I was hoping it would show the product id and name, because I have multiple products with the same v_products_model.
Also, the Froogle feed file is outdated and no longer works with Google. Most of the columns changed when Froogle changed to Google Products in early 2007. It actually has since changed again to Google Product Search or Google Shopping, while the backend where you upload products is now Google Base, although the format hasn't changed since the Google Products change in 2007.
Decoy,
Yes that is supposed to be there it tells the system that is the end of the line (or product info) you HAVE to have different model numbers I found that out the hard way once..lol..if nothing else add a 1,2,3,... or a,b,c.... to the end of the product numbers
Chad,
Oh you are a sweetheart !!! thank you so much I will try to modify the code using the link you gave and cross your fingers that it works.
I'll post back in a few mins and let you know if it did or not
Thxs,
Noneya
Wouldn't it make more sense for the product id to be included, as it's the primary key for the products table anyway and could therefore be treated the same way in the exported/imported file? I think it would be easier if I tried modifying the code to add that column (I'd rather not go through hundreds of existing products in zencart to add suffixes to the model numbers), if the author of EP isn't able to.Quote:
Originally Posted by Noneya99
I guess in a way it would make it easier for those who have to have the same model number .. however .. what if you are ADDing new products using the EP how are you to know what the product ID is going to be i mean yeah you could log in and find the last one added but then that kind of defeats the whole purpose of using the mod to be faster when putting products in.. Just my thoughts on it I'm not a programmer so I don't complain about anything that is created as a mod that I might be able to use I am grateful to them all b/c without them I'm screwed and SOL..lol.. they make me look good to my clients..lolQuote:
Originally Posted by fakeDecoy
Oops I was actually looking at the wrong EP exported file. But anyway the complete one with the rest of the columns is missing the 'id' field too like we're talking about.Quote:
Originally Posted by fakeDecoy
I actually wasn't aware that new products could be imported with this. That makes more sense then for the id to not be included.
Yeah I thought that was the whole purpose of the EP was to make putting in products faster and easier .. it does for me anyways were I was manually addeding thousands of products I can now add them all (plus maintain them when they need to be edited) .. now if you have more then i think the default is 300 lines you need to use the split feature .. but you can change that number in the EP under admin--> config.. I think i set mine to 500 and it works .. it also is great b/c after you upload the EP with either new products or modifing old ones .. it gives you a "print" out of what it uploaded and says things like "New Product added" or it will tell you one was skipped b/c something was wrong .. usually for me the model is too long..lol (b/c I duplicate the item name as the product with no spaces)Quote:
Originally Posted by fakeDecoy
Ok, Have Easy Populate ver 1.2.5.4 installed. After upload in gives the upload report with all the New Products indicated. But when i go to the catagories and look for the products they are not there. If I reupload the same file it indicates Updated for all the same products and then they appear under all the catagories.
Any Ideas?
What happens if a catagorey is type wrong. what happens to that item?
Thanks Tim
I won't argue with you there, but this IS how EP works. Langer made a EP Advanced that supports ID, but you'll have to buy that from his site... check page one and his post for EPA 3. He was doing a lot of work on it last summer but seems to have been swallowed up in a black hole and hasn't released an update.Quote:
Originally Posted by fakeDecoy
I needed multi-column pricings. No luck!
-Chaddro.
LOL. Okay, ya have me blushing now! If you get stuck, PM me and I'll send ya the file I've edited.Quote:
Originally Posted by Noneya99
I do have some ideas for a new release, but not any time soon. I'd like to add some selectors for products, like downloading only a single top level category, but all in good time (think late spring) as I have some freight modules to work on.
Never enough time in the day!
-Chaddro.
If I remember correctly, you add the product as a linked product under a new category. Can make things messy!Quote:
Originally Posted by Vertcnc
Not sure about the other.
Have no clue on this one I've never had that happen that I am aware of I run the upload then go to the admin home and check my product count and they add upQuote:
Originally Posted by Vertcnc
It's my understanding that if you type the category wrong as in misspell it .. it creates that new category and your product goes under there.Quote:
Originally Posted by Vertcnc
I haven't figured out an easy way to mass remove the categories yet i went and entered 5000 Products and then changed Some things and cleared out all of them and uploaded them all as new again in different categories .. and realized after the fact that I had 100+ categories still showing that now have no products in there .. so i just manually removed the empty categories .. I guess if you do that and catch it you can just manually "move" the product to a new category? but again back to the I'm not a programmer just a very grateful user of their hard work.
I think if i remember correctly on the modhole website that the advance has new features that are category specific related .. like adding a pic for the category.. that would be neat but I don't mind manually entering them in for this one site in particular i do want to buy the advanced but I think imma gonna wait til langer reappears so i know that the "year" of upgrades isn't wasted..LOL
Just to update I did modify the code to add sort order and it's working so far that I can tell I haven't re-uploaded the products yet .. but when i downloaded the full EP file the column is there and so are the numbers I manually entered before I downloaded.
If I have any problems I'll let you know
Thxs again Chad
I tried this again today and after the new products are uploaded it created the new catagories, the total # of products in the Admin page increased by the proper # but the items are not found in any of the new catagories.Quote:
Originally Posted by Noneya99
Strange one.
I know this covers two problems, but seem connected !!!
[FONT=Verdana]Easy Populate Version 1.2.5.4[/FONT]
[FONT=Times New Roman]And[/FONT]
[FONT=Verdana]MySql Backup.[/FONT]
[FONT=Verdana]Two Separate Stores Involved here.[/FONT]
[FONT=Verdana]Lunix Hosting Configuration 1[/FONT]
[FONT=Verdana]Runs php version 4.0.27[/FONT]
[FONT=Verdana]1. [/FONT][FONT=Verdana]Allows the MySql back up to work under Admin/Tools.[/FONT]
[FONT=Verdana]2. [/FONT][FONT=Verdana]Does NOT ALLOW Easy Populate to upload more than 1800 items[/FONT]
[FONT=Verdana]as it TIMES OUT. Ending with a blank page, but products are loaded up.[/FONT]
[FONT=Verdana]3. Found the best way to use EP was to go thru Create/Upload in temp/. 3259 in one shot.[/FONT]
[FONT=Verdana]4. Configuration 1 does NOT ALLOW access to php.ini. Max_execution = 60/30, Input_time = 60/60.[/FONT]
[FONT=Verdana]5. After months of trying, I found this: According to Dr Byte, the download of Attributes does not work.[/FONT]
[FONT=Verdana]Lunix Hosting Configuration 2 (disables “exe_cmd”)[/FONT]
[FONT=Verdana]Runs php version 4.3.11[/FONT]
[FONT=Verdana]1. [/FONT][FONT=Verdana]Does NOT ALLOW MySql Backup to work under Admin/Tools.[/FONT]
[FONT=Verdana]2. [/FONT][FONT=Verdana]Allows Easy Populate to upload as many products I can use.[/FONT]
[FONT=Verdana]3. [/FONT][FONT=Verdana]Configuration 2 ALLOWS access to php.ini. Max_execution = 60/30, Input_time = 60/60.[/FONT]
[FONT=Verdana]So is “exe_cmd” involved in ZenCart 1.3.7?[/FONT]
[FONT=Verdana]Thanks, John[/FONT]
Hi All,
Found something else.
Everytime I up load my EP full, the date changes to Wednesday 31, December 1969...
Yet my EP full says "24-01-2008 6:23:00 PM".
I have checked all pages under Configuration to find out how to shut off the date added, and set all of those requests to 0 or left them blank yet the date still appears.
How do I shut off the date???
Do I eliminate the column completly in EP Full or ??
Thanks, John
archeryshop.com/zencart
Found it...
Catalog -> Product Types ->Edit Product Type (It's Edit Layout)
One thing that I noticed that often needs to be done is that you need to go into:
Tools -> Store Manager >>
and Select:
Update ALL Products Price Sorter
This index apparently does not get updated when you upload price changes.
There is a BUG in the upload. You will have to read through the entire thread (sorry) but there are some fields that when left blank, pull the data from the last imported item that wasn't blank instead of properly reseting it.
I don't remember where that was! Sorry. But I believe dates was one of them. Best to eliminate a column that you are not changing when uploading. Also makes uploading changes faster ->>> less data to process.
-chaddro.
I am learning quite a bit tonight from searching these forums. What a wonderful place. I've looked for this answer but cannot find it.
Can categories be created using easy populate, with predefinded category id's. I am moving my store and it will be much easier if my categories continue to use same id number.
Thanks.