Magento

I’m unable to import products and images too, using community 1.6.2.

Its pretty ridiculous that importing products is so hard to do. This should be one of the core features, unbroken and unchanged in every release.

Magento makes it too difficult to import images and gallery.

Testing version 1.7.

There’s a ‘gallery’ and a ‘media_gallery’ in the database.

I was able to import ‘thumbnail’, ‘small_image’, and ‘image’ fine.  They show up in the frontend.  However, in the backend, it doesn’t show up because the managing products reads the images from the media_gallery.

Making any changes to the product in the admin backend will remove ‘thumbnail’, ‘small_image’, and ‘image’ because there is no media_gallery image.

Might have to bring back “product_gallery_importer”.

Managed to make a simple hack that allows you to add multiple images with the Data Flow import. If there’s any better way I couldn’t find it.

The end result is having to add a column ‘media_gallery’ in the .csv file, where you would write all the files you want added for the product in the following format : ‘/image1.jpg, /image2.jpg’, etc.
These images go like the rest in the /media/import folder.

This .cvs file you would then proceed to upload and run with the standard DataFlow Products Import profile. I should also say that I have only tested this on Magento 1.7, and that it’s recommended to create a module that overrides the core file and not hack it.

Now, what you need to do is open the file
app/code/core/Mage/Catalog/Model/Convert/Adapter/Product.php
and go to around line 773 and find

Same exact problem here, cant even use any of the offered solutions. What seems to be happening is that Magento 1.6 does not import an item if you don’t have the corresponding image. Out of 3000 items it imported maybe 1000. Magento 1.4 imported items just fine even without images. What gives? I did notice however that despite partially importing CSV, when I imported the same file AGAIN, it would still not process the whole file BUT, it added more items that weren’t previously imported. Somehow this “Image Does Not Exist” error has an impact on my imports.

And I cant just throw images into a media/import/s/k directory because Sku numbers for Art Supplies are ALL over the place, nothing uniform or standard. i.e 51135208373, 21200531095, 74711717403.

Following some of the solutions, I would have to create a directory for every possible number, import images separately to those directories and then run the CSV? Seems like a step back for Magento, and completely out of the question.

I was having the Image does not exist error too and it turned out it was because the csv wasn’t UTF-8 encoded.

You should try to convert your csv to UTF-8.
I did that with Notepad++. Just be careful when changing the encoding it might also screw up some of your special characters. I usually copy the whole text, change encoding then past it back (other editors might be better at changing the encoding).

Good luck !

Working on 1.7 as well. Did the above hack work for any of you? Does anyone know if I upload the products with Store Manager for Magento trial will they still be there when the trial ends? Was hoping to import these products this weekend! Any advice appreciated.

Thank you so much.

It is all right to magento 1.6.1.0

mathywow - 22 May 2012 07:07 AM

Managed to make a simple hack that allows you to add multiple images with the Data Flow import. If there’s any better way I couldn’t find it.

The end result is having to add a column ‘media_gallery’ in the .csv file, where you would write all the files you want added for the product in the following format : ‘/image1.jpg, /image2.jpg’, etc.
These images go like the rest in the /media/import folder.

This .cvs file you would then proceed to upload and run with the standard DataFlow Products Import profile. I should also say that I have only tested this on Magento 1.7, and that it’s recommended to create a module that overrides the core file and not hack it.

Now, what you need to do is open the file
app/code/core/Mage/Catalog/Model/Convert/Adapter/Product.php
and go to around line 773 and find

$addedFilesCorrespondence = $mediaGalleryBackendModel->addImagesWithDifferentMediaAttributes(
            $product,
            $arrayToMassAdd, Mage::getBaseDir('media') . DS . 'import',
            false,
            false
        );

and paste the following code right after it

if (isset($importData['media_gallery']) && !empty($importData['media_gallery'])) {
            $x = explode(',', $importData['media_gallery']);
            foreach ($x as $file) {
                $imagesToAdd[] = array('file' => trim($file));
            }

            $mediaGalleryBackendModel->addImagesWithDifferentMediaAttributes(
                $product,
                $imagesToAdd, Mage::getBaseDir('media') . DS . 'import',
                false,
                false
            );
        }

There were some problems in the Magento Import image script, so I posted a fix to http://www.lexitconsulting.com/2012/06/fixing-the-magento-product-import-script/, which allows to use the images inside /media/import (and you can name them whatever you want, and place them in any folder you want).

Working with CE 1.7.0.2 and no solution works for me.

Importing of a CSV file, no problem.
But a CSV file with images? NO WAY.

I have made 2 new products in CE 1.7.0.2

Export them to Excel (version 2012).

Save the exportfile as .cvs without any editing.

Import that cvs file SYSTEM > IMPORT/EXPORT > DATAFLOW - PROFILES

Big surprise: the file can’t be handled, no valid value for “type” ?????????

Click thumbnail to see full-size image

If anybody wants lowest quote for importing Magento products (from .csv file) with image feel free to contact me.

MakedonX - 06 August 2012 02:01 PM

If anybody wants lowest quote for importing Magento products (from .csv file) with image feel free to contact me.

We shouldn’t have to pay $500 to export gallery images. It is ridiculous! Should be a standard export function!!

Personally, I think it will be better to make a module that imports everything in a few minutes. I don’t think that it is very difficult.
The only thing that helped me with import was this service.  www.file2cart.com
At least it is faster than other services and modules.

Hi!
I am having the same issue. Was wondering if you found a fix? I am using Magento 1.7 and cannot upload product images at all.

Thanks!

fragrances - 22 August 2012 04:51 PM

MakedonX - 06 August 2012 02:01 PM

If anybody wants lowest quote for importing Magento products (from .csv file) with image feel free to contact me.

We shouldn’t have to pay $500 to export gallery images. It is ridiculous! Should be a standard export function!!

I do it for $30, for $500 psd to magento + importing products with images as free service