velvetpixel Posted December 27, 2011 Share Posted December 27, 2011 (edited) I am having an issue where whenever I upload my CSV file it seems the v_products_image does not load the link. It takes me to /images/ folder. Any suggestions? Did you upload your image files via FTP the /catalog/images directory? If so are premissions correct on them? Did you put references to those images in the v_products_image column? v_products_image someimage.jpg otherimage.jpg prettypicture.jpg Edited December 27, 2011 by velvetpixel Quote osCommerce 2.3.1 Add-Ons Installed Header Tags SEO Ultimate SEO URLs Google Sitemap SEO Easy Populate QT Pro Margin Report AJAX Attribute Manager Smart Columns CKEditor OSCThumb Select Product Image Directory Category CSS Menu Enable Disable Categories Contact Form Captcha Link to comment Share on other sites More sharing options...
finskaus Posted December 27, 2011 Share Posted December 27, 2011 Hello all, I am not so experienced in working with the OSC, but still manage to make it what I intended:) Now I have a problem, I do not know if it is possible through the "Excel populate" and insert the special prices in addition to the ordinary price. I need just to insert following data: Name Picture Regular price Special price Thanks in advance. Boki Quote Link to comment Share on other sites More sharing options...
gotboost350z Posted January 4, 2012 Share Posted January 4, 2012 Hey guys, for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled? here is the error No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 4, 2012 Share Posted January 4, 2012 (edited) Hey guys, for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled? here is the error No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This indicates the product model field is blank so it cant find which product to update. Check your input file. HTH G Edited January 4, 2012 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...
gotboost350z Posted January 4, 2012 Share Posted January 4, 2012 my csv file has the v_product_model field an for some unknown reason it just wont populate, i can build files and an it works jus fine, but when i go to import is jus says that there is No products_model field in record. which makes no sense like there is an issue with permissions or something. here is a link to a a csv file http://workaholicstudios.com/trans/csv.jpg Quote Link to comment Share on other sites More sharing options...
gotboost350z Posted January 4, 2012 Share Posted January 4, 2012 I found the problem im on a mac i need to save as a windows csv ha! Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 4, 2012 Share Posted January 4, 2012 Try changing it to v_products_model 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...
gotboost350z Posted January 4, 2012 Share Posted January 4, 2012 Oh ill try that thanks Quote Link to comment Share on other sites More sharing options...
bubaseballfan Posted January 8, 2012 Share Posted January 8, 2012 Hello, I am setting up a new store and am having the following error Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in ....easypopulate.php on line 1082 This occurs when I click on the easy populate link in version 2.3.1 Any suggestions? Quote Link to comment Share on other sites More sharing options...
apolyshow Posted January 10, 2012 Share Posted January 10, 2012 (edited) I am having a problem. I have install the EP 2.77a and everything is ok. But when i am trying to create and download the file, when i am open it wjth excel there is only one collumn with everything inside. Is there any way to produce different collumns for every section? Also same problem with 2.76i_2. I intall it now and have the same problem... What am i doing wrong? Edited January 10, 2012 by apolyshow Quote One amateur made the Arc, 5.000 pro made the Titanic... Link to comment Share on other sites More sharing options...
apolyshow Posted January 10, 2012 Share Posted January 10, 2012 Ok fix it with semicollon Quote One amateur made the Arc, 5.000 pro made the Titanic... Link to comment Share on other sites More sharing options...
Annisse Posted January 12, 2012 Share Posted January 12, 2012 (edited) Hello, Regarding V. 2.3 how do you add the 2nd larger image to Easy Populate? I am having the small issue. When I click on the thumbnail the image is huge, the 'fancybox' size is fine. I understand that you need to upload the 2nd same image file to fix this problem, but, what if you have 1000 products. There has to be a way to upload all the 2nd larger images at once than uploading one by one. Please help. Thanks. Here is a link to the exact issue I am referring to on my site: http://damefatale.co...roducts_id=2507 Thank you. Edited January 12, 2012 by Annisse Quote Link to comment Share on other sites More sharing options...
napulias Posted January 13, 2012 Share Posted January 13, 2012 Why not upload all the images directly into catalog/images directory? I'm using Easypopulate 2.77 with OSC 2.3.1 and it works just fine. The only problem seems to be that it does not *delete* any products, only adds and/or updates. I'm fetching my suppliers product catalog (some 8000 items) daily with ftp and several products will have been removed every time. To disable the removed products showing up in the store I created a shell script that sets the value of product_quantity to zero, waits for me to run the EP imports and afterwards changes the product_status to zero for products that have their quantity as 0. Works but is a bit cumbersome. Question: where should I put the database queries if I'd like to EP import processing to do the changes for product_quantity and product_status? Quote Link to comment Share on other sites More sharing options...
Annisse Posted January 13, 2012 Share Posted January 13, 2012 Anyone??? sorry, so computer iliterate here. I really am stumped why my images are huge when you click on the thumbnail. How do I get the main image to resize? The fancy box window is fine by the way. http://damefatale.com/catalog/product_info.php?products_id=2512 I am using OSC 2.3.1 Thank you! Hello, Regarding V. 2.3 how do you add the 2nd larger image to Easy Populate? I am having the small issue. When I click on the thumbnail the image is huge, the 'fancybox' size is fine. I understand that you need to upload the 2nd same image file to fix this problem, but, what if you have 1000 products. There has to be a way to upload all the 2nd larger images at once than uploading one by one. Please help. Thanks. Here is a link to the exact issue I am referring to on my site: http://damefatale.co...roducts_id=2507 Thank you. Quote Link to comment Share on other sites More sharing options...
napulias Posted January 13, 2012 Share Posted January 13, 2012 Annisse, Have you checked this: http://www.oscommerce.com/forums/topic/367597-help-req-image-resize-in-231/ I have only one image per product in my store so I can't test. //rkv Quote Link to comment Share on other sites More sharing options...
Douglas-John Ramm Posted January 17, 2012 Share Posted January 17, 2012 (edited) have successfully install easypopulate 2.77 downloaded a csv file edited it upload it and it didn't work tried again still nothing. then i received some error messages telling me it couldn't upload and install the csv file i edited. error message as follows Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate_functions.php on line 44 File uploaded. Temporary filename: /tmp/phpGRCzRq User filename: EP2012Jan16-2311.csv Size: 513194 Warning: file() [function.file]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1191 Warning: file(/home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv) [function.file]: failed to open stream: No such file or directory in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1191 Warning: fopen() [function.fopen]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1216 Warning: fopen(/home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv) [function.fopen]: failed to open stream: No such file or directory in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1216 ##Can not open file for reading. Script will terminate. All fixed temp folder in wrong spot. Doug Edited January 17, 2012 by Douglas-John Ramm Quote Link to comment Share on other sites More sharing options...
panthercoug Posted January 17, 2012 Share Posted January 17, 2012 Hello, My store is Osc 2.3 which version of EP would anyone reccomend to install that seems to work the best? I do not need to make use of attributes. Quote Link to comment Share on other sites More sharing options...
Douglas-John Ramm Posted January 18, 2012 Share Posted January 18, 2012 2.77 but read the instructions and back up your store Quote Link to comment Share on other sites More sharing options...
dvharrison Posted January 18, 2012 Share Posted January 18, 2012 Hi I have download and installed the latest verison of easy Populate on my 2.3.1 site on XAMPP. Everything works except I cannot download under the complete .csv file under the quick links. I can download everything else (including the attributes fields) Having said that, I can download a complete table under Export EP or Froogle Products File which is weird as surely thats the same thing. I have gone through all the php.ini settings: max_execution_time = 300 max_input_time = 200 post_max_size = 4M upload_max_filesize = 8M memory_limit = 500M session.gc_maxlifetime = 1400 and the easypopulate settings (attached). Please could anyone shed some light? easypopulate.php Quote Debbie Harrison Link to comment Share on other sites More sharing options...
dvharrison Posted January 18, 2012 Share Posted January 18, 2012 (edited) Also while I have your attention, I have a separate issue with the product images being fullsize on the product page. I have read in previous threads that this can be resolved using Easy Populate but on looking at the suggested contribution in the Support documentation http://addons.oscommerce.com/info/1032 I realise its only for 2.2. Is there a version for 2.3.1 or even another way to get my main images to resize? Or can it still be used? Please advise. Edited January 18, 2012 by dvharrison Quote Debbie Harrison Link to comment Share on other sites More sharing options...
phdesignz Posted January 19, 2012 Share Posted January 19, 2012 i'm not sure if this has been answered, but...how do i get the category images to display...all I'm seeling in the view source is /images...no picture even though I specified the correct path to the image. I'm trying to figure out what $categories['categories_image'] is defined as...help? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 19, 2012 Share Posted January 19, 2012 Geoff Have you uploaded the image to the images directory? What did you actually put in the import file and what was the name of the column you put it in? 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...
phdesignz Posted January 20, 2012 Share Posted January 20, 2012 (edited) Oh man, I figured out the answer. I edited the html_output file using the dynamic image resizer and some code got messed up somehow so I reinstalled the resizer and it works again. Lol! Edited January 20, 2012 by phdesignz Quote Link to comment Share on other sites More sharing options...
Douglas-John Ramm Posted January 20, 2012 Share Posted January 20, 2012 Not happy with this easy populate it will not upload the file propely if at all and if it dose it screws with the data base now i have read some of this tread but can not find a fix for this problem any help would be great. Doug Quote Link to comment Share on other sites More sharing options...
velvetpixel Posted January 20, 2012 Share Posted January 20, 2012 Not happy with this easy populate it will not upload the file propely if at all and if it dose it screws with the data base now i have read some of this tread but can not find a fix for this problem any help would be great. Doug If you are using a Mac make sure you are saving yoru CSV file in windows format. Quote osCommerce 2.3.1 Add-Ons Installed Header Tags SEO Ultimate SEO URLs Google Sitemap SEO Easy Populate QT Pro Margin Report AJAX Attribute Manager Smart Columns CKEditor OSCThumb Select Product Image Directory Category CSS Menu Enable Disable Categories Contact Form Captcha Link to comment Share on other sites More sharing options...
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.