Happy New Year to All…!!!
At the time of Importing Master data in Business Central, for the Items we have Item Picture is available which we can Import/Export/Delete from Item Card. In case of thousands(or more) of items it is very tedious task to import picture for each item manually.
In Business Central, we have functionality available through which we can Import Multiple Item Pictures in one go. For that, simply name your picture files with names corresponding to your item numbers, compress them to a ZIP file, and then use the Import Item Pictures page to manage which item pictures to import.
All common file formats are supported.
Let’s see this in Step by Step process,
To name picture files by the item names and prepare the ZIP file
At the location where your item pictures are stored, name each files according to the number of the related item. For example:
|Item No.||File Name|
Collect all the files in a ZIP file. For example, in Windows Explorer, select the files, and then choose Send to, Compressed (zipped) folder.
To import item pictures
For this blog post I have deleted Item Picture for 4 items and kept for 1 item out of total 5 items. See below before import item pictures screen.
Choose the icon, enter Inventory Setup, and then choose the related link. Choose the Import Item Pictures action.
In the Select a ZIP file field, click assist edit button,
select Choose button,
select the relevant ZIP folder, and then choose the Open button.
A line for each item and picture is created on the Import Item Pictures page.
For item cards that already have a picture, the Picture Already Exists check box is selected.
If you do not want any existing pictures to be replaced, deselect the Replace Pictures check box. If you do not want individual existing pictures to be replaced, delete the lines in question.
Choose the Import Pictures action.
The Import Status field is updated to show if the picture import was skipped or completed.
See below after import item pictures screen below,
This is how we can import multiple item pictures in Business Central.