Bulk Delete Country and Zones

Hi, I am a newbie!

I recently wanted to bulk remove countries from my drop down menu at checkout. So, I updated the list and using the instructions from viewtopic.php?t=8102, I was able to remove all the countries except the united states. Which is what I wanted to do.

However, when I check if my website has updated with the new changes. It still shows me all of the countries.

Was there an extra step that needed to be done after this?

Does this have to do with the export options?

Thanks!

However, when I check if my website has updated with the new changes. It still shows me all of the countries.

No OC version posted. However, FAQ: viewtopic.php?f=176&p=732808#p718325

Thank you!

I am using version 3.0.2.1 and that method didn't work ):

straightlight wrote: ↑

Tue Aug 28, 2018 1:52 am

However, when I check if my website has updated with the new changes. It still shows me all of the countries.

No OC version posted. However, FAQ: viewtopic.php?f=176&p=732808#p718325

If your countries and zones are indeed deleted from the OC admin and you still see the results from the store-front end, this issue might be related to this FAQ: viewtopic.php?f=176&p=732808#p731004 . In order to ensure your cache is working properly, see this FAQ: viewtopic.php?f=176&p=732808#p717782 and by contacting your host if the issue persists with the host cache.

I deleted the countries and zones using SQL on phpmyadmin. As followed by the link above. It seems fine there but when I am on OC admin, all the countries are still there and I still do not see change. I've refreshed and cleared cache. I am not sure where else to go.

straightlight wrote: ↑

Tue Aug 28, 2018 2:06 am

If your countries and zones are indeed deleted from the OC admin and you still see the results from the store-front end, this issue might be related to this FAQ: viewtopic.php?f=176&p=732808#p731004 . In order to ensure your cache is working properly, see this FAQ: viewtopic.php?f=176&p=732808#p717782 and by contacting your host if the issue persists with the host cache.

Ensure your database table write access are all check marked from your host console. It looks like you have only set access from your host console to delete entries from your SQL database tables but not elsewhere.