steveosoule
6/12/2014 - 6:28 PM

Miva Merchant - Look up PageFinder's Product Pagename

Miva Merchant - Look up PageFinder's Product Pagename

<mvt:assign name="g.select_sql" value="'SELECT name FROM s01_PageFinderProducts WHERE product_id=' $ l.settings:product:id $ ' LIMIT 1'" />
<mvt:item name="ry_toolbelt" param="query|g.select_sql|pagename" />
<mvt:if expr="l.settings:pagename">
	<mvt:assign name="l.settings:product:pagelink" value="'http://' $ g.domain:name $ '/' $ l.settings:pagename $ '.html'" />
<mvt:else>
	<mvt:assign name="l.settings:product:pagelink" value="'http://' $ g.domain:name $ '/product/' $ l.settings:product:code $ '.html'" />
</mvt:if>