I remember before the server went down there was a post in which someone attached a zip file with the sql for all country's and their zones. Does anyone still have that file?
All countires and zones?
After I've uploaded the sql file to the database the region bar for the country where regions are not specified shows "Not applicable". It should give an option for users to write zones on their own. Please check the image below.
Any solution to the problem?
| Attachment | Size |
|---|---|
| zone-not-applicable.jpg | 25.88 KB |
The list of 189 countries (without regions) which are supported by Paypal. Paypal supports 190 countries but I didn't find code for one country named "Democratic Republic of the Congo (CD)".
To show ONLY Paypal countries in country list remove all previous countries in SQL, database of ubercart (uc_countries), through phpMyAdmin, then import the file to phpMyAdmin. Remove the extension "_.txt" before you proceed.
| Attachment | Size |
|---|---|
| uc_countries.sql_.txt | 7.95 KB |
According to Wikipedia, the codes for CD are 180 and COD
http://en.wikipedia.org/wiki/ISO_3166-1
Attached is an updated file just with that one line added.
I've also made an insert query according to the full country list in the same wikipedia page... If anyone is interested I can put that up here.
| Attachment | Size |
|---|---|
| uc_countries.sql_.txt | 8 KB |
Thanks for this. I think your uc_countries.sql_.zip works fine on my site. all African countries appear to be available, which is my top priority.
It would be helpful for others I think if these were already included in the ubercart module by default, with all countries turned on or at least easy to turn on. I had an interesting 20 minutes of pressing the button to install all the countries available in ubercart before finding this.
Cheers,
Tobias
*List of 190 countries of PayPal.
*Name of countries are exactly as stated in paypal website - https://www.paypal.com/worldwide/.
*There is an error in country numeric code of Ethiopia which has been rectified in this update.
I have manually checked each and every code so there should not be errors anymore.
| Attachment | Size |
|---|---|
| uc_paypal_countries.sql_.txt | 7.98 KB |
The problem with the Paypal Countries list is that PayPal doesn't service all the countries in the world, and therefore the list is incomplete. I ran into this problem when trying to accept donations from South American countries like Paraguay and Uraguay -- PayPal doesn't have a relationship with those countries.
--
This thread contains a far more complete list of countries (245 at the time of this post):
http://www.ubercart.org/forum/internationalization/347/country_and_zone_...
Actually, I've done it myself see attached.
The original data I was working with had a region column for grouping the countrys by continent. I've attached a CSV file if anyone is interested in it. Perhaps would be handy for the shipping module.
Uberdevelopment www.tsd.net.au/blog