We're building an Item saved search in Netsuite to generate a Google Merchant Center product feed later.
We are tying to add a field to the saved search's Results tab that returns the URL of the default Associated Image for each item (the one that displays first/as the primary image on the item's web store product card).
We tried to add Item Image in results, and it has two separate problems:
1. When it does return a value, it's missing the protocol and domain portion, so it has not a full, usable URL as-is. We'd need the account domain prepended to make it load in a browser or work in a product feed.
2. For other items, the field returns no value at all, even though those items have Associated Images configured and display correctly on the live web store.
We are trying to get a Results field that reliably returns a full, absolute URL for each item's default Associated Image (we are using SuiteCommerce Advanced). How would we do so in item saved search?
Thank you!
P.S. We have thousands of items, so manually identifying or setting the image per item isn't feasible.