Example CSV File.
Header | Value
Content-Type | application/csv
Content-Dispostion | attachment;filename=yourfilenamehere.csv
<mvt:item name="toolkit" param="mvassign|comma|asciichar('44')" />
<mvt:assign name="spacer" value="'' $ g.comma $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ asciichar('10')" />
<mvt:assign name="totalChicken" value="0" />
<mvt:assign name="totalBeef" value="0" />
<mvt:assign name="totalTurkey" value="0" />
<mvt:item name="toolkit" param="mvassign|headerRow|'Order Date' $ g.comma $ 'Order ID' $ g.comma $ 'Last Name' $ g.comma $ 'Product' $ g.comma $ 'Quantity' $ asciichar('10')" />
&mvt:global:headerRow;
<mvt:foreach iterator="order" array="admin_order:orders">
<mvt:assign name="currentNum" value="1" />
<mvt:item name="customfields" param="Read_Order( l.settings:order:id, 'free_turkey', l.settings:free_turkey )" />
<mvt:item name="toolkit" param="mvassign|orderRow|l.all_settings:order:date $ g.comma $ l.all_settings:order:id $ g.comma $ l.all_settings:order:ship_lname $ g.comma" />
<mvt:foreach iterator="item" array="order:items">
<mvt:comment> === Counting === </mvt:comment>
<mvt:if expr="l.settings:item:code EQ 'chicken'">
<mvt:assign name="totalChicken" value="g.totalChicken + l.settings:item:quantity" />
<mvt:elseif expr="l.settings:item:code EQ 'beef'">
<mvt:assign name="totalBeef" value="g.totalChicken + l.settings:item:quantity" />
<mvt:elseif expr="l.settings:item:code EQ 'turkey'">
<mvt:assign name="totalTurkey" value="g.totalTurkey + l.settings:item:quantity" />
<mvt:elseif expr="l.settings:item:code EQ 'sample-pack'">
<mvt:assign name="totalChicken" value="g.totalChicken + l.settings:item:quantity" />
<mvt:assign name="totalBeef" value="g.totalChicken + l.settings:item:quantity" />
</mvt:if>
<mvt:comment> === Counting === </mvt:comment>
<mvt:if expr="g.currentNum EQ '1'">
<mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ l.all_settings:item:name $ g.comma $ l.all_settings:item:quantity $ asciichar('10')" />
<mvt:else>
<mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ l.all_settings:item:name $ g.comma $ l.all_settings:item:quantity $ asciichar('10')" />
</mvt:if>
<mvt:assign name="currentNum" value="g.currentNum + 1" />
</mvt:foreach>
<mvt:if expr="l.settings:free_turkey EQ 'yes'">
<mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'FREE Turkey' $ g.comma $ '1' $ asciichar('10')" />
<mvt:assign name="totalTurkey" value="g.totalTurkey + 1" />
</mvt:if>
&mvt:global:orderRow;
</mvt:foreach>
&mvt:global:spacer;
<mvt:assign name="totals" value="'' $ g.comma $ '' $ g.comma $ '' $ g.comma $'Total Chicken' $ g.comma $ g.totalChicken $ asciichar('10')" />
<mvt:assign name="totals" value="g.totals $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'Total Beef' $ g.comma $ g.totalBeef $ asciichar('10')" />
<mvt:assign name="totals" value="g.totals $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'Total Turkey' $ g.comma $ g.totalTurkey $ asciichar('10')" />
&mvt:global:totals;