OpenCart MySQL Commands

OpenCart MySQL Commands

Go to phpmyadmin and click on the sql tab.
there you will get a form to input queries.
input the following commands and press “GO”

To enable or disable countries

UPDATE country SET status = 0 WHERE country_id
223;
UPDATE zone SET status = 0 WHERE country_id
223;

223 = USA
222 = UK
150 = Netherlands

status 0 = disabled
status 1 = enabled