http://i285.photobucket.com/albums/l...ee/zencart.jpg
This is what it looks like by the way, in zen admin
I just don't know what to do now.
Printable View
http://i285.photobucket.com/albums/l...ee/zencart.jpg
This is what it looks like by the way, in zen admin
I just don't know what to do now.
Hi somewhere in this huge thread, someone mentioned a problem with uploaded products not producing a product page. I can't find that particular post but is here.
What happens when I use easy populate to upload new products, the upload works to a point where you can view the new products in the product listing, but when you click the product to open the product page, I get "page not found".
Does anyone have any idea what will cause this??
Help would be appreciated..
I also still have this problem regarding the attributes .txt file as mentioned in post above & below!
P.S using zen version 1.3.8aQuote:
I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA
I have the purchased version of Easy Populate. I want to know is it possible to define the category meta tages with EP. These are the fields i used for products:
v_metatags_title_en, v_metatags_keywords_en, v_metatags_description_en
Will it work for categories?
It seems there is no real answer, at least not one I could find here.
Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.
My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.
Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.
I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv
Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.
This has worked fine for me, it worked fine with oscommerce too. Two rules.
1) BACK UP FIRST
2) Never forget rule 1.
I added just 6 products with EP to start with to a sub category and they all uploaded fine to the correct place and all display ok, providing everything is added to the correct columns I wouldn't expect to have a problem (?) adding a lot at one time.
One thing I should of mentioned in my previous post about attributes.
When you download the DB table and open it with Excel or Calc the format is a little different to what you get from the EP attribute download.
In column A is attributes ID, this (it seems) has to be a different number for every line and the number has no bearing on the product ID in column B. In column B you have your product ID number and that column can have repeats of the ID number due to the same product have several attributes, so the same product with several attributes would look a little like this in column A & B
A##############################____B
products_attributes_id products_id
1##############################____1
2##############################____1
3##############################____1
4##############################____1
So product #1 has four separate attributes.
If your store is live it would be prudent to set up a test category with a handful of products and add attributes to these before trying it on live products. BACK UP the table first so if anything goes wrong you can restore the back up and put everything back to how it was.
Use Open Office, instead of excel.. works fine.Quote:
I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
http://www.openoffice.org/
I do use Calc from Open Office. The file seemed to edit ok but the attributes never got added when I restored the file. Perhaps I did something wrong but it seems a lot of people have trouble getting the attributes side of EP to actually work.
Thanks impact for that, I only uploaded 3 new products to test and this is where i came across the glitch. Haven't tried since, no point till I get a fix for it.
Thanks misty - visited site, says that it doesn't support all platforms as yet. do you know if windows Vista is one of those non supported platforms? Doesn't mention the platforms not supported.Quote:
TIA
Thank you so much for the tip to use OpenOffice! It was so great to finally see actual columns of data!!!
HOWEVER, my column headings don't match up with the data after the first few. I have been deleting thru the admin panel unnecessary Option Names with their corresponding Values to try to reduce the downloaded file size. So I tried manually realigning the file headings with their data but say there should be "16" attribute values for one name, the headings only seem to have three of them. Totally messed up.
Has anyone ever seen columns being out of synch like that? I noticed it in Excel too with what little I could see of the columns.
zencart 1.3.7
http://wiki.services.openoffice.org/wiki/WindowsVistaQuote:
Thanks misty - visited site, says that it doesn't support all platforms as yet. do you know if windows Vista is one of those non supported platforms? Doesn't mention the platforms not supported.
Did you download test file which contained several of your existing productsQuote:
Thank you so much for the tip to use OpenOffice! It was so great to finally see actual columns of data!!!
HOWEVER, my column headings don't match up with the data after the first few.
so you could obtain template, with correct Esy Populate headers, to work with?
Here's the scenario:Quote:
Did you download test file which contained several of your existing products so you could obtain template, with correct Esy Populate headers, to work with?
I use ezpop to create the attributes txt file
I use OfficeOrg to open the txt file
I search the txt file for "options_id" to see if the attached id # in the header is the same as the option # for the data included in that column. They don't match.
I look at the Option Names in the Admin Panel and notice that certain Option Names have been deleted (by me). Well, those same Option Name Id #'s are the ones that are missing from the data in the downloaded attribute text file - as you would expect. HOWEVER, the column headers STILL INCLUDE THE DELETED OPTION NAMES AND VALUES!!!
I restored my zencart to a recent backup to realign the options but it wasn't enough. I can try restoring to a system backup that was done a few days earlier.
Is it "forbidden" to delete option names??? (no products associated but yes, there are some values.) Maybe I should have deleted the values first and then the Option Name to clear out the db better?
I price by attribute quite a bit so this is so frustrating!!! Any help would be enormously appreciated.
thanks,
zencart 1.3.7
Madelina said - You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.
Wow, I was hoping this would fix my attributes file with mismatched headers and data for deleted Option Names but to no avail.
I couldn't get it to work either and after seeing the statement that you have quoted above,
I gave up trying and used the database method, that did work :smile:Quote:
EPA is supposed to support attributes, although I cannot personally verify this. Check langer's site. Attributes do not work in EP 1.2.5.4.
If you are having problems with products not showing then I would check to see that the category relations are correct, you can't add a product to a category that has sub categories, you have to add the product at the 'end of the line' so to speak.
Just installed this mod.I am getting the following errors when attempting to upload the EP (.txt) file and I get them both from browsing from my own computer as well as loading them from the temp file on the server. My temp folder chmod is set to 777. I am on an apache server.
Warning: file(/home/bidesign/public_html/youngslugs/webstore/temp/Full-EP2008May03-0707.txt) [function.file]: failed to open stream: No such file or directory in /home/bidesign/public_html/youngslugs/webstore/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/bidesign/public_html/youngslugs/webstore/admin/easypopulate.php on line 1301
Line 1201 starts with -$readed=
// get the entire file into an array
$readed = file(DIR_FS_CATALOG . $tempdir . $file['name']);
}
Line 1301 starts with - foreach
// now we string the entire thing together in case there were carriage returns in the data
$newreaded = "";
foreach ($readed as $read){
$newreaded .= $read;
}
I downloaded the included template file from this mod and used its format. Any help would be greatly appreciated.
Thanks,
Luck38
Is the temp folder in your webstore directory? I would check to see that all the folders and files are in the correct place, the error seems to suggest that it's calling for a file/folder that can't be found.
I am new to Zencart and i am coming from OSC. Not to sure if this is the right place to post this.
I am using cherry template and easy populate. I have 4 product descriptions.
Ex. v_products_description_1,v_products_description_2.
Fields are uploading; easypopulate is working great.
I can't seem to figure out how to display product descriptions 2 through 4.
I don't know which php file to go into to define v_products_description_2,3,4 and then how to display them.
I want them in the same box as description 1. Each product description underneath each other.
Hope this helps little more.
Where is the link to download this? i try to go to it and it says I dont have priveledges
Free Version of Easy Populate 1.2.5.4 at
http://modhole.com/modhole/index.php...11034d58f7ea8d
I am working on a test site and I can't upload my products right.
I exported from another shop then uploaded in my test shop. Categories get created, both levels.
Easy Populate 1.2.5.4 page at the bottom shows all products that have been uploaded, no errors but if I check in my store, only the categories are there but no products.
Now I go in admin- catalog- categories/products
I look at the new created category and see 17 of 17 active on the right, I click to go into the category and there is nothing there ether.
fix_cache_key and reset master id, cleared imagehandler cache.... what else?
I uploaded the same file one more time and Easy Populate shows:
Upload Results
File uploaded.
Temporary filename: /tmp/phpYI6geD
User filename: Full-EP2008May08-1111.txt
Size: 33656
UPDATED! - Model: WXPT0055 | FIGS-AND-M | Figs and M | This Figs | | | | | 19 | 2 | | 03/11/08 1 | 1 | | Wax Potter | Wax Potter | | | | | | Taxable Go | 1 |
and so on for all products. It shows UPDATED, meaning there were products to be updated? Where are they? Any idea?
Hi All
My webhost "Upgraded" cPanel (Linux/Apache etc server) and reset everything to default. It's taken us days to work through settings and get everything running again. [And, yes, we're moving hosts. He has been no help at all with this]
The first symptom was that our shopping carts couldn't access the mySQL database: we came in one morning to find all sites down and SQL errors everywhere. Our stores did not have permission to run scripts: there were no permissions set. After that we ran into more permissions probs, more sql errors, file size upload limits, email errors, and more.
Now everything is OK, but EZ Pop can not upload. We also have 1 X-Cart and 1 custom X-Cart-based custom site. None of our sites can take an upload.
There is some permission prob I guess. Sorry if this is the wrong forum, but I wondered if anyone would know what cPanel setting is restricting our access. Everything worked fine before.Quote:
This an EZ Pop err:
Warning: file(/home/xxx/public_html/temp/xxxx.txt) [function.file]: failed to open stream: No such file or directory in /home/xxx/public_html/admin/easypopulate.php on line 1201
X-Cart gives this error:
MyStore error on upload: The path you have specified is wrong or you have not access to write to the specified path.
TIA
--Pat
I am still having troubles uploading my products. I tried and installed all the ep files one more time and sql as well... just to be sure.
Now I have:
Warning: explode() [function.explode]: Empty delimiter in /home/mydanilo/public_html/artwax/ws/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
when I upload the file. Still looks like all info has updated, uploaded if I look at the llisting in admin. Categories were imported but no products. Can't get them to upload.
Thanks awhfy, but the dir permissions have not changed. All are the same as before so there's something else going on. Even when I FTP the file to the server and then run EZ Pop it doesn't work.
I was able to successfully import a small file with 88 products, but I usually import 10,000-40,000 at a time. And I can't very well do 400 imports of 100 each, so a solution to this problem is crucial.
Is there some cPanel setting that could restrict the number of records being updated or something? An itty bitty file works, but no luck with the file sizes that I normally do.
Thanks
--Pat
Hi,
I never build a site before this. Not like this, I used yahoo website builder.
Im working on getting EP installed, keep getting error message as follows
"Fatal error: main() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php') in /homepages/40/d244245786/htdocs/Jobberonline/adminep/easypopulate.php on line 105"
I have moved the admin and temp file to every place on the totem pole, and made the temp folder permissions 777. Still same error. Deleter all files and began fresh, no good.
And help would be appreciated.
Thx in advance.
John
I still don't succeed with importing products. I tried the same import on one of my other stores and the file imports just fine. So something is wrong on my current site. I suspect my db has a problem. How would I remove ep from the db? I want to try to uninstall and then reinstall the mod. Any help?
I have a strange thing, under Configuration - Easy Populate
actually I have 2x Easy Populate listed. Not right... just checked again, 3x.
How do I get rid of this thing and start from scratch? I want to have this mod working as I plan to import way more stuff down the road.
Great mod!
I am having one problem with it. When I make my database to upload everything is correct. But some were after uploading the file the data gets changed. All Zeros get changed to Ones.
As we are a liquor store, we have liters at 1.0 and 1800 Tequila gets changed to 1.1 liters and 1811 Tequila. Even the prices change.
I have checked everything and have even re-uploaded with a new datafile.
If you have any ideas it would be much appreciated.
New Post: Attribute File has Mismatched Headers and Data
It was because EPA version 3.03 promised:
"Bugfix: attributes export file header names corrected - caused broken attributes upload."
that I paid for the Advanced version of EP. However, it does not seem to have helped (see below.) The attribute headers are still wrong. the headers are picking up option names/values that have been deleted from the db while the actual data is ok, i think.
I AM DEAD IN THE WATER WITHOUT THIS. my site depends on pricing by attributes so I really, really, really need help!
I copied one piece of the txt file and transposed it to show the mismatch:
v_attribute_options_id_20 21
v_attribute_options_name_20_en Select Print Size:
v_attribute_values_id_20_1 66
v_attribute_values_price_20_1
v_attribute_values_name_20_1_en 4" x 6"
v_attribute_values_id_20_2 67
v_attribute_values_price_20_2
v_attribute_values_name_20_2_en 5" x 7"
v_attribute_values_id_20_3 68
v_attribute_values_price_20_3
v_attribute_values_name_20_3_en 8" x 10"
See how the option id =20 but the value of the id is =21? I deleted option id#20 in the db but the data is correct for id#21.
Please help! I have posted this to the zencart builder forum, i have sent a ticket [YZN-54237-446] to Nicholas with no reply and I have searched all messages and k-bases to no avail. TO whomever can help, THank you, thank you, thank you!
Hi
using EP 1.2.5.4. for first time. I have downloaded the COMPLETE txt file of the using EP so that I can see the structure in order to upload a some products. each product has a sample of music.
Is there a way of extending the file structure to upload the sample (in the same way I make reference to the image, I want to make reference to the mp3 file)
Thanks
John
Hi, I have edited and created a tab delimited text file with a spread sheet.
I pulled the original file via easy update, I get a succesful update, but still the products do not show. is there something I am doing stupid with a path name or file name? is there a default file name that I should be uploading?
my temp directory is in my store directory...laughinghorsephotos.com/catalog/temp where catalog is the zen cart directory. I have read the readme and the install text files and I am at a loss.
here is the process as I did it in sequence:
1. pulled down the file
2. Opened the file with MSWOrks spreadsheet.
3. edited the file to ripple/fill data.
4. saved the file in tab delimited text file form (at least that is what Works
claims it's doing)
5. Uploaded the file via zencart/tools/easypopulate
6. upload shows as successful, products do not show. only 30 products that were entered manually show.
got a feeling I have missed something really simple here.
any ideas?
:yes:Quote:
got a feeling I have missed something really simple here.
any ideas?
Use Open Office(free program), NOT Works or Excel
I just installed Easy Populate v1.2.5.4 today, and it looks like I got that right.
No file permissions set yet, so if there are some I have to look out for, please let me know.
I was able to get a copy of my merchandise data onto my local drive and view it with Open Office.
But when I attempted to make a small test of 3 items to upload, no luck . I keep getting the error:
Warning: explode(): Empty delimiter. in
Where did I go wrong here?
Also seeing: No model field in record. This line was not imported
But I don't use the model field in my products.
I have Easy Populate 1.2.5.5 configured, installed and working in my cart. I would like to add a category (products_condition) to my uploads so it will update my database and display on the individual product pages. I have the field added to my database and I have zen cart configured for the extra field. What would I need to add or change in the admin/easypopulate.php file to get the new category to be recognized and to upload to the database? Also, are there other easy populate files that I need to change to make this work?
I would appreciate any help or direction someone may be able to give.
Thanks,
Brad.
I'm a wiz at forcing Excel to behave, so if the tips below don't work feel free to IM me if you're stuck.
It's probably the way you are importing. During the Data import choose "Delimited" instead of fixed-width and on the next tab select "Tab" as your delimiter and de-select all others. If you have tab AND comma or something like that it will be too many cols, but just tabs should come in fine.
if you're trying to get a difficult file to convert in Excel, sometimes this works:
1) open the file in winword (or ultraedit or some other good text editor)
2) edit/replace tab (^t in winword) with ~ or % or $ or some char that isn't in your data file. Don't use the winldcards (* or ?)
3) save the file. Open it in excel. During the convert choose the char you replaced the tabs with as your delimiter.
Hi I have utf problem also.. N it freaks me out..
My whole db runs in unicode, the admin pages are utf8 encoded, when I export, it exports utf txt files.. When I open I can set to utf8 read encoding.. It shows nice.. When I try to save Xcell I can only choose between "tab-delimited" or "unicode".. There is no separate encoding.. That's one thing.. First I tried the "tab-delimited" option.. Result: after uploading and processing it, all öüóőúéáűí became ????????? characters.. Akay, I thought I just can give a sht n try unicode simply, 'cos I compared with the original exported file, and the tabs seemed to be ok.. But It seems like it didn't processed anything cos the last echo is:
File uploaded.
Temporary filename: /var/tmp/phpzIpYsH
User filename: visszaXP3.txt
Size: 362636
Upload Complete
But no effect..
Any idea? Thx!
I am confused by your post - my db is in utf8 also, but the whole point of EP is to avoid dealing with sql and php and utf8 etc. Did you post to the wrong place? Are you working in PHPMyAdmin? Frankly, I would LOVE to know the answer to your question because of all the trouble I'm having with EP. I wish I knew how to export/import directly into a MySql db!
Good luck to us both...
Well, I still have heard ZILCH from Nicholas or anybody else on this post - I am actually going to give up and do the attributes manually because I have wasted waaaaaayyyy too much time not being able to fix this!!!
But here's an update which may or may not tie into others's issues:
1. I had to use Open Office to open the attributes txt file because My Mac Excel 2004 won't recognize more than 200 something columns. OO actually recognized utf8 and handles the file well.
2. I chop up the att txt file into smaller pieces so i can convert them to .xls
3. I work in Excel and save the .xls to tab delimited .txt file. (xls to txt works great for EP's Full_ or EPA's Store_ files. The uploads work well.)
What's worked so far for attributes:
1. If I chop up the file to only my first option id - that's never been deleted - the db update works fine.
2. If I select just option id # 21 which is referred to as #20 since I had a deletion before it, I can't get either file to work:
a. the file with headers called #20 and data called #21, nor
b. where i've changed the headers to match the data as id #21
What's weird is that both of them report "products updated successfully." but when I go in thru phpmyadmin, nothing has been changed at all whatsoever.
Have I chopped up the file too much? Or does EP's att headers (or EPA's for that matter) JUST NOT WORK???
ALSO, Does anybody know how to export/import safely using PHPMyAdmin? Export as csv? What import options do you use???
Good luck to us all!!!
Try using Open Office.. works much better with EP than excel.Quote:
I work in Excel and save the .xls to tab delimited .txt file.
I just downloaded easy pop. and now i need to know were to put the files first folder is admin 2 is temp
I'm totally new to this and need help.
plus do I have to edit any php.
Thank you
Hi Timbo77.
I just did the install yesterday, and there is a step-by-step guide in the Install.txt file in the package you downloaded which will guide your way through.
Remember to backup your database and files before trying. You will find guides on how-to if your search this forum for backup.
Good luck :smile:
I don't know why this is happening can someone help me please
Warning: move_uploaded_file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phplEbLEv' to '/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt' in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.file]: failed to open stream: No such file or directory in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1301
Thank you
Greetings all,
I have large files to import, which I was previously able to upload via splitting the file. Recently, the server on my host - hostgator - hasn't been allowing me to split or upload files properly. The host gave me SSH access - mind you, I'm a newbie here - to do the upload. (I'm using putty for SSH.)
Here are my questions:
1) I noticed in tutorials on SSH that the file name ends in ".sql". Should I use that extension or use the ".txt" extension on my file?
2) The host recommended that I not split the file. Do I need to change anything on the Easy Populate configuration since I'm not splitting the file?
Any and all advice is appreciated. I may not be able to reply to responses right away...the toddler might need its momma.:D
Thanks a bunch.
Newbie Linda
Hi Linda,
Please use this at you own descretion, as I never used SSH, but if it is in sql format, it would probably need to be socked straight into the database (not uploaded via EP). There is a MySQL Patch in the tools section that allows for sql inserts. Backup your database, make a 1 product file and try inserting it there (just copy/paste the file there). If it works, great, if not, you will get a host of error messages and hopefully no ill effects. Push come to shove, just restore that backup you did a few minutes before, no harm, no foul. PS, I backup before any EP upload, just in case. It would be prudent to do so if using SSH also.
Thanks for the input.
My file is in the "easy populate" format. (I had just thought about changing the extension to .sql, but I do not think that's necessary - after reading a bit more on SSH.)
What I am not clear about is whether I can do a direct import of the easy populate formatted file to the database. Ultimately, I will give it a try with backups, etc...but, will check the forum for any other replies before doing so.
(My host is trying to fix a problem before I can try, but I will update the forum once done...hopefully successfully.
Linda
A lot of my products are going to be the same price so i downloaded Easy Populate. When i go Admin/ Tools/ Easy Populate I can only export my current products list as a text document.
Here are my options;
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file
When i open my complete download with open office i get this;
The wiki said something about being able to read this file as a spread sheet, how do you do this?Code:v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
500 34mm Red Gemstones Pack of 500 34mm Gemstones 5.5 0 2008-06-04 13:39:23 999 More Gems Red Gems --none-- 1 EOREOR
500 30mm Red Gemstones Pack of 500 30mm Red Gemstones 5.5 0 2008-06-04 13:38:27 999 More Gems Red Gems --none-- 1 EOREOR
/products/stamptool/stamptool.jpg Gem Setting Kit Everything you need to get started! <br />Gem Setter Tool <br />500 Gems <br />Free Template 15 0 2008-05-28 15:18:48 9999 Gem Setting Kit --none-- 1 EOREOR
black1 black1 0 0 2008-06-03 18:01:25 0 More Gems Black Gems --none-- 1 EOREOR
Torque Blue Gems Torque Blue Gems 0 0 2008-06-03 18:01:36 0 More Gems Torque Blue Gems --none-- 1 EOREOR
Silver Studs temop Silver Studs temop 0 0 2008-06-03 18:01:50 0 More Gems Silver Studs --none-- 1 EOREOR
500 20mm Red Gemstones Pack of 500 20mm Gemstones 5.5 0 2008-06-04 13:37:44 999 More Gems Red Gems --none-- 1 EOREOR
black prod2 black prod2 0 0 2008-06-03 18:02:38 0 More Gems Black Gems --none-- 1 EOREOR
thanks
james
Open openoffice calc then file open and choose
Files of type: Text CVS
then it will work...:D
Even if i open calc, when i open the file with calc it opens it as a text document in the text editor. It even does this when i rename to file to .cvs
My admin Easy Populate tools will only let me export files as txt, is this normal?
Thanks a lot! seems to be working now :clap:
Sorry for all the questions but how do I upload my new catalog?
Ive only changed the names of a few products as a test. Do I need to save the open office spread sheet as a txt file? The closest I can find is a .csv file, but that doesn't seem to work.
Forgot to mention, Ive also tried just changing the text description of one product in the downloaded catalog with a text editor. When I upload this file I get the following;
Quote:
Upload Results
File uploaded.
Temporary filename: /Applications/MAMP/tmp/php/phph4BC1U
User filename: Full-EP2008Jun06-1010.txt
Size: 1556
No model field in record. This line was not importedproducts/4 | 500 34mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 30mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | GemSetting | Everything | | | | | 15 | 0 | | 2008-05-28 | 9999 | | Gem Settin | | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black1 | black1 | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Torque Blu | Torque Blu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Torque Blu | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Silver Stu | Silver Stu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Silver Stu | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 20mm | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black prod | black prod | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Upload Complete
Hey all, im trying to update my product list using easy populate. Initially i populated with just product name, price and category. I now want to add descriptions.
My suppliers provide the descriptions, i just want to be able to paste them into ep and upload without having to manually tweak the formatting. Is there any way of doing this.
I have tried several ways but the descriptions all end up on 1 line. The supplied descriptions are in a text format on separate lines.
Thanks in advance
I suggest you format the description in Zen Cart for one product and then export it with EP. Then look at the exported file and see the description column. You should be able to see the br for the line brakes and so forth. Just do it the same way for the text you want to import. You need to keep the html formating stuff. Then it should work.
Can easy populate name categories as well as products? I named some of my categories in zen cart but when i export everything i cant find the text.
james
Good advice... create a product with everything you requireQuote:
I suggest you format the description in Zen Cart for one product and then export it with EP.
i.e. model number, product name, description, price, category, attributes etc etc etc
Then generate/download Easy Populate file..that gives you complete template
for your store's requirements to upload further products using Easy Populate..
TIP
Create categories first, via admin, BEFORE starting exercise above.
I see what you mean about the formatting but with 2000+ products manually inserting the html is going to be a nightmare. Is there no way ep can pick up simple formatting in the description field? I know there are a few advanced options.
A few years back i did the same exercise and im sure i just copied and pasted the mfrs descs into the appropriate field and no further formatting was required. Have i missed something simple?
Yes it can. Just put the formatting tags in the description as well. If you have a source spread sheet where the description has the formatting in it, then you just copy it over to your template file that you created earlier like I suggested. Then import back into Zen.
The source is a spreadsheet with word wrap on. There is no html formatting in the suppliers spreadsheet, there are simply new lines for each part of the description saved in .xls format.
How can i copy this over a template description that has the tags in it? Do you mean manually do it line by line? (bearing in mind i have 2000+ products to add).
Also i tried manually adding a product and downloading the ep file but cant see how you can format the description in the admin tool?
I have the problem that when I try adding a new product, the master_categories_id is not stored, checked the db and it says 0 for the new product. I tried specifying the category per its name and also its ID, none worked.
Do others have this problem when trying to add a new product to an existing category?
Help! Thanks in advance.
Nevermind...
I got confused by an extra line that appears at the end of the report, saying that it didn't add the product because it lacked the category, but it's talking about an empty entry the EP seems to try inserting instead of discarding:
The master category id doesn't get stored, as I had found, but the product gets an entry in the products_to_categories table. I thought that the category value was required in the products table, so I was worried, but it seems to be working without it.Quote:
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Does anyone know how to update category description with Easy Populate?
When I make a category with a description in the admin, and export it, Easy Populate doesn't have the description anywhere.
20 and counting, not helped by how often my client changes his mind!
I will do it in the admin if I have to, it just seems strange that Easy Populate cant do this. Is there another piece of software that can? This must be a real issues for people with massive sites.
Well thanks for your posts Anguz, Guess i'll just have to do it the admin way for now. If I ever find a better way I will try and remember to PM you.
james
Anybody knows if there is any development going on with EP module?
I remembered that the advanced version would have been 1.2.7 and now when I looked it in modhole it was suddenly 1.3 but the update date for the info was dated back to 2006! Is it so or how?
I'm using 1.2.5.4 and would like to have some enhancements on it if possible attribute-wise etc but it is unclear to me if any development is going on.
Elli
Direct the question to modhole and let us know....
A lot of advanced features are listed: http://www.zencartbuilder.com/index....&products_id=1
Wonder if it is worth the money? Do these extended, improved features work well? Anybody have a thought to share?
I am having a little problem...
When I Uploaded some new products.
I can see it if I search for the products such as:
Adult Bat Girl
http://nothingbutcostumes.com/index....ducts_id=14417
But the directory I put it in...
Either by clicking "New for 08" on top of the listing or
"New for 08" in the Categories Section...
I get a blank Screen....
After spending a weekend editing EP for my use, I didn't see much in the way of editing categories in it. The little bit of category checks and some attempts to create which ends up making trash is about it. I may spend some more time to cleanup that part.
Last time I made changes to my category descriptions and added images was to use phpmyadmin. I exported the tables, made edits and then drop them back in.
To get UTF8 support for zen cart you have to do a little tweaking. What code needs to be changed is presented at my blog post
trsplet.com/blog/2008/06/14/php-zen-cart-easy-populate-utf8-podpora-utf8-support
I'm new here, and new to Zen Cart but not new to web designing in general.
I have downloaded Easy Populate and can't seem to get the format correct in Excel.
I have the entire spreadsheet completed, but when i go to upload it in the admin panel, it uploads one product and not even completely for that one product, when i have 1000's of products that should be uploaded. :(
I am attaching the spreadsheet, and would be really grateful if someone could look at it and change the format quickly (I think i may just be saving it wrong).
I don't have many funds available right now, but i'm willing to give large discounts in my new store or $20 or so to whoever can help me out.
Spreadsheet File: http://www.highhobbies.com/AllProducts.csv
CSV File: http://www.highhobbies.com/AllProducts.csv
I have tried for hours, I'm at my last resort here.
If you are trying to help and have any problems, please post here, PM me, or PM me for my email address or AIM screenname and I will be here to help.
Thanks in advance!
-George
Link didn't work... Trying again...Quote:
When I Uploaded some new products.
I can see it if I search for the products such as:
Adult Bat Girl
http://nothingbutcostumes.com/index....ducts_id=14417
But the directory I put it in...
Either by clicking "New for 08" on top of the listing or
"New for 08" in the Categories Section...
I get a blank Screen....
http://nothingbutcostumes.com/index....ducts_id=14417
Really banging my head on this one... :frusty::frusty::frusty::frusty:
Your link is not working - did you find your answer?
You are correct, EP does not export category descriptions; however, the paid-for version does - EPA. It costs $65 which considering the work involved in this program is certainly warranted!
Buy here - http://www.zencartbuilder.com/index....&products_id=1
I ran into this as well - but many of my descriptions are almost dupes. I can't vouch for OO but in Excel, if you put your curser NOT in the cell; but in the Formula MENU line for that cell...it acts more like a text editor. I actually did my typing on a notepad and then pasted it to the Formula MENU cell. Once you get the hang of formatting html it's not that bad - it's exactly the same as you see right here in the Posting Editor!
Here are some things to try:
-paste all your client's descriptions to Word
-edit as you wish with bold etc.
-then File/Save to Web Page and
-View/HTML source to grab the code to paste into Excel as I showed above.
Good luck!
Why am I not able to see my uploaded my datafeed results.
I am using zen 1.3.8a with Easy Populate support for Version 1.2.5.4.
All installed and have NO errors etc . temp folder is cmod 700 and resides -
/xyzsitename/addondomainname/all the zen file and folders
/xyzsitename/addondomainname/temp /
I have been provided with datafeed from 'sensualmystique.com' as 'new datafeed 051308.xls' file format.
So far so good but what do I need to do to populate my shop. Shop is empty (I have deleted all the previous products and categories)
I have tried opening in Excel then saving as CSV text file then re upload under in admin under 'Upload EP File'
then what? I still can not see the products ..nothing has changed. what am I missing ?
Hey Langer, I swap you with a bit of sunshine from Gold Coast ...hehehe
Thanks in advance
It shouldn't be comma separated values, but tab separated, just making sure cause you said CSV, and the file extension txt.
After placing the file in the temp dir, go to easypopulate in the admin panel and paste the name of the file in the text field to get the file from the temp dir and click the import to db button.
Hope that helps.
Version 1.2.5.4 from 2005 is the last EP version, is that right? The Froogle feeder doesn't work - Google changed it to Google Products and changed almost all the required fields, and field names, a couple years ago. I modified some of the code last year, but it needs more work. Does anyone plan on working on it?
oavs: I re-read your message and I seem to undertand that the txt file you got wasn't generated with EasyPopulate. If so, you should get one generated by it and then copy the data under the columns it has, that way you make sure you're working with the right format.
How do one get generate by Easy Populate?
As I said I have the new datafeed 051308.xls on my machine locally. What is next? It is tab separated text file saved from Excel.
I am also not interested in The Froogle feeder any any other feeders. I just want my datafeed to work on my own shopping site.
In my datafeed file that was sent to me from the supplier I have the following headings. What do I do with them? Do I need to change any one of them?
Quote:
ITEM ID CATEGORIES TITLE FULL SIZE IMAGE01 FULL SIZE IMAGE02 FULL SIZE IMAGE03 THUMBNAIL IMAGE01 THUMBNAIL IMAGE02 THUMBNAIL IMAGE03 DETAILS META_KEYWORDS META_DESCRIPTION QUANTITY REMAINING WHOLESALE PRICE ON SALE PRICE WEIGHT SKU COLOR SIZE
EP is not that easy to use, but once you get the hang of it, it does make life easy.
With that... becuse your database is empty, exporting an EP file wont help you much. In the zip file you should have an temp directory. The dir has a txt file called Full-EP2005Aug31-0404.txt this is the basic dump file that EP uses. It has the full header.
EP will not make categories from the txt file. You need to make categories in Zen cart before you try to install you products. If you don't and you have categories in your txt file that are not in your cart... good luck finding your products.Quote:
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
EP uses the model number to create products in your cart...
Use EP headings and copy your vendor products under the ones that match.. once done, save as a Tab Delimited text file.. not a CSV file.
Remember... EP wont make categories, use v_status 1 = active, 0 = in-active, 9 = delete product, all lines need an ending word of EOREOR.
davewest, I believe it does create the categories that you mention if they aren't the db already. I think I did a test that showed me that.
oavs, you can do a simple test with a single product first, with a new category, and see what happens.
I am sorry but I am totally lost. I have zipped one of my datafeed and one of the sample datafeed came with the EP. If you can do two lines for me please so I know what to do with the rest.
So close yet so difficult. You think read me would be little more clearer about the most crucial part. Installing running it fine yet I can not use the thingy so little help would be much appreciated.
Thanking you in advance.
PS I can't see my zip file on the forum..where did it go?
Sorry about this but here is the zip again.
Looks like uploads not working. Here is the small sample of my datafeed. If someone could put it in a EP format so I 'll know what to do with the rest. Thank you.
Quote:
ITEM_ID CATEGORIES TITLE IMAGE THUMBNAIL OVERVIEW DETAILS META_KEYWORDS META_DESCRIPTION QUANTITY_REMAINING QUANTITY_SOLD RETAIL_PRICE YOUR_PRICE SALE_PRICE FIXED_SHIPPING WEIGHT SHIP_SEPARATE LENGTH WIDTH HEIGHT MAX_PER_BOX CHARGE_SHIP CHARGE_TAX IS_NEW IS_FEATURED AVAILABLE_TO VIEWABLE MANUFACTURER VENDOR SKU COLOR SIZE COLORSIZE
1 39->0|36->4|32->0|1->0 80067 - Beautiful soft cup babydoll edged with lac 80067.jpg Thumb_80067.jpg Beautiful soft cup babydoll edged with lace trim. BABYDOLLS BABYDOLLS BABYDOLLS - Beautiful soft cup babydoll edged with 503 0 10.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80067 Light Pink S->M->L
2 36->2|36->3|32->0|1->0 80083 - Sheer net and lace babydoll with shirred l 80083.jpg Thumb_80083.jpg Sheer net and lace babydoll with shirred lace and BABYDOLLS BABYDOLLS BABYDOLLS - Sheer net and lace babydoll with shirr 792 0 12 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80083 Red/Black One Size->XL
3 36->2|1->0 80085 - Marabou feathers babydoll. Adjustable str 80085.jpg Thumb_80085.jpg Marabou feathers babydoll. Adjustable straps and BABYDOLLS BABYDOLLS BABYDOLLS - Marabou feathers babydoll. Adjustable 946 0 12.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80085 Black One Size->XL
4 40->0|36->1|36->3|31->0|1->0 80070 - 2 piece lace babydoll with satin bow and m 80070.jpg Thumb_80070.jpg 2 piece lace babydoll with satin bow and matching BABYDOLLS&return;&newline;&return;&newline;[SOLD_O BABYDOLLS BABYDOLLS - 2 piece lace babydoll with satin bow a 1710 0 12.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80070 Red / One Size->Red / XL->White / XL
5 36->2|1->0 80038 - Sheer underwire ruffled babydoll and match 80038.jpg Thumb_80038.jpg Sheer underwire ruffled babydoll and matching thon BABYDOLLS BABYDOLLS BABYDOLLS - Sheer underwire ruffled babydoll and m 883 0 13 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80038 Black S->M->L->XL
6 40->0|36->1|36->2|36->3|36->4|32->0|31->0|1->0 80042 - Stretch lace and chiffon babydoll with mat 80042.jpg Thumb_80042.jpg Stretch lace and chiffon babydoll with matching th BABYDOLLS BABYDOLLS BABYDOLLS - Stretch lace and chiffon babydoll with 1414 0 13.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80042 White / L->White / XL->Red / S->Red / M->Red / L->Red / XL->Black / S->Black / M->Black / L->Black
7 36->2|1->0 80043 - Floral embroidery underwire babydoll with 80043.jpg Thumb_80043.jpg Floral embroidery underwire babydoll with cup stra BABYDOLLS BABYDOLLS BABYDOLLS - Floral embroidery underwire babydoll w 960 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80043 Black S->M->L->XL
8 40->0|36->4|36->5|32->0|1->0 80040 - Cross dye stretch lace underwire babydoll 80040.jpg Thumb_80040.jpg Cross dye stretch lace underwire babydoll with sid BABYDOLLS BABYDOLLS BABYDOLLS - Cross dye stretch lace underwire babyd 1696 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80040 Mint->Light Pink S->M->L->XL
9 39->0|36->1|1->0 80069 - Sheer babydoll trimmed with ruffles and bo 80069.jpg Thumb_80069.jpg Sheer babydoll trimmed with ruffles and bows. Pan BABYDOLLS BABYDOLLS BABYDOLLS - Sheer babydoll trimmed with ruffles an 601 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80069 Pink S->M->L->1X/2X->3X/4X
10 32->0|25->0|1->0|36->4 80046 - Soft nylon embroidered netting babydoll ha 80046.jpg Thumb_80046.jpg Soft nylon embroidered netting babydoll has satin BABYDOLLS BABYDOLLS BABYDOLLS - Soft nylon embroidered netting babydol 1565 0 15.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80046 Pink S->M->L->XL
11 36->2|36->3|32->0|1->0 80077 - Knit chiffon babydoll with tattoo lace cup 80077.jpg Thumb_80077.jpg Knit chiffon babydoll with tattoo lace cups. Inclu BABYDOLLS BABYDOLLS BABYDOLLS - Knit chiffon babydoll with tattoo lace 1884 0 16.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80077 Black/Red S->M->L->XL
12 36->2|36->4|1->0 80050 - Stretch satin soft cup babydoll with lace 80050.jpg Thumb_80050.jpg Stretch satin soft cup babydoll with lace trim. In BABYDOLLS BABYDOLLS BABYDOLLS - Stretch satin soft cup babydoll with l 1641 0 16.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80050 Pink/Black S->M
13 25->0|1->0|36->2 80048 - Chiffon cowl neck babydoll with rhinestone 80048.jpg Thumb_80048.jpg Chiffon cowl neck babydoll with rhinestone halter BABYDOLLS BABYDOLLS BABYDOLLS - Chiffon cowl neck babydoll with rhines 0 0 18.75 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80048 Black M
14 36->3|32->0|25->0|1->0 80071 - ######## sheer net babydoll with slightly padd 80071.jpg Thumb_80071.jpg ######## sheer net babydoll with slightly padded cups BABYDOLLS BABYDOLLS BABYDOLLS - ######## sheer net babydoll with slightly 0 0 17 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80071 Red S->L->XL
15 36->3|32->0|25->0|1->0 80068 - Sheer net underwire babydoll with cute ost 80068.jpg Thumb_80068.jpg Sheer net underwire babydoll with cute ostrich fea BABYDOLLS BABYDOLLS BABYDOLLS - Sheer net underwire babydoll with cute 0 0 17 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80068 Red XL
16 32->0|25->0|1->0|36->4 80041 - Charmeuse and matching lace babydoll with 80041.jpg Thumb_80041.jpg Charmeuse and matching lace babydoll with ######## sid BABYDOLLS BABYDOLLS BABYDOLLS - Charmeuse and matching lace babydoll w 1647 0 18 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80041 Pink S->M->L->XL
17 32->0|25->0|1->0|36->3 80100 - 2 piece babydoll with satin bow and matchi 80100.jpg Thumb_80100.jpg 2 piece babydoll with satin bow and matching thong BABYDOLLS BABYDOLLS BABYDOLLS - 2 piece babydoll with satin bow and ma 1967 0 20.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80100 Red One Size->XL
18 32->0|25->0|1->0|36->4|36->2 80029 - Pink stripe microfiber, open back&co 80029.jpg Thumb_80029.jpg Pink stripe microfiber, open back, und BABYDOLLS BABYDOLLS BABYDOLLS - Pink stripe microfiber, open bac 1638 0 21.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80029 Black/Pink S->M->L->XL
19 36->1|1->0 80049 - Microfiber underwire babydoll with stretch 80049.jpg Thumb_80049.jpg Microfiber underwire babydoll with stretch lace cu BABYDOLLS BABYDOLLS BABYDOLLS - Microfiber underwire babydoll with str 903 0 21.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80049 White S->M->L->XL
Ive installed Image Handler 2 and Easy Populate. Both are working fine but now when I go to my Admin/ Categories Products, none are displayed.
If I use Easy Populate I can import products and they appear in my store front, but not in my admin.
james
oavs, did you look for the txt file in the temp dir? Did you look at the EasyPopulate entry in the Tools menu in the Admin area?
I am going to use EP to upload over 8,000 products to my site and even though most product images will be named according to their product number I'm sure there will be some that do not get named correctly or are not found at all so I would like the no_image gif to show up instead of a broken image.
I know there has to be a modification done to the zen_image function file I'm just not sure how, I'm not much of a php coder, I can understand it but cannot write it. Something like if image not found display no_image.gif
I can't even find the zen_image function file for the life of me.
When i install my site live i get this;
Warning: require(includes/modules/category_product_listing.php) [function.require]: failed to open stream: No such file or directory in /home1/clearmag/public_html/admin/categories.php on line 639
Fatal error: require() [function.require]: Failed opening required 'includes/modules/category_product_listing.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home1/clearmag/public_html/admin/categories.php on line 639
Ok I found the answer to my question and here it is if anybody else needs it. This worked in ZC 1.3.8 not sure about the older or newer versions coming out.
In includes/functions/html_output.php after
Enter the following:Code://auto replace with defined missing image
if ($src == DIR_WS_IMAGES and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') {
$src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
}
This will replace any broken product images with the no image file.Code:if (!file_exists($src)) {
$src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
}
Yes, I did . Can you tell me what am I supposed to be looking for? There are text files as per original installation.
After I upload my datafeed file, I get this message on the bottom. Then what ?
Upload Results
File uploaded.
Temporary filename: /tmp/phpXgT8SQ
User filename: new datafeed 051308.txt
Size: 129316
Upload Complete
----------------------------
I have no idea what to do with these??
Download EP and Froogle Files
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file
Create EP and Froogle Files in Temp Dir (temp/)
Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)
Create Model/Price/Qty tab-delimited .txt file in temp dir
Create Model/Category tab-delimited .txt file in temp dir
Create Froogle tab-delimited .txt file in temp dir
Create Model/Attributes tab-delimited .txt file in temp dir