Full list of countries in address field

[Dakkar]

Hello. I would like the customer to be able fill into adress field his country from the list or complete it on his own. At the moment, the list of available countries includes only those for which I have downloaded the localization package. Do I have to download the localization package for every possible country?

[tuk66]

No, the list contains all enabled countries. Localization packs contain translations, currencies, etc. PrestaShop is filled with all countries.

[Dakkar]

Thanks!

[Dakkar]

Is there any way to change the address format for all countries at the same time?

[tuk66]

Yes, using SQL query.

[prestapp]

On 20/11/2017 at 6:13 PM, tuk66 dice:

Yes, using SQL query.

Hi,

can you add the SQL query?

Thanks

[Luisbo69]

On 11/20/2017 at 12:03 PM, Dakkar said:

Is there any way to change the address format for all countries at the same time?

UPDATE `XXX_address_format` SET `format` = 'firstname lastname\r\naddress1\r\ncity\r\nCountry:name' WHERE 1

[Luisbo69]

On 1/19/2021 at 6:01 AM, prestapp said:

Hi,

can you add the SQL query?

Thanks

UPDATE `XXX_address_format` SET `format` = 'firstname lastname\r\naddress1\r\ncity\r\nCountry:name' WHERE 1