i want to use "Curaçao" as a country. It is listed in the "vendor/magento/zendframework1/library/Zend/Locale/Data/en.xml" but i do not see it in the country drop down list.
Does anyone know how i can get it to show up in the list? Thank you.
You'll also need to add Curaçao to the directory listing in your store. If you have access to the database, you can test using SQL statements, then create a custom module and InstallData script that can be used again in the future.
For more information on the installer script method, you can see how Magento is creating the initial directory items on Github.
Testing with SQL Queries
Add a record to the
directory_country table, referencing the territory code from the Zend Locale file.
INSERT INTO `directory_country` (`country_id`, `iso2_code`, `iso3_code`) VALUES('CW', 'CW', 'CUW');
Create the default region (same as the country, in this case)
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`)VALUES('CW', 'CUW', 'Curaçao');
Finally, add a region name reference.
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES('en_US', (SELECT `region_id` FROM `directory_country_region` WHERE `country_id` = 'CW'), 'Curaçao');