I created a new site for a client this week using Magento Community Edition. It’s a highly robust system for handling Ecommerce, but it is not clear how to import images in bulk.
As I looked for where to import the images I kept finding help files and forum posts talking about System > Import/Export > Import where I select Product Images for Entity Type. This does not exist in the Community Edition
I then searched the Magento Community Forums only to find nothing. I posted a question and the answer I got was to install some insanely complex import tool. I also found other modules that would cost anywhere from $50-250 to buy.
In my hunting I decided to look at what other features Magento Community Edition offered and I ran across Dataflow – Profiles. After some research, this is exactly what I needed! Why does it not say this anywhere else?
Setting up Magento Image Import
Here’s how to do it:
- Go to System > Import/Export > Dataflow Profiles. There is a list there.
Add New Profile and use these parameters:
- Name: Pick a descriptive name like Import Product Images
- Entity Type: Images
- Directon: Import
- Type: CSV / Tab Separated
- Add Fields to the Profile: You will need to add each of these one at a time: sku, image, image_label, small_image, small_image_label, thumbnail, thumbnail_label
Testing Image Import
Create another profile identical to the one above with the following differences:
- Name: Try Export Product Images
- Directon: Export
- File Name: Give it a name.
- Path: Create a folder on your site for exports.
- Type: CSV
- Export: Only Mapped Fields
- SKU: Pick an item with images on it and use that SKU.
This will export that one item and the image info with it.
Create your Image Import File
Use the exported file as a template to put your entire list of images on. I suggest making a test file of 5 images to import.
Import the File
Go to System > Import/Export > DataFlow – Profiles and pick your Product Image Import profile. Click on Upload File to the left, choose your test file for File 1: and save profile. Click on Run Profile to the left, select the file you want to import and click on Run Profile in Popup.
You need to upload your images before importing them into Magento. Put the images in /magento-root-folder/media/import. If the import folder does not exist you will need to create one. If the images are not in the folder they will not import.
The fact that this runs in a popup is important. A script then starts searching for each SKU and inputing the new image data. I ran it for 500 images and it took about 10 minutes. If you are worried about connection issues I would split your data up into smaller lists.
Images Imported Into Magento
I was so frustrated trying to figure out why Entity Type: Product Images was not there and what to do because it wasn’t. I hope this reduces your stress.