country Change country to all my clients

[alexis_gyf]

Hello

Is there an solution to change country to all my clients automatically?

For example before it was a Country "A" with States and zones

Now I create a new Country "B" with new zones but same states.

 

Thanks

Edited September 30, 2023 by alexis_gyf (see edit history)

[endriu107]

You must update PREFIX_address table in your DB. Something like UPDATE ps_address SET id_country = new_country_id WHERE id_country = old_country_id

[alexis_gyf]

Hello

Thanks for your answer but i don't have too much knowledge on database editing.

I have 3 countries with ids 9, 247 and 248 and i want to keep only the id 9

 

I am going to PREFIX_address table and click on edit (or edit inside) link and then type inside these?

UPDATE ps_address SET id_country = 9 WHERE id_country = 247

UPDATE ps_address SET id_country = 9 WHERE id_country = 248

 

Thanks

Edited October 1, 2023 by alexis_gyf (see edit history)

[endriu107]

If you want keep only one country you can do only this one query UPDATE ps_address SET id_country = 9

On YouTube you will find tutorial how to run query in database.

[alexis_gyf]

Thanks again i will check video tutorial.

What if i want to change all my customers the country to this one id 9?

 

 

[alexis_gyf]

1 hour ago, endriu107 said:

If you want keep only one country you can do only this one query UPDATE ps_address SET id_country = 9

On YouTube you will find tutorial how to run query in database.

I change it on sql but on dashboard on address customer i see the old country selected.

Is anything else that i have to change?

Thanks

Edited October 1, 2023 by alexis_gyf (see edit history)

[alexis_gyf]

@endriu107 solve it.

 

Thanks again

[Kogkalidis]

19 hours ago, alexis_gyf said:

I change it on sql but on dashboard on address customer i see the old country selected.

Is anything else that i have to change?

Thanks

There is a bunch of reasons.

1. Cache
2. A scenario where the address is injected with words in a separate table so any alteration in ps_address table will not change a thing.

Could you please let us know what did you do to solve it and what was your case with a little bit more details?

Thanx mate

[alexis_gyf]

45 minutes ago, Kogkalidis said:

There is a bunch of reasons.

1. Cache
2. A scenario where the address is injected with words in a separate table so any alteration in ps_address table will not change a thing.

Could you please let us know what did you do to solve it and what was your case with a little bit more details?

Thanx mate

Hello

Clear cache, delete cache folder, clear cache browser