Tuesday, October 29, 2013

how to set default country in virtuemart 2.0 with joomla 2.5

Hy guys it easy to set your default country in virtuemart like custom query , i write a query for you put your country name i marked red color.see the country name from virtuemart country table ;
i think you can do

how to set default country in virtuemart 2.0 with joomla 2.5
example
UPDATE can_virtuemart_userfields SET `default`=(SELECT virtuemart_country_id 
FROM can_virtuemart_countries WHERE country_name='United States') 
WHERE name='virtuemart_country_id';

3 comments: