Author Topic: Where to get list of countries / states to import to VM  (Read 318 times)

websmith

  • Jr. Member
  • **
  • Posts: 119
  • A beginner
Where to get list of countries / states to import to VM
« 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.

Studio 42

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2355
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Where to get list of countries / states to import to VM
« Reply #1 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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26372
  • Always on vacation
    • Jenkin Hill Internet
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.6 on Joomla 3.8.2 PHP 7.0.25

Testing VM3.2.6 on J!4alpha1

websmith

  • Jr. Member
  • **
  • Posts: 119
  • A beginner
Re: Where to get list of countries / states to import to VM
« Reply #3 on: March 10, 2017, 16:26:42 pm »
Wooops typo.  :-[