-
Re: Easy Populate support
Ok. Sorta trouble shooting myself here.
Tried some test data.
But now it works like I dont have any problems at all.
But I only uploaded 2 products.
So now I am thinking. Or know the answer (Banging head) Hmmm maybe
thats why there is a "Split File" section. Duh!
Okay well. Maybe I have that solved. Which now still leaves me to thew other
question about my "Temp" folders.
Is the way I am doing it te only way to get attributes done easly, Or is there another way? Am I doing harm leaving temp folders in closed directories.
Thanks
-
Re: Easy Populate support
The products which are not showing have either:
- invalid master categories id
- no product description
To fix master-categories-id, DO A DATABASE BACKUP and then go to Admin->Tools->Store Manager, and choose "Reset all products master categories id". This may take awhile to run.
-
Re: Easy Populate support
Quote:
Originally Posted by DrByte
The products which are not showing have either:
- invalid master categories id
- no product description
To fix master-categories-id, DO A DATABASE BACKUP and then go to Admin->Tools->Store Manager, and choose "Reset all products master categories id". This may take awhile to run.
Whew... Ok. You are right.
I tried combining a upload I know that works & the file. The part that worked worked and the data I was trying to upload still didnt show. Ok so now i know its the data. Tried chaging everything.. Then dropped my descriptuions and replaced with a duplicate tite and it worked...
Whew!
Ok. Now about this other thing. Is there a way I can incorporate this re-alligning the master id's with my Batch proccessing attributes idea? Im not sure if there is anyway else to do it without leaving the files in the temp folders i created. Also ust a though. If a file has a invalid master id from the start with a linked product to it. Which catagory would the master link id go to?
-
Re: Easy Populate support
Hi Guys.
Whenever I tried to download I file (not upload, download), I get this error message:
Quote:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, support AT supportwebsite DOT com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Apache/1.3.33 Server at
www.southbayperformance.com Port 80
I tried to contact my support, and they said it had to do w/ the software I was running, and that I'd have to talk to the software support.
-
Re: Easy Populate support
Quote:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
1. your server's errorlog will usually tell you a lot of info about what is causing this.
2. As an alternative, skip using "download" and use "create" instead, and then use FTP to download the file from your "imports" folder (or "temp" or whatever it's called)
-
Re: Easy Populate support
It happens when I do create aswell.
-
Re: Easy Populate support
EasyPopulate 1.2.5.4: I wonder if this is a known issue. I have a product in my store, Model ADS-BYMYLIF, priced at 16.95. I use Easypopulate to upload the following file:
Code:
v_products_model v_products_quantity EOREOR
ADS-BMYLIF 0 EOREOR
I refresh, quantity has gone to 0, but the price has shot up to 95.47 (which happens to be what shown in Products Prics (Gross) when the 16.95 is the Products Price (Net)) -- is there a fix for this?
If it's fixed in EP Advanced, this would be an additional prod to upgrade (which I'm likely to do anyway once the other half wakes up and gives me the OK)
Thanks!
-
Re: Easy Populate support
Woodymon asked if anyone else was having trouble with discriptions loading. DrByte suggested uploading five at a time and asked what editor he's using.....this got my attention but don't see a responce from Woodymon.
I am using ep_v1.2.5.4
Last night I uploaded 22 products and the discriptions didn't take.
I edit in MS excell and only one line uploads...but I see that is because excell only saves one line of my discriptions. Langer mentions in the notes that you can overload excell but I can't find an alternative.
I have no problems with price changes and all else seems to be working just fine...except for Froogle. I use Froogle Google for that. I'm afraid to go with later release until I see that all the bugs are worked out.
So my questions are: is it safe to upgrade? What are the issues? Any suggestions on a better editing tool?
-
Re: Easy Populate support
the usual cause for only one product uploading/updating is the omission of EOREOR from the end of each row
-
Re: Easy Populate support
Here is what i do with excell. Hope this helps.
I have a colums for Title, Description.
Then I chop up my html at places before where I want the title to go
The middle of the title and descriptions and then what ever i want all the items to have on the end. Then I put it all togeather with something that looks like this:
=K2&C2&L2&F2&M2
-
Re: Easy Populate support
can anybody help me to find easypopulate contribution for zencart, its not available under the Admin Tools category... please advise.
-
Re: Easy Populate support
-
Re: Easy Populate support
Thanks for the reply madk but this is paid... cant i find a free solution?
-
Re: Easy Populate support
If you'd looked a little closer, you'll find that the free version is on the first link you were given; you only need to pay if you want the pro version (which is well worth it)
Anyway here is the precise link... http://www.modhole.com/modhole/index...ies&category=1
-
Re: Easy Populate support
I've been posting my questions on Langers support forum on his site, but I'm probably making him talk to himself by now, so I'll ask here.
On the read me/instructions that compe with the package, it says:
"For example, the presence of the ptc_categories_index_path column will invoke a categories upload only, and product descriptions will only update if the products name column is present."
Yet in my store template that is a field. I already did the categories upload. So when uploading the products do I leave this field in the EP file or leave it out?
I'm also confused at this point if I need to use the store template to upload products or the productid template?
If I am supposed to use the ptc_categories_index_path do I enter the categories as: (for example) Accessories~Other Accessories ?
thank you,
betty
-
Re: Easy Populate support
also, in the store template the field v_tax_class_title has the sample field as:
--none--
am I supposed to keep the dashes in it?
b
-
Re: Easy Populate support
Hello,
I am new to ZenCart and slowly learning the ropes.
I have followed the install instructions (Install.txt) for Easy Populate and have uploaded the Easy Populate contribution mod to my server. However, when I log into my ZenCart Admin panel and check the Tools menu, I can't find Easy Populate. My site - while under construction and testing - is in a directory one level below the root. (e.x.www.mysite.com/mysite/). I changed the name of the "Admin" directory to "easypopulate_admin" so the files wouldn't overwrite the existing "Admin" directory in the "mysite" directory, and proceeded to upload that folder into the "mysite" directory. I then uploaded the "temp" directory into the "mysite" directory and changed the permissions on the "temp" directory to chmod 700 (read,write,execute for owner only). After this, I opened my ZenCart Admin panel and looked at the tools menu, but could not find "Easy Populate".
Please let me know if I did something wrong during the installation of this mod. I have tried re-installing it a few times now and nothing has happened. Thanks for all of your help in advance guys!
In Christ,
Jesse
-
Re: Easy Populate support
Quote:
Originally Posted by Jesse_Tyler
Hello,
I am new to ZenCart and slowly learning the ropes.
I have followed the install instructions (Install.txt) for Easy Populate and have uploaded the Easy Populate contribution mod to my server. However, when I log into my ZenCart Admin panel and check the Tools menu, I can't find Easy Populate. My site - while under construction and testing - is in a directory one level below the root. (e.x.
www.mysite.com/mysite/). I changed the name of the "Admin" directory to "easypopulate_admin" so the files wouldn't overwrite the existing "Admin" directory in the "mysite" directory, and proceeded to upload that folder into the "mysite" directory. I then uploaded the "temp" directory into the "mysite" directory and changed the permissions on the "temp" directory to chmod 700 (read,write,execute for owner only). After this, I opened my ZenCart Admin panel and looked at the tools menu, but could not find "Easy Populate".
Please let me know if I did something wrong during the installation of this mod. I have tried re-installing it a few times now and nothing has happened. Thanks for all of your help in advance guys!
In Christ,
Jesse
You sure did. Renaming the admin folder was your big mistake. Just upload it as admin (all the eaypopulate files are new and you won't be overwriting anything)
-
Re: Easy Populate support
Langer:
One idea I thought about for your easy populate advance (Which I am going to purchase soon after this season.
Can you make it so you can add a "Category" image in the datasheet upload.
I am dealing with alot of categories and this would help speed things up quicker.
Also.
I had a question before that didnt get answered. It was that I was uploading my products to a temp directory to add attributes to them then changing the directories in the database and then reuploading them. Effects: 1) Invalid master id's. 2) I have alot of these "Temp" folders that I cant delete, so I just move them to a unused closed directory. Is there a better way to do this? Will I run into any problems later? I have to do this this way because I am dealing with huge amounts of products.
-
Re: Easy Populate support
Quote:
Originally Posted by bettysue
I've been posting my questions on Langers support forum on his site, but I'm probably making him talk to himself by now, so I'll ask here.
Support for the advanced version is not given here.
-
Re: Easy Populate support
Quote:
Originally Posted by bettysue
also, in the store template the field v_tax_class_title has the sample field as:
--none--
am I supposed to keep the dashes in it?
b
This merely reflects the name of your tax class for a particular product. In you Zen Cart store, you have the option "--none--" which is why Easy Populate exports it. It means you have no tax class assigned to that product.
-
Re: Easy Populate support
sorry Langer, will go back to yourforums for question.
betty
-
Re: Easy Populate support
Greetings,
Thankyou for your help Ryk and Dr.Byte! :D I have now successfully uploaded my Easy Populate Mod and it is showing this in the Tools menu of the Admin panel. I have also configured everything. My next step is to upload an .xls (Excel) file to my site. This I am unsure how to do. I have searched the threads in an effort to learn how, but could not find the specific instructions I need.
I basically have an Excel spreadsheet with 4 tabs and an average of about 1375 sports trading cards on each tab. In the spreadsheet, the sports cards are organised by 8 different categories (Year, Company, Special Notation, Player, Card #, Condition, If #, and Price). I was just wondering if there is a special way to do this, or if it is even possible to accomplish uploading a sheet of this type to my database through Easy Populate?
I really appreciate all your help guys. Thankyou in advance :smile:
In Christ,
Jesse
-
Re: Easy Populate support
Jesse - the only way that you can import via EP is to use a tab delimited text file. You can use Save As from Excel for this but it will only save a "flat" file...therefore you'll need to modify your xls
Also, there is a very specific format to follow, so your best bet is to download your existing products via EP and use that as your template.
If you haven't got product data yet, then just add a test item with as much info as possible to give you guidance.
-
Re: Easy Populate support
Code:
Warning: require(includes/extra_datafiles/easypopulate_filenames.php) [function.require]: failed to open stream: No such file or directory in /home/cgc/public_html/store/admin/includes/init_includes/init_file_db_names.php on line 39
Fatal error: require() [function.require]: Failed opening required 'includes/extra_datafiles/easypopulate_filenames.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/cgc/public_html/store/admin/includes/init_includes/init_file_db_names.php on line 39
What am I doing wrong?
-
Re: Easy Populate support
I'm getting "0" for categories when inserting my Easy Populate files. I made sure I deleted all 0's from my excel files and txt files but easy_populate seems to treat the blank cells as 0 for category. Does anybody have any suggestions?
-
Re: Easy Populate support
Is there a value for Easy Populate that I can use to indicate if the product is refurbished. i.e Product Name equals "v_products_name_1".
-
Re: Easy Populate support
Does it work with price breaks? All my products prices are set this way. Is there any other way to update they quickly?
Adam
-
Re: Easy Populate support
Nevermind, i fixed my prob :D
-
Re: Easy Populate support
Thanks Ryk! I appreciate your help! I have successfully uploaded the first sheet of cards. The only problem I'm having currently is that I uploaded one sub-category too many and am trying to find a fast way of deleting it out of each category in which it was placed. (E.x. I have different years listed in the "v_categories_name_3" column of the tab-delimited .txt file I uploaded to EP, and "NM-MT" in every field (approx. 200) the "v_categories_name_4" column of the same .txt file. I decided, after accidentally uploading this .txt file that I didn't want the "NM-MT" category anymore, but found that the only way I knew how to delete it from every year category was to do so manually through the ZenCart admin panel.
If there is any way of accomplishing this much quicker, pehaps automatically somehow, I would really appreciate if someone could help me understand how to do so. Thanks in advance for all of your help, and thanks again Ryk for your assistance! :D
-
Re: Easy Populate support
Hi all
Can anyone tell me if Easy Populate will work with Zen 1.3.5, or better still anyone using it with 1.3.5???
Thanks
-
1 Attachment(s)
Re: Easy Populate errors
i installed easy cart which in theory should be the absolute best thing in the world. except i am unable to figure out how to make it work. that might have to do with my abilities so i am here to find out... ;-)
i have changed the permissions to the file in the extra_functions folders to execute so i am unsure where to go with it from here.
when i upload my tab delimited db i get the following messages:
Warning: move_uploaded_file(/home/vanrred6/public_html/store/temp/FULL-EP2006SEP19-0404.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/vanrred6/public_html/store/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phplMjzZu' to '/home/vanrred6/public_html/store/temp/FULL-EP2006SEP19-0404.txt' in /home/vanrred6/public_html/store/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: file(/home/vanrred6/public_html/store/temp/FULL-EP2006SEP19-0404.txt) [function.file]: failed to open stream: No such file or directory in /home/vanrred6/public_html/store/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/vanrred6/public_html/store/admin/easypopulate.php on line 1301
and i only see one item in the store. which isn't live so i can send you there. (still building it)
i am using ep_v 1.2.5.4, zen cart v. 1.3.0.2
and my txt file is based on your full one. i've attached in a zip file.
can you tell me what i am doing wrong?
(sorry if i am overloading you with info but after yrs of phone tech support its habit)
-
Re: Easy Populate support
i dunno what i did right but it's working.
now i have a couple of questions:
1.) if i make a mistake in my original tab delim file, can i upload the corrected one and have it overwrite the old info?
2.) Images/ xxx.jpg as inserted in the file, where exactly is that located? because nearest thing i can tell, its not root/inages and its not admin/images...
-
Re: Easy Populate support
Quote:
Originally Posted by mimieux
i dunno what i did right but it's working.
now i have a couple of questions:
1.) if i make a mistake in my original tab delim file, can i upload the corrected one and have it overwrite the old info?
2.) Images/ xxx.jpg as inserted in the file, where exactly is that located? because nearest thing i can tell, its not root/inages and its not admin/images...
1. That's a large part of the purpose of EP! :D
2. The image column assumes your images are in the main images directory and should contain only the filename, unless you are using sub-directories, in which case you need the path from within the images/ directory.
-
Re: Easy Populate support
Quote:
Originally Posted by Bootyrat
Hi all
Can anyone tell me if Easy Populate will work with Zen 1.3.5, or better still anyone using it with 1.3.5???
Thanks
Yes - at least, the pro version does.
-
Re: Easy Populate support
thanks ryk! i managed to figure it all out. funny how relooading a few times will fix most evils...LOL
cheers!
-
Re: Easy Populate support
Does anyone know if Easy Populate or Easy Populate Advance can handle quantity pricing. For example, qty 50-100 costs $3 and 101-200 costs $2.50 etc... I can do it via the pricing manager but would like to have the ability in Easy Populate.
Thanks!
-
Re: Easy Populate support
Quote:
Originally Posted by castylx
Does anyone know if Easy Populate or Easy Populate Advance can handle quantity pricing. For example, qty 50-100 costs $3 and 101-200 costs $2.50 etc...
Hi. Not yet, but this is a priority.
-
Re: Easy Populate support
does nayone have an attributes file for easy populate they could share? the one that comes with the module doesn't open properly in my excel...
cheers.
-
Re: Easy Populate support
can someone tell me where i can download easy populate from as i have looked and searched everywhere for it and all links i find are dead
thanks
-
Re: Easy Populate support
-
Re: Easy Populate support
Hi all
Having a problem where at the botom of each product I am seeing: "Min: 0 Units: 0
*Mixed ON" when I do a test order it won't go through as it is looking for input into those fields. I can't find those fields in any template, if thats where the problem stems from. How do I get rid of or change the mins to make my site work? Thanks
-
Re: Easy Populate support
Anyone with firsthand knowledge if the latest EP (NOT Advanced version) is supported on Zen Cart v.135. I gave up using on Zen Cart 1.3.0.2 due to previous posted upload issues (product descriptions not showing up). Thought I would give it another chance on v.1.35. Then later can upgrade to Advance version. Thanks.
-
Re: Easy Populate support
I don't know if I am doing something wrong or not. The test site is
http://www.funmartcycle.com/shop
I am running:
Zen Cart 1.3.5
Database Patch Level: 1.3.5
v1.3.5 [2006-09-29 11:11:25] (Fresh Installation)
Easy Populate 1.2.5.4
Title Value Action
Uploads Directory temp/
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Split File On # Records 300 Info
Maximum Category Depth 7 Info
Upload/Download Prices Include Tax false Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Every time I import it, it shows me agian what it imported but none of the products show up, and it only creates one of the categories. Are there required fields, should I include the heading with the v_"stuff in it" I am confused. I have attacted a link to the txt file I am using.'
http://www.funmartcycle.com/shop/temp/helmets_shop.txt
-
Re: Easy Populate support
hiya,
i got exactly the same thing when i started using it a couple of months ago, and what i had forgotten to do was put EOREOR at the end of each row.
hope that helps
Erica xx
Quote:
Originally Posted by nicholas.eckermann
I don't know if I am doing something wrong or not. The test site is
http://www.funmartcycle.com/shop
I am running:
Zen Cart 1.3.5
Database Patch Level: 1.3.5
v1.3.5 [2006-09-29 11:11:25] (Fresh Installation)
Easy Populate 1.2.5.4
Title Value Action
Uploads Directory temp/
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Split File On # Records 300 Info
Maximum Category Depth 7 Info
Upload/Download Prices Include Tax false Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Every time I import it, it shows me agian what it imported but none of the products show up, and it only creates one of the categories. Are there required fields, should I include the heading with the v_"stuff in it" I am confused. I have attacted a link to the txt file I am using.'
http://www.funmartcycle.com/shop/temp/helmets_shop.txt
-
Re: Easy Populate support
I use to have a spread sheet that could run through Easy Populate to delete products.
I tried it out with the latest version of Zen and it did not work.
If some one has a workign spread sheet to do this and I please get it?
Thanks!
-
Re: Easy Populate support
Hi there guys, does Easy Populate advanced 3.0 currently support
Extended product table support the options "under development"? Or is that simply for a furture release?
Specifically - (Qty purchase, call for price, free shipping etc.)
I simply want the ability to adjust the 6 Qty purchases of 1000s of products at a time - is this supported? If not, is there another easy way to do this?
Thanks in advanced!
-
Re: Easy Populate support
I'm using the old ep mod. I just found out a new version is available. I currently have over 2000 items on my site. When I try to export the attributes file it times out (actually it goes to a blank page and the browser says 'done'). I've also tried to create it in the temp file but it has the same result.
I am using zencart 1.3. Any suggestions?
Also, does anyone know where I can find the old version? I wanted to try and reinstall it.
-
Re: Easy Populate support
voltage, there are issues with browser timeout on the standard version, yet this should not prevent the script execution from completing.
The standard version is still at my modhole site, the link is in my signature.
-
Re: Easy Populate support
Do you have any idea what could cause this? In your opinion, if this is happening with the standard version, would it also happen with the advanced?
Quote:
Originally Posted by
langer
voltage, there are issues with browser timeout on the standard version, yet this should not prevent the script execution from completing.
The standard version is still at my modhole site, the link is in my signature.
-
Re: Easy Populate support
Quote:
Originally Posted by
Parafanaylya
and then it gets a second message:
Where is the debug log in uploads directory?
Funny, I just got that and now it won't go away. EP is also not apparently uploading anything. It says file uploaded fine but there are no changes in the cart at all. Any ideas?
-
Re: Easy Populate support
Hi I have Easypopulate running on a 1.2.7 version and I am just setting up a 1.3.5 site.(Version - EasyPopulate v1.2.5.4)
I have uploaded all the files to the folders but I am getting this error
Quote:
Warning: main(includes/extra_datafiles/easypopulate_filenames.php): failed to open stream: No such file or directory in /vhost/vhost5/s/h/o/shoes2buy.co.uk/www/admin/includes/init_includes/init_file_db_names.php on line 40
Fatal error: main(): Failed opening required 'includes/extra_datafiles/easypopulate_filenames.php' (include_path='.:/usr/share/pear') in /vhost/vhost5/s/h/o/shoes2buy.co.uk/www/admin/includes/init_includes/init_file_db_names.php on line 40
Any ideas what is going wrong for me?
Thanks
Andrew
-
Re: Easy Populate support
Scrat, try checking that the file in the error message uploaded correctly and has the correct permissions.
-
Re: Easy Populate support
Sorry Checked my error all working fine now many thanks
Andrew
-
Re: Easy Populate support
Is there an alternative to microsoft excel. I have too many attributes and the spreadsheet only allows a set number of columns. I'm working to cut this number down but in the meantime . . . ?
-
Re: Easy Populate support
Quote:
Originally Posted by
voltage
Is there an alternative to microsoft excel. I have too many attributes and the spreadsheet only allows a set number of columns. I'm working to cut this number down but in the meantime . . . ?
Try open office.
-
Re: Easy Populate support
Also it has been suggested Gnumeric will work with some modification, and if you love penguins there is Siag Office http://siag.nu/
-
Re: Easy Populate support
Also have a look at CSVed 1.3.11
This can cope with many more columns than Excel or Open office.
-
Re: Easy Populate support
Didn't know if you were already aware of this, but there appears to be a problem in Easy Populate where the master_categories_id field in the products table is set to 0. This is discussed in
http://www.zen-cart.com/forum/showth...612#post278612
Thanks,
Scott
-
Re: Easy Populate support
First post, first time zen cart user. First problem lol
Just did a fresh install of zen cart, no products in the database. I got the newest Easy Populate standard, follow the install.txt directions to the tee. Here's what i get after placing the files, and chmodding my temp directory
Code:
Warning: main(includes/application_top.php) [function.main]: failed to open stream: Permission denied in /home/scmadmin/public_html/cart/admin/index.php on line 23
Warning: main(includes/application_top.php) [function.main]: failed to open stream: Permission denied in /home/scmadmin/public_html/cart/admin/index.php on line 23
Fatal error: main() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/scmadmin/public_html/cart/admin/index.php on line 23
any suggestions?
-
Re: Easy Populate support
I cannot see how the installation of Easy Populate could cause the issue you are having. My suggestion would be to re-upload your zen cart files using a dedicated ftp application (eg Filezilla) and see if this resolves the issue.
The most likely cause of this problem is corrupted or missing files.
-
Re: Easy Populate support
Hmmm...
Well I grabbed a new copy of zc as well as a new copy of easy populate and experienced the same thing. Might be something in my hosts php.ini, who knows. I'll just write up my own sql file for this. Thanks though!
-
Re: Easy Populate support
Hi,
I have a few Easy Populate questions.
- Would it be possible to import by using a chron job?
- The files will be large. Wll I have any time-out issues for processing the file?
- From what I've read, EP does not create new categories automatically, but will create new vendors. Is this correct?
- The EP tables require headers. Is field order important?
Please feel free to note other considerations.
Thanks,
Steve
-
Re: Easy Populate support
Quote:
Originally Posted by
steveorg
Would it be possible to import by using a chron job?
No
Quote:
Originally Posted by
steveorg
The files will be large. Wll I have any time-out issues for processing the file?
possibly
Quote:
Originally Posted by
steveorg
From what I've read, EP does not create new categories automatically, but will create new vendors. Is this correct?
No. Categories are also created on the fly
Quote:
Originally Posted by
steveorg
The EP tables require headers. Is field order important?
No, as long as EOREOR is last in every row, including the header row.
-
Re: Easy Populate support
Before I shoot the computer??? When I try to upload...
"An appropriate representation of the requested resource /store/admin/easypopulate.php could not be found on this server."
The file is in place where ir should be,
-
Re: Easy Populate support
This has something to do with mod_security - I'm sure this has been answered here somewhere before... If you search this site for "mod_security" I'm sure you will find the fix - it is a hosting issue.
-
Re: Easy Populate support
must be a particular mod_security ruleset... I use mod_security and have no problems with EP
Your host should be able to see it in the mod_security audit log and tweak the ruleset accordingly.
-
Re: Easy Populate support
Thanks, I disbled the mod-sec with .htaccess while I uploaded. All worked perfect with EP.
I emailed my host..waiting a a permanent fix
-
Re: Easy Populate support
I need sum help. I am using excel to format the easypopulate uploads. I am trying to figure out how to calculate the price so that the entire column is increased by $10. It's been some time since I used excel.
-
Re: Easy Populate support
1. Insert a column beside v_products_price. Give it the same name: v_products_price
2. Rename the OLD v_products_price to v_products_price_OLD
3. in the first blank cell of the new column, press =
4. Press arrow-left/right to move to the OLD price column and highlight the OLD price for that row
5. Press + 1 0 ENTER
6. Press Arrow-Up to select the price you just added
7. Press SHIFT and while holding shift, press PgDn until you get to the last row of real data
8. Press CTRL-D to "duplicate" the formula to all the cells.
-
Re: Easy Populate support
Hello all,
I seem to be having a problem when uploading my Excel file (in Tab delimited format). I have about 12 categories and when I upload it it will put the first 10 categories in another folder with the name of the quantity I gave all of the items (9999 since they're virtual) but 1 complete category will be in the category's "root" while the biggest category seems to of split into 2, one being in the category's "root" and the other half in the 9999 folder. I've included a screenshot to help solve the confusion and if this is still confusing just tell me and I'll be glad to re-word the situation :yes: :lamo:
http://img221.imageshack.us/img221/5...hotlinknz6.gif
edit:
I have the following headers inside the Excel file:
v_products_model
v_products_name
v_products_price
v_date_avail
v_date_added
v_products_quantity
v_categories_name_1
v_categories_name_2
v_tax_class_title
v_status
EOREOR
Am I missing something? :(
-
Re: Easy Populate support
If I remember correctly, you need all the columns from the original EP sample for it to work correctly, even if the only thing in a column is its title.
-
Re: Easy Populate support
Follow up on my 406 errors and the "mod_sec" issues some have.
Sad news for me. Here is the reply from my server company.
========================
Response from Server Admin below.
---------------------
mod_security is installed on the server, it is working as it should and that
is why easy populate for zencart is not working. I am not intimately
familiar with the easy populate script however from what i have read some
say it is written in a fashion that allows sql injections which are filtered
by mod_sec . The client can do a few things.
a. Don't use easy populate
b. Work with the software developer to have easy populate written to work
with mod_sec
c. Disable mod_sec for his domain using .htaccess , he would need to create
the file and put something like this in it:
==================
SecFilterEngine Off
SecFilterScanPOST Off
==========================
It sounds like the client already knows how to do that. While we do not
condone disabling mod_sec at the domain level we also don't disallow it. It
is the client's responsibility if something negative occurs from disabling
mod_sec through .htaccess .
To use easy populate I guess I have to take my chances.
Zen Cart with a nice native Import/export function would be nice.
-
Re: Easy Populate support
Quote:
Originally Posted by
jmauto
Follow up on my 406 errors and the "mod_sec" issues some have....
Response from Server Admin...
c. Disable mod_sec for his domain using .htaccess ..
To use easy populate I guess I have to take my chances.
You could just use the .htaccess trick while doing an import, then comment it out in the .htaccess for the rest of the time.
-
Re: Easy Populate support
I have tried looking before asking but i cant get ep to upload into my store ive included what im trying to upload im only trying to do one right now to test to see if i have the right format of how it wants it.....
ALE96001 Juli Ashton - *** Around the House - DVD http://www.xxxfreesexchat.com/MV/ALE/96001.JPG Juli shows how to experience new sexual pleasures right at home. "With the help of *** expert Dr. Ava Cadell, Juli shows how to experience new sexual pleasures right at home. Three ######## couples move beyond the bedroom to discover a variety of creative uses for otherwise common household items found in every room of the house. Includes new techniques for women and men. With Juli Ashton, Devin, Charlie and Chennin Blanc. Very explicit, 85 min." 18 Movies_DVD Movies_educational eoreor
this is all in one line and please excuse the content as i am going to sell adult products. is there something im doing wrong here
-
Re: Easy Populate support
I am relatively new to ZenCart but have been making my way through understanding the workings. I would like to be able to import product info into my cart from a previous project. I tried to install and configure Easy Populate for this. I am having trouble with uploading a changed version of the data file. It seems to be related to permissions in the temp folder although I did set the permissions to the temp folder to read/write/execute (chmod 700) but am still getting an error like this:
Warning: move_uploaded_file(D:/inetpub/DomainID135310/ZenCart/temp/Full-EP2006Nov10-1705.txt): failed to open stream: Permission denied in D:\inetpub\DomainID135310\ZenCart\admin\includes\functions\extra_functions\easyp opulate_functions.php on line 57
Warning: move_uploaded_file(): Unable to move 'C:\PHP4\uploadtemp\php149E.tmp' to 'D:/inetpub/DomainID135310/ZenCart/temp/Full-EP2006Nov10-1705.txt' in D:\inetpub\DomainID135310\ZenCart\admin\includes\functions\extra_functions\easyp opulate_functions.php on line 57
Warning: file(D:/inetpub/DomainID135310/ZenCart/temp/Full-EP2006Nov10-1705.txt): failed to open stream: No such file or directory in D:\inetpub\DomainID135310\ZenCart\admin\easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in D:\inetpub\DomainID135310\ZenCart\admin\easypopulate.php on line 1301
Any help would be appreciated.
Thanks,
Ellie
-
Re: Easy Populate support
Quote:
read/write/execute (chmod 700)
is wrong; should be 777
-
Re: Easy Populate support
Thanks. I will try that. Was going by the install isntructions.
Ellie
-
Re: Easy Populate support
Quote:
Originally Posted by
Scrat
Sorry Checked my error all working fine now many thanks
Andrew
I was experiencing similar problems... What was your error exactly?
-
Re: Easy Populate support
Quote:
Originally Posted by
Ryk
is wrong; should be 777
Ok, I did chmod777 and that still didn't work. Next step talk to webhost?
-
Re: Easy Populate support
Windows hosting almost always requires the host to assign write privileges to the temp folder on IIS server user IUSR_<server_name>. This cannot usually be done from your host account.
-
Re: Easy Populate support
I was wondering if it were possible to have the image category list both a jpeg and gif version of the images, the thing is that the distributors send me a set of pictures
with a list of the products they send me, most are gif files but some are still jpeg files. I was wonder if it were possible to have 2 image columns and just list one as jpeg and one as gif without having to upload every image single by hand.
-
Re: Easy Populate support
Sorry folks, I found a program that allows me to convert file image types.
-
Re: Easy Populate support
Hello! I am having trouble with the froogle feeder. While special prices are reflected in the feed, sales prices aren't. I searched for this topic but got no result. Anyone can tell me whether this is EP's deflect, or it's just I am doing something wrong? Or, is there a simple hack I can use to make it include sales prices? THanks a lot!:sleepy:
-
Re: Easy Populate support
I don't think that easy populate is causing your issues, It might be something else, did you address this at the froogle thread. Which version of the froogle feeder are you using?
-
Hit a wall with excel
For the most part I have looked through tutorials and even managed to
remember some of the stuff I learned from back in the day, but I still
managed to hit a wall. Here is the problem, I get a spread sheet from one of
the distributors I deal with and in the file I get everything but the
description. They only update the description every so often. The list
consists of 5,000 products and they have more than that for the description.
in the spread sheet they have the a column for the manufacturers part number
and in the descriptions the part numbers are their too. I was wondering if
it were possible to have the description to be organized so that they are
listed directly next to the corresponding manufacturers number, In other words since they have similar info could they be organized based on that.
-
Re: Easy Populate support
Quote:
Originally Posted by
ctcentralinfo
I don't think that easy populate is causing your issues, It might be something else, did you address this at the froogle thread. Which version of the froogle feeder are you using?
Hi! I am using the froogle feed producer built in in the EasyPopulate (v1.2.5.4)module. I didn't install any other froogle modules. So I don't think the stand-alone froogle module is relavant. Am I right? If so, anyone can fix my problem? All that I can see relavant is the easypopulate.php file under /admin/ folder. There is code for special price to be included. But no code for the sales. Am I missing something? Or, maybe I am looking at a totally wrong place? Thanks!
-
Re: Easy Populate support
(v1.2.5.4)? What version of zen-cart is it compatible with? The problem maybe that your version is outdated. Google switched to Google base.
-
Re: Easy Populate support
Quote:
Originally Posted by
ctcentralinfo
(v1.2.5.4)? What version of zen-cart is it compatible with? The problem maybe that your version is outdated. Google switched to Google base.
I am using the latest zencart 1.3.6 release. There's no problem of google accepting it, because everything goes through without problem except for the sales price.
Am I the only one experiencing this problem? I assume most people will be using EP and creating froogle feed from there. Is there a new realease of EP?
Thanks!
-
Re: Easy Populate support
Quote:
Originally Posted by
stargre
I am using the latest zencart 1.3.6 release. There's no problem of google accepting it, because everything goes through without problem except for the sales price.
Am I the only one experiencing this problem? I assume most people will be using EP and creating froogle feed from there. Is there a new realease of EP?
Thanks!
Anyone can help? Thanks so much!
-
Re: Easy Populate support
Salemaker support is not available in Easy Populate at this time.
-
Re: Easy Populate support
Quote:
Originally Posted by
langer
Salemaker support is not available in Easy Populate at this time.
Thanks for letting me know. Now I can settle down and change it manually without spending hours trying to 'fix' the problem.
-
Re: Easy Populate support
Okay. The first install of EZ populate went smoothly. Unfortunately, after attempting to have it take a db file set according to its template, I could no longer get anything but a 404 error when trying to access zen cart's admin area. The db did not upload because the original front end with all its sample products appeared and worked but none of the new products showed up.
Deleted the entire when I could not get it to restore.
Installed a new zen cart.
Uploaded EZ Populate Standard. Have everything set exactly as I had it then. Now, I got an error. I installed the SQL patch as per install instructions. I still get an error, but it is a different line reference than it was the last time. however the message is the same:
Fatal error: Call to undefined function: ep_chmod_check() in /home/.johnwasher/snowbear/secure.marinepartsman.com/Yamaha-outboard-parts-store/admin/easypopulate.php on line 204
The temp bin IS chmoded 700
What am I missing here?
BTW, the cart is now loaded on a SSL server instead of fighting the split folder issue. Cart was running fine, and still seems to be.
I have a 300,000 product DB to get up this week.
-
Re: Easy Populate support
Looks like some files are missing or corrupt, as that function in the error message is part of the function file in the package.
-
Re: Easy Populate support
Okay. I'll re-upload EZ Populate and try it again. Thank you.
-
Re: Easy Populate support
Please could someone tell me where can I download Easy Populate standard edition?
-
Re: Easy Populate support
there is a link for the standard version in my signature.
-
Re: Easy Populate support
Yes, I saw that, but no option to download the standard version on the resulting page, could you please provide me with a download link?
-
Re: Easy Populate support
Are you serious Nellie? :blink: Did you try the Downloads link in the header menu there?
-
Re: Easy Populate support
Nellie, you will find the download link for EasyPopulate Standard on the right-hand side of the page. Number 11 under "Recently Added Files".