<?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[no]]></output_empty_file>
      <localpath><![CDATA[/home/qttest/public_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_weight]]></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>
      <spreadsheetid><![CDATA[]]></spreadsheetid>
      <sheetname><![CDATA[]]></sheetname>
      <range_from><![CDATA[]]></range_from>
      <range_to><![CDATA[]]></range_to>
      <valueInputOption><![CDATA[RAW]]></valueInputOption>
      <export_filename><![CDATA[intrastat.xlsx]]></export_filename>
      <export_file><![CDATA[xlsx]]></export_file>
      <sheet_name><![CDATA[intrastat]]></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[yes]]></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[Arial]]></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>
      <language><![CDATA[en-EU]]></language>
      <splitorderline><![CDATA[no]]></splitorderline>
      <ordernostart><![CDATA[]]></ordernostart>
      <ordernoend><![CDATA[]]></ordernoend>
      <orderlist><![CDATA[]]></orderlist>
      <usedatefield><![CDATA[modified_on]]></usedatefield>
      <orderdaterange><![CDATA[thisyear]]></orderdaterange>
      <lastorderid><![CDATA[]]></lastorderid>
      <orderdatestart><![CDATA[]]></orderdatestart>
      <orderdateend><![CDATA[]]></orderdateend>
      <ordermdatestart><![CDATA[]]></ordermdatestart>
      <ordermdateend><![CDATA[]]></ordermdateend>
      <orderstatus>
        <option><![CDATA[S]]></option>
      </orderstatus>
      <orderpayment>
        <option><![CDATA[]]></option>
      </orderpayment>
      <ordershipment>
        <option><![CDATA[]]></option>
      </ordershipment>
      <order_address><![CDATA[BT]]></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":"invoice_number"}}]]></groupbyfields>
      <sortfields><![CDATA[{"sortfields0":{"name":"modified_on","sortby":"ASC"}}]]></sortfields>
      <use_system_limits><![CDATA[no]]></use_system_limits>
      <max_execution_time><![CDATA[]]></max_execution_time>
      <memory_limit><![CDATA[]]></memory_limit>
    </settings>
    <template_name><![CDATA[Intrastat]]></template_name>
    <template_alias><![CDATA[intrastat]]></template_alias>
    <advanced><![CDATA[0]]></advanced>
    <action><![CDATA[export]]></action>
    <frontend><![CDATA[0]]></frontend>
    <secret><![CDATA[]]></secret>
    <log><![CDATA[0]]></log>
    <lastrun><![CDATA[2025-06-10 18:02:29]]></lastrun>
    <enabled><![CDATA[1]]></enabled>
    <ordering><![CDATA[0]]></ordering>
    <notes><![CDATA[]]></notes>
    <tag><![CDATA[]]></tag>
    <featured><![CDATA[1]]></featured>
    <fields>
      <field>
        <field_name><![CDATA[modified_on]]></field_name>
        <column_header><![CDATA[]]></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>
        <field_name><![CDATA[invoice_number]]></field_name>
        <column_header><![CDATA[]]></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>
        <field_name><![CDATA[order_number]]></field_name>
        <column_header><![CDATA[]]></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>
        <field_name><![CDATA[custom]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[87089235]]></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>
      </field>
      <field>
        <field_name><![CDATA[billing_country_2_code]]></field_name>
        <column_header><![CDATA[]]></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[Skip non-EU]]></name>
            <action><![CDATA[export]]></action>
            <ordering><![CDATA[0]]></ordering>
            <plugin><![CDATA[csviskip]]></plugin>
            <plugin_params>
              <applywhenempty><![CDATA[0]]></applywhenempty>
              <match_method><![CDATA[regex]]></match_method>
              <match_regex><![CDATA[/^(?!AT|BE|BG|HR|CZ|DK|EE|FI|FR|DE|GR|HU|IE|IT|LV|LT|LU|MT|NL|PL|PT|RO|SK|SI|ES|SE).{2}$/]]></match_regex>
              <match_values><![CDATA[]]></match_values>
              <date_selector><![CDATA[date_before]]></date_selector>
              <date_to_check><![CDATA[date_current]]></date_to_check>
              <date_format><![CDATA[]]></date_format>
              <date_value><![CDATA[]]></date_value>
            </plugin_params>
          </rule>
        </fieldrules>
      </field>
      <field>
        <field_name><![CDATA[custom]]></field_name>
        <column_header><![CDATA[source_country]]></column_header>
        <default_value><![CDATA[CN]]></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>
      </field>
      <field>
        <field_name><![CDATA[billing_eu_vat_id]]></field_name>
        <column_header><![CDATA[]]></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>
      </field>
      <field>
        <field_name><![CDATA[order_total]]></field_name>
        <column_header><![CDATA[]]></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>
      </field>
      <field>
        <field_name><![CDATA[custom]]></field_name>
        <column_header><![CDATA[shipping]]></column_header>
        <default_value><![CDATA[DAP]]></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>
        <field_name><![CDATA[order_note]]></field_name>
        <column_header><![CDATA[shipping_cost]]></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>
        <field_name><![CDATA[order_weight]]></field_name>
        <column_header><![CDATA[]]></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>
    </fields>
  </template>
</csvi>
