<mvt:assign name="g.delimiter" value="','" />
<mvt:assign name="g.newline" value="asciichar(10)" />

provider&mvt:global:delimiter;order_id&mvt:global:delimiter;transaction_type&mvt:global:delimiter;completed_at&mvt:global:delimiter;customer_name&mvt:global:delimiter;shiptocity&mvt:global:delimiter;shiptostate&mvt:global:delimiter;shiptozip&mvt:global:delimiter;shiptostreet&mvt:global:delimiter;shiptocountrycode&mvt:global:delimiter;shipping_amount&mvt:global:delimiter;handling_amount&mvt:global:delimiter;discount_amount&mvt:global:delimiter;total_sale&mvt:global:delimiter;sales_tax&mvt:global:delimiter;from_country&mvt:global:delimiter;from_state&mvt:global:delimiter;from_city&mvt:global:delimiter;from_zip&mvt:global:delimiter;from_street&mvte:global:newline;

<mvt:foreach iterator="order" array="admin_order:orders">

<mvt:comment>Only send orders which are not: 300 = Cancelled, 400 = Backordered, 500 = RMA Issued, 600 = Returned </mvt:comment>
<mvt:if expr="l.settings:order:status NE 300 OR
	      l.settings:order:status NE 400 OR
	      l.settings:order:status NE 500 OR
	      l.settings:order:status NE 600">

<mvt:comment>Reset Charges Variables</mvt:comment>
<mvt:assign name="l.settings:shipping_charge" 	value="'0.00'" />
<mvt:assign name="l.settings:tax_charge" 	value="'0.00'" />
<mvt:assign name="l.settings:handling_charge" 	value="'0.00'" />
<mvt:assign name="l.settings:discount_amount" 	value="'0.00'" />

<mvt:foreach iterator="charge" array="order:charges">
	<mvt:if expr="l.settings:charge:type EQ 'SHIPPING'">
		<mvt:assign name="l.settings:shipping_charge" value="l.settings:charge:disp_amt" />
	</mvt:if>

	<mvt:if expr="l.settings:charge:type EQ 'TAX'">
		<mvt:assign name="l.settings:tax_charge" value="l.settings:charge:disp_amt" />
	</mvt:if>

	<mvt:if expr="l.settings:charge:type EQ 'HANDLING'">
		<mvt:assign name="l.settings:handling_charge" value="l.settings:charge:disp_amt" />
	</mvt:if>

	<mvt:if expr="l.settings:charge:type EQ 'DISCOUNT'">
		<mvt:assign name="l.settings:discount_amount" value="l.settings:charge:disp_amt + l.settings:discount_amount" />
	</mvt:if>
				
</mvt:foreach>

<mvt:comment>Remove negative from discount amount</mvt:comment>
<mvt:assign name="l.settings:discount_amount" value="abs(l.settings:discount_amount)" />

<mvt:comment>Remove tax amount from order:total</mvt:comment>
<mvt:assign name="l.settings:order_total_no_tax" value="l.settings:order:total - l.settings:tax_charge" />


Miva&mvt:global:delimiter;&mvt:order:id;&mvt:global:delimiter;Order&mvt:global:delimiter;&mvte:order:date;&mvt:global:delimiter;&mvte:order:ship_fname; &mvte:order:ship_lname;&mvt:global:delimiter;"&mvte:order:ship_city;"&mvt:global:delimiter;&mvte:order:ship_state;&mvt:global:delimiter;&mvte:order:ship_zip;&mvt:global:delimiter;"&mvte:order:ship_addr;"&mvt:global:delimiter;&mvte:order:ship_cntry;&mvt:global:delimiter;&mvte:shipping_charge;&mvt:global:delimiter;&mvte:handling_charge;&mvt:global:delimiter;&mvte:discount_amount;&mvt:global:delimiter;&mvte:order_total_no_tax;&mvt:global:delimiter;&mvte:tax_charge;&mvt:global:delimiter;&mvte:store:country;&mvt:global:delimiter;&mvte:store:state;&mvt:global:delimiter;&mvte:store:city;&mvt:global:delimiter;&mvte:store:zip;&mvt:global:delimiter;"&mvte:store:address;"&mvt:global:delimiter;&mvt:global:newline;

	</mvt:if>
</mvt:foreach>