Admin Right Menu > Country > Load Address Data.
JS Jobs provides interface for loading address data (cities and states) into database using SQL files.
This portion has JoomSky logo and download button that can be used to get address data files from Joomsky.
This portion has fields that can be used to manage different aspects of data import.
Action: This field has two options keep data and discard data. Keep data means the existing cities and states will remain in the tables, discard data means existing cities and states will removed before inserting data. File: This field is used to specify which file is gonna be used (joomsky file or some other). Data Contain : This fields specifies what the file contains (what you want to insert/update), the options are cities, states and city & states File*: This field is used to specify the file that will be used for loading data.
This portion has 'Load Address Data' button after data file has been selected a click on this button will populate (update) tables in the database.
If user has changed country id's from database there will be unexpected results.
Click here to read more...