Media Excel import
If one has media such as images and documents available via a web address (URL), they can easily be imported and connected to products in feed.
This requires having unique product numbers in feed® that can be identified during import. One can also assign desired media roles. This assumes that one has knowledge of or access to master data to view the import code for a media role.
Import via Excel
- The first step is to download an Excel template from feed® by clicking the "Download template" button.
The template contains tabs with information that is important to read and follow. - Next, edit this template and input a row for each piece of media you want to associate with a product.
- Finally, upload the edited Excel file back into feed® by either dropping the file in the upload area or clicking the upload icon and navigating to the saved Excel file for uploading.
The list on the right side of the upload box shows history of uploads. If you click a line in this list you will get details on the upload.
If every media in the Excel has uploaded successfully, and all columns has been imported successfully, you will not see a list below Errors.
If there is a list below Error, you can click on the lines to get more information on the error or warning.
- Error will not upload the media,
- Warning will upload the media, but fail on one or more of the connections.
In the example below the media was imported, but could not create a connection to a product in feed since it found no match with the product number "media test".
The line number refers to the row number in the Excel file.
To correct these problems, look at the messages and correct the issues in the Excel file and do another import.
Deletion of media via Excel Import
To delete media via Excel import, the ActionType column has action types: DELETE and FORCE_DELETE:
DELETE: This will delete the media if it is not in use.
FORCE_DELETE: This will delete the media even if it is in use. If it is in use, the associations will first be removed, and then the media itself will be deleted.
Read more in the Information and ActionType - Explanation tabs in the template that can be downloaded from feed® under Integrations → Excel → Import → Media.