Insert cities by using excel


I have a store and I want to insert all Greek cities which I have in an MS excel file. Is there any way to insert them all at ones instead of writing them into Shipping/taxes → States → Add State one by one.

Thank you for your help


It would require multiple SQL statements to create the destination_id and then to setup the destination_descriptions table. Easiest approach would be to write a small script that would ready your CSV city data and go through the process of creating them.

Thank you very much for your response it helps a lot.


how to import states ?

Basically same issue for states. States have a code and are related to a country code and have a corresponding description for each language.