[ SOLVED!! ] How can I delete countries?

[SK01]

Hi. I am wondering how I can delete the countries that is displayed when creating an account.

I just want 1 country there, so I want to delete all the others. I think it might be just to change some code somewhere, but since I am new to Prestashop I am asking for your help. Thanks in advance!

[tomerg3]

You can just disable them, in the Backoffice->Shipping->Countries.

[SK01]

I have tried that before.. but the countries is still displayed. Is there any other option?

[tomerg3]

That is the part that controls the countries, you must have not done it correctly.

Can you post a screen shot of that page and a link to your registration page?

[SK01]

Hi again, my fault..

I didn't saw that it was 5 pages ^^.. what a stupid mistake from my side.

Thanks Tomerg3

[tomerg3]

No problem, it happens
Can you please add (Resolved) to the title of the first post.

[SK01]

Thanks very much I will do that right away =)

[nobynator]

Is there a fast way to disable all or do I have to click on Edit>Disable one by one?

[tomerg3]

You can do it with a database query, use phpmyadmin and run the following.

UPDATE ps_country SET active= 0 WHERE iso_code != 'XX'

Replace XX with the country code you want to keep active.

[nobynator]

If I just knew that before I messed up everything, how do I get the Zones/Countys/States to original, which files do I need to replace?

[tomerg3]

Those are also stored in the database, you best option is to install a new PS in a new database, and copy over the tables you messed up.

[nobynator]

Whats the name of the tables that are messed up in my case when it comes to Zones/Countrys/States?

[tomerg3]

Compare any table with the word zone or country or state in it, and copy it over if they are different.

It's best to create a backup before you do anything with the database...

[nobynator]

Okey Ill try it later, second question, how do I get the STATES deleted, I have like 3 states and try to delete them but it says they are in use? Not sure what they mean that they are in use and if so where? hmm

[conniedesign]

I have the same problem too. After I added a new States (Tasmania) at the Back office, I couldn’t see it displayed on the listed states column.

I went to do a test to fill up the address and on the Front Office, on the states drop-down lists has displayed (Tasmania). How can I delete the created states – Tasmania at the Back Office.

I went to search for an answer and only able to find how to delete the countries and not 'STATES'. I did sent this question to the forum but no one has replied and wanted to resolve this problem.

I greatly appreciate your help if you can advice me as I need to launch my website soon. I have attached a screen shots to make my explanation clear.

Thank you and hear from you.
Connie

[vineshkumar]

I didnot get your problem entirely. But still, you added Tasmania and you didnt find it. Did you check that in 2, 3rd page in BO->States. the screenshot is of first page.

[conniedesign]

Hi Kumar,

Thank you for your quick reply. I thought no one will response my post again.

Yes, I went to look carefully of the entire listed States but I couldn't find Tasmina. The funny thing was States that I created eg Tasmania, New South Wales, Victoria and Queensland were not displayed on the listed States. Do you know why?

I have attached a screen shot for your preview. I will wait and hear from you soon. Thank you so much for your post.

Cheers
Connie

[vineshkumar]

In the screenshot, I can see only US based states. Then there is definitely something wrong, might be database related.

What I did was since I was planning to sell only within India, I deleted all countries from the list except India and also all states by going in phpmyadmin and entered the states which I require from BO later. After which the states where getting populated properly in FO while registering.

Atleast in your case, please check ps_states table first and then if needed, add new states from phpmyadmin and see if thats reflected in BO. Or else if you need only Australian states, you can clear the table in phpmyadmin and add new states from BO.

Note: Take a backup of the ps_states table and follow the process.

[conniedesign]

Hi, thank you for your reply. I have send you a post by fast reply.

I am afraid that I will delete some other fields in phpmyadmin and I'm not a programmer. Whether you can guide me the steps or a tutorial links that I can read and follow the example.

I found out how to backup the MySQL in phpmyadmin and do I just backup the ps_state database file or Select All.

At the bottom, I can insert a row and there are some field boxes to enter the States ID/Country/Zone. Not sure how to do that.

Thank you

[vineshkumar]

What you do here is go for the second sheet ie enter values in ps_state.

Enter these values
BLANK, 23, Australia zone code, State name, states ISO code, 0, 1

Blank means do not enter anything. Leave it empty. It is auto increment value.

Australia zone code you will find in table ps_zone which is the last one. Take the id_zone value corresponding to Australia and use in place of Austraia zone code.

[conniedesign]

Finally I know I found all the created missing states and was at page 4 on the ps_states.

Now I know how I can add and edit the states on my phpmyadmin from ps_states.

I appreciated for your kind help and patient, thank you.

Cheers
Connie

[Farid Zenon]

Just delete mysql data enquiry follow by Countries ID code on date base

[eggdesign]

Would it not make life alot easier if there was a "select all" or quick edit to delete multiple countries at once? Just one of many frustrating design faults of Prestashop.

[Bejo]

i can not select all state then delete it with once

 

it's said An error occurred while deleting selection.

 

Help