fairestcape,
thanks for the reply.
Will find something that works.
Kevin
Printable View
fairestcape,
thanks for the reply.
Will find something that works.
Kevin
Hi
Installed EP v 1.2.5.4 in ZC 139h
Uploaded one item in a tab delimited text file with a model #, name , description and category.
Checked the database and this record appears correct.
Checked the store and also appears correct
Went into admin and found the listing with the correct name and model # in the correct category; However when entering into the product all the fields are blank including the name ,model#, and Description.
How is this Possible???
If you open the product and it's blank, is it still blank if you leave that product and come back to it?
I have that bug on my store. No idea why it does it, but it works otherwise.
What other modules do you have installed?
Hi
Mods Installed:
Cross sell
google feeder
Ih
Lite box
ceon URLs
Hi
regarding previous post:
Quote:
Hi
Installed EP v 1.2.5.4 in ZC 139h
Uploaded one item in a tab delimited text file with a model #, name , description and category.
Checked the database and this record appears correct.
Checked the store and also appears correct
Went into admin and found the listing with the correct name and model # in the correct category; However when entering into the product all the fields are blank including the name ,model#, and Description.
How is this Possible??
If I manually enter a new product with just a Model# and then use EP to update everything appears fine in the admin product details page.
ceon URLs is most likely to be the culprit.Quote:
Originally Posted by mikebr
We use all the others ourselves, but we keep well away from all these so-called SEO modules. In general, they do more harm than good and have ZERO influence on Search Engine results.
This is weird. A few weeks ago I installed EP and it went well. I was able to download my current products at that time and today was finally about to upload some new ones. Problem is, I no longer see EP under Admin-Tools nor under Admin-Configuration.
I checked with my FTP program and all the files were in place. I typed in the browser "...adminxx/easypopulate.php?langer=install" and got the denied.php message. (Same thing after I later tried "langer=remove.") I tried installing the SQL patch and was told they are duplicate tables. I deleted the mod's files and then re-installed them and still did not see it under Admin-Tools.
Now I don't know what to do. There were no Uninstall instructions per se and did not see anything here. Any ideas, please? I'm using 1.39g.
R
Hello
i got some error in my easy populate
Warning: fopen(/home/myweb/public_html/tempEP/ep_debug_log.txt) [function.fopen]: failed to open stream: Permission denied in /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 222
Warning: fwrite(): supplied argument is not a valid stream resource in /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 223
Warning: fclose(): supplied argument is not a valid stream resource in /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 224
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/myweb/public_html/admin/easypopulate.php on line 853
Warning: Cannot modify header information - headers already sent by (output started at /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php:222) in /home/myweb/public_html/admin/easypopulate.php on line 1201
Warning: Cannot modify header information - headers already sent by (output started at /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php:222) in /home/myweb/public_html/admin/easypopulate.php on line 1202
Warning: Cannot modify header information - headers already sent by (output started at /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php:222) in /home/myweb/public_html/admin/easypopulate.php on line 1206
Warning: Cannot modify header information - headers already sent by (output started at /home/myweb/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php:222) in /home/myweb/public_html/admin/easypopulate.php on line 1210
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_last_modified,v_specials_expires_date, v_products_price,v_products_weight,v_last_modified,v_date_added,v_products_quant ity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_na me_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_na me_7,v_categories_name_8,v_categories_name_9,v_categories_name_10,v_tax_class_ti tle,v_status,v_product_is_always_free_shipping,"v_ product_is_call",v_metatags_products_name_status,v_metatags_title_status,v_metat ags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metat ags_title_1,v_metatags_keywords_1,v_metatags_description_1
How can i fix it???
Thank you!!
Quote:
Originally Posted by Rob-adrenalfuel
I have same exactly problem, any suggest?
I USED new verison 1.3.9 ,have the problem and swich to old one 1.2.5.4 under new Zencart 1.3.9.
please help, I do not want upload the product one by one.
I believe this is an SSL issue. Do you have your store admin configured to be all SSL? If so, turn that off and see if that fixes the issue.Quote:
Originally Posted by bluejewelry
You would do this in your config.php in the admin\includes folder.
There is a fix for this, but I can't for the life of me remember just where that is.
thanks, I tried, but I find my SSL are turned off already.Quote:
Originally Posted by chadderuski
Any suggest???please!!!!Quote:
Originally Posted by bluejewelry
Sending you a pm...Quote:
Originally Posted by bluejewelry
Hi Chadderuski,Quote:
Originally Posted by chadderuski
I had the opportunity to test and here are my inputs:
1. categories and subcategories in on cell is very efficient... VERY COOL
2. I made a test run - my sites' default language is Hebrew... Once I uploaded using EP4, the category name on both, the English and Hebrew appeared as a number and not the category name. The subcategories appeared with the Hebrew name on both the English and Hebrew section..
Could you please advise,
Eran
come on , please there must have someone can help me out here.Quote:
Originally Posted by bluejewelry
I am trying to upload a huge product csv with Easy Populate 1.2.5.4 for Zen Cart 1.3.9h. I have a few issues. My csv file has over 140,000 rows. Columns are separated by |(vertical line) instead of commas, the product titles are longer than 64 & contains # () and the description contains commas.
Is there any hope for me to import this file?
Hi Eran!Quote:
Originally Posted by eranariel
I have a major update I'm pushing to github soon, although I haven't fixed every multi-lingual issue yet. Did you define your category languages for both english and hebrew in your original Full import?
Are you using attributes import yet? I need to fix some code here also for multiple languages.
Yes, the script is not quite complete when importing multiple-language categories (it's rather complex!). But! You can use the "Categories Only" option to first export, assign your languages (and meta tags) and then upload. ONE IMPORTANT caveat is that you don't change any categories IN STORE. The Categories Only option works on the categories ID so if you change things in store between export/import you may have unpredictable results.
Send me a PM with your email and I'll work with you more closely off site.
-chadd
Yes, there is hope, but you'll need to do a few things. First, you'll need OpenOffice (it's free). When you open the CSV file with OO, you'll have the option to select "Other" ... here you'll put your pipe character.Quote:
Originally Posted by SeeingBlue
You may have to experiment with "Quoted field as text" to see if it matters. Also, you should know what character set your store is using: UTF-8, or ISO-8859-1 ... Select the correct character set on import.
Once your file's data looks okay, go to File > Save As, Select "Text CSV" and be sure to check the "Edit filter settings" box. Click "keep current format" and then set our character set, Field Delimiter to Comma, and Text delimiter to " Double-Quote.
For your product titles, you can modify the length of products_name in phpMyAdmin. Doing this will not break zencart.
I'm working on a new version (EP 4 beta) that you can get from github. Please send me a pm with your email so I can let you know when I've posted the next update (tonight or tomorrow, time permitting). I have been working with a site with 900,000 products and have done a lot of optimizing and also added a feature that lets you split your CSV files prior to import. This makes importing much simpler, and you can adjust your import files to work with your host so you don't get time-out from the long processing time. I also fixed some bad logic in 1.2.5.4 that made large imports cumbersome even though langer had some code in there for splitting import files...
On the site in question, I broke those down into 50,000 import files which were completing import in about 250 seconds on their hefty VPS. You may need smaller break points.
Please send PM with your email so I can let you know when I get the update posted to github. Shouldn't take me too long.
-chadd
Did you get my PM?Quote:
Originally Posted by bluejewelry
Has anyone set up a cron to use with Easy Populate to auto update? Would love to hear if youve been successful and if you have any tips. I cant seem to reach the developer of the original Easy Populate. Also, does anyone know what the difference was in auto populate and auto populate advanced 3.0?
I have set up cron job to auto update the stock - based on Easy Populate. However because it is running as a cron you have to remove quite a lot of stuff (all the d/load stuff for a start). Also because it is running as a Cron, none of the built in security stuff is applicable (application_top etc).Quote:
Originally Posted by makenoiz
I ended up rewriting the whole thing to get it working properly (cut and pasting large chunks). Thre result is quite good - my client just uploads a stock file (via ftp) and the cron runs every hour to check for a new file, and if there is one, it uploads it all to the datbase.
A lot of things had to be hard coded though. Removing the program from the ZenCart framework means that you have to explicitly include the bits you need (like database access, tax functions etc).
Hope this helps point you in the right direction.
Forgive me if this has already been asked and answered, but I have been reading for a couple of hours and am still a little confused.
What is the differecne between EP 1.2.5.4 and EP 4.0? Do they work with each other or are is 4.0 an updated/rewritten 1.2.5.4 or what?
I am setting up a Zencart site for my sister in law and she is not web savvy and need a relatively simple way to add and remove products.
Thanks
Tom
Hi Tom,Quote:
Originally Posted by agile4
EP 1.2.5.4 is a port from OsCommerce's version by Langer. Many people have modded and tweaked it with varying degrees of success and failure with the end result of falling back to 1.2.5.4
EP 2.x ( hard to find :P ) Was an attempt to rewrite/update EP, but is considered very faulty. Don't use it.
EP 3.0.3 'Advanced' was Langer's attempt to commercialize his improved version. It can still be had, but Langer has not been seen for years now.
EP 4.0 Beta is my work. I have put much effort into cleaning up and improving the code, completely rewriting much of it. Much effort was put into improving it's performance so it can be used on any platform. RECENTLY tested on a store with 900,000 sku's.
It has been been separated from the 1.2.5.4 code and installs it's own configuration keys so you can actually have both 4.0 and 1.2.5.4 installed.
HOWEVER!! The files from EP 4 and 1.2.5.4 are no longer compatible. I have rewritten category importing and added many fields that 1.2.5.4 can't handle. It should be considered it's own product.
It's still "Beta" because it's not completely done to my standards. The most recent update at github has many fixes (centered mostly around multi-lingual stores).
Once caveat: Use OpenOffice to make your CSV files. Better cross platform compatibility. Excel sort of does it's own thing (that's MicroSoft for ya), and I haven't had a chance to sort things out for all the versions since DOS. OpenOffice also lets you PICK your language. UTF-8, ISO 8859-1, etc. Very useful for foreign language stores.
I do not have a complete set of Doc/How-To's but have detailed important things to know like you MUST used Products Model # and they should be unique.
I also have rudimentary attribute importing working, but this needs more work and features to be truly useful. AS IS, you can create your attributes and options name and apply them to your products (even multiple attributes per product) at upload. Attributes must be applied AFTER you have created a product.
You can get it at github here:
https://github.com/chaddro/EasyPopulate-4.0
You'll see a ZIP button. Be sure to also install Dr. Byte's MySQL backup tool. You'll always want to backup your store before doing imports (no matter what version you use).
OH! Before I forget. EP 4.0 is now compatible with Zencart 1.5!
-chadd
PS. I'd be remiss in not mentioning Apsona ShopAdmin. This is a paid product that has received many positive comments. I have not reviewed it myself, so I don't know if it can do things like import attributes, or quantity discounts like EP 4.
Thanks Chadd,
I just installed it and at was a piece of cake.
The only issue I have is that I can not download the export file from inside of ZC. I get a permissions error. I have the temp directory in my admin/temp folder. The folder is set to 0755 but the .cvs files are created as 0644. Not sure how to fix this, but I'm sure it;s covered somewhere in the thread, so I'll do a search in a few.
Thanks again.
Tom
For now, I moved the /temp/ folder out of the admin folder and it fixed the download issue. Tomorrow, I'll try recreating it with a different method in the admin area to see if that works
Thanks
Hi Agile,Quote:
Originally Posted by agile4
I now have a dedicated support thread for EasyPopulate 4.0:
http://www.zen-cart.com/forum/showthread.php?t=190417
In order to put your move your temp folder into your admin, you will have to add an .htaccess file and add the allowed file types as .csv and .txt (in the even you get an error log from EP4).
I know that works for 1.3.9. I haven't tested it under 1.5.
I am having this same issue. Has anyone figured out what needs to be done to fix this? Would greatly appreciate any help. :unsure:Quote:
Originally Posted by Rob-adrenalfuel
Thanks
chadderuski,
I am wondering if this has been mentioned before, line 206 in easypopulate.php for zen cart 1.5 suppose to be <?php instead of <?.
I was getting this
'; echo 'Upload Directory: '.$tempdir.'
'; echo 'Verbose Feedback: '.(($ep_feedback) ? "TRUE":"FALSE").'
'; echo 'Split Records: '.$ep_split_records.'
'; echo 'Execution Time: '.$ep_execution.'
'; echo '
Custom Products Fields
'; echo 'Product Short Descriptions: '.(($ep_supported_mods['psd']) ? "TRUE":"FALSE").'
'; echo 'Product Unit of Measure: '.(($ep_supported_mods['uom']) ? "TRUE":"FALSE").'
'; echo 'Product UPC Code: '.(($ep_supported_mods['upc']) ? "TRUE":"FALSE").'
'; // Google Product Category for Google Merchant Center echo 'Google Product Category: '.(($ep_supported_mods['gpc']) ? "TRUE":"FALSE").'
'; echo '
Installed Languages
'; foreach ($langcode as $key => $lang) { echo $lang['id'].'-'.$lang['code'].': '.$lang['name'].'
'; } echo 'Default Language: '. $epdlanguage_id .'-'. $epdlanguage_name.'
'; echo '
Until i noticed that and made the change.
I am using Easy Populate 4.0.17 - Beta 12-24-2011
Hi TamyA!Quote:
Originally Posted by TamyA
I have a dedicated support thread for EP 4 here:
http://www.zen-cart.com/forum/showthread.php?t=190417
In answer to your question, <? is a php short tag. It is not "wrong" per say, but it would be better if I didn't use them. Some server configurations may not recognize the tag. Thanks for the heads up. I'll fix it in the next update.
Can someone please help me...
I am having trouble uploading my data sheets. I have tried everything! To Start I know its not my data. I am uploading a copy of Complete Catalog from Easy Populate with all but 1 record stripped out.
When I upload it it spins for about 3 minutes and returns like its trying to hit my back end again but the page looks like the front end (And its blank with my sites template)
DOMAIN/admin/easypopulate.php?split=0
If I refresh or click on the URL and hit enter it goes back to easy populate but nothing is updated.
I am running:
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
If cvs file size too big can't do it?
http://www.mysite.com/my_hidden_admi...langer=install
Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.
File Full-EP2012Jan16-1503.txt successfully exported! The file is ready for download in your /temp/ directory.
I can't find Easy Populate in my admin tools area.
Easy Populate 1.2.5.4
ZC 1.5
EP 1.2.5.4 will not work with ZC 1.5.Quote:
Originally Posted by hiddensecurity
Try EP 4.0 Beta.
Can you provide a link to that thread?:smile:
http://www.zen-cart.com/forum/showthread.php?t=190417Quote:
Originally Posted by hiddensecurity
Just found it.
Anybody can explain an easy simple way to insert a link into the admin menu without being rocket scientist to add a new addon?
I try to install an Excel populate addon but seems to be easier to forget the 1.5 and just stuck with 1.3.9....
Regards,
Joe
Hi
I import large amounts of new products into my database with this version of EP. All of the products get uploaded to a single 'Upcoming Products' category, and only have name, short description, price and stock information on it.
However, for some reason, EP assigns random manufacturers to the products I upload. I then have to re-download the full EP, and delete the wrongly assigned manufacturers (this only happens with the 'Upcoming Products' category).
How can I solve this, and should I update to EP 4 beta?
Thanks
I have the 1.5 version of my ep contribution ready and will upload to downloads section this weekend. Seems to do everything cleanly if you have problems please pm meits easier
There are few ideas that help here:Quote:
Originally Posted by gamesmart
1) Remember to make new categories by hand in the admin when using more than one language BEFORE uploading new EP file
2) If you didn't remember to do (1), remove ONLY that category that is a problematic one, create it again (and then you can add also other language names at once) and update the site again with your EP file
OR
3) you can go to the Dr.Byte solution to remove the problematic language by taking first a "backup" of the products with EP, then saving somewhere all the category names you already have in the problematic language (if you have plenty of categories, it is faster to create them again by copy-pasting the names rather than re-inventing them) and then removing the problematic language in Localization -> Languages and adding it back. It will get all the product content from the working default language, so check you have all categories existing now (count the amount if many) and then upload again the EP backup file and you get all your products in that language back too. Then you still need to copy-paste the category names back to your previously problematic language.
Before trying the number 3, check if the solutions 1 or 2 helps you since those are fast to test.
Hello,
I'm trying to upload 2 languages (english and french) is there any way to do it?
I tried to upload just the english names, and it's working, but then both in the admin and the cart there are no product in french, just english.
Thanks
Hello all, I am attempting to use EP for the first time. everything loaded correctly( i think) when I attempt to import data, i do not get any error messages. but I do not see any products.
Should i change the permissions on my DB or add the categories first?
any help is appreciated
When I use Easy Populate to import products. The following fields go into the db as "0", They should go in as "1".
products_quantity_order_min
products_quantity_order_units
products_qty_box_status
products_quantity_mixed
products_mixed_discount_quantity
Do you have any suggestions?
Thanks
I need help, I've installed the newest version for my fresh install of 1.5, I can't get any Admin Boxes to show up in Configuration or Tools menu?? The page shows up when I type the Easy Populate admin page directly into the address bar, the one that lets you upload or download the files from /temp/
but it won't show in the drop down menu's. I'm a co-admin so I need it for others to use easily, otherwise I'd do it manually every time. I've tried the removal...
easypopulate.php?langer=remove
....it won't let me, tells me I need to "install, click here", every time I try... I do click "here" and it does the "Successfully installed.." etc... but it is allready installed, and if I try the uninstall again it just does it again and again.... I've tried to Re-Install all the files, that doesn't work either..
I tried to install the SQL thru copy/pasting it in the SQL tool in the admin. Everything! Any way to completely uninstall everything manually (especially the database stuff) other than the easypopulate.php?langer=remove that I've allready tried? I really just want to start over!! Or something...
Thanks
Before you go too far, I'd switch to Chadderuskies EP 4
https://github.com/chaddro/EasyPopulate-4.0
It's a great improvement over 1.2.5.4
Nick
Hi!
I am guessing this is the right area to ask questions about Easy Popluate...
I am trying to install Easy Populate but don't know where to put all the folders in. Below are the steps I took...
My Zencart : v1.5.0
Ezpopulate: 1.2.5.4
FTP program: Filezilla
1. I unzipped the files, renamed the admin file to EzpopAdmin.
2. Uploaded the temp file to the root directory (/) of zencart.
3. Uploaded the EzpopAdmin folder in entirety to admin... means... /-admin-EzpopAdmin
4. I realized perhaps that's wrong so, then deleted the EzpopAdmin folder and tried to uploaded just the files namely, includes and easypopulate.php. But I am a bit scared since the original admin folder already has an includes folder. Will the Ezpopulate one overwrite it?
Also where do I put install_sql, license, readme, history, install etc files that are left over? In the Root directory (/) or some other folder.
Sorry, I don't know much about such stuff... I did however upload a template successfully... so perhaps there is hope for me yet.
Thank you beforehand...
:ohmy:First off, you just made some hackers day. Never post your admin folders name here or anywhere else.:no:Quote:
Originally Posted by nftgrt
If you rename the folder exactly as your admin folder is named, then just upload the folder. Nothing will be overwritten, the files are just added to the correct location within your admin. If you mispelled it, then delete the mispelled folder and try again.
Also where do I put install_sql, license, readme, history, install etc files that are left over? In the Root directory (/) or some other folder.
Sorry, I don't know much about such stuff... I did however upload a template successfully... so perhaps there is hope for me yet.
Thank you beforehand...[/quote]
They are just FYI so you can keep them or trash them. I would suggest you keep them if you need some info later, but not on your site.
Does this version of Easy Populate work with the new 1.5 zencart? If not, that could explain some problems.
Have not used this version for some years now.
sph
www.prommart.com
www.fashion-mart.biz
Does anybody have an example of a populated sample file that you that can be imported. my file is not populating my DB and i cant tell why.
I'm no expert on Zen-Cart modules/programming/etc, but when I install a module I can READ if the module is compatible for 1.3.8, 1.3.9 or 1.5. That's not only for this mod, also many people just go ahead and install Image Handler and Super Orders... :blink:Quote:
Originally Posted by SPH
It surprises me that so many people just go ahead and install the modules without reading the info and support threads (at least, thats what it looks like to me).
When a module says it's compatible for 1.3.9, why install it on ZC1.5?!?! Many threads and post indicate that many modules are worked on the make them compatible for ZC1.5
Again, I'm not an expert, but if I just read I can see that ZC1.5 has a more tightened system to register add-ons and that there are many security improvements. So many moules need to be adapted to that. Thats why all the developers need time to upgrade their add-ons which they do in their free-time since many of us want free add-ons!
So please READ and if you are waiting for 1.5 modules to be upgraded, please be PATIENT and give the developers time to make them work and test... I think they go crazy by reading al those posts about people who don't 1.3.9 modules get to work with ZC1.5... :bangin:
Sorry, but I had to say this. No means to upset anyone...:hug: It's not just SPH since he's one of many ;) But as I said, this is going on with many modules.
As others say; Happy Zenning!! :smile:
No, it's not me. As I said, I haven't used this version of EP for several years. I was replying to those having problems with it on 1.5...suggesting it's not compatible.Quote:
Originally Posted by Gerjan
I know how to read the forums and module info, thanks.
:oops: In your case; my apologies! I thought it meant it could explain some problems that you encountered :hug:Quote:
Originally Posted by SPH
Funny, as I just asked the same request at the Prestashop forum the other day as I want to get in to that cart in addition to zencart. Someone did give me a sample.Quote:
Originally Posted by wagnerguy
I'd return the favor for you, but have not used this version of EP for several years now. And if we're going to upgrade to the new 1.5 zencart, apparently only current option is the new EP4, which I use in conjunction with another EP, the one that allows addition of additional upload fields via the zencart admin. (I think that's the Easy Populate 1.3.9GP.e, apparently not compatible with 1.5)
sph
www.prommart.com
www.fashion-mart.biz
No problem, thanks!Quote:
Originally Posted by Gerjan
no problem.. one thing, do i need to add the categories to the import file? everything else is thereQuote:
Originally Posted by SPH
So, has easy populate always overridden the status column and i'm just now noticing or am i uploading something incorrectly?
If you are still using EP 1.2.5.4 then my tutorial may help:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
"Any fields left blank (NULL) will not always retain the current data in your store. Best to delete unneeded columns, and use original store data as updates template"Quote:
Originally Posted by schoolboy
is that what you're speaking of? i only upload 2 columns, model and quantity, to keep our store synced with our accounting software (we do a lot of off-line phone and purchase orders too) which is run about twice a day. it's kind of obnoxious having to deactivate certain items every time. or do non-listed columns get affected anyway?
will EP 4 beta solve this problem? i guess i may as well test locally to find out....
I use EP4 in conjunction with another EP. EP4 looks like our best bet for upgrading to 1.5 cart. He is still working on the attributes function, though.Quote:
Originally Posted by apogeerockets
EP4 works flawlessly for me re the products function. And one thing I really like about it: you can download by category. Meaning that when you download your products, you do not have to download them all. Very nice touch.
Is the EP 1.2.5.4 in the works to be upgraded to 1.5? Just wondering, as I have not used this version for years.
sph
www.prommart.com
www.prom-mart.com
test area
Probably not. EP4 will assume the mantle going forward.Quote:
Originally Posted by SPH
My only issue with EP4 is that it favours CSV over tab-delimited, and that's why I don't use it. When product descriptions are full of commas, and possibly the odd quote mark, it risks throwing the load file into total disarray.
Tab-delimiting is far more robust and error-resistant, and makes for a much easier conversion from spreadsheet to txt format (one of Langer's original reasons for choosing it).
I haven't run into problems yet, knock on wood. But will keep an eye on it.
sph
www.prom-mart.com
Ecommerce Cart Test area
Hi fairestcape!Quote:
Originally Posted by fairestcape
Actually, there are provisions in the EP4 for using tab-delimited files. If you look at the first few lines of easypopulate_4.php, you'll see this. Note that I am using php's fgetcsv() function to read data from the input file. fgetcsv() is not perfect, but it is so much faster and less convoluted than langer's code. Feel free to experiment!
The main issues with fgetcsv() is that the CSV file must be properly formatted. OpenOffice does this correctly, but Excel is finicky depending on the platform (mac/pc) and version you are using.
-chadd
Let's keep discussion of EP4 in the EP4 thread, please.
I just installed EP4 and manually inputted a single product to copy formatting for other products.
When I downloaded the products file, the product wasn't in the file. I added a few products to the file from memory and then uploaded them.
The new products didn't load into zen cart, but when I download the file again the new products, but tnot the original were int he scv file.
Did I do something wrong in the install?
Also I would like to have my site in multiple languages, is there a possible additional descriptions that I can load with ep?
Thank you.
Andi
I'll continue with this on the EP4 thread, but do have a comment on the above, that is relevant to 1,2,5,4Quote:
Originally Posted by chadderuski
We only discovered this a short while ago, but it is very effective in "by-passing" the fussiness of Excel, and the inststence of Excel in saving .txt formats its own way.
This is what we do...
(We use CRIMSON EDITOR as our PLAIN TEXT EDITOR in matters of code editing, etc. So if you want to use our method of creating the tab-delimited TXT file that EP 1.2.5.4 requires, out of an Excel spreadsheet, then go and get CRIMSON EDITOR and install it.)
STEP ONE
Create your initial spreadsheet in MS Excel, using the columns relevant to your data import needs.
STEP TWO
SAVE this as a MS Excel spreadsheet... NOT as a TXT file.
STEP THREE
OPEN Crimson Editor
STEP FOUR
Toggle back to the MS Excel spreadsheet and HIGHLIGHT all the data. CTRL+C (copy) it to computer clipboard.
STEP FIVE
Toggle to Crimson Editor and CTRL+V (paste) clipboard contents.
You now have a "perfect", tab delimited file, which you just need to save as a .txt file.
its give me seccurity error and got mesage "Please contact administrator "
You need to desribe what you did FIRST... How are we supposed to know what ause it to do this?Quote:
Originally Posted by ludoto93
What were you doing BEFORE it ame up with this message?
i fix it but i dont know how to add products now ? example my categorie id is 150 then how to add 10 products same time there?Quote:
Originally Posted by schoolboy
I am am SUPER new to zen cart and easypopulate.
May I know if easypopulate 1.2.5.4 is still working with zen-cart 1.5?
Or I must now use EP 4.0?
Please help me!!! Thank you very much.
You should use EP ver 4 with ZC 1.5Quote:
Originally Posted by hanming
NO admin > Tools > "Easy Populate" button
None in "admin >configuration" either
Installed zen cart v1.5.0
Installed ez populate easypopulate-shafiqv1-2-5-6
NO button
Installed right over previous install ep_v1.2.5.4
NO Button
Easy Populate works using:
h ttp://mysite.com/admin-directory/easypopulate.php?langer=install
(space added to stop this system from amking it a linkl)
When I run it there is a green message at the top of the screen which says:
Installation Successfull! A full download of you store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.
Success File Full-EP2012May11-1111.txt successfully exported! The file is ready for download in your /temp/ directory.
I have installed Easy Populate on another zen cart before.
Am I doing something wrong?
Is it OK to use it without the button.
Quote:
Originally Posted by larryweiss
I have this very same issue. can any1 help?
Use this following query in mysql. you will have the ez-populate under tools.Quote:
Originally Posted by panelcart
INSERT INTO `admin_pages` (`page_key`, `language_key`, `main_page`, `page_params`, `menu_key`, `display_on_menu`, `sort_order`) VALUES
('ezpopulate', 'BOX_TOOLS_EASYPOPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', 150);
Thanks for the help.!Quote:
Originally Posted by Balaji
I'm not sure if it is fully working with it right now..... Some confirm this!Quote:
Originally Posted by hanming
Almost all the earlier version modules works in zen 1.5 which are not having boxes defined in admin. For box definitions you need to use admin>admin access management>admin page registration. So the easy populate too.
That worked - now how do I add the settings to the configuration menu??Quote:
Originally Posted by Balaji
Thanks
Matt
My plan is to upload stock received to admin via EP but ADD to current stock quantity when uploading.
Three columns:
1. v_products_id
2. v_products_model
3. v_products_quantity
At my line 1561 a query selects the current contents...
$sql = "SELECT
p.products_quantity as v_products_quantity,
I see in my line 1980 this...
$query = "UPDATE " . TABLE_PRODUCTS . " SET
products_quantity = '" . zen_db_input($v_products_quantity) . "' ,
In order to do this, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "'
Have you tried this?Quote:
In order to do this, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "'
I can't really test it, but i'm thinking it might be more like this:
orPHP Code:
zen_db_input($v_products_quantity + $row['p.products_quantity'])
Seems like it would be better to accomplish this at the spreadsheet level.PHP Code:
// Put Higher up in code
$existing_qty = $row['p.products_quantity'];
// Then in Statement
zen_db_input($v_products_quantity + $existing_qty)
In order to add to products_quantity, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "'
Thanks dj,Quote:
Originally Posted by djdavedawson
All 3 suggestions - my 1 and your 2 all overwrite the products_quantity, testing each a couple times to make sure.
What is missing?
At my line 1551, I see that there is a query to get the record's current contents which selects p.products_quantity as v_products_quantity - so it should be drawing current qty and adding the incoming v_ quantity.
I know this may be redundant but try this.
If that doesn't work try this to make sure you're even in the right spot.PHP Code:
// Put Higher up in code
$combined_qty = ($v_products_quantity + $row['p.products_quantity']);
// Then in Statement
zen_db_input($combined_qty)
PHP Code:
zen_db_input(($v_products_quantity + 1))
dj,Quote:
// Put Higher up in code
$combined_qty = ($v_products_quantity + $row['p.products_quantity']);
// Then in Statement
zen_db_input($combined_qty)
Definitely in the right direction. It did overwrite again, but when changing the variable $combined_qty to
it did just that, starting with a qty of 5 in the upload and added 1 for a total of 6. So it is working. For some reason it's not grabbing the current p.products_quantity and adding, it's only taking the v_products_quantity from the upload.PHP Code:$combined_qty = ($v_products_quantity + 1);
How about this?
PHP Code:
$combined_qty = ($v_products_quantity + $row['v_products_quantity']);
strange. still overwriting.
I tried this too.
I assume since the sql select statement is pulling the data appropriately it should work. But what if the current data is not recognizable as it wants to overwrite p.products_quantity with v_products_quantity. Seems like it is not possible to draw current products_quantity with Easy Populate?PHP Code:$combined_qty = ($v_products_quantity + $row['products_quantity']);
What happens when you do this?
Find this around 1456:
Replace With this:PHP Code:
while ($row){
$product_is_new = false;
Then in your statement around line 1962PHP Code:while ($row){
$product_is_new = false;
$existing_qty = $row['v_products_quantity'];
PHP Code:products_quantity="' . zen_db_input(zen_db_input($v_products_quantity + $existing_qty)
AHA - searching for an existing product!
It looks like we have a winner - thank you dj!
In conclusion, if someone wants to use Easy Populate to mass upload received product (saves us up to 30 minutes per order received)
A. download current quantities. (we have 2 custom fields as well - order point and order quantity - then excel formula what needs to be ordered. I also disregard the formula if doing custom ordering)
B. strip down to 3 columns - v_products_id v_products_model v_products_quantity
C. Save csv for when product arrives.
D. Receive product, make sure you received what is on your csv
E. Upload csv
Use the following code in EP
Find this around 1456:
Replace With this:PHP Code:while ($row){
$product_is_new = false;
Then in your statement around line 1962PHP Code:while ($row){
$product_is_new = false;
$existing_qty = $row['v_products_quantity'];
PHP Code:products_quantity="' . zen_db_input(zen_db_input($v_products_quantity + $existing_qty)
You're welcome. :)
Be sure to backup backup and test test test before you rely on this.
I do this kind of thing in excel using vlookup with absolute table refs from one worksheet to another and adding the values all in one column.
Then I just copy the column and 'paste values' right on the of the outputs.
~D
Hello guys, i have an issue and i was wondering if this code will work for my situation. I have an .xls sheet with all my innovatory, fields are like this: Product unique name, product ID, product price, product description, product size (and quantities for that size). Write now i am adding sizes and quantities for each product manually in the data base. I have a lot of products, so naturally its taking me a while to do that. I would like to use some kind of a script that can read product id, product sizes for that id, and product quantities for those sizes, and then export everything in to data base. I have been struggling with this for a week now, any help would be appreciated.
I just installed Easy populate and renamed the admin folder to match my admin folder. When I go to tools there is no Easy Populate option, can someone help me out ?
thanks
is there a uninstall sql or can someone make me one to uninstall all the past versions of easy populate?
The "Download Model/Attributes .csv file " and using it to upload the new product attributes work wonderfully. Unfortunately, it doesn't seem to support the "attribute plus weight," like it does the plus price. Is there something I am missing? I have searched the forums but find no one else needing this. Any assistance would be greatly appreciated!!
Why can i download everything except my products (by name)?
Becasue I had the wrong version. Sorted now.Quote:
Originally Posted by Pretty dumb
I am going to put this out there for conversation. From my view, Easy populate for ZC is no longer user friendly and strictly relevant to coders. I built a few websites using ZC 2 years ago and it was great, but right now I am searching for something else. If you are not a DB guy/girl and do not have a way to bulk upload/download product information, it is worthless.
hi all
how can i download a single product from zen cart using easy populate i have try but i have dowload the etire folder (for 200 products) i have finnised the modifications but i wanna try the upload with a single products iff sommetings goo wrong iff you know what i meen :))
iff sommebody can help me thx
I can tell you that from looking at Opencart and Prestashop, their equalivents of Easypopulate look much more user UN-friendly, harder to use. Just one look at their spreadsheets and the headings was enough. This is probably the main reason I haven't taken either of these other carts to a live domain.Quote:
Originally Posted by russa2
That and that Zencart now appears to have a much better selection of free templates...and great plugins that in many cases surpass, IMO, those built-in in other carts.
What version of ZC are you using and have you looked at Easy Populate 4 for 1.5.0/1.5.1? I also understand that an earlier version of EP we've successfully used in the past is now 1.5.0 ready.
I don't know that you can download a single product with any EasyPopulate version. However, with EasyPopulate 4 you can download a single category.Quote:
Originally Posted by IOAN
But if all you want is a single product, why not just edit it in the admin?
Am running into a problem with EP 1.2.5.4 (zc - 1.5)
I've got a database which manages our products, and we've created a dozen or so attribute names, each attribute having anywhere from 2 or 3, up to 20 values.
The database export handles this to a .mer which is converted to a CVS (.txt), for upload & maintenance.
Normally, we open EP, and grab the models/attributes template, which we then can correlate correct field relationships TO, in our database.
We ran into a problem this week, when we added 6 more attribute names and about 15 more values for them, then needed to get the new template, for cross-relating....
When I click the Models/Attributes button (to get a sample), the site runs.....and runs..............and runs.. Eventually it either "glitches" or does something else--but in fact, it reloads the FRONT SIDE page to the site...
I've attempted this on numerous browsers, platforms, have set the retry/timeout settings on browsers out to 5-10 minutes... All to no avaiil.
The window shows the "processing" icon (spinning gear) for right about 3 minutes, then reloads our main front page...
I have tried numerous other ideas - - have monitored the /temp folder to see if iit produces anything, but nothing.....
Any thoughts?
On a parallel note:I would love to move to EP4, but the file format is entirely different (a many-to-many relationship, vs a 1-to-many relationship, where each product has a single entry with all attributes ID'd by # and by price fields)... Is there a way in EP4 to get the same template downloadd, which shows field names?? OR, can EP4 be set up to use the same format as EP 1.2.5.x (ie one record/product per row, with all attributes in that record)?
Does anyone know how I can add the size to a product (clothing business) and then add it to the export file of Easy Populate ?
My distributors will give me periodic .csv files to upload for stock updating and I need to give them in the exported file the : model or product name, size (s,m,l,xl), price and quantity. When they give me back the .csv, products that are 0 qty should be made inactive.
I'd really appreciate the help.
Thanks in advance.