Export Saved Search with Thumbnail Image

I have a saved search created with product sku’s and the corresponding item image (already saved to the individual item page).  Is there a way to export this saved search in pdf or excel and keep the pictures in tack? Every time I export, the image column has the URL from the file cabinet instead of the actual picture.

Do I need to create an Advanced PDF template for this saved search? If so, how do I get the images to populate?

Please help!

Rookie Asked on December 17, 2020 in Saved Searches.
Add Comment
3 Answer(s)

Using Chrome (there isn’t an easy way without extensions with other browsers), “Print” the saved search:

Print Images Issue

Select the destination as “Save as PDF” and save.

 

Now all of your images should still appear and it’s in a PDF.

 

Please vote the answer up if it works for you and let me know how you get on.

Rookie Answered on December 21, 2020.

That does work if you use the Default pdf option. However, I’m wanting to customize the Advanced PDF to make it look a little nicer and that’s when I run into the problem of the URL showing instead of the actual image.

on December 22, 2020.
Add Comment

If it’s just a one off, I have a VBA (excel) Sub that inserts images into cells containing URLs (highlight cells, run sub)
https://pastebin.pl/view/9d47b52f

However, if this is going to be repeated,  or something other users are going to need to use, I would recommend taking the PDF route
I would recommend you start here: Advanced Templates for Printing Saved Search Results

Beginner Answered on December 17, 2020.

Thanks David!

The excel route is what we’ve been doing but I wanted to make this particular saved search print from the system and email directly to customers out of NetSuite.

It’s essentially a price list but with stock availability and images attached to it.

on December 18, 2020.
Add Comment

I figured it out! Here is the code to use on the Advanced PDF Template, also be sure the you have checked “available without login” on the file cabinet item.

<td><@filecabinet nstype="image" alt="" src="${result.custitem_atlas_item_image}" style="float: left; width: 50px; height: 50px;" /></td>
 
Rookie Answered on December 22, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor