Miva - Order Items: Variant Code To Master Code
<mvt:foreach iterator="item" array="order:items">
<mvt:comment>
<!--
Variant Basket Item Replacement Helper
-->
</mvt:comment>
<mvt:comment><!-- Determine of product is a variant or not --></mvt:comment>
<mvt:if expr="l.settings:item:product:id GT 0 AND l.settings:item:product:id NE l.settings:item:product_id">
<mvt:assign name="l.settings:item:is_variant" value="1" />
<mvt:assign name="l.settings:item:true:master:id" value="l.settings:item:product_id" />
<mvt:assign name="l.settings:item:true:variant:id" value="l.settings:item:product:id" />
<mvt:assign name="l.settings:item:true:lookup:id" value="l.settings:item:true:variant:id" />
<mvt:else>
<mvt:assign name="l.settings:item:is_variant" value="0" />
<mvt:assign name="l.settings:item:true:master:id" value="l.settings:item:product_id" />
<mvt:assign name="l.settings:item:true:variant:id" value="0" />
<mvt:assign name="l.settings:item:true:lookup:id" value="l.settings:item:true:master:id" />
</mvt:if>
<mvt:comment><!-- Lookup & Standardize master product code --></mvt:comment>
<mvt:if expr="l.settings:item:true:lookup:id">
<mvt:assign name="g.sql_select" value="'SELECT id,code FROM ' $ g.store_table_prefix $ 'Products WHERE id = ' $ l.settings:item:true:lookup:id $ ' LIMIT 1'" />
<mvt:item name="ry_toolbelt" param="query|g.sql_select|item:true:lookup:results" />
<mvt:assign name="l.settings:item:standard:id" value="l.settings:item:true:lookup:results[1]:id" />
<mvt:assign name="l.settings:item:standard:code" value="l.settings:item:true:lookup:results[1]:code" />
</mvt:if>
&mvt:item:standard:code;
</mvt:foreach