Using the EuVat Dataflow Adapter to Update your existing Customer Data

EuVat delivers with a Dataflow Adapter that allows to update your existing customer data by EuVat to reassign the Customer Group of each customer, or update customer related EuVat settings in bulk.

Create a new Advanced Profile:

System » Import/Export » Advanced Profiles

Performing a mass update of the EuVat Tax Status for existing Customer Accounts

This Actions XML allows to perform a mass update on the Tax Status for the existing Customer Accounts. It offers the following options:

Action XML for EuVat Customer Update

<action type="euvat/convert_adapter_euvatupdate" method="update">
   <!-- Optional: Use Store Name to only update Customer Accounts associated to a Store -->
   <var name="storename">My Store</var>
   <!-- Optional: Use Store-ID to only update Customer Accounts associated to a Store -->
   <var name="storeid">1</var>
   <!-- When omitting "storename" or "storeid" then all Customer Accounts are used -->
   <!-- Define a Customer-ID Range to only update a portion of the full Customer Account collection -->
   <var name="customerIdRange">0-10</var>
</action>


<var name=“storename”>Your Store Name</var>
<var name=“storeid”>…</var>
Required: Define your Store Name here (or the Store ID), the Update will only update customers registered with the Website the Store is related to.

<var name=“customerIdRange”>0-10</var>
Optional: To limit the update to customers with a Range of Customer ID's, define the range with this variable.

Be aware that EuVat is changing the Customer Group assignment of your customer data. Refrain from running this Adapter if you want to keep the current group assignment of your Customers intact, and setup Euvat to assign 'Customer Tax Classes' instead. Then run this Adapter to update your customers Tax Class assignment.



Performing a mass update for existing Customer Accounts to set the EuVat Update Exclusion Status

EuVat is allowing to set individual customers to be excluded from any automatic updates performed by EuVat, see here for more on this feature...

This Actions XML allows to perform a mass update on the EuVat Update Exclusion status for the existing Customer Accounts. It offers the following options:

Action XML for EuVat Customer Update on excluding from updates

<action type="euvat/convert_adapter_euvatupdate" method="exclude">
   <var name="storename">My Store</var>
   <var name="customerIdRange">0-10</var>
   <var name="euvatExclude">0</var>
</action>


<var name=“storename”>Your Store Name</var>
Required: Define your Store Name here, the Update will only update customers registered with the Website the Store is related to.

<var name=“customerIdRange”>0-10</var>
Optional: To limit the update to customers with a Range of Customer ID's, define the range with this variable.

<var name=“euvatExclude”>0</var>
Required: Use value “0” to remove the customer account from the exclusion of EuVat updates, use value “1” to set the customer account to be excluded from EuVat updates to the Customer Group or Tax Class.

Use Run Profile to run this profile to update your customers Customer Group with EuVat: