Is it possible to display the results of a saved search on a web page without using a publish saved search? Possibly with a SSP?? We have a bunch of standard items and also matrix child items that we have put on special offer and want to display only these items in a list with the option to add them to the cart. A published saved search does this, however because of a defect that NetSuite is taking forever to fix it doesn't display the correct results.
The items are marked as on sale using a custom check box field. I am looking to get this sorted ASAP as we looking to launch the marketing campaign tomorrow and im confident that NetSuite will not have fixed this problem by then.
The results need to include the item name, custom currency field (old price), specific price level pricing {pricelevel2}, formulas working out difference between old price and {pricelevel2}, matrix options if present, add to cart button. The final field is the product image which needs to display either a custom field image for standard items and if its a matrix child item to display the parent custom field image. Its the image field that is creating issues on the published saved search. It works fine using this formula when viewing the UI, but breaks when viewing the published saved search:
CASE WHEN {urlcomponent} IS NULL THEN CONCAT('<img src="http://www.blitzsport.com/images/list/', CONCAT({parent.urlcomponent}, '.jpg">')) ELSE CONCAT('<img src="http://www.blitzsport.com/images/list/', CONCAT({urlcomponent}, '.jpg">')) END
Thanks
Chris