Odoo Help

Ray Carnes
On 8/26/15, 2:48 PM

Updated for v10:

1. Install https://apps.odoo.com/apps/modules/10.0/base_location/ 


A. Load in a City, State, Zip data file.  I use the US Census files because they are free and updated every year.


You will have to manipulate this file in Excel to pull out the information.  A format like this will go straight into Odoo:

00501,00501,Holtsville,NY,United States
01001,01001,Agawam,MA,United States
01002,01002,Amherst,MA,United States
01003,01003,Amherst,MA,United States
01004,01004,Amherst,MA,United States
01005,01005,Barre,MA,United States
01007,01007,Belchertown,MA,United States
01008,01008,Blandford,MA,United States
01009,01009,Bondsville,MA,United States
01010,01010,Brimfield,MA,United States
01011,01011,Chester,MA,United States
01012,01012,Chesterfield,MA,United States
01013,01013,Chicopee,MA,United States
01014,01014,Chicopee,MA,United States


B. Install https://apps.odoo.com/apps/modules/10.0/base_location_geonames_import/ to do the download and import for you.

This allow users to enter a Zip Code and have the City, State automatically completed. This also catches invalid Zip Codes – ensuring a higher quality of data in your system.

Address completion is available on the screens where you enter a partner address:  

1. Navigate to the Sales --> Sales --> Customers Menu and click CREATE.

You will see a field above the City, State Zip area where you will enter the Zip Code and see the related City and State that will be auto completed:

2. As you enter the Zip Code, Odoo will show you a list of matches you can choose from: 

3.  Once you select the Zip Code, the City, State and Country are automatically filled in:


You can manually add a missing Zip Code record by navigating to Sales --> Configuration --> Address Book -->
Localization --> Cities/Location  

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/26/15, 2:43 PM
Seen: 1105 times
Last updated: 8/11/17, 1:19 PM