This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to search for items that don’t have images? We’re on Suitecommerce Advanced

Do try doing a saved search? Or you need it at the site?

You might need to create your own solution via scripting, I do not remember if it was for all items or for matrix items but the images are not exposed via saved search.

I think you’re right <@U5L945PD5> I tried saved search and it didn’t work out 

Review this, probably you can do it via suiteql: <https://timdietrich.me/blog/netsuite-suiteql-item-images-sca/> but I'm pretty sure it does not work for matrix items.

It was taking me a bit to try to hack the SuiteQL to get it and I'm close. I started out with the naming convention for your image files if you have multiple images per item.

image.png

You can use a formula to pull out the file prefix.

in this case using period '.' as the delimiter for the file prefix (for matrix items).

And for this instance, you can join items on on files by looking at the item UPC code in the prefix of the file.

And with a left outer join between items and image files, you should be able to select just those items that have zero corresponding image files in the file cabinet. So in theory, it should work.

I was going to try to get either the workbook or the SuiteQL so I could post it. But I haven't worked it out fully yet.

My apologies for not having a working solution posted yet.

<https://developers.suitecommerce.com/check-for-missing-product-images-with-the-item-search-api.html>