Importing Product Images via CSV in Magento 220.127.116.11
Posted on 5/30/2012
Many users have reported issues when trying to import images using the default Import/Export within Magento. I too have suffered this headache. Luckily, I have figured out a way to bypass any issues by separating out our import files.
Traditionally when we import our CSV, we have one giant document full of attributes. Including all the image references Well, in my version don't include the image attributes. Instead, we'll put those into a new CSV along side a column with the SKU of the product.
In order to import a second CSV that is customised like this we'll need a separate import profile. I'll teach you how to create one now.
Step 1) Create the advanced profile
The solution is to create a custom import profile (System > Import/Export > Dataflow – Profiles). You only need to include the attributes that are required, which is just the SKU. Plus the appropiate image attributes. Plus labels if you want to go all out.
When you are creating your new profile, enter the following settings:
Now you can hit save! With our Profile now complete, we just need to create the folder media/import. This is where you will be storing all your images awaiting import.
Step 2) Create your Magento images import CSV
So now we have our profile created all we need to do is create our CSV. The CSV is pretty standard format. First of we have our SKU, and then followed by our image attributes.
When uploading images, they need to be within a folder called
media/import. Once saved to that folder you can then reference them relatively. By that I mean if your image is in
media/import/test.jpg in your csv reference it as
/test.jpg. It's as easy as that.
Now finally all you need to do is modify your CSV file to include only the following columns:
sku, image, image_label, small_image, small_image_label, thumbnail, thumbnail_label
Now you can upload and run the profile, sit back and breath.
Did this help you? Have any questions? Got any other tips like this? Let me know in the comments!