Magento 2 : State dropdown showing regionID is required field












1















I am using magento 2.1. On Admin side on order creation page, some specific countries have states in dropdown. I need to show state dropdown for India country. For this purpose I have fired following 2 queries.



INSERT INTO `directory_country_region` VALUES
(548 , 'IN', '35','Andaman Nicobar'),
(549 , 'IN', '28','Andhra Pradesh'),
(550 , 'IN', '12','Arunachal Pradesh'),
(551 , 'IN', '18','Assam'),
(552 , 'IN', '10','Bihar'),
(553 , 'IN', '04','Chandigarh'),
(554 , 'IN', '22','Chhattisgarh'),
(555 , 'IN', '26','Dadra Nagar Haveli'),
(556 , 'IN', '25','Daman Diu'),
(557 , 'IN', '07','Delhi'),
(558 , 'IN', '30','Goa'),
(559 , 'IN', '24','Gujarat'),
(560 , 'IN', '06','Haryana'),
(561 , 'IN', '02','Himachal Pradesh'),
(562 , 'IN', '01','Jammu Kashmir'),
(563 , 'IN', '20','Jharkhand'),
(564 , 'IN', '29','Karnataka'),
(565 , 'IN', '32','Kerala'),
(566 , 'IN', '31','Lakshadweep'),
(567 , 'IN', '23','Madhya Pradesh'),
(568 , 'IN', '27','Maharashtra'),
(569 , 'IN', '14','Manipur'),
(570 , 'IN', '17','Meghalaya'),
(571 , 'IN', '15','Mizoram'),
(572 , 'IN', '13','Nagaland'),
(573 , 'IN', '21','Odisha'),
(574 , 'IN', '34','Pondicherry'),
(575 , 'IN', '03','Punjab'),
(576 , 'IN', '08','Rajasthan'),
(577 , 'IN', '11','Sikkim'),
(578 , 'IN', '33','Tamil Nadu'),
(579 , 'IN', '36','Telangana'),
(580 , 'IN', '16','Tripura'),
(581 , 'IN', '09','Uttar Pradesh'),
(582 , 'IN', '05','Uttaranchal'),
(583 , 'IN', '19','West Bengal');


Second Query :



INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',548,'Andaman Nicobar'),
('en_US',549,'Andra Pradesh'),
('en_US',550,'Arunachal Pradesh'),
('en_US',551,'Assam'),
('en_US',552,'Bihar'),
('en_US',553,'Chandigarh'),
('en_US',554,'Chhattisgarh'),
('en_US',555,'Dadar and Nagar Haveli'),
('en_US',556,'Daman Diu'),
('en_US',557,'Delhi'),
('en_US',558,'Goa'),
('en_US',559,'Gujarat'),
('en_US',560,'Haryana'),
('en_US',561,'Himachal Pradesh'),
('en_US',562,'Jammu and Kashmir'),
('en_US',563,'Jharkhand'),
('en_US',564,'Karnataka'),
('en_US',565,'Kerala'),
('en_US',566,'Lakshadweep'),
('en_US',567,'Madhya Pradesh'),
('en_US',568,'Maharashtra'),
('en_US',569,'Manipur'),
('en_US',570,'Meghalaya'),
('en_US',571,'Mizoram'),
('en_US',572,'Nagaland'),
('en_US',573,'Odisha'),
('en_US',574,'Pondicherry'),
('en_US',575,'Punjab'),
('en_US',576,'Rajasthan'),
('en_US',577,'Sikkim'),
('en_US',578,'Tamil Nadu'),
('en_US',579,'Telangana'),
('en_US',580,'Tripura'),
('en_US',581,'Uttar Pradesh'),
('en_US',582,'Uttaranchal'),
('en_US',583,'West Bengal');


After firing above queries, on order page, in country dropdown when I select India, state dropdown is getting populated. But when I select state and fills other required info and submits page, it is showing me following error.




"regionId is a required field."




Not able to fix this issue. Kindly help if anyone knows.










