I’ve placed the images in media/import, tried putting a “ / “ in front of the images, set the store to default & admin… but I’m still having trouble getting images the images to attach to their products. As of now, the images will show for the product, but upon import they are all set to “exclude” which causes me to have to manually uncheck this for each item.
Has anyone been able to import a .CSV or .XML sheet with images and have them show on the frontend correct without any manual re-saving?
@Richard H. Thanks for the tip… that put me on the right path;
Until now, I had one store with one store view. Everytime I did an import, the images would be imported but always set to EXCLUDE. In my XML spreadsheet everything looked ok, the Store name was Set to “Admin’, all the attributes had columns, proper SKU, price, etc. Everything worked fine except the images were excluded (odd right?)
So, after reading Richard H’s post about the images NOT being excluded on other store views, I went and added another store view. Just for kicks. I dont need it, nor will I use it but I thought it might help.
I then re-uploaded a test product, changed the STORE Column to “Default” instead of “Admin” (again just for kicks), and.. low and behold...it worked. The product and corresponding image was uploaded and it WAS NOT set to exclude. Everything worked fine.
So the question is still… whats the issue with Store Views and the conflict with Images?
I can import images succesfully but the small images and thumbnails are display in the product view in the image gallery along with the main image.
I put all base, small and thumbs in media foloder. Any tips?
I confirm it works, not perfectly but with some effort it does…
I have accomplish to import 200 products with images by following this steps:
On the CSV:
file names in lowercase,
the usual beggining slash,
weight always over 1 (not sure this is a issue),
encode in UTF-8(had problems with my latin characters)
On the Import Profile:
Original Magento attribute names in first row:No
Mapping them with “column1,column2...”
Save in media/import
with the subfolders:
800 for 800x800 pix
135 for 135x135
75 for 75x75
Probably the server will give a memory problem with so many resizes during import.
I couldn’t find a suitable program that resized pictures with some canvas in white(to avoid distortion) to fit my needs so I created one in C#.
Created another profile with
store, SKU and categories_id
to update the products with the right store
Issue: Obviously they were not showing in the right sotres and the sometimes the 3 pictures (thumb, smal..) were showing in “More Views”
I hope this post helps someone as it helped me reading all the others available about this matter.
If you want some CSV example or my own C# resizer just mail me at tiago[dot]duarte[dot]matos[at]gmail
I hate to be the one to have to revisit this subject. But I downloaded the most recent version of magento-1.0.19870.1 , and am having problems with importing images. The Media file structure is not the same as in this original post, and I haven’t been able to find the PHP file that directs the DataFlow where to grab the photo from.
I can import and export products to CSV no problem, it seems only the the /xyz.JPG is not the correct path anymore when used to import.
I’m developing locally on WAMP.
The image path that gets exported is “/M/M/MML-199.JPG” from a manually input product and product image.
My current file structure is: wamp/www/magento/....
And the media file structure to the import is: magento/media/import
And to the “M” file where the image is stored is: magento/media/catalog/product/m/m/.
Please let me know if you need more information than I’ve given or any ideas that any of you may have.