♥geoffreywalton Posted December 30, 2012 Share Posted December 30, 2012 latest stable version of easypopulate. @@cruzing Eli try this http://addons.oscommerce.com/category?search=Easypopulate&v=23 is there a difference between easypopulate and excel populate ? Yes Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
cruzing Posted January 4, 2013 Share Posted January 4, 2013 (edited) repost from general add-ons EP vers: 2.77a-2.3.1 osCommerce Online Merchant v2.3 OS: Array HTTP: DB: PHP: Array (Zend: ) Temp Directory: /home1/ecvariet/public_html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false Other Support: MVS Support: false Additional Images: false More Pics: false UltraPics Pics: false Unlimited Images: false HTC: false SPPC: false Extra Fields: true PDF Upload: false Quick Backup Enabled: true I've been looking for a solution for three days and need help.Doing a lot of reading and maybe it's just me. I can use easy populate with no issue except I can't get an image linked to a product. Below are where original images are: http://www.xxxxxxxy.com/images/microsoft/intkeyboardps2.gif.......... these show fine under file manager dir=/public_html/images/microsoft/...... uploaded images file via ftp to dir=/public_htm;/images/HonestGreen/....these don't show http://www.xxxxxxxx.com/images/HonestGreen_Images/0116343.jpg I go into categories/products and update image(and see image) but nothing updates. Can someone Please point me in the right direction Thank You Edited January 4, 2013 by cruzing Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 4, 2013 Share Posted January 4, 2013 You say that you're uploading the images to /images/HonestGreen/, but you're looking for the images in /images/HonestGreen_Images/. See the difference? Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
cruzing Posted January 4, 2013 Share Posted January 4, 2013 it's often said that the solution "is at the tip of our nose"but we fail to recognize it.if've read this before" You say that you're uploading the images to /images/HonestGreen/, but you're looking for the images in /images/HonestGreen_Images/. See the difference?" I just never thought that was the issue, I would have never found it. Jim Thank you . Quote Link to comment Share on other sites More sharing options...
Benjjj6 Posted January 10, 2013 Share Posted January 10, 2013 Could someone please explain the difference between: Normal Add New Only Update Only Delete Only Surprisingly I can not find out the difference between these in the documentation. Many thanks Ben Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 11, 2013 Share Posted January 11, 2013 Ben It is fairly self explanatory bt here is a starter for you Normal - Insert or update Add New Only Insert only Update Only Delete Only Cheers G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Procella Posted January 20, 2013 Share Posted January 20, 2013 I have been googling, reading posts, and tering my hair out over this problem: I have a problem with export/import using EP. when i export my products, all is fine. The text i enter in my admin, looks just fine in the csv file. But importing it again (after correcting prices etc.), all text after danish letter æøå/ÆØÅ (nor does thee letter) does not get imported. Using html-encoding (ø æ å) it seems to work fine. PHPMyAdmin says my DB is using utf8_danish_ci . My languagefiles use UTF8 (dansk.php). Are there any files that i have missed perhaps? And is there a difference to utf8_danish_ci and utf8_general_ci, and the definition on my languagefile: da_DK.utf8 Should they be named exactly the same? Quote Timo Jensen Link to comment Share on other sites More sharing options...
asduncan Posted January 26, 2013 Share Posted January 26, 2013 I have tried hard to solve this problem but have reached the end. Running osCmax v2.5.2 which has EasyPopulate already installed. The new products are not added to the store. Have changed the temp directory permissions to 777 * downloaded the complete .csv file * only have 1 product in my store, copied the line, changed the model number and one word in v_products_name_1; * uploaded the file (which has been saved as csv) and get the following message:- File uploaded. Temporary filename: /tmp/php3KSrms User filename: EP2013Jan24-0404.csv Size: 13389 Nothing else and when I check the store products the new products are not added. The files are getting save successfully in /temp Deleted the files in /temp tried again, same issue Tried saving the file as comma delimited, same issue Add a third product to the file, using the same method (copying the row), same issue (the size info did change which is what I would expect) I have read through easyconfig. I did note in the config.php I couldn't see the line:- define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/'); so I added this. Same issue as above. My category is Products: A to Z - tried removing the : - same issue. New products are not being added to the store. Quote Link to comment Share on other sites More sharing options...
PupStar Posted January 26, 2013 Share Posted January 26, 2013 I have tried hard to solve this problem but have reached the end. Running osCmax v2.5.2 which has EasyPopulate already installed. The new products are not added to the store. Have changed the temp directory permissions to 777 * downloaded the complete .csv file * only have 1 product in my store, copied the line, changed the model number and one word in v_products_name_1; * uploaded the file (which has been saved as csv) and get the following message:- File uploaded. Temporary filename: /tmp/php3KSrms User filename: EP2013Jan24-0404.csv Size: 13389 Nothing else and when I check the store products the new products are not added. The files are getting save successfully in /temp Deleted the files in /temp tried again, same issue Tried saving the file as comma delimited, same issue Add a third product to the file, using the same method (copying the row), same issue (the size info did change which is what I would expect) I have read through easyconfig. I did note in the config.php I couldn't see the line:- define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/'); so I added this. Same issue as above. My category is Products: A to Z - tried removing the : - same issue. New products are not being added to the store. oscmax is a fork and is not support on this forum. Try posting your question with them. Quote Link to comment Share on other sites More sharing options...
Weekend_warrior1999 Posted January 27, 2013 Share Posted January 27, 2013 (edited) I am trying to figure out a way to create a cron entery that will automatically import a CVS file that is already downloaded in the temp directory, can anyone help? I know how to create a cron entry, but I'm having trouble finding exactly what to put in the entry line... I've got so far curl "username:password@websiteaddress/catalog/admin/easypopulate.php?localfile=updatefile.cvs&imputmode=Normal" but it errors out without any output I think it's gpot something to do with the fact i'm not able to supply a OSCsid for auth? any suggestions? Edited January 27, 2013 by Weekend_warrior1999 Quote Link to comment Share on other sites More sharing options...
asduncan Posted January 27, 2013 Share Posted January 27, 2013 Found the answer to my issue above. I am a MAC user so had to save the csv file as Windows CSV. Just didn't see the instructions on the left for MAC users :-( Quote Link to comment Share on other sites More sharing options...
Weekend_warrior1999 Posted January 28, 2013 Share Posted January 28, 2013 (edited) Ive sorta got a cron script work around... I'm posting to get some help. This is what I have so far. separate cron downloads EPcsv.txt then I run this: #!/bin/bashcurl -v --cookie cookies.txt --cookie-jar cookies.txt --user-agent Mozilla/4.0 --data "username=username&password=password" http://username:password@@site.com/catalog/admin/login.php?action=process sleep 10 curl -v --cookie cookies.txt --user-agent Mozilla/4.0 --data "localfile=EPcsv.txt.txt&imput_mode=Normal&buttoninsert=Insert%20into%20db" http://username:password@@site.com/catalog/admin/easypopulate.php When I run this script i get no output for the second curl statement, but if I immediately rerun the script it appears to correctly run, I get a huge output of the CSV file and the PHP/HTML output of the EP/admin area. The thing I dont understand it why it wont work on first run but seems to on second run... I placed the sleep statement to ensure the cookie is saved prior to second curl statement is ran... sorta at a loss. Edited January 28, 2013 by Weekend_warrior1999 Quote Link to comment Share on other sites More sharing options...
mlordi Posted January 31, 2013 Share Posted January 31, 2013 I am trying to figure out what I am missing and going crazy. I am running oscommerce 2.3.3 and used multiple versions of this add on and for the life of me cannot get the v_products_image field to import. It is just skipping over it like I don't have it defined in my file but I do. Is there a certain version I should be using or a code update I need to apply? Quote Link to comment Share on other sites More sharing options...
Weekend_warrior1999 Posted February 1, 2013 Share Posted February 1, 2013 on mine it imported, but you had to upload your images to (siteurl.com/catalog/images/images) Quote Link to comment Share on other sites More sharing options...
JustinS Posted February 1, 2013 Share Posted February 1, 2013 What causes easy populate to not properly place products being added in the folders that are supposed to be created when uploading the easy populate file? When I upload the easy pop file with 700 products on it, it adds about 3 or so folders each time and places some of the products in them, but the rest are just created and dumped without being in any folder at all. Any help would be greatly appreciated. Thank you. Quote Link to comment Share on other sites More sharing options...
Weekend_warrior1999 Posted February 3, 2013 Share Posted February 3, 2013 (edited) Well after several days of tinkering, I think I've got a working cron model that downloads both CSV/image files, removes old images, unarchives new images, and imports new CSV file in "Normal" mode, deactives any "out of stock" items and places generic image you already have downloaded as a category image holder, updates sitemaps, and updates google adwords. Gonna test it for a few days and if there is any interest I'll release it as a addon contrib for EP. Edited February 3, 2013 by Weekend_warrior1999 Quote Link to comment Share on other sites More sharing options...
Weekend_warrior1999 Posted February 3, 2013 Share Posted February 3, 2013 Well it appears that it still has the (if I run the script twice it correctly authenticates) Problem. Quote Link to comment Share on other sites More sharing options...
firstcapitalfirearms Posted February 28, 2013 Share Posted February 28, 2013 I just installed Easy Populate for OSC version 2.3.1 and just uploaded some items. I am switching over to OScommerce from Zen Cart because my credit card processor doesn't support ZC. Anyways in ZC when I do an upload it automatically creates the categories/sub categories but Easy Populate for OScommerce did not do that. Is there something I did wrong? Thanks Mark Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 28, 2013 Share Posted February 28, 2013 Download a file and check you are using the correct column headings. Cheers G @@firstcapitalfirearms Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
websitewendy Posted April 5, 2013 Share Posted April 5, 2013 hi, i was directed here from the main support forum so i hope this is the correct place for my inquiry. i just installed osc2.3 and easy populate 2.8 .. I'm not new to oscommerce or easy populate, but it has been a few years.. i downloaded the default product/categories csv.. removed all but one and modified that to one of my products.. tried uploading .. it says file uploaded and it is in the temp dir.. but the product is not added. i tried adding from the temp directory instance and it still does nothing. (i've tried all options.. update only etc) i made sure the /temp/ and csv in it are 777 any advice appreciated. I should note that I am on a mac and have seen weird things with excel files and macs not cooperating. and the host is godaddy Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted April 5, 2013 Share Posted April 5, 2013 (edited) @@websitewendy Take the file you downloaded and delete everything in it except the first 2 lines and import that. Use a text editor to do that not excel or other spreadsheet applicatation. If that works we are 1 step closer. Cheers G Edited April 5, 2013 by geoffreywalton Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
cruzing Posted April 12, 2013 Share Posted April 12, 2013 A little help please. I have added the upc extra field (as per below)and can upload the information but it does not show up anywhere. Also when I download a .csv file from easy populate the information is there. v_products_model v_products_upc EOREOR 1125426 2.15E+09 EOREOR What did I miss ? Thank You :x :x // ** products table ** // Lets say you have added a field to your "products" table called // "products_upc". The header name in your import file will be // called "v_products_upc". Then below you will change the line // that looks like this (without the comment double-slash at the beginning): // $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export // // TO: // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' ); // // If you have multiple fields this is what it would look like: // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC', 'products_restock_quantity' => 'Restock' ); // Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted April 13, 2013 Share Posted April 13, 2013 Hi You need to add code to the product_info.php script to display the data, not forgetting to amend the query to retrieve the extra field. HTH G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
partrade12 Posted April 18, 2013 Share Posted April 18, 2013 Do my images need to be a certain size? and Where do I upload them? Quote Link to comment Share on other sites More sharing options...
saupe31 Posted April 26, 2013 Share Posted April 26, 2013 i used this to update shipping prices it uploads no error even showed the bits it updated but when i download the new file none of the changes are there and none of the prices have changed on site Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.