Free Geolocation Database for Osclass

Power Your Site's Location-Based Search Instantly

How to use geolocation file

• ✅ Download SQL file from table below. It contains country, region and city records in SQL import format.
• ✅ Go to your Osclass Backoffice (oc-admin) > Tools > Import SQL data.
• ✅ Click on file input and select downloaded .sql file, Then click "Import data" button.
• ✅ Location data has been imported into Osclass. You can now see imported location in Backoffice > International > Locations.

Alternatively, you can replace /*TABLE_PREFIX*/ in sql file with your Osclass database tables prefix (default: oc_) and simply run SQL commands on your database directly. Once you run SQL successfully (or partially), you may need to remove imported data if you want to re-import same locations. You may also customize SQL file before import and enrich it with custom locations.