很抱歉发布现有问题，但我的问题与其他问题完全不同。
我的要求是，在结账过程中，当客户选择印度作为国家时，州/省列表将显示为下拉列表。但除了美国、德国、加拿大等少数国家外，该州的名单没有显示。
我按印度各州更新了以下两个表"directory_country_region"answers"directory_country_region_"。请检查以下查询--
NSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`,
`default_name`) VALUES
(485, 'IN', 'ANDRA', 'Andra Pradesh'),
(486, 'IN', 'ARUNA', 'Arunachal Pradesh'),
(487, 'IN', 'ASSAM', 'Assam'),
(488, 'IN', 'BIHAR', 'Bihar'),
(489, 'IN', 'CHAND', 'Chandigarh'),
(490, 'IN', 'CHHAT', 'Chhattisgarh'),
(491, 'IN', 'DADAR', 'Dadar and Nagar Haveli'),
(492, 'IN', 'DAMAN', 'Daman and Diu'),
(493, 'IN', 'DELHI', 'Delhi'),
(494, 'IN', 'GOA', 'Goa'),
(495, 'IN', 'GUJAR', 'Gujarat'),
(496, 'IN', 'HARYA', 'Haryana'),
(497, 'IN', 'HP', 'Himachal Pradesh'),
(498, 'IN', 'JK', 'Jammu and Kashmir'),
(499, 'IN', 'JHARK', 'Jharkhand'),
(500, 'IN', 'KARNA', 'Karnataka'),
(501, 'IN', 'KERAL', 'Kerala'),
(502, 'IN', 'LAKSH', 'Lakshadeep'),
(503, 'IN', 'MP', 'Madya Pradesh'),
(504, 'IN', 'MAHAR', 'Maharashtra'),
(505, 'IN', 'MANIP', 'Manipur'),
(506, 'IN', 'MEGHA', 'Meghalaya'),
(507, 'IN', 'MIZOR', 'Mizoram'),
(508, 'IN', 'NAGAL', 'Nagaland'),
(510, 'IN', 'ORISS', 'Orissa'),
(511, 'IN', 'PONDI', 'Pondicherry'),
(512, 'IN', 'PUNJA', 'Punjab'),
(513, 'IN', 'RAJAS', 'Rajasthan'),
(514, 'IN', 'SIKKI', 'Sikkim'),
(515, 'IN', 'TAMIL', 'Tamil Nadu'),
(516, 'IN', 'TAMIL', 'Tripura'),
(517, 'IN', 'UP', 'Uttar Pradesh'),
(518, 'IN', 'UTTAR', 'Uttaranchal'),
(519, 'IN', 'WB', 'West Bengal');
另一个是
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',485,'Andra Pradesh'),
('en_US',486,'Arunachal Pradesh'),
('en_US',487,'Assam'),
('en_US',488,'Bihar'),
('en_US',489,'Chandigarh'),
('en_US',490,'Chhattisgarh'),
('en_US',491,'Dadar and Nagar Haveli'),
('en_US',492,'Daman and Diu'),
('en_US',493,'Delhi'),
('en_US',494,'Goa'),
('en_US',495,'Gujarat'),
('en_US',496,'Haryana'),
('en_US',497,'Himachal Pradesh'),
('en_US',498,'Jammu and Kashmir'),
('en_US',499,'Jharkhand'),
('en_US',500,'Karnataka'),
('en_US',501,'Kerala'),
('en_US',502,'Lakshadeep'),
('en_US',503,'Madya Pradesh'),
('en_US',504,'Maharashtra'),
('en_US',505,'Manipur'),
('en_US',506,'Meghalaya'),
('en_US',507,'Mizoram'),
('en_US',508,'Nagaland'),
('en_US',510,'Orissa'),
('en_US',511,'Pondicherry'),
('en_US',512,'Punjab'),
('en_US',513,'Rajasthan'),
('en_US',514,'Sikkim'),
('en_US',515,'Tamil Nadu'),
('en_US',516,'Tripura'),
('en_US',517,'Uttar Pradesh'),
('en_US',518,'Uttaranchal'),
('en_US',519,'West Bengal');
虽然我用印度的州更新了这两个表，但在结账时，无论是没有州显示在账单信息中，还是像编辑客户地址这样的其他地方。请帮忙。
您可以像这样为印度添加
INSERT INTO `directory_country_region` VALUES
(NULL , "IN", "Andaman Nicobar","Andaman Nicobar"),
(NULL , "IN", "Andhra Pradesh","Andhra Pradesh"),
(NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"),
(NULL , "IN", "Assam","Assam"),
(NULL , "IN", "Bihar","Bihar"),
(NULL , "IN", "Chandigarh","Chandigarh"),
(NULL , "IN", "Chhattisgarh","Chhattisgarh"),
(NULL , "IN", "Dadra Nagar Haveli","Dadra Nagar Haveli"),
(NULL , "IN", "Daman Diu","Daman Diu"),
(NULL , "IN", "Delhi","Delhi"),
(NULL , "IN", "Goa","Goa"),
(NULL , "IN", "Gujarat","Gujarat"),
(NULL , "IN", "Haryana","Haryana"),
(NULL , "IN", "Himachal Pradesh","Himachal Pradesh"),
(NULL , "IN", "Jammu Kashmir","Jammu Kashmir"),
(NULL , "IN", "Jharkhand","Jharkhand"),
(NULL , "IN", "Karnataka","Karnataka"),
(NULL , "IN", "Kerala","Kerala"),
(NULL , "IN", "Lakshadweep","Lakshadweep"),
(NULL , "IN", "Madhya Pradesh","Madhya Pradesh"),
(NULL , "IN", "Maharashtra","Maharashtra"),
(NULL , "IN", "Manipur","Manipur"),
(NULL , "IN", "Meghalaya","Meghalaya"),
(NULL , "IN", "Mizoram","Mizoram"),
(NULL , "IN", "Nagaland","Nagaland"),
(NULL , "IN", "Orissa","Orissa"),
(NULL , "IN", "Pondicherry","Pondicherry"),
(NULL , "IN", "Punjab","Punjab"),
(NULL , "IN", "Rajasthan","Rajasthan"),
(NULL , "IN", "Sikkim","Sikkim"),
(NULL , "IN", "Tamil Nadu","Tamil Nadu"),
(NULL , "IN", "Tripura","Tripura"),
(NULL , "IN", "Uttar Pradesh","Uttar Pradesh"),
(NULL , "IN", "Uttaranchal","Uttaranchal"),
(NULL , "IN", "West Bengal","West Bengal");
INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'en_US', tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id='IN';
要了解更多详细信息，只需使用SQL 将magento商业链接
这里还有一个博客
希望这将解决您的问题
我相信这会对你有所帮助。请将所有sql脚本复制到下表：
- 将表
directory_country_region更改为hsdirectory_country_region - 从表
directory_country_region更改为hsdirectory_country_region_name
或者只运行以下查询：
INSERT INTO `hsdirectory_country_region` (`region_id`, `country_id`, `code`,
`default_name`) VALUES
(485, 'IN', 'ANDRA', 'Andra Pradesh'),
(486, 'IN', 'ARUNA', 'Arunachal Pradesh'),
(487, 'IN', 'ASSAM', 'Assam'),
(488, 'IN', 'BIHAR', 'Bihar'),
(489, 'IN', 'CHAND', 'Chandigarh'),
(490, 'IN', 'CHHAT', 'Chhattisgarh'),
(491, 'IN', 'DADAR', 'Dadar and Nagar Haveli'),
(492, 'IN', 'DAMAN', 'Daman and Diu'),
(493, 'IN', 'DELHI', 'Delhi'),
(494, 'IN', 'GOA', 'Goa'),
(495, 'IN', 'GUJAR', 'Gujarat'),
(496, 'IN', 'HARYA', 'Haryana'),
(497, 'IN', 'HP', 'Himachal Pradesh'),
(498, 'IN', 'JK', 'Jammu and Kashmir'),
(499, 'IN', 'JHARK', 'Jharkhand'),
(500, 'IN', 'KARNA', 'Karnataka'),
(501, 'IN', 'KERAL', 'Kerala'),
(502, 'IN', 'LAKSH', 'Lakshadeep'),
(503, 'IN', 'MP', 'Madya Pradesh'),
(504, 'IN', 'MAHAR', 'Maharashtra'),
(505, 'IN', 'MANIP', 'Manipur'),
(506, 'IN', 'MEGHA', 'Meghalaya'),
(507, 'IN', 'MIZOR', 'Mizoram'),
(508, 'IN', 'NAGAL', 'Nagaland'),
(510, 'IN', 'ORISS', 'Orissa'),
(511, 'IN', 'PONDI', 'Pondicherry'),
(512, 'IN', 'PUNJA', 'Punjab'),
(513, 'IN', 'RAJAS', 'Rajasthan'),
(514, 'IN', 'SIKKI', 'Sikkim'),
(515, 'IN', 'TAMIL', 'Tamil Nadu'),
(516, 'IN', 'TAMIL', 'Tripura'),
(517, 'IN', 'UP', 'Uttar Pradesh'),
(518, 'IN', 'UTTAR', 'Uttaranchal'),
(519, 'IN', 'WB', 'West Bengal');
INSERT INTO `hsdirectory_country_region_name` (`locale`, `region_id`, `name`) VALUES
('en_US',485,'Andra Pradesh'),
('en_US',486,'Arunachal Pradesh'),
('en_US',487,'Assam'),
('en_US',488,'Bihar'),
('en_US',489,'Chandigarh'),
('en_US',490,'Chhattisgarh'),
('en_US',491,'Dadar and Nagar Haveli'),
('en_US',492,'Daman and Diu'),
('en_US',493,'Delhi'),
('en_US',494,'Goa'),
('en_US',495,'Gujarat'),
('en_US',496,'Haryana'),
('en_US',497,'Himachal Pradesh'),
('en_US',498,'Jammu and Kashmir'),
('en_US',499,'Jharkhand'),
('en_US',500,'Karnataka'),
('en_US',501,'Kerala'),
('en_US',502,'Lakshadeep'),
('en_US',503,'Madya Pradesh'),
('en_US',504,'Maharashtra'),
('en_US',505,'Manipur'),
('en_US',506,'Meghalaya'),
('en_US',507,'Mizoram'),
('en_US',508,'Nagaland'),
('en_US',510,'Orissa'),
('en_US',511,'Pondicherry'),
('en_US',512,'Punjab'),
('en_US',513,'Rajasthan'),
('en_US',514,'Sikkim'),
('en_US',515,'Tamil Nadu'),
('en_US',516,'Tripura'),
('en_US',517,'Uttar Pradesh'),
('en_US',518,'Uttaranchal'),
('en_US',519,'West Bengal');
成功后，不要忘记在管理面板中清除并刷新magento缓存。