<?xml version="1.0"?>
<csvi>
  <template>
    <settings>
      <action><![CDATA[export]]></action>
      <component><![CDATA[com_virtuemart]]></component>
      <operation><![CDATA[order]]></operation>
      <override><![CDATA[]]></override>
      <exportto>
        <option><![CDATA[todownload]]></option>
      </exportto>
      <output_empty_file><![CDATA[yes]]></output_empty_file>
      <localpath><![CDATA[/var/www/html]]></localpath>
      <ftphost><![CDATA[]]></ftphost>
      <ftpport><![CDATA[]]></ftpport>
      <sftp><![CDATA[no]]></sftp>
      <ftpusername><![CDATA[]]></ftpusername>
      <ftppass><![CDATA[]]></ftppass>
      <ftproot><![CDATA[]]></ftproot>
      <ftpfile><![CDATA[]]></ftpfile>
      <export_email_addresses><![CDATA[]]></export_email_addresses>
      <export_email_addresses_cc><![CDATA[]]></export_email_addresses_cc>
      <export_email_addresses_bcc><![CDATA[]]></export_email_addresses_bcc>
      <export_email_subject><![CDATA[]]></export_email_subject>
      <export_email_body><![CDATA[]]></export_email_body>
      <databasetype><![CDATA[]]></databasetype>
      <localtablelist><![CDATA[]]></localtablelist>
      <primary_key_source><![CDATA[Order No]]></primary_key_source>
      <primary_key_target><![CDATA[id]]></primary_key_target>
      <create_new_columns><![CDATA[yes]]></create_new_columns>
      <empty_table><![CDATA[no]]></empty_table>
      <database_username><![CDATA[]]></database_username>
      <database_password><![CDATA[]]></database_password>
      <database_host><![CDATA[]]></database_host>
      <database_portno><![CDATA[]]></database_portno>
      <database_name><![CDATA[]]></database_name>
      <database_table><![CDATA[]]></database_table>
      <clientid><![CDATA[]]></clientid>
      <clientsecret><![CDATA[]]></clientsecret>
      <spreadsheetid><![CDATA[]]></spreadsheetid>
      <sheetname><![CDATA[]]></sheetname>
      <range_from><![CDATA[]]></range_from>
      <range_to><![CDATA[]]></range_to>
      <valueInputOption><![CDATA[RAW]]></valueInputOption>
      <export_filename><![CDATA[[d]-[m]-[Y]-dpd.csv]]></export_filename>
      <export_file><![CDATA[csv]]></export_file>
      <sheet_name><![CDATA[Sheet 1]]></sheet_name>
      <sheet_font><![CDATA[Arial]]></sheet_font>
      <field_delimiter><![CDATA[,]]></field_delimiter>
      <text_enclosure><![CDATA["]]></text_enclosure>
      <include_column_headers><![CDATA[yes]]></include_column_headers>
      <include_empty_nodes><![CDATA[no]]></include_empty_nodes>
      <signature><![CDATA[yes]]></signature>
      <use_excel_date><![CDATA[no]]></use_excel_date>
      <publish_state><![CDATA[]]></publish_state>
      <recordstart><![CDATA[]]></recordstart>
      <recordend><![CDATA[]]></recordend>
      <export_date_format><![CDATA[d/m/Y H:i:s]]></export_date_format>
      <export_price_format_decimal><![CDATA[2]]></export_price_format_decimal>
      <export_price_format_decsep><![CDATA[.]]></export_price_format_decsep>
      <export_price_format_thousep><![CDATA[]]></export_price_format_thousep>
      <offset><![CDATA[]]></offset>
      <header><![CDATA[]]></header>
      <body><![CDATA[]]></body>
      <footer><![CDATA[]]></footer>
      <header_column_font><![CDATA[]]></header_column_font>
      <header_font_size><![CDATA[12]]></header_font_size>
      <header_font_style><![CDATA[regular]]></header_font_style>
      <header_align_horizontal><![CDATA[center]]></header_align_horizontal>
      <header_align_vertical><![CDATA[top]]></header_align_vertical>
      <header_column_color><![CDATA[]]></header_column_color>
      <header_column_background><![CDATA[]]></header_column_background>
      <default_column_width><![CDATA[12]]></default_column_width>
      <freeze_panel_size><![CDATA[]]></freeze_panel_size>
      <paper_size><![CDATA[9]]></paper_size>
      <zoom_factor><![CDATA[100]]></zoom_factor>
      <show_grid_lines><![CDATA[yes]]></show_grid_lines>
      <margin_top><![CDATA[]]></margin_top>
      <margin_right><![CDATA[]]></margin_right>
      <margin_bottom><![CDATA[]]></margin_bottom>
      <margin_left><![CDATA[]]></margin_left>
      <margin_header><![CDATA[]]></margin_header>
      <margin_footer><![CDATA[]]></margin_footer>
      <central_vertical><![CDATA[no]]></central_vertical>
      <central_horizontal><![CDATA[yes]]></central_horizontal>
      <empty_rows><![CDATA[]]></empty_rows>
      <merge_cells><![CDATA[]]></merge_cells>
      <custom_text><![CDATA[]]></custom_text>
      <custom_text_column_font><![CDATA[]]></custom_text_column_font>
      <custom_text_font_size><![CDATA[12]]></custom_text_font_size>
      <custom_text_font_style><![CDATA[regular]]></custom_text_font_style>
      <custom_text_align_horizontal><![CDATA[center]]></custom_text_align_horizontal>
      <custom_text_align_vertical><![CDATA[top]]></custom_text_align_vertical>
      <custom_text_column_color><![CDATA[]]></custom_text_column_color>
      <custom_text_column_background><![CDATA[]]></custom_text_column_background>
      <custom_text_footer><![CDATA[]]></custom_text_footer>
      <custom_text_footer_column_font><![CDATA[]]></custom_text_footer_column_font>
      <custom_text_footer_font_size><![CDATA[12]]></custom_text_footer_font_size>
      <custom_text_footer_font_style><![CDATA[regular]]></custom_text_footer_font_style>
      <custom_text_footer_align_horizontal><![CDATA[center]]></custom_text_footer_align_horizontal>
      <custom_text_footer_align_vertical><![CDATA[top]]></custom_text_footer_align_vertical>
      <custom_text_footer_column_color><![CDATA[]]></custom_text_footer_column_color>
      <custom_text_footer_column_background><![CDATA[]]></custom_text_footer_column_background>
      <custom_image_path><![CDATA[]]></custom_image_path>
      <custom_image_name><![CDATA[]]></custom_image_name>
      <custom_image_cell><![CDATA[A1]]></custom_image_cell>
      <custom_image_height><![CDATA[]]></custom_image_height>
      <custom_image_width><![CDATA[]]></custom_image_width>
      <custom_image_row_height><![CDATA[]]></custom_image_row_height>
      <custom_image_rotation><![CDATA[]]></custom_image_rotation>
      <language><![CDATA[en-GB]]></language>
      <splitorderline><![CDATA[no]]></splitorderline>
      <ordernostart><![CDATA[]]></ordernostart>
      <ordernoend><![CDATA[]]></ordernoend>
      <orderlist><![CDATA[]]></orderlist>
      <usedatefield><![CDATA[created_on]]></usedatefield>
      <orderdaterange><![CDATA[]]></orderdaterange>
      <lastorderid><![CDATA[]]></lastorderid>
      <orderdatestart><![CDATA[]]></orderdatestart>
      <orderdateend><![CDATA[]]></orderdateend>
      <ordermdatestart><![CDATA[]]></ordermdatestart>
      <ordermdateend><![CDATA[]]></ordermdateend>
      <orderstatus>
        <option><![CDATA[G]]></option>
        <option><![CDATA[C]]></option>
        <option><![CDATA[S]]></option>
      </orderstatus>
      <orderpayment>
        <option><![CDATA[]]></option>
      </orderpayment>
      <ordershipment>
        <option><![CDATA[]]></option>
      </ordershipment>
      <order_address><![CDATA[BTST]]></order_address>
      <ordermanufacturer>
        <option><![CDATA[none]]></option>
      </ordermanufacturer>
      <ordercurrency>
        <option><![CDATA[]]></option>
      </ordercurrency>
      <orderpricestart><![CDATA[]]></orderpricestart>
      <orderpriceend><![CDATA[]]></orderpriceend>
      <product_categories>
        <option><![CDATA[]]></option>
      </product_categories>
      <incl_subcategory><![CDATA[no]]></incl_subcategory>
      <use_product_customfields><![CDATA[yes]]></use_product_customfields>
      <orderuser>
        <option><![CDATA[]]></option>
      </orderuser>
      <orderproduct>
        <option><![CDATA[]]></option>
      </orderproduct>
      <category_separator><![CDATA[/]]></category_separator>
      <values_separator><![CDATA[,]]></values_separator>
      <items_separator><![CDATA[|]]></items_separator>
      <fields_separator><![CDATA[~]]></fields_separator>
      <nested_values_separator><![CDATA[#]]></nested_values_separator>
      <globalrules><![CDATA[]]></globalrules>
      <groupbyfields><![CDATA[{"groupbyfields0":{"name":"virtuemart_order_id"}}]]></groupbyfields>
      <sortfields><![CDATA[]]></sortfields>
      <use_system_limits><![CDATA[yes]]></use_system_limits>
      <max_execution_time><![CDATA[120]]></max_execution_time>
      <memory_limit><![CDATA[1024]]></memory_limit>
      <csvi_template_id><![CDATA[68]]></csvi_template_id>
      <tags/>
    </settings>
    <template_name><![CDATA[Shipping Export -DPD]]></template_name>
    <template_alias><![CDATA[shipping-export-dpd]]></template_alias>
    <advanced><![CDATA[1]]></advanced>
    <action><![CDATA[export]]></action>
    <frontend><![CDATA[1]]></frontend>
    <secret><![CDATA[]]></secret>
    <log><![CDATA[1]]></log>
    <lastrun><![CDATA[2025-07-23 13:20:34]]></lastrun>
    <enabled><![CDATA[1]]></enabled>
    <ordering><![CDATA[12]]></ordering>
    <notes><![CDATA[]]></notes>
    <tag><![CDATA[]]></tag>
    <featured><![CDATA[1]]></featured>
    <fields>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[virtuemart_order_id]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Order No]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[1]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[full_name]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Name]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[2]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[company]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Company Name]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[3]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[phone_2]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Phone No]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[4]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[Phone Cleanup]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csvimultireplace]]></plugin>
            <plugin_params>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[ ]]></findtext>
              <replacetext><![CDATA[]]></replacetext>
              <multivalue><![CDATA[1]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[0]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[/^\+44|^44/]]></findtext>
              <replacetext><![CDATA[0]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[regex]]></method>
              <stopfirstfind><![CDATA[1]]></stopfirstfind>
              <needle><![CDATA[44]]></needle>
              <start><![CDATA[1]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[phone_2]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Mobile No]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[5]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[Phone Cleanup]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csvimultireplace]]></plugin>
            <plugin_params>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[ ]]></findtext>
              <replacetext><![CDATA[]]></replacetext>
              <multivalue><![CDATA[1]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[0]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[/^\+44|^44/]]></findtext>
              <replacetext><![CDATA[0]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[regex]]></method>
              <stopfirstfind><![CDATA[1]]></stopfirstfind>
              <needle><![CDATA[44]]></needle>
              <start><![CDATA[1]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[address_1]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Shipping Address Line 1]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[6]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[cleanup for Shipping Export]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csvimultireplace]]></plugin>
            <plugin_params>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[,]]></findtext>
              <replacetext><![CDATA[.]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[(]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[)]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[;]]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[']]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[address_2]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Shipping Address Line 2]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[7]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[cleanup for Shipping Export]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csvimultireplace]]></plugin>
            <plugin_params>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[,]]></findtext>
              <replacetext><![CDATA[.]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[(]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[)]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[;]]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[']]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[city]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Shipping Town/City]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[8]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[cleanup for Shipping Export]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csvimultireplace]]></plugin>
            <plugin_params>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[,]]></findtext>
              <replacetext><![CDATA[.]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[(]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[)]]></findtext>
              <replacetext><![CDATA[-]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[;]]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
              <operation><![CDATA[findreplace]]></operation>
              <findtext><![CDATA[']]></findtext>
              <replacetext><![CDATA[ ]]></replacetext>
              <multivalue><![CDATA[0]]></multivalue>
              <applywhenempty><![CDATA[1]]></applywhenempty>
              <separator><![CDATA[|]]></separator>
              <method><![CDATA[text]]></method>
              <stopfirstfind><![CDATA[0]]></stopfirstfind>
              <needle><![CDATA[]]></needle>
              <start><![CDATA[]]></start>
              <end><![CDATA[]]></end>
              <addvalue><![CDATA[]]></addvalue>
              <dateFormat><![CDATA[]]></dateFormat>
              <customDateFormat><![CDATA[]]></customDateFormat>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[zip]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Post Code]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[9]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[email]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Email address]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[10]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[customer_note]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Customer Comments]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[11]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[virtuemart_shipmentmethod_id]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Service Code]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[12]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[ScodeSwap - Standard]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csviscswap]]></plugin>
            <plugin_params>
              <applywhenempty><![CDATA[0]]></applywhenempty>
              <match_method><![CDATA[text]]></match_method>
              <match_regex><![CDATA[]]></match_regex>
              <match_values><![CDATA[]]></match_values>
              <service_type><![CDATA[standard]]></service_type>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[country_2_code]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[Country Code]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[13]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <table_name><![CDATA[]]></table_name>
        <table_alias><![CDATA[]]></table_alias>
        <field_name><![CDATA[virtuemart_shipmentmethod_id]]></field_name>
        <source_field><![CDATA[]]></source_field>
        <xml_node><![CDATA[]]></xml_node>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[14]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[virtuemart_order_id]]></field_name>
        <column_header><![CDATA[Order Weight]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[15]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[Total order weight]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[orderproductmulti]]></plugin>
            <plugin_params/>
          </rule>
        </fieldrules>
      </field>
      <field>
        <field_name><![CDATA[virtuemart_order_id]]></field_name>
        <column_header><![CDATA[Items Weight]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[16]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
        <fieldrules>
          <rule>
            <name><![CDATA[Total order weight]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[orderproductmulti]]></plugin>
            <plugin_params/>
          </rule>
        </fieldrules>
      </field>
      <field>
        <field_name><![CDATA[virtuemart_shipmentmethod_id]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[17]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[custom]]></field_name>
        <column_header><![CDATA[profileid]]></column_header>
        <default_value><![CDATA[2]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[18]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[custom]]></field_name>
        <column_header><![CDATA[Department]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[19]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[shipment_name]]></field_name>
        <column_header><![CDATA[Shipping]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[20]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[shipping_title]]></field_name>
        <column_header><![CDATA[Shipping]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[21]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
      </field>
      <field>
        <field_name><![CDATA[virtuemart_order_id]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[22]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[no]]></enabled>
        <sort><![CDATA[0]]></sort>
        <font_size><![CDATA[0]]></font_size>
      </field>
    </fields>
  </template>
</csvi>