share|improve this question























  • No one has idea about this? :(

    – Mahesh Gaikwad
    Jul 13 '17 at 12:03











  • I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

    – Suresh Chikani
    Jul 13 '17 at 18:06













  • I have done reindexing and cleared cache as well. But still same problem.

    – Mahesh Gaikwad
    Jul 14 '17 at 9:49
















1















I am using magento 2.1. On Admin side on order creation page, some specific countries have states in dropdown. I need to show state dropdown for India country. For this purpose I have fired following 2 queries.



INSERT INTO `directory_country_region` VALUES
(548 , 'IN', '35','Andaman Nicobar'),
(549 , 'IN', '28','Andhra Pradesh'),
(550 , 'IN', '12','Arunachal Pradesh'),
(551 , 'IN', '18','Assam'),
(552 , 'IN', '10','Bihar'),
(553 , 'IN', '04','Chandigarh'),
(554 , 'IN', '22','Chhattisgarh'),
(555 , 'IN', '26','Dadra Nagar Haveli'),
(556 , 'IN', '25','Daman Diu'),
(557 , 'IN', '07','Delhi'),
(558 , 'IN', '30','Goa'),
(559 , 'IN', '24','Gujarat'),
(560 , 'IN', '06','Haryana'),
(561 , 'IN', '02','Himachal Pradesh'),
(562 , 'IN', '01','Jammu Kashmir'),
(563 , 'IN', '20','Jharkhand'),
(564 , 'IN', '29','Karnataka'),
(565 , 'IN', '32','Kerala'),
(566 , 'IN', '31','Lakshadweep'),
(567 , 'IN', '23','Madhya Pradesh'),
(568 , 'IN', '27','Maharashtra'),
(569 , 'IN', '14','Manipur'),
(570 , 'IN', '17','Meghalaya'),
(571 , 'IN', '15','Mizoram'),
(572 , 'IN', '13','Nagaland'),
(573 , 'IN', '21','Odisha'),
(574 , 'IN', '34','Pondicherry'),
(575 , 'IN', '03','Punjab'),
(576 , 'IN', '08','Rajasthan'),
(577 , 'IN', '11','Sikkim'),
(578 , 'IN', '33','Tamil Nadu'),
(579 , 'IN', '36','Telangana'),
(580 , 'IN', '16','Tripura'),
(581 , 'IN', '09','Uttar Pradesh'),
(582 , 'IN', '05','Uttaranchal'),
(583 , 'IN', '19','West Bengal');


Second Query :



INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',548,'Andaman Nicobar'),
('en_US',549,'Andra Pradesh'),
('en_US',550,'Arunachal Pradesh'),
('en_US',551,'Assam'),
('en_US',552,'Bihar'),
('en_US',553,'Chandigarh'),
('en_US',554,'Chhattisgarh'),
('en_US',555,'Dadar and Nagar Haveli'),
('en_US',556,'Daman Diu'),
('en_US',557,'Delhi'),
('en_US',558,'Goa'),
('en_US',559,'Gujarat'),
('en_US',560,'Haryana'),
('en_US',561,'Himachal Pradesh'),
('en_US',562,'Jammu and Kashmir'),
('en_US',563,'Jharkhand'),
('en_US',564,'Karnataka'),
('en_US',565,'Kerala'),
('en_US',566,'Lakshadweep'),
('en_US',567,'Madhya Pradesh'),
('en_US',568,'Maharashtra'),
('en_US',569,'Manipur'),
('en_US',570,'Meghalaya'),
('en_US',571,'Mizoram'),
('en_US',572,'Nagaland'),
('en_US',573,'Odisha'),
('en_US',574,'Pondicherry'),
('en_US',575,'Punjab'),
('en_US',576,'Rajasthan'),
('en_US',577,'Sikkim'),
('en_US',578,'Tamil Nadu'),
('en_US',579,'Telangana'),
('en_US',580,'Tripura'),
('en_US',581,'Uttar Pradesh'),
('en_US',582,'Uttaranchal'),
('en_US',583,'West Bengal');


After firing above queries, on order page, in country dropdown when I select India, state dropdown is getting populated. But when I select state and fills other required info and submits page, it is showing me following error.




"regionId is a required field."




Not able to fix this issue. Kindly help if anyone knows.










share|improve this question























  • No one has idea about this? :(

    – Mahesh Gaikwad
    Jul 13 '17 at 12:03











  • I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

    – Suresh Chikani
    Jul 13 '17 at 18:06













  • I have done reindexing and cleared cache as well. But still same problem.

    – Mahesh Gaikwad
    Jul 14 '17 at 9:49














1












1








1


1






I am using magento 2.1. On Admin side on order creation page, some specific countries have states in dropdown. I need to show state dropdown for India country. For this purpose I have fired following 2 queries.



INSERT INTO `directory_country_region` VALUES
(548 , 'IN', '35','Andaman Nicobar'),
(549 , 'IN', '28','Andhra Pradesh'),
(550 , 'IN', '12','Arunachal Pradesh'),
(551 , 'IN', '18','Assam'),
(552 , 'IN', '10','Bihar'),
(553 , 'IN', '04','Chandigarh'),
(554 , 'IN', '22','Chhattisgarh'),
(555 , 'IN', '26','Dadra Nagar Haveli'),
(556 , 'IN', '25','Daman Diu'),
(557 , 'IN', '07','Delhi'),
(558 , 'IN', '30','Goa'),
(559 , 'IN', '24','Gujarat'),
(560 , 'IN', '06','Haryana'),
(561 , 'IN', '02','Himachal Pradesh'),
(562 , 'IN', '01','Jammu Kashmir'),
(563 , 'IN', '20','Jharkhand'),
(564 , 'IN', '29','Karnataka'),
(565 , 'IN', '32','Kerala'),
(566 , 'IN', '31','Lakshadweep'),
(567 , 'IN', '23','Madhya Pradesh'),
(568 , 'IN', '27','Maharashtra'),
(569 , 'IN', '14','Manipur'),
(570 , 'IN', '17','Meghalaya'),
(571 , 'IN', '15','Mizoram'),
(572 , 'IN', '13','Nagaland'),
(573 , 'IN', '21','Odisha'),
(574 , 'IN', '34','Pondicherry'),
(575 , 'IN', '03','Punjab'),
(576 , 'IN', '08','Rajasthan'),
(577 , 'IN', '11','Sikkim'),
(578 , 'IN', '33','Tamil Nadu'),
(579 , 'IN', '36','Telangana'),
(580 , 'IN', '16','Tripura'),
(581 , 'IN', '09','Uttar Pradesh'),
(582 , 'IN', '05','Uttaranchal'),
(583 , 'IN', '19','West Bengal');


Second Query :



INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',548,'Andaman Nicobar'),
('en_US',549,'Andra Pradesh'),
('en_US',550,'Arunachal Pradesh'),
('en_US',551,'Assam'),
('en_US',552,'Bihar'),
('en_US',553,'Chandigarh'),
('en_US',554,'Chhattisgarh'),
('en_US',555,'Dadar and Nagar Haveli'),
('en_US',556,'Daman Diu'),
('en_US',557,'Delhi'),
('en_US',558,'Goa'),
('en_US',559,'Gujarat'),
('en_US',560,'Haryana'),
('en_US',561,'Himachal Pradesh'),
('en_US',562,'Jammu and Kashmir'),
('en_US',563,'Jharkhand'),
('en_US',564,'Karnataka'),
('en_US',565,'Kerala'),
('en_US',566,'Lakshadweep'),
('en_US',567,'Madhya Pradesh'),
('en_US',568,'Maharashtra'),
('en_US',569,'Manipur'),
('en_US',570,'Meghalaya'),
('en_US',571,'Mizoram'),
('en_US',572,'Nagaland'),
('en_US',573,'Odisha'),
('en_US',574,'Pondicherry'),
('en_US',575,'Punjab'),
('en_US',576,'Rajasthan'),
('en_US',577,'Sikkim'),
('en_US',578,'Tamil Nadu'),
('en_US',579,'Telangana'),
('en_US',580,'Tripura'),
('en_US',581,'Uttar Pradesh'),
('en_US',582,'Uttaranchal'),
('en_US',583,'West Bengal');


After firing above queries, on order page, in country dropdown when I select India, state dropdown is getting populated. But when I select state and fills other required info and submits page, it is showing me following error.




"regionId is a required field."




Not able to fix this issue. Kindly help if anyone knows.










share|improve this question














I am using magento 2.1. On Admin side on order creation page, some specific countries have states in dropdown. I need to show state dropdown for India country. For this purpose I have fired following 2 queries.



INSERT INTO `directory_country_region` VALUES
(548 , 'IN', '35','Andaman Nicobar'),
(549 , 'IN', '28','Andhra Pradesh'),
(550 , 'IN', '12','Arunachal Pradesh'),
(551 , 'IN', '18','Assam'),
(552 , 'IN', '10','Bihar'),
(553 , 'IN', '04','Chandigarh'),
(554 , 'IN', '22','Chhattisgarh'),
(555 , 'IN', '26','Dadra Nagar Haveli'),
(556 , 'IN', '25','Daman Diu'),
(557 , 'IN', '07','Delhi'),
(558 , 'IN', '30','Goa'),
(559 , 'IN', '24','Gujarat'),
(560 , 'IN', '06','Haryana'),
(561 , 'IN', '02','Himachal Pradesh'),
(562 , 'IN', '01','Jammu Kashmir'),
(563 , 'IN', '20','Jharkhand'),
(564 , 'IN', '29','Karnataka'),
(565 , 'IN', '32','Kerala'),
(566 , 'IN', '31','Lakshadweep'),
(567 , 'IN', '23','Madhya Pradesh'),
(568 , 'IN', '27','Maharashtra'),
(569 , 'IN', '14','Manipur'),
(570 , 'IN', '17','Meghalaya'),
(571 , 'IN', '15','Mizoram'),
(572 , 'IN', '13','Nagaland'),
(573 , 'IN', '21','Odisha'),
(574 , 'IN', '34','Pondicherry'),
(575 , 'IN', '03','Punjab'),
(576 , 'IN', '08','Rajasthan'),
(577 , 'IN', '11','Sikkim'),
(578 , 'IN', '33','Tamil Nadu'),
(579 , 'IN', '36','Telangana'),
(580 , 'IN', '16','Tripura'),
(581 , 'IN', '09','Uttar Pradesh'),
(582 , 'IN', '05','Uttaranchal'),
(583 , 'IN', '19','West Bengal');


Second Query :



INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',548,'Andaman Nicobar'),
('en_US',549,'Andra Pradesh'),
('en_US',550,'Arunachal Pradesh'),
('en_US',551,'Assam'),
('en_US',552,'Bihar'),
('en_US',553,'Chandigarh'),
('en_US',554,'Chhattisgarh'),
('en_US',555,'Dadar and Nagar Haveli'),
('en_US',556,'Daman Diu'),
('en_US',557,'Delhi'),
('en_US',558,'Goa'),
('en_US',559,'Gujarat'),
('en_US',560,'Haryana'),
('en_US',561,'Himachal Pradesh'),
('en_US',562,'Jammu and Kashmir'),
('en_US',563,'Jharkhand'),
('en_US',564,'Karnataka'),
('en_US',565,'Kerala'),
('en_US',566,'Lakshadweep'),
('en_US',567,'Madhya Pradesh'),
('en_US',568,'Maharashtra'),
('en_US',569,'Manipur'),
('en_US',570,'Meghalaya'),
('en_US',571,'Mizoram'),
('en_US',572,'Nagaland'),
('en_US',573,'Odisha'),
('en_US',574,'Pondicherry'),
('en_US',575,'Punjab'),
('en_US',576,'Rajasthan'),
('en_US',577,'Sikkim'),
('en_US',578,'Tamil Nadu'),
('en_US',579,'Telangana'),
('en_US',580,'Tripura'),
('en_US',581,'Uttar Pradesh'),
('en_US',582,'Uttaranchal'),
('en_US',583,'West Bengal');


After firing above queries, on order page, in country dropdown when I select India, state dropdown is getting populated. But when I select state and fills other required info and submits page, it is showing me following error.




"regionId is a required field."




Not able to fix this issue. Kindly help if anyone knows.







magento2






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jul 13 '17 at 11:09









Mahesh GaikwadMahesh Gaikwad

229




229













  • No one has idea about this? :(

    – Mahesh Gaikwad
    Jul 13 '17 at 12:03











  • I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

    – Suresh Chikani
    Jul 13 '17 at 18:06













  • I have done reindexing and cleared cache as well. But still same problem.

    – Mahesh Gaikwad
    Jul 14 '17 at 9:49



















  • No one has idea about this? :(

    – Mahesh Gaikwad
    Jul 13 '17 at 12:03











  • I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

    – Suresh Chikani
    Jul 13 '17 at 18:06













  • I have done reindexing and cleared cache as well. But still same problem.

    – Mahesh Gaikwad
    Jul 14 '17 at 9:49

















No one has idea about this? :(

– Mahesh Gaikwad
Jul 13 '17 at 12:03





No one has idea about this? :(

– Mahesh Gaikwad
Jul 13 '17 at 12:03













I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

– Suresh Chikani
Jul 13 '17 at 18:06







I have added state for India, it's working good and also create order from admin successfully without any error. I have try Country 'India' with state. You can one more try after reindexing and clean cache. I hope it will work for you. Great Question.

– Suresh Chikani
Jul 13 '17 at 18:06















I have done reindexing and cleared cache as well. But still same problem.

– Mahesh Gaikwad
Jul 14 '17 at 9:49





I have done reindexing and cleared cache as well. But still same problem.

– Mahesh Gaikwad
Jul 14 '17 at 9:49










1 Answer
1






active

oldest

votes


















0














Have you updated general/region/state_required config value in core_config_data list with AT,BR,CA,CH,EE,ES,FI,HR,IN,LT,LV,RO,US
Updating this should work for you else you can simply rollback your query and install this module to solve your problem.



This module updates all required database entries and show drop-down for states in frontend.



https://packagist.org/packages/credevlabz/magento2-directory-indian-states






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f183523%2fmagento-2-state-dropdown-showing-regionid-is-required-field%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Have you updated general/region/state_required config value in core_config_data list with AT,BR,CA,CH,EE,ES,FI,HR,IN,LT,LV,RO,US
    Updating this should work for you else you can simply rollback your query and install this module to solve your problem.



    This module updates all required database entries and show drop-down for states in frontend.



    https://packagist.org/packages/credevlabz/magento2-directory-indian-states






    share|improve this answer




























      0














      Have you updated general/region/state_required config value in core_config_data list with AT,BR,CA,CH,EE,ES,FI,HR,IN,LT,LV,RO,US
      Updating this should work for you else you can simply rollback your query and install this module to solve your problem.



      This module updates all required database entries and show drop-down for states in frontend.



      https://packagist.org/packages/credevlabz/magento2-directory-indian-states






      share|improve this answer


























        0












        0








        0







        Have you updated general/region/state_required config value in core_config_data list with AT,BR,CA,CH,EE,ES,FI,HR,IN,LT,LV,RO,US
        Updating this should work for you else you can simply rollback your query and install this module to solve your problem.



        This module updates all required database entries and show drop-down for states in frontend.



        https://packagist.org/packages/credevlabz/magento2-directory-indian-states






        share|improve this answer













        Have you updated general/region/state_required config value in core_config_data list with AT,BR,CA,CH,EE,ES,FI,HR,IN,LT,LV,RO,US
        Updating this should work for you else you can simply rollback your query and install this module to solve your problem.



        This module updates all required database entries and show drop-down for states in frontend.



        https://packagist.org/packages/credevlabz/magento2-directory-indian-states







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 21 '17 at 9:02









        Aman SrivastavaAman Srivastava

        945613




        945613






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f183523%2fmagento-2-state-dropdown-showing-regionid-is-required-field%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            An IMO inspired problem

            Management

            Has there ever been an instance of an active nuclear power plant within or near a war zone?