Odoo Help


How do I import supplier records with foreign state or country codes?

Jeff Beidler
on 8/11/14, 1:56 PM 2,807 views

I am attempting to import supplier records, and all works well as long as the supplier country is "US".  However, the validation fails when it hits a record where the supplier country is "CA".  I get an error message about an unknown state code.  I don't see anywhere in the system to add/configure other state codes.  How do I work around this issue?

Jeff Beidler
On 8/11/14, 2:34 PM

Well, I have found that I can go to Sales-->Configuration-->Address Book-->Localization-->Fed. States and import state codes, but it seems like there has to be a better way.  It would be a pain to have to go look up every country you need, make a CSV file of state/province codes, and then import that.  It seems like there should be some way to just go in and enable other countries.

AFAIK, there is actually no other way to import States or Cities. Of course, this can be easily done (Integrated = added to OpenERP) for all countries, but think about the amount of data needed for populating the database !!! is it really necessary ?

Med Said BARA
on 8/11/14, 2:52 PM

Med Said BARA

--Med Said BARA--

| 5 5 7
--Med Said BARA--
Med Said BARA
On 8/11/14, 2:26 PM

You can add the States and Codes for CANADA under: Sales --> Configuration --> Address Book .

Also, try to take a look at http://bazaar.launchpad.net/~akretion-team/partner-contact-management/base-location-geonames-import/files there are some modules that can be useful, especially this module http://bazaar.launchpad.net/~akretion-team/partner-contact-management/base-location-geonames-import/files/head:/base_location_geonames_import/ !

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 8/11/14, 1:56 PM
Seen: 2807 times
Last updated: 3/16/15, 8:10 AM