-
Re: Easy Populate support
Quote:
Originally Posted by
Ryk
Are you serious Nellie? :blink: Did you try the Downloads link in the header menu there?
Nellie is not the only one, there is no download link that I can see (in the header menu or otherwise). I can see ways to purchase Easy populate Advanced, but there is no link for "downloads" or any sort of link to "easy populate standard" on the www.zencartbuilder.com site that I can find. Can someone please point it out?
I did find it elsewhere though - so for those looking, it is here http://www.modhole.com/modhole/index...ies&category=1
-
Re: Easy Populate support
Sorry - my mistake - I have the author's website bookmarked and didn't realise that there are two different urls/sites. Try
http://www.modhole.com/modhole/index.php
-
Re: Easy Populate support
Here's the link. Download links are at the bottom of the page.
http://www.modhole.com/modhole/index..._Document_id=2
-
Re: Easy Populate support
Okay. No matter what, I'm still getting this error:
Fatal error: Call to undefined function: ep_chmod_check() .../easypopulate.php on line 204
There are NO REFERENCES COMING UP IN THE LOGS to help me out.
-
Re: Easy Populate support
Quote:
Originally Posted by
CyberCobre
Okay. No matter what, I'm still getting this error:
Fatal error: Call to undefined function: ep_chmod_check() .../easypopulate.php on line 204
There are NO REFERENCES COMING UP IN THE LOGS to help me out.
This appears to be coming from the line of initialization code that is checking for the existence and/or read/write permissions of said temp directory ie [[ $tempdir = EASYPOPULATE_CONFIG_TEMP_DIR; ]]
The configuration variables for EZPOP are insertions into the zen configuration file ie [[ INSERT INTO configuration VALUES
('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ...]]
If you don't have a /catalog/temp/ directory that is read/writeable OR you didn't re-install the sql patch to the configuration file OR the temp file doesn't match the configuration patch, I would suspect that you might see such an error.
I have shoveled 20-30K items into zen via ezpop w/o incident, just make sure you have the various ezpop configs set the way you want (ie price incl tax, etc.)
-
Re: Easy Populate support
Quote:
Originally Posted by
andrea71
Nellie is not the only one, there is no download link that I can see (in the header menu or otherwise). I can see ways to purchase Easy populate Advanced, but there is no link for "downloads" or any sort of link to "easy populate standard" on the
www.zencartbuilder.com site that I can find. Can someone please point it out?
I did find it elsewhere though - so for those looking, it is here
http://www.modhole.com/modhole/index...ies&category=1
the www.modhole.com site has a link in the top horizontal nav bar called "Downloads", and file number 11 in the recently added files in the right-hand sidebox is "Easy Populate (Standard)"
It is this site that is linked to in my signature for the standard version.
-
Re: Easy Populate support
Quote:
Originally Posted by
docfx
This appears to be coming from the line of initialization code that is checking for the existence and/or read/write permissions of said temp directory ie [[ $tempdir = EASYPOPULATE_CONFIG_TEMP_DIR; ]]
The configuration variables for EZPOP are insertions into the zen configuration file ie [[ INSERT INTO configuration VALUES
('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ...]]
If you don't have a /catalog/temp/ directory that is read/writeable OR you didn't re-install the sql patch to the configuration file OR the temp file doesn't match the configuration patch, I would suspect that you might see such an error.
I have shoveled 20-30K items into zen via ezpop w/o incident, just make sure you have the various ezpop configs set the way you want (ie price incl tax, etc.)
temp directory is read/writable.
SQL patch installed.
I'm just not having any luck here at all. *sigh*
-
Re: Easy Populate support
Quote:
Originally Posted by
CyberCobre
Fatal error: Call to undefined function: ep_chmod_check() .../easypopulate.php on line 204
Undefined function means that the function is missing, and this can only be missing if the file containing it is missing or corrupted.
I recommend uploading all files again by ftp, especially the file /admin/includes/functions/extra_functions/easypopulate_functions.php
-
Re: Easy Populate support
-
Re: Easy Populate support
YeeeeeHAAAAAAAAAAAAAAAW. Blessings upon you Mr. Langar. That was the ticket...though why when it had been uploaded three other times.... Cyber Gremlins. That's it! They needed the Voice of the Master.
Now, do you know how big a file I can upload safely? I don't want to lose the backend again. I have a total of 86MB to get into the db.
-
Re: Easy Populate support
I need a bit of advise I am trying to upload a file I downloaded and then editted to delete items no longer in stock. I have even tried to just re upload the downloaded file and this is the error I am getting.
I do have someone working on my site (thanks TinaS) but we cant seem to catch each other with the time zone difference so I thought I would see if any one here could give me some advise on what the problem may be and how I can fix it.
This is the error message I am getting
-------------------------------------------------------------------------------------------
Warning: move_uploaded_file(/home/cheekybu/public_html/shop/temp/Full-EP2006Nov25-0909.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/cheekybu/public_html/shop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phphh1KNW' to '/home/cheekybu/public_html/shop/temp/Full-EP2006Nov25-0909.txt' in /home/cheekybu/public_html/shop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: file(/home/cheekybu/public_html/shop/temp/Full-EP2006Nov25-0909.txt) [function.file]: failed to open stream: No such file or directory in /home/cheekybu/public_html/shop/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/cheekybu/public_html/shop/admin/easypopulate.php on line 1301
-
Re: Easy Populate support
Quote:
Originally Posted by
langer
Salemaker support is not available in Easy Populate at this time.
I'm sure this is going to sound stupid (with me being new to Zen-Cart and all), but WHY?
What makes the items uploaded via Easy Populate any different than items manually entered? How hard is it to fix this?
I just spent the past 30 hours or so entering items into my EP spreadsheet and then uploaded them and noticed none of the items I uploaded had any sales on them. I updated my sales and still nothing. I deleted my sales and recreated them and still nothing, now I find this post...
I can do some coding if need be, just point me in the right direction. :)
-
Re: Easy Populate support
Quote:
Originally Posted by
oeginc
I'm sure this is going to sound stupid (with me being new to Zen-Cart and all), but WHY?
What makes the items uploaded via Easy Populate any different than items manually entered? How hard is it to fix this?
I just spent the past 30 hours or so entering items into my EP spreadsheet and then uploaded them and noticed none of the items I uploaded had any sales on them. I updated my sales and still nothing. I deleted my sales and recreated them and still nothing, now I find this post...
I can do some coding if need be, just point me in the right direction. :)
Ok, nevermind... I fixed it.
-
date added
everything is going smoothly/working, except that ALL my products seem to qualify as new products. In my upload, I set the date added to June 1st for all but a few products, which I set to November 25th. Date formats in PHPmyAdmin all look fine. Went to admin > maximum values and set "New product listing - limited to" to 30 (days), but still, all products show up.
THOUGHTS???
-
Re: Easy Populate support
Quote:
Originally Posted by
oeginc
Ok, nevermind... I fixed it.
Could you please share with us the modification you made for it to work? I have spent hours on it as well. Unfortunately, I am not a coding guy. Thanks a lot!
-
Re: Easy Populate support
For admin
Why Easypopulate it is not in download list here???
Thanks to reply
Serge
Easy Populate Advanced for Zen Cart versions 1.2.4 through to current (1.3.6) 50€ putain !!
-
Re: Easy Populate support
Just as soon as I get the time to fix Easy Populate Standard it will be added here.
Easy on the language there Monsieur...
-
Re: Easy Populate support
Hi
I bet this has been covered before. But I cant seem to find an answer.
Here is what my problem is.
Easypopulate was working fine.
I moved to a new server. Now its not.
All I get when I try is it waits a while and then nothing.
Its not my files because I tried one that worked before.
Also, I cannot download anything either. I get the same responce.
Not sure what I should try next.
-
Re: Easy Populate support
Uninstall / reinstall might be your quickest solution.
-
Re: Easy Populate support
Is there a way to Uninstall?
Or should I just overwrite the files?
-
Upload worked - products not found when clicked
Looked through the log didn't see this listed.
zen 1.3.6 easypop 1.2.5.4
Installed and upload inventory and everything seemed to upload and work correctly.
Now - items show up in categories etc. go to click on them, they can't be found.
Also - after install the following line started showing up in header
* Shopping Cart * Checkout * Create Account * Log In
site- http://www.lostpaper.com/toshop
Any clues
-
Re: Easy Populate support - HTML descriptions in Excel come stuffed?
Hey,
With the old easypopulate, when I cut and paste HTML including tables and bulleted lists into the description cell in Excel and upload that to the store it is completely stuffed. Yet if I cut and paste the same HTML into Zen-Cart using the online add product feature it is fine?
Will this be fine in the new version or what else can I do for the time being? I have HTML descriptions to enter but it is too slow to enter individually online but when I do it in excel pasting lists it comes stuffed (usually I take the HTML code from Frontpage and paste in Excel), when I upload it the product description has massive spaces
Also there is product dross which can't get rid of, and there is a MySQL timeout at the bottom whenever I download my easypopulate into excel?
regards,
Dave
-
Re: Easy Populate support
Does EP produce a correct file for upload to Google Base?
I have installed EP1.2.5.4 on ZCv1.3.6
Is the download for EP formatted for Google?
My upload to Google was declined for this reason:
"Using Froogle attributes (fields): We noticed that your bulk upload is using attribute names specified in the old Froogle product feed format. For example, you've included "product_url" as an attribute name, although this attribute is named "link" in the Google Base format. Please convert your product feed to the new Google Base format by changing the attribute names in your header line:"
-
Re: Easy Populate support
Yes, it does, but it is in EasyPopulate Advanced, 3.0.3 and it works very well. In the export files generator, there is now a Google Base option that will generate a complete file that you can upload to google. The only thing you will have to do (at least it was all I had to do) is to open the file, save it as a tab-text (.txt) file.
It may just be me, but I didn't have to make any adjustments to the actual file at all and Google excepted it 100%.
-
Re: Easy Populate support
Quote:
Originally Posted by
wtashby
Yes, it does, but it is in EasyPopulate Advanced, 3.0.3 and it works very well. In the export files generator, there is now a Google Base option that will generate a complete file that you can upload to google. The only thing you will have to do (at least it was all I had to do) is to open the file, save it as a tab-text (.txt) file.
It may just be me, but I didn't have to make any adjustments to the actual file at all and Google excepted it 100%.
Thanks. I had understood that the standard version also worked for Google.
The option to generate the file is in the standard version. But I guess it does not generate a correct file?
-
Re: Easy Populate support
Previous versions (or standard) have the Google/Froogle feed generator. Froogle no longer exists, but to be honest, I never used that feature when I had the older versions of EP, so, I don't have a base for comparison. I just know that Google Base in EP Advanced works. If your version of ZenCart will support it, I would suggest that you upgrade. The new category system takes a little getting used to, but once you figure it out, it's pretty easy, and, very fast and powerful.
Hope this helps, sorry if it doesn't. Just my nickles worth:smartass:
-
Re: Easy Populate support
Well, to be honest with you, I was personally a little upset that "Easy Populate Advanced" was being sold for profit when it was developed with code that was in the GPL.
Therefor, I have started modifying the last released version of EP to work properly with Google Base, as well as some other modifications (I've already fixed the SaleMaker bug).
I've uploaded the SaleMaker fixed version in the Admin Tools, I'm just waiting for the mods to approve it now.
The Google Base version will be along shortly.
-
Re: Easy Populate support
HI all,
Many thankx ! Monsieur Langer for your reply
Have nice day to Américan people
Serge
-
Re: Easy Populate support
what am I doing wrong?
installed SEF. front end looks good SEF works OK in the admin->tools->EZ populate
I get the storefront page.
please help.
-
Re: Easy Populate support
Hey Guys....
I am new to Zen Cart...but very familiar to OScommerce..........
I am trying to figure something out.....and figure that easy populate is what I need....maybe modified a little
My suppliers have given me cd's of all their products and I am just trying to figure out how to import them into my database..........
I have played around with easy populate a bit and i am having no success.........
I have saved as many formats.....and the products just arent showing up anywhere???????
is there an easy way to import these files are does it need to be a manual edit in order for it to work????
I am running the latest Zen and PHP5.......
Any help would be greatly appreciated
Kopy
-
Re: Easy Populate support
Hi all,
Just a quick question before purchasing.
Does EP Advanced import and export attributes effectively?
I have many attributes for each item so it's not just the items that take time, it's all those attributes.
Thanks in advance.
Happyworker
-
Re: Easy Populate support
Quote:
Originally Posted by
Happyworker
Does EP Advanced import and export attributes effectively?
Support for Easy Populate Advanced is not available from this site - sorry.
-
Re: Easy Populate support
Okay thanks langer, I will try elsewhere. It was more just a question of will it help me with the attributes.
Thanks again,
Happyworker
-
Excel Populate
Hi.
Excel Populate is concurrent of Easy Populate. This is advanced version of easy populate. Generated file is in real Excel format. Products, attributes, categories, manufacturers in different Excel sheets. Find it here
http://www.advancewebsoft.com/
-
Re: Easy Populate support
Hi langer and all,
I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.
I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.
So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?
Thanks
milkyway
-
Re: Easy Populate support
There is a smart tags option in Admin -> Configuration -> Easy Populate which converts newlines into html line breaks. This will preserve such rudimentary formatting.
-
Re: Easy Populate support
Zencart is not recommended with PHP5. Go back to PHP4 (last release of 4).
Easypopulate is just that ... easy. Best is to dump one of the sample tab delimited text files (in the TEMP directory) into MS Excel and see the column headings.
Once you've got all your data into the spreadsheet (MAKE SURE YOU DID NOT FORMAT ANYTHING - eg: bullet points, indents, etc), save as a TAB-DELIMITED TXT file (NOT CSV). Exit Excel, declining its offers to preserve Excel formatting.
Depending on the size of the txt file, you can either upload from your hard drive, or ftp the thing into the TEMP (not TMP) folder that easypopulate "owns", then run the insert from the TEMP folder.
You can "FORMAT" using certain html tags. So if in your PRODUCT DESCRIPTIONS you want bullet points for example, proper use of <ul> <li> </li> and </ul> will render them properly.
-
Re: Easy Populate support
Quote:
Originally Posted by
milkyway
Hi langer and all,
I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.
I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.
So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?
Thanks
milkyway
I had a similar issue - with nearly 3000 products. I (partially) resolved it as follows...
As I wanted double line breaks after each sentence in the product description, I decided to use the "friendliness" that exists between MS WORD and MS EXCEL.
I highlighted the entire "Product Description" column in Excel, then Copied to clipboard.
I then Pasted the column into MS Word. I now had a single column "table" of all the product descriptions.
Then I converted TABLE to TEXT, with breaks selected as paragraphs (not tabs).
Doing "Search & Replace" I replaced all instances of ^p (paragraph) with $$$ . (This is just a unique string that I can easily find later to "reconvert" $$$ to ^p .)
Now I have a massive paragraph of sentences, broken at various intervals by $$$.
Then I did a "Search & Replace" for "fullstop + spacebar" (. ) - ie: the end of each sentence - and replaced it with .<br /><br /> (fullstop + tag + tag).
Now I had all my sentences properly tagged with the double <br /> html.
Then i did a search & replace for $$$, turning them back into ^p.
Finally, I highlighted all text and did a TEXT TO TABLE, with PARAGRAPH as the line break.
Before copying and pasting back into Excel, I created another column in Excel NEXT TO the original Product Description column.
I PASTE the altered column into this new column, and alongside is the original text. I can quickly do a random sampling to see if the text in both columns matches up. Check the first, last and several middle records. If they match up, you're pretty safe that your new column is identical to your old column, but now you have the <br /><br /> tags in place.
Delete the old column, remembering to shift its EP header over to the new column first.
------------------------------
I got quite brave with this technique and later used it to create tables within the product description field. Only this time I had a separate spreadsheet with alternating columns of description text and strings of html tags.
Using the CONCATENATE function in Excel, it was possible to merge all these strings of text together, and the results were excellent. I now had description fields with unique little tables and additional data patched in.
Take a look:-
http://www.schoolmarket.co.uk/pages-...and-shaft.html
...and use the NEXT button to see how it is configured for following products.
-
Re: Excel Populate
Quote:
Originally Posted by
Warrior
Hi.
Excel Populate is concurrent of Easy Populate. This is advanced version of easy populate. Generated file is in real Excel format. Products, attributes, categories, manufacturers in different Excel sheets. Find it here
http://www.advancewebsoft.com/
does this work with Zencart or just OSC.......and does it handle images?.....just by file name, then by FTP.......
Kopy
-
Re: Easy Populate support
Hi there,
I'm having a bit of trouble with importing.
I'm trying to update my attributes but everytime I upload it back to the server, and I see that nothing has changed.
My v_products_model column is complete...so I'm curious why it's not working.
I'm not getting any errors either, the changes just aren't showing up.
??
I have used all the methods of importing without any luck.
Any help or suggestions on what I'm doing wrong would be appreciated.
Happyworker
-
Re: Easy Populate support
Ok, i am a little confused. Now Easy Populate Reg. is still free, but the feature packed advance is not, right? Wasn't easy populate reg. in the download section before, why is it not now? I read a pervious post by langer, and i guess there is a problem with the new easy populate reg for 1.3.6, is that why you can't download it?
Thanks
Brad
-
Re: Easy Populate support
Quote:
Originally Posted by
bradlawson
Ok, i am a little confused. Now Easy Populate Reg. is still free, but the feature packed advance is not, right? Wasn't easy populate reg. in the download section before, why is it not now? I read a pervious post by langer, and i guess there is a problem with the new easy populate reg for 1.3.6, is that why you can't download it?
Thanks
Brad
That's correct, and I have fixed a few of the problems in the "free" version of Easy Populate and uploaded it to here, but ZenCart appears to be taking their sweet time approving downloads, as of this moment it's been 7 days and still no word.
Maybe I'll just have to setup a download section on one of my websites somewhere.
-
Re: Easy Populate support
Quote:
Originally Posted by
schoolboy
Quote:
Originally Posted by milkyway
I'd highly recommend the greek restaurant Nestos Estiatorio in New City
The Viet Nam Restaurant, 304 North Main Street, Spring Valley, NY 10977
Turkois Grill, on Saddle River Road in Airmont
Greek Village, Rt 303/ Livingston St. in Northvale NJ
Originally Posted by milkyway
Hi langer and all,
I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.
I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.
So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?
Thanks
milkyway
I had a similar issue - with nearly 3000 products. I (partially) resolved it as follows...
As I wanted double line breaks after each sentence in the product description, I decided to use the "friendliness" that exists between MS WORD and MS EXCEL.
I highlighted the entire "Product Description" column in Excel, then Copied to clipboard.
I then Pasted the column into MS Word. I now had a single column "table" of all the product descriptions.
Then I converted TABLE to TEXT, with breaks selected as paragraphs (not tabs).
Doing "Search & Replace" I replaced all instances of ^p (paragraph) with $$$ . (This is just a unique string that I can easily find later to "reconvert" $$$ to ^p .)
Now I have a massive paragraph of sentences, broken at various intervals by $$$.
Then I did a "Search & Replace" for "fullstop + spacebar" (. ) - ie: the end of each sentence - and replaced it with .<br /><br /> (fullstop + tag + tag).
Now I had all my sentences properly tagged with the double <br /> html.
Then i did a search & replace for $$$, turning them back into ^p.
Finally, I highlighted all text and did a TEXT TO TABLE, with PARAGRAPH as the line break.
Before copying and pasting back into Excel, I created another column in Excel NEXT TO the original Product Description column.
I PASTE the altered column into this new column, and alongside is the original text. I can quickly do a random sampling to see if the text in both columns matches up. Check the first, last and several middle records. If they match up, you're pretty safe that your new column is identical to your old column, but now you have the <br /><br /> tags in place.
Delete the old column, remembering to shift its EP header over to the new column first.
You can achieve the same results with the following Excel VBA procedure. It replaces all paragraph and line breaks in the column headed by v_products_description_1.
Code:
Sub InsertBR()
Application.ScreenUpdating = False
Cells.Find(What:="v_products_description_1", After:=ActiveCell, LookIn:= _
xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Range(Selection, Selection.End(xlDown)).Select
For Each cl In Selection.SpecialCells(xlCellTypeConstants, 23)
cl.Replace What:=Chr(13), Replacement:="<br /><br />", SearchOrder:=xlByColumns
cl.Replace What:=Chr(10), Replacement:="<br /><br />", SearchOrder:=xlByColumns
Next cl
ActiveCell.Select
Application.ScreenUpdating = True
End Sub
Usage note: To work correctly, all records must have a description. Otherwise, the code will stop at the first blank description.
Steve
-
Re: Easy Populate support
Just post the new verison some where and put the link on the fourm.
Thanks
Brad
-
Failed to open dir
I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.
When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:
Import Data from file in temp/
Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695
Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697
What does this mean, and what can I do to fix it?
-
Re: Easy Populate support
jvoce, what version are you using?
-
Re: Easy Populate support
Quote:
Originally Posted by
jvoce
I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.
When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:
Import Data from file in temp/
Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695
Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697
What does this mean, and what can I do to fix it?
It sounds like you don't have a directory called 'temp' in your cart directory... That's where easy populate stores files that it creates on the server. The default installation comes with some sample EP files in that directory (Attributes-EP*.txt, Category-EP*.txt, Froogle-EP*.txt, Full-EP*.txt, PriceQty-EP*.txt and there is a blank index.html file as well).
-
Re: Easy Populate support
Zen-Cart Verison: 1.3.6
Easy Populate: ep_v2_75_zen-cart_1_2.zip
I just noticed that you're website says it has problems with it. I'll try the other version.
Hopefully that should work?
-
Re: Easy Populate support
I've downloaded your version, and so far it looks like it's working. We have to try and tweek the excel file that comes out from one of our own computer programs to place the items properly in the file.
We are looking forward to the day that more flexability is given for attributes matching unique model numbers.
Thank you, and Merry Christmas.
-
Re: Easy Populate support
Quote:
Originally Posted by
oeginc
That's correct, and I have fixed a few of the problems in the "free" version of Easy Populate and uploaded it to here, but ZenCart appears to be taking their sweet time approving downloads, as of this moment it's been 7 days and still no word.
Maybe I'll just have to setup a download section on one of my websites somewhere.
Hey if youd like me to help out with hosting the new file I would be more than glad to...let me know.
-
Re: Easy Populate support
Quote:
Originally Posted by
ericpeng
I am usign Canada Post Shipping Module.
Anyone know how to add dimensions(L x W x H) & weight to Easy Populate ??
Thanks
Did anyone solve this issue. I am trying to achieve the same thing. ie download lx w x h that have been input into the canada post mod fields
-
ISBNs in Excel
Hi All!
I'm trying to master ep in Excel for easy uploading and downloading of all our products. It's working great for uploading, love it. I don't quite have downloading completely understood.
Whenever I download the list and open it in Excel the first zero in any ISBN goes missing. I know this is an Excel thing, but I'm wondering if there's anyway I can set the download not to do this, instead of just placing another character in front of each number.
If anyone has ideas please pass them on. Thanks.
-
Re: Easy Populate support
I'm no Excel pro, but once you have the data in the spreadsheet (or a blank sheet with all the necessary fields) set the field to text as opposed to numeric. Once set clear everything but the header row & use this as template for importing your data.
Dennis
-
Re: Easy Populate support
i am trying to use EP, bt i am trying to figure out how to do the proper dump.........seems like when i do my dump, everything is CSV, and I am wondering if it is possible to have each value in their own column...........i have tried every possible dump and just cant seem to figure it out.......I am looking to add about 10,000 products to my store, and to enter each in a CSV format is just too long of a process.....
Can anyone assist me with this process...
Any advice would be greatly appreciated
Kopy
-
Re: Easy Populate support
When you download the dump it should be a text file. If you import it into Excel & define tab as the separator (I define all fields as text so leading 0's and dates aren't messed with by Excel) everything should be in it's own column. What are you trying to open it with?
Personally I prefer Microsoft Access. I can massage my data better.
Dennis
-
Sort Option - Easy Populate
Is it possible to enter in a sort number field?
-
Parent Category Display
I've checked and checked, but somehow on my latest import, I've got some inconsistent results with regards to subcategorization:
In two main categories, there are only subcategory folders, NO products at the top level, as the zen cart designers intended (or so I am led to believe).
In 4 other main categories, the subcategories are visible on the catalog admin page, BUT all the subcategorized products HAVE ALSO been linked to their parent categories (so that clicking into the parent category will display all products from all subcategories). I actually like the second behaviour, but
a) I've read that I'll be in danger of a flaky store if I try to have parent categories contain BOTH products and subcategories;
b) I can't get the stubborn main categories to behave the same way, even using the multiple categories link manager.
Anyone have any advice on how to get all parent categories to behave the same way, without manually re-linking each product one at a time????
-
Re: Easy Populate support
I'm trying to add a field for sort order, yet I'm not having much luck. Could someone point me in the right direction please?
-
Re: Easy Populate support
Here's a quick question. It appears that Froogle is having issues with item descriptions that have quotations in them.
I notice that in the easypopulate.php file, there is a way to enable smart tags. Is there a way to have it strip out all quotation marks in the description text only?
For example, the following product description will not be allowed in Froogle:
"This products was voted "Best Item" of the year."
I would want the EasyPopulate script to simply strip out (or use a certain escape sequence when putting quotations in the description.
Can anyone help me on this one?
-
Re: Easy Populate support
Hello everyone,
Maybe someone can help me with this. I know that EP can be modified to add more fields into it. I want to add the "products_priced_by_attribute" field to the feed as there are some things that require this. There were some commented fields but none are this one. I thought it'd be a good idea to ask how to add it instead of messing up my EP.
Thanks and Happy Holidays to All
Pete
-
Re: Easy Populate support
Langer,
Is there any possibility that you can, or will add a function in EP that will allow the use of XML files for uploading products? Many suppliers are begining to add XML as an option.
Thanks
-
Re: Easy Populate support
HI to everyone,
i stumbled accross EP for the first time today to help me batch create multiple items.
The install has gone with no problems however after downloading the Download Complete tab-delimited .txt file to edit section
I edit my changes in excel and save it back as a tab deliminated text file.
after importing the file i get the following results:
File uploaded.
Temporary filename: /tmp/phpxvhmCG
User filename: complete-test.txt
Size: 1671
UPDATED! - Model: Home Range | | Spindle Si | CH1 - Spin | | | | | 41 | 0 | 01/01/2007 | 22/12/2006 | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Fiddle Sid | CH2 - Fidd | | | | | 41 | 0 | 01/01/2007 | 22/12/2006 | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Slat Side | CH3 - Slat | | | | | 41 | 0 | 01/01/2007 | 27/12/2006 | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Spindle Ca | CH5 - Spin | | | | | 53 | 0 | 01/01/2007 | 27/12/2006 | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Fiddle Car | CH6 - Fidd | | | | | 53 | 0 | 01/01/2007 | 27/12/2006 | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Slat Carve | CH7 - Slat | | | | | 53 | 0 | 01/01/2007 | | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Bordeaux R | CH9 - Bord | | | | | 41 | 0 | 01/01/2007 | | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Bretton Ru | CH10 - Bre | | | | | 48 | 0 | 01/01/2007 | | 999 | | Chairs | | | | | | | Taxable Go | 1 |
UPDATED! - Model: Home Range | | Amish Rush | CH11 - Ami | | | | | 49 | 0 | 01/01/2007 | | 999 | | Chairs | | | | | | | Taxable Go | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Upload Complete
q1. Why does it report skipped! - model - no catagory for this product? Would this be the next line in excel that is empty?
q2. Although EP reports the above products are UPDATED! no products are enterd in to my product list within zen cart.
I notice if i give each product an individual v_products_model name EP updates and adds each of the above. howveer i do not want this, all of the products need to be named "Home Range"
When all product model names are the same EP does not change anything within ZC and no new products are added.
If there is any other information i can provide please ask.
Thanks for what appears to be a great add-on.
Zencart version 1.3.6
EP version 1.2.5.4
-
Re: Easy Populate support
Tricky Ireland:
q1:That is for the last row that's blank
q2: Is the model name Home Range? They have to have different model numbers (i.e. Home Range1, Home Range2, etc) otherwise EP will think they're all the same thing. I don't know if there can be spaces in the model number.
Pete
-
Re: Easy Populate support
Quote:
Originally Posted by
kebeid
Tricky Ireland:
q1:That is for the last row that's blank
q2: Is the model name Home Range? They have to have different model numbers (i.e. Home Range1, Home Range2, etc) otherwise EP will think they're all the same thing. I don't know if there can be spaces in the model number.
Pete
Thanks for the quick reply pete,
do you know of any way to leave this column blank?
when creating a new product manually it is not a requirement to enter the model number!
When leaving the column blank in EP the product does not get added and EP complains of the blank column.
Thanks again
-
Re: Easy Populate support
I would say that the EP file has to be modified in a way that it doesn't have to take the model number. That's the only way I can think of unless you wanna use a way other than EP to upload your products. I've always known that you must have a model number for EP to work - thats sorta what the program bases everything in the feed on.
Pete
-
Re: Easy Populate support
Quote:
Originally Posted by
kebeid
I would say that the EP file has to be modified in a way that it doesn't have to take the model number. That's the only way I can think of unless you wanna use a way other than EP to upload your products. I've always known that you must have a model number for EP to work - thats sorta what the program bases everything in the feed on.
Pete
Thanks again Pete, not a big deal, the model number will be useful when searching the catalogue so all is well that ends well! :yes:
Again thanks for a good product, i will keep my ear to the ground on further developments!
-
Re: Easy Populate support
Quote:
Originally Posted by
wtashby
Langer,
Is there any possibility that you can, or will add a function in EP that will allow the use of XML files for uploading products? Many suppliers are begining to add XML as an option.
Thanks
Always willing to move with the times - except for my fashion sense it seems..
-
Re: Easy Populate support
Langer,
I know that EP can be modified to add more fields into it. I want to add the "products_priced_by_attribute" field to the feed as there are some things that require this. There were some commented fields but none are this one. I thought it'd be a good idea to ask how to add it instead of messing up my EP.
Pete
-
Re: Easy Populate support
For anyone who was interested in adding the product sort order through EP here's how I finally did it.
Adding Product Sort Order:
1) Open Admin/easypopulate.php
2) Insert following:
Line 389: 'v_products_sort_order'=> $iii++,
Line 457: p.products_sort_order as v_products_sort_order,
Line 601: p.products_sort_order as v_products_sort_order,
Line 1290: 'v_products_sort_order',
Line 1439: p.products_sort_order as v_products_sort_order,
Line 1848: sort_order,
Line 1917: products_sort_order,
Line 1931: '".zen_db_input($v_products_sort_order)."',
Line 1965: '", products_sort_order="'.zen_db_input($v_products_sort_order) .
I hope this helps! :D
-
Easy Populate configure missing
I'm running Zencart 1.3.6, and have just installed EP 2.75a-Zen-Cart v1.2. EP shows up in Tools (ZC Admin), but not in Configuration. I've checked twice that all of the EP files are in the right places. Suggestions?
mark
-
Re: Easy Populate support
I have installed the latest version of easy populate and the install went fine. I uploaded my file that has 36,000 items in it and split it, that also went fine. When I try to install the split files into the database it just goes to a blank screen and does nothing.
-
Re: Easy Populate support
jvoce, would that work for "products_priced_by_attribute" as well?
Pete
-
Re: Easy Populate support
Quote:
Originally Posted by
kebeid
jvoce, would that work for "products_priced_by_attribute" as well?
Pete
I would assume it might, but I haven't tried that yet, as I haven't had need to.
I'll give it a try and see if I can get it to work. In the mean time it won't hurt to try the same thing yourself. Let me know if you have success before I do.
-
Re: Easy Populate support
I tried it, it went through and nothing happened. There was the one line I didn't do
Quote:
Line 1848: sort_order,
. It didn't show errors, though.
-
Re: Easy Populate support
Is anyone having the problem of the files not being loaded into the database and it just going to a black screen. I have installed and reinstalled the files several times. It worked for about 50 file uploads and then it just quit working. Any clues?
-
Re: Easy Populate support
kebeid - I haven't had time to check this out yet. I should have a chance to try tomorrow.
I suspect that price by attributes will require a more complicated solution than I can provide. I'm a new zenner myself.
I promise to try though.
-
Re: Easy Populate support
Ok I spent the money on the Advanced version on this script and it does not work either. I am getting items that have categories in the cart but the script is putting it in the main directory. It will not import the categories file. and just all around does not work. Can anyone explain how to import the categories and have the script create new categories. In other words in the cart in Blank and I have a file containing the all the categories, and subcategories how do you get it to work. The Free version would create the folder if it did not exist.
-
Re: Easy Populate support bump
From January 2, with no response yet.
I'm running Zencart 1.3.6, and have just installed EP 2.75a-Zen-Cart v1.2. EP shows up in Tools (ZC Admin), but not in Configuration. I've checked twice that all of the EP files are in the right places. Suggestions?
mark
More info: the only other mod I'm using is Image Handler 2. I've tried various settings from tools, both Download and Save to Temp. I get a quick flurry of activity in Firefox, and no results.
mark
-
Re: Easy Populate support bump
Have you installed the sql file through the install sql patches in admin-tools?
Pete
-
Re: Easy Populate support
No. I hadn't thought of using the SQL patch tool- it isn't mentioned in the installation instructions.
mark
-
Re: Easy Populate support
Hello,
I'm a new user and I'm having some problems with installing Easy Populate.
I read the Wiki and tried to do the install from what they're saying. but I have to say, I'm having some trouble understanding what the steps are to install Easy Populate.
If someone could exaplain or even link me where it's gone over a little more in detail with the steps.
Thanks a lot.
-
Re: Easy Populate support
gaukler, did that work out for you?
SwordGoddess, there's nothing to it just unzip the files and upload them to their respective directories - there are no overrides or replacements of files. Then in admin install the sql file in the sql patches under tools menu.
Pete
-
Re: Easy Populate support
I spent the money on a file that is basically useless. What is the deal with it importing item in the main directory. I have to go in now and delete 14 pages of items.
I hate to be an *** but when you buy something you expect it to work. I can understand the free version having bugs. It keeps telling that the categories don't exist and I know they do because I entered them manually.
-
Re: Easy Populate support
I have had great success with EP, but would very much like to be able to add tables to it, such as the wholesale table for the dual price mod, Does anyone know how this can be done, it surly cant be to hard (unless your me and dont know anything :P). At this stage i have been trying to manually update the table, but it stuffed the database lol
-
Only one product shows up
Hi all,
I have installed EP_v1.2.5.4. Everything went smooth as silk. From tool>easy populate I have uploaded tab-delimited files from the /temp file and files from my computer and on that page it says that the update has been successful and shows a long list of all the products that were in the file. However when I look at the catelog only the first product from the file has been added. Added very nicely I must say, with all of the categories/ sub-categories in the right order, but only one product. If the answer to this question lies somewhere earlier in this thread please point me in the right direction, or if anyone knows a fix please let me know.
Thank you,
Sean
-
Re: Only one product shows up
Do you have EOREOR at the end of every product row you're adding?
-
Re: Only one product shows up
Quote:
Originally Posted by
kebeid
Do you have EOREOR at the end of every product row you're adding?
Yes, that did the trick. There seems to have been a bad side effect of loading EP. My cart is being dumped during the checkout proccess. It happens in a number of spots. If you delete a product on the shopping cart page, it acts as though you deleted all of the product and returns the "shopping cart is empty" page. It also sometimes happens between steps 1 & 2, and sometimes between steps 3 & 4. Sometimes it goes all the way through checkout. It seems as though it is more likely to succeed through the checkout if there is more than one product in the cart. Has anyone seen this before or know what is happening??? HELP!!!
Thank you,
sean
-
Re: Easy Populate support
Update: I have backed EP (easy populate) out and the problem remains. I really dont even know what it is that I am going to be looking for.
Thanks,
Sean
-
Re: Easy Populate support
kebeid, which file needs to be added using the SQL patch tool?
mark
-
Re: Easy Populate support
Quote:
Originally Posted by
gaukler
kebeid, which file needs to be added using the SQL patch tool?
mark
Hi,
I am not kebeid, but the file you want came in the zip file you originally downloaded. It is called: install_sql
Sean
-
Re: Easy Populate support
Quote:
Originally Posted by
xstremedesign
I spent the money on a file that is basically useless. What is the deal with it importing item in the main directory. I have to go in now and delete 14 pages of items.
I hate to be an *** but when you buy something you expect it to work. I can understand the free version having bugs. It keeps telling that the categories don't exist and I know they do because I entered them manually.
xstremedesign, I have responded to your concerns both by email & a pm here in order to address them, and have not received a response from you yet.
I cannot understand why you insist on seeking support here for Easy Populate Advanced, as it simply is not given here, nor why you are spamming my forum given that I have responded to your emails and have as yet had no reply.
If you are hell bent on getting a refund and not resolution of any issues, then so be it - why keep slagging off about something that you are not interested in resolving? Please, save the slander for those who deserve it. I have earnt my credentials here, have you?
-
Re: Easy Populate support
Hello folk,
I have a couple of no doubt simple questions about EP, my soon to be favourite tool.
All my products have been put in manually, since I needed to get used to Zen Cart anyway. Now I've done a full download as a backup as well as a Froogle download, just to see what's in it.
Q1/ Froogle - the fields called upc, shipping, and manufacturer_id are empty. Will that be a problem for Froogle? I can add the upc code myself but I don't know what goes in the other fields.
Q2/ Froogle - the currency field says "usd" for all the records. Reasonable, unless you know my currency is CAD. Why would it be usd in the Froogle output?
TIA
Rob
-
Re: Easy Populate support
Things are working better now that I'm using the correct version of EP. As I said in my first post, I had tried to install EP 2.75a-Zen-Cart v1.2. I hadn't seen the fine print, which said that this was the buggy old version, and that the one with the lower version number was the newer one.
mark
-
Re: Easy Populate support
Hello,
I was able to finnally install EP and get everything working on it. That is, of course, thanks to the board for the simple help of even the install! Thanks again.
Now, my next problem
I was able to figure out the speadsheet for putting in all the information. But when I do upload the file it only uploads the last product and skips the rest.
I can provide the test group of items (the csv file) that I'm working with.
-
Re: Easy Populate support
Quote:
Originally Posted by
SwordGoddess
Hello,
I was able to finnally install EP and get everything working on it. That is, of course, thanks to the board for the simple help of even the install! Thanks again.
Now, my next problem
I was able to figure out the speadsheet for putting in all the information. But when I do upload the file it only uploads the last product and skips the rest.
I can provide the test group of items (the csv file) that I'm working with.
Hi SwordGoddess,
You have to have EOREOR at the end of each row. This makes it go on to the next product. You can just put a column at the end and in each cell put EOREOR.
Sean
-
Re: Easy Populate support
v0903856,
First, thanks for the response. I did start by putting the EOREOR on the end of each string of information. It will say
"UPDATED! - Model: Books | book1.jpg | Eternal Wi | Amma a | | | | | 13 | 0 | | 01/17/07 1 | 5 | Amma | Amma | Books | Taxable Go |
"
But it won't say new product. Have I not done some settings correctly?
-
Re: Easy Populate support
SwordGoddess, the model is the index and therefor must be unique in your store.
If you have a product with model "Books" already in your store, you will simply update it for each instance where this is the model in your import file.
-
Re: Easy Populate support
I was able to figure out what my problem was. I had filled out the model information incorrectly.
Thanks again.
-
Re: Easy Populate support
I am new to this. I installed EP and had no problem and getting no errors. However when I try to Upload EP File for Import - I get just a page reload, no categories or products get uploaded. When I Import Data from file in temp/ - same thing, just a page reload, no categories or products get uploaded.
Can anyone help with this????????
Ray
-
Re: Easy Populate support
hiya .. i wonder if anyone can help me out. i have just installed 1.3.7 and easy populate, on a new store. I have uploaded my .txt file and its got all the image file names in .. i have uploaded the images to the appropriate folders but non are showing on the site. I have already done one site using this method, but i've slept since then and cant think what i might of done different lolol
This is the site where its not working properly yet. www.goodigumdrops-candy-shop.co.uk
if anyone can think of what i am doing wrong .. please can you let me know
thank you
Erica xx