Insert cities by using excel

Store Builder Questions
1

Hello,

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

Theodore

2

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.

3

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

Theodore

4

how to import states ?

5

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