Akeneo – Import Images & Files with CSV

Import Example

It is possible to import Images and Files through a CSV file.

To do so you have to upload the new images and files to the server in the same folder where the CSV file is located.

For example we want to add the example.jpg image to the product with SKU testproduct so we create the following CSV file:

Now upload the CSV file and the example.jpg image to the server for example to the app/custom-import folder.

Once the files are uploaded create an import profile and set the File path within the Properties of the profile to the CSV file with the full path.

In this example the path is /var/www/app/custom-import/test.csv.

Now you are ready to run the import.

Overwrite existing images

If you have existing images in Akeneo and you want to overwrite them make sure you first import a CSV file with only the SKU column filled in because if you import a file with the same name as the existing one the image or file won’t be updated.

Retrieve Magento 1 Product Files

It is possible to create the CSV file based on the Magento 1 Data so you can migrate the files to Akeneo when you are going to migrate for Magento 2.

In the example below we will be migrating the Magento 1 Files from the Magestore_Productfile to Akeneo.

Upload all the files from the media/productfile Magento directory to the Akeneo server in the app/custom-import folder.

Now the files are ready and you can create the CSV file with the following query for the Magento 1 Database:

In the example query below there are 10 file attributes which are created in Akeneo with codes like file1, file2 etc. Besides that these attributes are localisable and the files will be imported for only the locale nl_NL.

The above query can also be added so you can import files from for example the Amasty ProductAttachment Module.

Besides the files you can also migrate the File Titles with the following query