Add previously purged shipping locations adds empty lines

[Shop Suey]

About a decade ago I decided to ship national only.
I purged all countries but one manually via the admin.
Today I need to add some additional countries and get the problem, that there are also some empty lines added to choose.
How can I fix this?
Please see the attachement.

[mprough]

About a decade ago I decided to ship national only.
I purged all countries but one manually via the admin.
Today I need to add some additional countries and get the problem, that there are also some empty lines added to choose.
How can I fix this?
Please see the attachement.

In order to create these you will need to grab the SQL from the correct install version of Zen Cart or port them from another same version install.

~Melanie

[Shop Suey]

I could install a blank shop with the same zc version.
How can I port them?

[mprough]

I could install a blank Shop with the same zc version.
How can I port them?

You'll need to use a database tool like PHPmyAdmin to export the table, then drop it in to the other DB. BACKUP first =)

[Shop Suey]

Thank you for the hint.
There is a way with more control. I don't like to copy&paste tables between different shop and database versions.

1. add via admin
2. pickup the countries id from the table countries_name
3. edit the countries id at the table countries

This seems to work so far.

[swguy]

> I purged all countries but one manually via the admin.

This is a better way:

https://docs.zen-cart.com/user/admin...ling-countries