For doing item import with the custom image field values of the item record we need the filename of the image added in the custom image field of the item record
The image URL and internal id were only available from Netsuite saved search so in order to get the filename
Follow the steps below –
- Create a saved search of items with internal id and URL
- Create a document search with image filename and URL
Export both files. Compare and merge the required excel fields using the VLOOKUP function for getting the required file with the filename of the custom image field for import
Excel’s vLookup formula pulls data from one spreadsheet into another by matching on a unique identifier located in both spreadsheets.