Technobezz

How to Remove all open cart Countries Except Your Country

To  Remove all open cart Countries Except Your Country ,you first need to know the Id code of your particular country .

If you try to remove a country , it will pop up and say “Caution: This country can not be deleted as it is currently assigned to  zones!”

Therefore to remove all they countries listed, you will need to do it by MySQL. Which in this case you’ll need complete access to you host panel to execute this code.This will remove all the open cart countries in 5 secs.Its much better than doing it manually,Obviously

How To Find the Id Code of your country,Open cart

Please Navigate Your way to

System>Location>Countries

Hover over Your Country’s Edit Link , as shown in the picture below

id

 

 

 

 

 

 

 

 

The Id For United States Of America is id=223 .This can be done to all apply countries , follow the same procedure to find the Id code of any country within your open cart installation..Hover over the Edit Link, The Destination Url Will Appear at the bottom of the window, illustration the full URL, and the id for that country

 

 

Now the you know your Id code for you country, what you need now is the Code to be executed within MySql Of you myphpadmin back office

This is the code you will be using within your Mymphpadmin-Mysql

delete from country where country_id <> 223;
delete from zone where country_id <> 223;

 

As shown in the picture below, Login to your desired database .Navigate SQL .paste and run the code that is shown above. Here you can remove all countries and only allow  USA, Costa Rica, UK, Canada etc

How to all open cart Countries Except Your Country

 

More on this topic

Leave a Reply

Pluto TV
All you need to know about Pluto TV
Samsung Galaxy S10: Several Versions of Renders Make Appearance 10
Samsung Galaxy S10: Several Versions of Renders Make Appearance
The Sims 5: Customer Feedback will Form the Basis for Improvements 12
The Sims 5: Customer Feedback will Form the Basis for Improvements
Samsung Galaxy S10: No Facial Recognition or Headphone Jack 14
Samsung Galaxy S10: No Facial Recognition or Headphone Jack
Android Apple Gaming How To Internet iPhone Personal Computers Review Site review The Top Best
The Sims 5: Customer Feedback will Form the Basis for Improvements 16
The Sims 5: Customer Feedback will Form the Basis for Improvements

The Sims 5: The good old cliché goes ‘Customer is King’,...

"My iPhone 6 Just Won't Turn on" - Why This Happened and How To Fix it' 19
“My iPhone 6 Just Won’t Turn on” – Why This Happened and How To Fix it’

User complaint :  My iPhone 6 Just Won’t Turn on”, I...

HBO Go vs Hbo Now
HBO GO vs. HBO NOW

You have always felt embarrassed while watching those off the track...