siavash Posted August 10, 2004 Posted August 10, 2004 hi all. i'm looking for the most straight forward and quick method to reference my product images. i have uploaded the image files in their right directory in catalog/images . now if i want to go to add product page in admin to reference one by one 2000+ products i'm sure i'd be wasting a lot of time, nerves and energy! what's the quickest possible way -- By the way i use Excel and upload products by EayPoulate. i have already read the wiki and knowledge base on this. Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
ozcsys Posted August 10, 2004 Posted August 10, 2004 hi all. i'm looking for the most straight forward and quick method to reference my product images. i have uploaded the image files in their right directory in catalog/images . now if i want to go to add product page in admin to reference one by one 2000+ products i'm sure i'd be wasting a lot of time, nerves and energy! what's the quickest possible way -- By the way i use Excel and upload products by EayPoulate. i have already read the wiki and knowledge base on this. If you are uploading your products using easypopulate you should be uploading the image info along with the price, weight etc. as there is an image field in the products table along with the others. The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right??
siavash Posted August 10, 2004 Author Posted August 10, 2004 i know and i will use that image field in EP but how do i reference them? espicially that the pix have to go to various folders (i have 10+ manufacturer folders and each has 3-4 subfolders, etc.)! this means that i have to manually type in my Excel fields every signle image path one by one. is that right? this would take longer i suppose than using the image upload in admin! or am i mistaken? thanks for your promptness. Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
siavash Posted August 11, 2004 Author Posted August 11, 2004 any ideas anyone? how do you reference thousands of images? it is very time consuming if i have to type in image paths one by one in the excel (to use with EasyPopulate) or Admin. please help it's rather urgent! thanx Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
♥bruyndoncx Posted August 11, 2004 Posted August 11, 2004 Excel I think is probably the easiest to manipulate the data. Assuming the image path is composed of different fields (manufacturer/category/model etc) you can use the concatenate function to create the image path in a column. Then when you've done this, you have to "paste special" this column as a new column and select "values only" to get the resulting image path in the columns iso the concatenate formula. This way you can prepare an excel for upload with easypopulate, or even an SQL script with update statements if you wanted to. KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
siavash Posted August 11, 2004 Author Posted August 11, 2004 Excel I think is probably the easiest to manipulate the data.Assuming the image path is composed of different fields (manufacturer/category/model etc) you can use the concatenate function to create the image path in a column. Then when you've done this, you have to "paste special" this column as a new column and select "values only" to get the resulting image path in the columns iso the concatenate formula. This way you can prepare an excel for upload with easypopulate, or even an SQL script with update statements if you wanted to. thanks for the reply. i know this is not an osc issue but i'm not too familiar with "concatenate" function. i tried the excel example but am not quite sure how this or data consolidation (if helpful at all) should work for my purpose. can you or anybody. give further support! if i can learn to be only 1 image path reference from my image folders on PC into my excel i'll work the rest out! Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
♥bruyndoncx Posted August 11, 2004 Posted August 11, 2004 I've zipped up sample file and screenshots from excel (dutch version). Note that english version replace ";" with "," in formula's. Email me ... for the zip KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
siavash Posted August 11, 2004 Author Posted August 11, 2004 just sent u an email. Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
siavash Posted August 12, 2004 Author Posted August 12, 2004 got up this morning thinking someone might have known the answer over the atlantic!! i guess when you finish smarting up your shops looks you need to upload your products which is what your e-shop is all about. and images give your shop a nice and lively look and dimension. now i need some help with the latter!as i have already said i have uploaded some 2000+ images into their right directoties. i know need to know how the easiest, quickest and neaest way to reference the products to their respective image files. (i use MS excel to easypopulate to upload products.) Did you try? Did you fail? No matter! Try again. Fail again! But fail better!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.