{"id":378,"date":"2024-02-28T00:09:11","date_gmt":"2024-02-27T18:39:11","guid":{"rendered":"https:\/\/mukundasoftware.com\/blog\/?p=378"},"modified":"2024-02-28T08:41:35","modified_gmt":"2024-02-28T03:11:35","slug":"how-to-disable-all-countries-and-only-allow-india-opencart-3","status":"publish","type":"post","link":"https:\/\/mukundasoftware.com\/blog\/help\/opencart\/how-to-disable-all-countries-and-only-allow-india-opencart-3.html","title":{"rendered":"How to disable all countries and only allow India &#8211; OpenCart 3"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong> <br>Status = 0 [Means Disable]<br>Status = 1 [Means Enabled]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Login to <strong>phpmyadmin<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select your <strong>Database<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click on<strong> SQL<\/strong> Tab and Run this code:<br><br><code>UPDATE ocdemo_country SET status = 0 WHERE country_id &lt;> 99;<br>UPDATE ocdemo_zone SET status = 0 WHERE country_id &lt;> 99;<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"176\" src=\"https:\/\/mukundasoftware.com\/blog\/wp-content\/uploads\/2024\/02\/phpmyadmin_sql_code_country_disable_in_opencart.jpg\" alt=\"phpmyadmin mysql database screenshot\" class=\"wp-image-382\" srcset=\"https:\/\/mukundasoftware.com\/blog\/wp-content\/uploads\/2024\/02\/phpmyadmin_sql_code_country_disable_in_opencart.jpg 539w, https:\/\/mukundasoftware.com\/blog\/wp-content\/uploads\/2024\/02\/phpmyadmin_sql_code_country_disable_in_opencart-300x98.jpg 300w, https:\/\/mukundasoftware.com\/blog\/wp-content\/uploads\/2024\/02\/phpmyadmin_sql_code_country_disable_in_opencart-150x49.jpg 150w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;ocdemo_&#8221; is database prefix. Change according to your installed OpenCart database prefix.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">India Position in OpenCart Country List &#8211; &#8220;99&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Note: Status = 0 [Means Disable]Status = 1 [Means Enabled] Login to phpmyadmin Select your Database. Click on SQL Tab and Run this code: UPDATE ocdemo_country SET status = 0 WHERE country_id &lt;> 99;UPDATE ocdemo_zone SET status = 0 WHERE country_id &lt;> 99; &#8220;ocdemo_&#8221; is database prefix. Change according to your installed OpenCart database prefix. &#8230; <a title=\"How to disable all countries and only allow India &#8211; OpenCart 3\" class=\"read-more\" href=\"https:\/\/mukundasoftware.com\/blog\/help\/opencart\/how-to-disable-all-countries-and-only-allow-india-opencart-3.html\" aria-label=\"Read more about How to disable all countries and only allow India &#8211; OpenCart 3\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":380,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[],"class_list":["post-378","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-opencart"],"_links":{"self":[{"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/posts\/378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=378"}],"version-history":[{"count":3,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/posts\/378\/revisions"}],"predecessor-version":[{"id":384,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/posts\/378\/revisions\/384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/media\/380"}],"wp:attachment":[{"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mukundasoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}