JSON Export Template
<mvt:comment>
| Loop though all orders returned all new orders.
</mvt:comment>
{
<mvt:assign name="g.number_orders" value="miva_array_elements( l.settings:admin_order:orders )" />
"orders_returned": "&mvtj:global:number_orders;",
"orders":
[
<mvt:foreach iterator="order" array="admin_order:orders">
{
"date": "&mvtj:order:date; &mvtj:order:time;",
"id": "&mvtj:order:id;",
"login": "&mvtj:order:id;",
"batch_id": "&mvtj:order:batch_id;",
"status": "&mvtj:order:formatted_status;",
"customer_id": "&mvtj:order:cust_id;",
"customer_login": "&mvtj:order:customer_login;",
"bill_fname": "&mvtj:order:bill_fname;",
"bill_lname": "&mvtj:order:bill_lname;",
"bill_addr1": "&mvtj:order:bill_addr1;",
"bill_addr2": "&mvtj:order:bill_addr2;",
"bill_city": "&mvtj:order:bill_city;",
"bill_state": "&mvtj:order:bill_state;",
"bill_zip": "&mvtj:order:bill_zip;",
"bill_cntry": "&mvtj:order:bill_cntry;",
"bill_comp": "&mvtj:order:bill_comp;",
"bill_phone": "&mvtj:order:bill_phone;",
"bill_fax": "&mvtj:order:bill_fax;",
"bill_email": "&mvtj:order:bill_email;",
"ship_fname": "&mvtj:order:ship_fname;",
"ship_lname": "&mvtj:order:ship_lname;",
"ship_addr1": "&mvtj:order:ship_addr1;",
"ship_addr2": "&mvtj:order:ship_addr2;",
"ship_city": "&mvtj:order:ship_city;",
"ship_state": "&mvtj:order:ship_state;",
"ship_zip": "&mvtj:order:ship_zip;",
"ship_cntry": "&mvtj:order:ship_cntry;",
"ship_comp": "&mvtj:order:ship_comp;",
"ship_phone": "&mvtj:order:ship_phone;",
"ship_fax": "&mvtj:order:ship_fax;",
"ship_email": "&mvtj:order:ship_email;",
"items": [
<mvt:assign name="g.item_count" value="miva_array_elements( l.settings:order:items )" />
<mvt:foreach iterator="item" array="order:items">
{
"line_id": "&mvtj:item:line_id;",
"code": "&mvtj:item:code;",
"name": "&mvtj:item:name;",
"quantity": "&mvtj:item:quantity;",
"weight": "&mvtj:item:weight;",
"price": "&mvtj:item:price;",
"item_subtotal": "&mvtj:item:subtotal;",
"item_status": "&mvtj:item:formatted_status;",
"options": [
<mvt:assign name="g.options_count" value="miva_array_elements( l.settings:order:item:options )" />
<mvt:foreach iterator="option" array="item:options">
{
"attribute_code": "&mvtj:option:attr_code;",
"attribute_prompt": "&mvtj:option:attr_prompt;",
<mvt:if expr="l.settings:option:option_id">
"option_data": "&mvtj:option:opt_code;",
<mvt:elseif expr="NOT ISNULL l.settings:option:data">
"option_data": "&mvtj:option:data;",
<mvt:elseif expr="NOT ISNULL l.settings:option:data_long">
"option_data": "&mvtj:option:data_long;",
<mvt:else>
"option_data": "&mvtj:option:attr_code;",
</mvt:if>
"option_subtotal": "&mvtj:option:subtotal;"
}
<mvt:if expr="pos3 LT g.options_count">,</mvt:if>
</mvt:foreach>
]
}
<mvt:if expr="pos2 LT g.item_count">,</mvt:if>
</mvt:foreach>
],
<mvt:foreach iterator="charge" array="order:charges">
<mvt:if expr="l.settings:charge:type EQ 'TAX'">
"tax": "&mvtj:charge:amount;",
</mvt:if>
</mvt:foreach>
"total": "&mvtj:order:total;",
<mvt:comment>
| Display all payment fields. To decrpyt encrypted payment data, request must be made with Passphrase[1]=XXXX parameter.
</mvt:comment>
"payment_info": [
<mvt:assign name="g.payment_count" value="miva_array_elements( l.settings:order:payment:fields )" />
<mvt:foreach iterator="field" array="order:payment:fields">
{
"payment_label": "&mvtj:field:label;",
"payment_value": "&mvtj:field:value;"
}
<mvt:if expr="pos2 LT g.payment_count">,</mvt:if>
</mvt:foreach>
],
"shipping_info": {
<mvt:foreach iterator="charge" array="order:charges">
<mvt:if expr="l.settings:charge:type EQ 'SHIPPING'">
"ship_cost": "&mvtj:charge:amount;",
</mvt:if>
</mvt:foreach>
"ship_method": "&mvtj:order:ship_method;"
},
<mvt:comment>
| List all charges available in the order charges loop. This will include Tax, Shipping, Discounts, and Gift Certificates if available
</mvt:comment>
"charges": [
<mvt:assign name="g.charges_count" value="miva_array_elements( l.settings:order:charges )" />
<mvt:foreach iterator="charge" array="order:charges">
{
"charge_type": "&mvtj:charge:type;",
"charge_description": "&mvtj:charge:descrip;",
"charge_amount": "&mvtj:charge:amount;"
}
<mvt:if expr="pos2 LT g.charges_count">,</mvt:if>
</mvt:foreach>
],
<mvt:item name="customfields" param="Read_Order( l.settings:order:id, '' )" />
<mvt:assign name="g.custom_field_count" value="miva_array_elements( l.settings:customfields )" />
<mvt:foreach iterator="field" array="customfields">
"&mvtj:field:code;": "&mvtj:field:value"
<mvt:if expr="pos2 LT g.custom_field_count">,</mvt:if>
</mvt:foreach>
}
<mvt:if expr="pos1 LT g.number_orders">,</mvt:if>
</mvt:foreach>
]
}