This problem can happen when Site Tracking settings are activated on your site and the tracking data has been gathering for years. Sometimes the tracking data can reach a couple GB and then it starts to burden the database.
We recommend to run the following MySQL queries to clean this data (Tools > DB Management > Run SQL Query):
DELETE FROM va_tracking_visits
and this one:
DELETE FROM va_tracking_pages
read more...To add VAT validation, please implement the following steps:
Note: to enable automatic checking of the VAT number and tax recalculation as soon as the VAT number is entered, you can add the following line in the Custom Order Field properties in "JavaScript Settings" "OnChange Event" field:
document.order_info.operation.value='refresh';document.order_info.submit();
//$vat_validation = true;
like:
$vat_validation = true;
To specify countries from which users are obligated to pay VAT regardless whether they specify a VAT number or not uncomment the string:
$vat_obligatory_countries = array("GB");
And specify in brackets the country codes with a comma: "GB","FR","LT", etc.
If you don't want to use a third party server validation uncomment the string:
$vat_remote_exception_countries = array("NL");
Then VAT number will be validated for specified countries only with the local regular expressions.
You can activate email login in Settings > Site Users > User Types > Customer > Profile Settings > Predefined Fields:
Login DetailsTo change login for old users please run a SQL query:
update va_users set login=email
Otherwise old users (registered before this change) could still use their old login details. It works this way because email field may not be required during registration so these users need to have a way to login.
After these changes, would ViArt now use the field "login" to populate the field "email" in the order profile?
Yes, it would.
Would this mean that I can remove "Email" from the "show" and "required"Yes, you can remove it. read more...