Total Posts: 367
Getting my first products into Magento with DataFlow toke me some hours, but after lots of trial & errors and lots of reading on this forum I learned a lot. I will explain here how I managed to import products with multiple-images and multiple-languages.
My store configuration:
Website - Store - Store View (default)
Website - Store - Store View (spanish)
Website - Store - Store View (french)
Website - Store - Store View (italian)
Website - Store - Store View (german)
The CVS file
I used a CVS file, but i guess this should work just fine with a Excel XML file. I’ve attached an example of my CVS file to this post.
Magento uses the SKU as the unique identifier. So in this example of simple products, you see only one product, in 5 languages with 3 pictures. Because the rows all share the same SKU, Magento knows it is a single product.
You don’t need to supply the image, small_image and thumbnail for each language, because the image is shared between the Store Views. If you do supply the image, you will get duplicate images. The image names can be whatever you like and should be the same as the real images. The small_image and thumbnail is not autogerenated, so you need to create them as well. Lots of freeware tools are available to do this job at once. Files needs to be uploaded to your /media/import folder on you host.
The only problem I have with image at this moment is the “Excluded” option is checked on the default Store View for all images, and on all other Store Views “Excluded” isnt checked on any image. The result of this is:
- Defaul Store View “More Views” on product level doesn’t show any images. You only see the first image above More Views
- All other Store Views show all images on “More Views” of this SKU. This includes the thumbnail and the small_image. So I have each image 3 times on product level.
None-English Locale in Admin panel
When you don’t use the default, english locale, but for example the Dutch locale, your Import has to reflect the translations as well. I was using the Dutch translation for the Admin panel and couldn’t get my products Status enabled on import. When I used the translated version of Enabled ("Aan") it worked. So if you have problems importing, try to use the default locale, english.
If you think it can be done easier let me know, but this worked fine for me. It would also be nice to see some examples of other configurations. Like multiple websites, multiple stores, grouped or configurable products.
Disclaimer: My mother tongue isn’t english so don’t shoot me for my spelling and grammar.
this would be help full for me
thanks a lot