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

Question

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?

Med Said BARA · Answer

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 [1] 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/ [2] !

[1] http://bazaar.launchpad.net/~akretion-team/p

Jeff Beidler · Answer

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.

Gerelateerde posts	Antwoorden	Weergaven
How to Set Odoo Default Country - Odoo 11CE countries states odoo11community	3 apr. 19	7391
Disable states for certain countries v12 Opgelost country countries ecommerce states	2 mei 19	5635
Issue with import and comma in Excel File (odoo 19) import	0 sep. 25	234
Importacion de Atributos y Valores import	2 mei 25	2301
Import from Winbooks Opgelost import	4 mei 25	6774

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!