VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: websmith on March 10, 2017, 03:41:13 AM

Title: Where to get list of countries / states to import to VM
Post by: websmith on March 10, 2017, 03:41:13 AM
Joomla 3.6.5
VM 3.0.18.5

We currently only have US as option for ordering and shipping to, and would like to ship to other countries. Where can I get a list of countries, states and codes to import or add? and what file would I need to edit for this?

I know this can be done manually in admin but that could take a very long time to imput. Im hoping there is a list that can be imported somehow. Thanks for any help or advise.
Title: Re: Where to get list of countries / states to import to VM
Post by: Studio 42 on March 10, 2017, 11:09:19 AM
The list exist, ad or remove your accepted country or enable it in Virtuemart(if you select nothing then it's same as selecting all).
Another solution if you have removed it, is to get the query from
YOURSITE\administrator\components\com_virtuemart\install\install_required_data.sql
after Dumping data for table `#__virtuemart_countries`
And run is directly in phpmyadmin You need to change the prefix of course to your Joomla prefix
Title: Re: Where to get list of countries / states to import to VM
Post by: jenkinhill on March 10, 2017, 11:51:42 AM
Quote from: websmith on March 10, 2017, 03:41:13 AM
Joomla 4.6.5

Really?
Title: Re: Where to get list of countries / states to import to VM
Post by: websmith on March 10, 2017, 16:26:42 PM
Wooops typo.  :-[