How to import with images from url

Before importing

A prerequisite to importing entities with images is having an excel spreadsheet with the data organized in named columns. For this tutorial we have a made a simple spreadsheet containing information internal ids of products and URL's of images from the web.

By importing URL's of images from the web into an AssetReferenceAttribute the PIM will automatically download the image and upload it to Struct PIM 4.

Notice how cell B2 contains two URL's separated by a ";". This is because we are importing into an AssetReferenceAttribute with 'Allow multiple assets' enabled. In this case the ";" acts as a delimiter and each URL will be imported as one picture into the attribute.

Starting the import

To start importing you choose the excel spreadsheet with the data you want to import, in this tutorial the spreadsheet is called "import_with_images_url.xlsx".

Next you need to choose the correct Import type. Choose the one that fits what you need to import. In this tutorial we are importing to an AssetReferenceAttribute, so we choose "General Except Import".

Since we are using images from the web we do not enable "Upload assets".

Having chosen the file you want to import and the import type, click 'Start upload' to continue.

Mapping your data

Mapping data works the same way as it does without media.

If you are uncertain on how to do this you can follow read more about this in earlier import-tutorials:

Mapping with General excel import: How to import products Mapping with List property import: How to import data into a list property on entities

One difference however is that this is where you will choose the folder to upload your images to. This is done by selecting the folder in the list under 'Select upload folder'.

Approve changes

When approving data you should be able to see the media files being attached to your entity.

If you are happy with the changes, approve them and click 'Commit import' to finalize the import.