Printable View
I am using the current version of ZC
So when i update the quantity and upload the sheet the quantity does not change. based on the message i am getting the file is processed with no errors.
I also notice that i am not seeing any form of ID column is that what could be causing this?
hello, ive got cost price of my products, how do I get ep to show that in the download.
I have tried to install and use EP but I keep getting this error
Fatal error: Allowed memory size of 96468992 bytes exhausted (tried to allocate 590 bytes) in /chroot/home/musicski/music-skins.com/html/store/admin/easypopulate.php on line 847
I have change the memory to 92mb and that is still not enough my whole shop size is about 3gigs we have a lot of products how can I fix this?
ckosloff Mybe the porter of the EP 1.2.5.5 csv2 version may be able to tell you, but I would have thought you would have needed some of the admin settings, temp folder,date format etc.
touchclothing If you are using just one product table and the multisite has not altered that table then there should be no problem, best way check with the author/thread of that mod.
myplace311 What version are you using ? You would need a 'model column' in the upload file for any version of EP to work.
lucianman As you are using a custom field in the database product table you would need to add a custom column in the EP file search this thread for notes how to do this.
touchclothing php has a really small memory, you have increased the memory by default but your database is sooooo big it still is not enough, are you tring to save to temp folder and ftp from the server, not direct download.
Yo man is multitasker. :laugh:Quote:
Originally Posted by Scrat
Seriously, I never needed the DB patch.
As far as contacting the last porter (phazei), hmmm...he stated himself he is not very active with ZC any more.
I am just trying to download to my desktop. But when I try to run the install it http://www.music-skins.com/store/adm...langer=install
I get the same error
what do I need to set the memory size to
Does this contribution you can delete or move multiple items at the same time. Because I have about 70 items in the Specials and I want to remove them all at the sametime. Can someone able to help me?
BK... if you want to remove them as in DELETE the items from your product list you can put in the "status" field 9 and it will delete the item from the store .. however be careful even if you delete all items from a category the catgeroy is still listed and not deleted you will have to manually go in and delete the category.
Hope this helps
I don't want to let the items out of the store. I have items listed in the Specials list and there are about 70 items in the Specials list I have delete them individually and its taking my time. Is there another way to this?
touchclothing
Try this :
If langer install does not work for you, import the SQL patch in the folder to manually install via zencart sql patch insertor.Quote:
Originally Posted by chadderuski
Have you deleted all your old EP files ? and any SQL patch inserts as this could cause you problems ? as these alternative versions do work a little differently.
Also with your products table being so big save to the /temp folder and ftp the file to your deasktop.
ckosloff Hmmm... It looks a really good port but does have some issues from want people are asking on this thread, if it works without the SQL patch than you prossibly don't need it but I haven't really used this version only had a quick look at it.
If you look at the history of EP there are several version ep_v2_75_zen-cart_1_2, 1.2.5.4, 1.2.5.5, 1.2.5.5.csv.2,2.77H, even EPA.
They all have bugs in them still, but the most stable and proven is 1.2.5.4, but all these version are not being maintained by any of the orginal authors/porters (exp. EPA !) thus as you see by this thread the same questions are asked again and again.
Download the db using the ep option for full tab delimited.Quote:
Originally Posted by bkeaton
There should be a headings
v_specials_price v_specials_date_avail v_specials_expires_date
with prices and dates populated. Either add or change the date (under the red one) to todays date for the ones you want to end and upload it As always, back up the db before doing this.
Quote:
Originally Posted by Scrat
I dont have access to the ini is there any way I can do with .htaccess?
myplace311 What version are you using ? You would need a 'model column' in the upload file for any version of EP to work.
I am using version 1.2.5.5
when i download the report that column is blank the title is there just no data as we sell shampoo and there aren't models
does that column work as the ID?
Sorry for the newBness im a vb guy trying to get into this PHP world :frusty:
Thanks for the help!
touchclothing
After goooogling, I found this...
Try this but you may find an internal error:Quote:
methods for increasing the amount of memory a PHP script may consume
2. If you don't have access to PHP.ini try adding this to an .htaccess file:
php_value memory_limit 64M
4. Talk to your host.
myplace311 Zencart & EP need a unique model refernce for each product to work properly, so in ZC you need to insert a 'Products Model:' (eg 00001,00002,00003 etc) in this box and then hopefully your download file will have these ref's in and therefore will update the database accordingly.Quote:
2. the edit to the .htaccess file caused an internal server error (once I reverted back, it was fine.
So you are saying that the model field is being used as the product id?Quote:
Originally Posted by Scrat
is there a reason that the ID is not exported with the file? (thus when oding an upload if no ID then = new product)
i will just run an update qry set model = ID
So in the event that i am adding new products i will need to provide the id in the model field am i getting this write?
sorry if this is already in the post i did do a search but i haven't gone page by page there is a lot of them ;)
I did that before and I raised it to
php_value memory_limit 94M
but it still gave me that error thats when i posted here
I am very new to zen cart. We installed the latest version last week and I am working on adding products. The only addons that have been installed are Easy Populate 1.2.5.4 and image handler.
I have uploaded several files of products and they are loading fine but I keep getting this warning:
Warning: explode() [function.explode]: Empty delimiter in /home/fantasyb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241.
Does anyone have any clue what this is saying? I appreciate any suggestions.
Thank you.
Just checking here - once I have installed EP I should have an easy populate option in configuration. Is that right?
Because I do not. Actually EP seems to be working but I evidently can't configure anything. :smile:
Let me know
Thanks!
myplace311 If you talking about the database ID, this is not used by EP in the upload file as EP converts the Model via a SQL query to insert/update/delete the product. In the upload file you need a Model ref unique to that product, other wise EP will just not work. So if you edit a product in ZC and add a unique Model ref in the appropriate field and then do a complete downlaod you will see how EP works.
medrep50 If you are using Langer 1.2.5.4 read your error 'Empty delimiter' looks as if your upload file format is incorrect, the best way to test is download a complete file to start with and look at that alter a few things and then upload the new file, and I am sure that will work for you.
niccol This depends on the version of EP you are using as if you read a few threads back re. 1.2.5.5 csv2
Certainly Langer Version 1.2.5.4 does
touchclothing
Are you using EP 1.2.5.4 from Modhole? if so have you spoken to your host re php memory. Cheap hosting packages look good but there is big draw backs, you have a lot of products and this will use a lot of memory. Cheap hosting means thousands of sites on the same server - not good for you !Quote:
Originally Posted by touchclothing
Also are using saving this to your /temp folder on your server NOT direct downlaod?
Googled this solve-php-fatal-error-allowed-memory
scrat, thanks for the reply.
first of all I need to apologise. Yes, my version is 1.2.5.5 and I can read so should have noticed the title of the thread.
nonetheless there is some strange stuff happening. running the sql patch gives bundles of errors.
looks like a uninstall and re-install may be in order.
It looks from the thread that the previous version is more stable. Would that be a correct assessment?
Thanks
niccol In my opinion the version to use is Langer's 1.2.5.4 (from Modhole) good and stable with one or two known bugs which you can live with (Search this thread) that don't give you any headaches.
But I don't think you are going to get anyone to rewrite any mod's at present with the looming of ZC 2.0:clap:, which by the sounds of it will break:( most est. mod's.
Thanks again scrat.
I seem to have it working but when I download a file only the first item in the database is included.
I've searched the thread ( except that it won't allow short words like first or only or one which make the search a bit hard) but didn't find anything. Am I missing something really obvious?
Thanks guys...
niccol What version are using ?
How many products in your database ? (Have to looked via phpmyadmin thats everything looks OK in the products Table?)
Thanks scrat!
Well, yes, I haven't gone into the full story. I have been having some issues with the security update / admin profiles mod / URI rewriting mod as well. I think this has probably confused my whole issue. Separating out the effects is pretty difficult.
I had tried 1.2.5.4 & 1.2.5.5 & the paid for version of 1.3.0.3. With pretty much the same result as described in the previous post. (except of course the paid version which never seemed to want to come to the party). After a lot of re-installing backed up versions of the admin folder ( certain combinations of install of security patch/admin profiles/uri rewrite locked me out of admin ) I have got rid of the security patch for the time being while I try and work everything else out.
So, this morning, without the security patch I am up and running with version 1.2.5.4, I think. Evidently need to work out the details of how EP actually works but it seems to be doing what it says on the box.
I didn't talk to much about the security/admin profiles/uri rewrite issues before because I don't think I had realised how that was effecting EP and so it didn't seem pertinent to this thread. And also, to be honest, I don't for sure know what is going on yet.
Without the security patch I can get admin profiles and easy populate to play nice together. With the security patch and the appropriate patch to admin profiles, I can't.
I am slowly and carefully trying to work out what the actual issue is.
hi,
Sorry if this is a repeat question, I have installed EP_v1.2.5.4 and any change I make to a products description is not refelected. To exaplin a little better, I exported a complete dump and then changed a few descriptions, then imported but none of my changes are reflected?
Anyone know why?
something has to be wrong I incressed it to 128 and not I get this
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 155 bytes) in /chroot/home/musicski/music-skins.com/html/store/admin/easypopulate.php on line 871
what is going on
I think the security patch has broken easy populate...Quote:
Originally Posted by vitalwares
touchclothing
Can you advise on these questions as I don't really know the full history, this would help at lot ?Quote:
Originally Posted by Scrat
Version ?
Temp Folder or Not ?
Spoken to Host ?
vitalwares First of all is its V1.2.5.4, from ZC download or Modhole ? As this makes a bigggg difference !
I know I'm not supposed to ask for help for paid mods here but I'm running out of options.
I paid for Easy Populate Advanced and I'm unable to get any support!! Is there anyone out there I can pay to trouble shoot an error with EPA.
I'm sorry to ask here but I have run out of options.
:cry:
kcb410 There are lots of people using EPA that may be able to help you, post your problem and they may help you out !
kcb... would it help if I sent you a zipped copy of that mod? Just send me some proof that you paid Langer for your copy. It may be that your files are corrupted...
hello everyone ,
i have met a problem, after i select the CSV file and click the button to Insert into db, the page show (it didnt happen ago ) :
Page Not Found
Custom 404 Error Page with Site Map Sample Text ...
Put your custom "page not found" message here. You can change this text in the Define Pages Editor located under Tools in the Admin.
but the products was add successfully in my website , and show successfully in my website...
what is the matter? please help me !!! thanks at first !!\
jason
I have installed Easy Populate.
I am currently combining two websites.
I created the categories from the old website in the correct places.
downloaded from my old site the Easy Populate file, changed the prices then uploaded to our new site.
When I have multiple items in a category only a single item is displayed. However I get a report that says all items were successfully uploaded.
Please can someone help.
Thanks
Stephen
www.jbconline.co.uk
The report came back: (I have copied part of it)
Upload Results
File uploaded.
Temporary filename: /tmp/phppTLeLD
User filename: Full-EP2009Jul02-2109.csv
Size: 43790
UPDATED! - Model: Bubble Eco | | 75cm x 50m | TWO rolls | | | | | 28 | 8 | | 09/02/2009 | 5 | | Bubble Wra | 30mm large | | | | | | VAT | 1 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 Bags | | | | | 5.48 | 2 | | 11/02/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 Bags | | | | | 7.35 | 2 | | 28/02/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 8.5" 8.5" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 Bags | | | | | 7.35 | 2 | | 02/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 0 | 0 | Brown Kraf | Paper Bags | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 500 B | | | | | 7.13 | 2 | | 02/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 0 | 0 | Brown Kraf | Paper Bags | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 500 B | | | | | 5.76 | 2 | | 02/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 0 | 0 | | Paper Bags | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 Bags | | | | | 15.25 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 10" x 14" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 500 B | | | | | 20.25 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 19" x 21"" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 500 B | | | | | 8.99 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 13" x 14" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 500 B | | | | | 13.37 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 14 x 18 Br | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 | | | | | 8.33 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 19" x 21"" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | kraftpaper | Brown Kraf | 1000 | | | | | 11.69 | 2 | | 03/03/2009 | 10 | | Paper Bags | Kraft Pape | | | | | | VAT | 1 | 1 | 1 | 0 | 1 | 0 | 19" x 21"" | Kraft pape | Brown Kraf |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 3.49 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 4.13 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 4.77 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 5.2 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 6.22 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 5.87 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
UPDATED! - Model: Paper Bags | whitesulph | White Sulp | White Sulp | | | | | 6.87 | 5 | 03/03/2009 | 03/03/2009 | 20 | | Paper Bags | White Sulp | | | | | | VAT | 1 | 1 | 1 | 1 | 1 | 1 | White Sulp | WHite Sulp | White Sulp |
Thank you!!Quote:
Originally Posted by Scrat
I am getting the following error when I upload my first test product file:
Warning File Import Failed! Primary index column v_products_id or c_categories_index_path missing from uploads file. Please consult the readme.html file for more information.
Both seem to be in the file.
I was able to upload a category file successfully.
Can someone please troubleshoot this for me??
Any help is appreciated.
stecrox By the looks of it the version you are using is uploading the products but by default makes them not active check in that cat. to see if this is the case.(That the product is in there, and not active)
Scrat
I have just taken a look but only one product has uploaded which is the one listed.
stecrox
Quote:
In my opinion the version to use is Langer's 1.2.5.4 (from Modhole) good and stable with one or two known bugs which you can live with (Search this thread) that don't give you any headaches.
I have a lot, a LOT, of product links I need to create. They are coming from a variety of subcats and going to a variety of subcats. So I can't just duplicate a subcat or all the products within the subcat. I sure would like to find a way to do this without having to do them one at a time through the ZC products page. Can I create product links using EasyPopulate? If so, how much of the spreadsheet data would be required? (Is there documentation on this that I missed?)
Does eays populate only work with php v5?
This can be done. If you download the complete CSV file your will see v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 etc. If you have multiple categories you type the main cat in v_categories_name_1 and your subs will be in v_categories_name_2, 3 etc. You'll need to create the categories before you upload the products. I just did this with over 900 products in dozens of sub categories without any issues.Quote:
Originally Posted by pharry
Hi,
How can I get easy populate to include the MSRP field?
I am using the 'msrp_display_1-2 module' and have not changed in the files
any help is much appreciated...
LVT LTD
A : YesQuote:
Does eays populate only work with php v5?
A : Search this thread for adding additional fieldsQuote:
How can I get easy populate to include the MSRP field?
I'm using EP 1.2.5.5.csv. I don't see another thread for it.
I need the id in the exported file to create the url for each product in a product feed for another site. Or else just an exported field for the url would work too. Neither is included.
I vaguely remember a pay version that included an id tag, but this mod appears to be abandoned, and I'm not into paying for it if I won't even get support (such as getting the download I paid for, to start with).
Is there another mod that will export data? Or has someone worked out the changes necessary to the code to create the id field in the export?
fakeDecoy What about the 'Google Base Feeder' would that do this for you?
Scrat, Google Base Feeder would work except that it only seems to export in XML format. I need something I can manipulate, like CSV or TXT.
fakeDecoy First of all I would use V1.2.5.4 as this is the most stable and then I would search this thread for how to add extra fields from the Database, as others have doc. the way to do this.
Yikes... 245 pages in this thread. Any idea how long ago that was discussed?Quote:
Originally Posted by Scrat
fakeDecoy
A Great Tool at the top of each thread 'Search this Thread'
Adding an Extra Field
I need help....
When I try to download my complete .csv from the admin I get the error:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /XXXXXXX/admin/includes/functions/general.php on line 38
Everything else can download fine.
Any Solutions? :frusty:
Kenichi
:frusty:
Quote:
USE LANGER's version 1.2.5.4 (from Modhole) good and stable with one or two known bugs which you can live with (Search this thread) that don't give you any headaches.
You'll need to increase the memory in your public_html/php.ini file.
If you do not have a public_html/php.ini file, you should be able to create a new php.ini by going to the cPanel in your web hosting account -- PHP Config -- Install master php.ini. Then rename php.ini.default in public_html to php.ini (you can use cPanel -- File Manager).
Once you have a public_html/php.ini file, you can edit it. Find and update the memory_limit (usually 64M is sufficient, although up to 128M will work).
This worked well for me.
Quote:
Originally Posted by Kenichi
Hi - hoping this thread may have a simple answer to this... Have installed EP and nothing updates. This is probably because I'm on a Mac. Install says "If you have an Apple/MAC, then uncomment the line in the "configuration variables" section in the easypopulate.php
file that is in the admin folder." WHICH LINE?
I think you are looking at the CSV version 1.2.5.5 rather than version 1.2.5.4. See above notes about using version 1.2.5.4...Quote:
Originally Posted by Sir Henry
It is more stable.
Sir Henry First of all, make sure you have a product in your ZC manually as EP will not update ZC, secondly there seems to be issues with MAC's and .txt /.csv (tab) files, see below from an earlier post.
and like elkbow says use 'version 1.2.5.4...'Quote:
Originally Posted by Scrat
Help!
I am using EP 1.2.5.4. And when i was trying to upload my data at first, it would just put the CSV file in the temp file and that was it, nothing else.
From reading the forums I saw that a Tab Delineated file was the best approach.
So i did that and it came back with all the lines I uploaded and some lines it updated......Great progress. Then when i go to my catalog the items don't show ?????? What gives, I am new to this so please help. Thanks. :frusty:
Eureka!!!! My frustration blinded me! I had blank data that diffed from the items i was updating. So EP ignored the new data. Sorry for my haste.Quote:
Originally Posted by Montag_451
Thanks anyway.......
I downgraded from EP 1.2.5.5 to EP 1.2.5.4 as you recommended in order to try to get this to work.
So it turns out I don't need to add a new field. There's already one there.
v_products_url_1
This column is in the Complete file download, but it's empty for every row. Why is that? For any feed out there, I need to be able to give the product url.
Hi - thanks all for your posts. Will try a few suggestions off-line first. Any ideas how to uninstall EP so the downgrade will be as clean as possible? FYI had a brief flirtation with CRE Loaded (slicker than ZC, but very poor features compared to Zen) and EP worked fine with that - even with a Mac and MS Excel!
fakeDecoy
v_products_url_1 = the url of the supplier NOT THE PRODUCTQuote:
Originally Posted by fakeDecoy
You will need to add the 'product_id' field to the EP Complete.txt download.
Or use Google Feeder and convert XML to CSV gooogled :- command line program XML2CSV open source...
Ok, I finally figured it out. The below from post #949 has a bug, I think - in one piece of code you insert the new field between the name and description, and in another you insert it after them. I haven't tried messing with it to see if I can corrupt my database, but it might be important to be consistent when changing it like I did.
To add the products_id field, all I did was the below two edits out of the 10 or so.
Code:Line 360
Original:
$filelayout = array_merge($filelayout , array(
'v_products_name_' . $l_id => $iii++,
'v_products_description_' . $l_id => $iii++,
));
Changed to:
$filelayout = array_merge($filelayout , array(
'v_products_name_' . $l_id => $iii++,
'v_new_field_' . $l_id => $iii++,
'v_products_description_' . $l_id => $iii++,
));
Line 791
Original:
$row['v_products_name_' . $lid] = $row2['products_name'];
$row['v_products_description_' . $lid] = $row2['products_description'];
if ($ep_supported_mods['psd'] == true) {
$row['v_products_short_desc_' . $lid] = $row2['products_short_desc'];
}
Changed to:
$row['v_products_name_' . $lid] = $row2['products_name'];
$row['v_products_description_' . $lid] = $row2['products_description'];
$row['v_new_field_' . $lid] = $row2['new_field'];
if ($ep_supported_mods['psd'] == true) {
$row['v_products_short_desc_' . $lid] = $row2['products_short_desc'];
}
Im having slight issues with double spacing between the lines of text.
I use dreamweaver to come up with the HTML description, then i paste it back into excel. Once my products are done i copy the information into a notepad then upload to the server using "easy populate" upload from the admin.
the problem is that i get double spaces! even though in HTML code the spacing is <br> i still get double spaces!
now.. when i take the same code and input it manually into the product description (without using easy populate) everything shows up fine!
is anyone else having this issue? its driving me crazy! please assist!
p.s. I also keep getting double quotation marks when copying data from excel to notepad. thats a seperate issue but any idea why this is happening?
Look at the first post in the thread -Quote:
Originally Posted by fakeDecoy
Here's a quick tutorial on how to add fields to easypopulate v1.2.5.4 or 1.2.5.5
http://www.zen-cart.com/forum/showthread.php?t=116061
The instructions are very easy to follow and I was able to do it.
Good luck
Mona
[FONT=Verdana]Easy Populate v1.2.5.5;
has huge bug when I try to import products with same model number
I was really relying on this so I thought I should post here and see if anyone knows what I can do.
It inserts the first product; then instead of inserting the second product; it updates the first one because the product model is the same
; and creates some sort of product link bug
For example if I try to import
- model - product name -
- FP 600x450 - name 1 -
- FP 600x450 - name 2 -
BIG BUG when you try to do this!
Seems this module can really stuff up your catalog in you have the same model name for many of your items.
Example attached. [/FONT]
I just finished uploading 900 products and under the v_products_model column I had to start with the next available Zen Cart product ID number and continue sequentially. That worked fine for me.Quote:
Originally Posted by vandiermen
Hello All,
I'm uploading attributes with some success. The uploads seems to be getting stuck on my attribute for 'Uploading a file'.
Does anyone know what the v_attribute_values_id_
should be for the v_attribute_values_name_
(FILE)?
I think this is what is causing it.
Any help would be appreciated.
Thanks!!
I have about 4000+ products I will have to update with a ID number on the end of the v_products_model :dontgetitQuote:
Originally Posted by kcb410
SAV - 200x150 - ID01
SAV - 300x200 - ID02
PVC - 200x150
...
SAV - 200x150 - ID04
SAV - 300x200 - ID05
PVC - 200x150
http://www.safetysigns4u.com.au/inde...x&cPath=99_100
I would try a small test file on that first. I'm not sure how EP will handle letters, number & characters. I'm finding it to be a challenge as to what EP will accept and handle well.Quote:
Originally Posted by vandiermen
Quote:
Originally Posted by kcb410
The model number can handle just about anything as long as it it does not exceed the allotted number of characters that you have assigned to it. I have used many special characters (#, &,$, -, digits, spaces, etc.) without any problems.
Thank you for that information. I am new to Easy Populate but I am knee deep in learning by trial and error!! Great mod but I'm struggling with attributes a lot.Quote:
Originally Posted by awhfy99
hello all!
i have to make a website for someone. He request an auto update of stock. I had made a script to transform his list automaticaly into the tipe of tab delimited list that easy populate need.
Can anyone help me making easy populate to automaticaly update from a file on localhost?
Hello all!
I have recently uploaded 900 new products to my web site.
They are all priced by attributes. Does anyone know how to change "Product is Priced by Attributes" to yes using EP?
I would like to avoid having to do it one product at a time.
Any help is appreciated.
Thank you!
where can I get easy populate now?
In my opinion this is the best version to getQuote:
Originally Posted by clnwink
Easy Populate and attributes:
I have a great deal of products that require unique attributes (mostly shoe sizes)
Unless I pre-create a "Attribute ID" for each of these unique attributes, than download the attribute file and update it than re-insert it WILL NOT allow me create new attributeID's with unique names and update them automatically correct?
Any shortcuts for creating attributeID's and names based on unique product model out there?
I did some digging and got the "updated attribute controller" and it helps if I need to manually insert them into each product...but not by much!
Thanks!
I want to install that one.Quote:
Originally Posted by vandiermen
How can I uninstall 1.2.5.5?
Thanks.
I've installed EZ Pop CSV but my store is too large to download the data so I don't have the new format.
Can someone post the headings this version needs for the full product import? Also the specials headings. We don't use attributes so the basic would work fine.
I tried my old ez pop file and it couldn't find the model number so I assume the format is new.
Thanks!
This is the complete.csv file.Quote:
Originally Posted by Tapper
I think this is the one you're looking for.
Hello all,
I'm trying to upload my HTML product descriptions using EP.
I have 900 products, some of the descriptions upload fine and others not all the text uploads or the formatting is inconsistent with missing line breaks etc.
Here's a correct page - http://www.kcbgraphics.com/index.php...roducts_id=170
Here's an incorrect page - http://www.kcbgraphics.com/index.php...roducts_id=171
Has anyone bumped into this issue and resolved it?
Any help would be appreciated.
Thank you.
ZC1.3.8
PHP5.2.9
Mysql5.0.81
Thanks, that's the ticket
LOL, it's the same as the old format, just saved as a CSV. Who knew?
I am officially the sharpest knife in the drawer today! :smartalec:
Hello all,
I'm trying to upload revised product descriptions. In Admin - Tools - Easy Populate it shows the upload completing without any errors but when I go to my product descriptions none of my changes are showing.
Has anyone seen this issue before?? If so... how did you resolve it?
Any help would be appreciated.
ZC 1.3.8
PHP 5.2
MySQL 5.0.81
The previous discussions where people had upload issues using an Apple computer that I could find all say you cannot use a MAC to create the file. The truth is: you cannot use Excel on a MAC but you do have options. I use "Numbers" to output the csv file - worked fine for EP 1.2.5.6!!
I try not to give up until I have spent at least 2 days at something. :)
Hi,
Trying to install Easy Populate v1.2.5.6 on Zc v1.3.8 and I get these error msgs when I type in ?langer=install in my browser:
EASYPOPULATE_MSGSTACK_INSTALL_KEYS_FAIL
Warning EASYPOPULATE_MSGSTACK_TEMP_FOLDER_MISSING
Warning EASYPOPULATE_MSGSTACK_INSTALL_CHMOD_FAIL
I have tempEP CHMOD setting at 777, in my root directory (same as my store)
Do I need to install the MySql patch or do I have something else wrong?
thanks in advance.
EZ Pop can run with teh temp folder at 755 instead of 777: many hosts won't allow code to run if folders are set at 777.Quote:
Originally Posted by autoace
Copy the files up again, I think you're missing some.
Make sure the tempEP folder is there. Check that the temp folder is set in configuration/ easy pop. You might have a "tempEP" folder and it's set for "tmp" or something.
Tapper:
Thanks for the quick reply, I changed my tempEP folder to 755 and re-uploaded all the files.
My temp folder's name is 'tempEP', do I rename that to temp and it is is my root directory same as my store.
Same error message.
Do I need to install the 'install_sql' file? Upload or via phpMyAdmin?
How do I know which file is the configure file to check what the name of temp folder should be?
Thanks for your help.
Remove the EP from the end of your temp folder. It is /temp and it cannot be anything else.Quote:
Originally Posted by autoace
Im using EP to upload automotive products and have come across an issue...
there are instances where a part# can belong to different car models for ex:
Part#21-496 - for Audi A3
also
Part#21-496 - for VW GTI
in Easy populate i file these under 2 seperate categories, Audi and VW.
The part# (model#) stays same, but i change the description of the product to read 1. for audi a3 2. for vw GTI
but EZ populate just overwrites this and makes both products "for VW GTI.
basically,
1. How to make EZ populate NOT to overwrite the descriptions?
2. How to make EZ populate create DUPLICATE (not linked) products instead?
Your assistance is greatly appreciated.
Thanks!
Any idea bout this error
if is possible any friend here post a example of csv.file for importQuote:
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE zen_products SET
products_price = '50' ,
products_image = 'peces/koicarp02.jpg' ,
products_weight = '5' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2009-08-09 01:19:12' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '1' ,
master_categories_id = '69' ,
manufacturers_id = '2',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '', EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' WHERE ( `products_id` = '129' )
Thanks in advance
credenscelQuote:
Originally Posted by credenscel
Since EP uses the "part number" as the key you cannot have two items with the same part number in the database and it appears you are not trying to violate that you just want it to be assigned in two categories. What I did was to make a second upload table with the second category tree. This added and did not overwrite the original. There may be an easier way but it worked for me so I am sticking to it.
Good luck.
My friend your store for car parts I think is like my store with many items
I become boring of easy populate
I use now Storemanager from the company Magneticone and the true is very easy upgrade products and also import 1000 of products with also images.
is not a free product but also is not really expensive.
For me solve many days of update products Now I make in few clicks
Try I using now Free for 30 days but I really I go to buy . Zen cart become really porwerfull
Quote:
Originally Posted by credenscel
A few things come to mind for me.
1) The simplist is to add an prefix (or suffix) to your part numbers (Audi, VW, GM, etc) so that each would then have a unique number. Very simple to do, just use the concatenate feature of your spreadsheet (at least excel has that option).
2) It is also possible create a PN field, so that it will allow duplication of your PN's (use with the 1st idea?). You could substitute the PN field for the model # on the shipping invoices and search features, etc.
3) Another idea (which has not been researched by me) is that there might be a way to change the indexing key in EP from the model number to another field (such as the image path, since that is unique by definition). This assumes that the PN's all have a unique image.
Myself, I would stay with the VW-0123456 idea.
I have just started using EP 1.2.5.6.
I hope you guys will help me get started with this add-on that I really need to use.
I didn't need to run any SQL, just uploaded the files and it was there.
Just in case I ran ?langer=install in the address bar after easypopulate.php and got warnings, but the files finally downloaded to tempEP.
When I attempted to download attributes I got the following:
"An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer."
But in the end I did get the file, I have literally hundreds of attributes and was seeing all of them for all models, even those that don't belong.
Any input on this error, please?
Hey guys,
I'm relatively new to ZenCart and just starting to use it on a website for the company i work for.
I have the latest version of ZenCart, running a few add-ons, all to no luck as of right now. That is why I got on the forums.
I installed Easy Populate (latest version) and noticed it was giving me the array_flip error... Fixed that pretty easily, and noticed that my company didn't spring for PHP5 so running PHP4.
lame, i know
anyway, so now I am siting here and and everything seems to be working OK, no errors.. BUT, as soon as I upload to teh temp, then upload up, or do any type of "insert into db" .. I get nothing. it says its all okay, but nothign is actually pushing up.
I am goinng to do some more searching, just confused as to where the issue is... php4 issue? (i went back a few versions to see if this was the case... and still didn't work) install issue? (tried reinstalling a few times with a few different versions). array_flip fix issue? (maybe this does not actually fix it?)
any help appreciated.
If you download the .csv template and then re-upload it, nothing will happen, and that is OK.Quote:
Originally Posted by royboy789
wait, that makes no sense... it says everything goes through ok, when i hit "insert into db" or watever... no errorsQuote:
Originally Posted by ckosloff
but the products i put into the CSV (new ones) don't get put into my store... very weird.
I changed this from 0 to 1000 but someone mentioend maybe i should have made the string larger, so I put in a few zeros.... still not working.
array_flip(fgetcsv($handle, 1000000, $csv_deliminator, $csv_enclosure))) {
I don't know if the problem I had and the way I solved it will help you or not...but here goes.Quote:
Originally Posted by royboy789
I had downloaded my entire ez-populate list of products...a total of about 2500 because I had to make some changes....Once I made the changes i used the tool to split the files which were uploaded to my temp file. Then I started to upload each file...but although I got the message that everything was okay...actually nothing was being uploaded.
So I downloaded all 8 of the temp files to my computer and took a look at them. One thing I noticed was that there were several columns that I really did not use that appeared blank...but I decided to delete them anyway...they were the specials_price...specials_date_avail and specials_expires_date. Once I deleted those columns and had ezpopulate upload each of the files everything worked fine.
Wish I had great insight as to why it worked...but you might try and look for some columns that should be blank and eliminate them and see if that helps.
Good luck.
I have searched through this thread and have not found any mentioning of this issue, and I apologize if this subject has already been covered.
I have a large inventory of items (48000+). When trying to download a Froogle (Google Base) feed, and when, in fact, trying to download any of these .csv/.txt files, my Admin area times out.
When I uploaded the inventory, I used a simple CSV splitter program to break up the upload file into 1000 item chunks...and I'm sure that if I were more PHP savvy I'd be able to code something to do the same thing but...I ain't. Any suggestions?
:frusty:
Thanks in advance,
Dale
We have just install Easy Populate
Version: 1.2.5.6.csv.2
Last Updated: Jun 18 2009
Into Zen Cart™ Version: v1.3.7
It works great except for one bug. When you give the item a price ie $1.00 and you set sales tax in my case to IN @ 7%, it writes the $1.00 into the gross field and writes the net field as $0.93... basically lowering my net price.
We tried it without setting sales tax and it write $1.00 in both net and gross.
My solution until this is fixed is to load all items with no Sale Tax and then use SQL to change the flag
Anyone else experiencing this?
Mike
It might be as simple as going to admin>configuration>my store and changing the Admin Set max_execution_time for processes to something longer, we have it set to 6000 seconds and then we get to the server's timeout issue. The server issue is set in the php.ini file located on your server. You may or may not have access to this, depending on your host, and you should be able to put one in the root directory of your site to control site-specific php. There is a setting in the php.ini for timeouts.Quote:
Originally Posted by jdw1979
I tried setting the Admin timeout. It didn't work. Well, phooey (I would say something else but it's a family forum)...I'll take a stab at creating a php.ini. I use Godaddy, so the actual file isn't available to me; though I have created one before to do something that I can't remember...a mind is a terrible thing to waste. I'll let you know how the php.ini edits go.
Dale
Oh how often I feel this way -->:lamo: