Magento 2 : State dropdown showing regionID is required field
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
add a comment |
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
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
add a comment |
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
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
magento2
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
add a comment |
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
add a comment |
1 Answer
1
active
oldest
votes
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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
add a comment |
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
add a comment |
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
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
answered Nov 21 '17 at 9:02
Aman SrivastavaAman Srivastava
945613
945613
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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