Ttdfjt

Why are Star Wars Rebel Alliance ships named after letters from the Latin alphabet?

Why have both: BJT and FET transistors on IC output?

Does the use of a new concept require a prior definition?

Does the problem of P vs NP come under the category of Operational Research?

Went to a big 4 but got fired for underperformance in a year recently - Now every one thinks I'm pro - How to balance expectations?

"Will flex for food". What does this phrase mean?

What is the difference between "logical equivalence" and "material equivalence"?

Can it be useful for a player block with a hanging piece in a back rank mate situation?

If I buy and download a game through second Nintendo account do I own it on my main account too?

Reasons for using monsters as bioweapons

Deploy custom Lightning App Home Page assignment using SalesforceDX

Plotting Chebyshev polynomials using PolarPlot and FilledCurve

UX writing: When to use "we"?

Can I say "Gesundheit" if someone is coughing?

cannot trash malware NGPlayerSetup.dmg

Why did the United States not resort to nuclear weapons in Vietnam?

What is the most 'environmentally friendly' way to learn to fly?

Applied Meditation

Export economy of Mars

How is Sword Coast North governed?

How do I respond appropriately to an overseas company that obtained a visa for me without hiring me?

Password management for kids - what's a good way to start?

Transistor design with beta variation

How long should I wait to plug in my refrigerator after unplugging it?

Magento 2 How to add all country regions in database?

How add table name prefix to all table after Magento installationMagento 2: how to change default Country option on checkout pageOverriding Core File in MagentoAdding regions in addresses other than US in Magento 2How to add new country in country dropdown in magento2.2.1Issue while importing tablerates.csvMagento 2.2.4 Change Country NamesMagento 2 Region list not filter for default country on billing address for first timeMagento 2 How to Change Estimate Shipping Default CountryMagento 2 - Get country name from country code

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I checked directory_country_region in the database there is no region of the United Kingdom, I need all region of United Kingdom.

Is Magento provide the sheet of all country regions or from where I can add them?

Please help me.

magento2 database country-regions

share|improve this question

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

add a comment | 

0

I checked directory_country_region in the database there is no region of the United Kingdom, I need all region of United Kingdom.

Is Magento provide the sheet of all country regions or from where I can add them?

Please help me.

magento2 database country-regions

share|improve this question

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

add a comment | 

I checked directory_country_region in the database there is no region of the United Kingdom, I need all region of United Kingdom.

Is Magento provide the sheet of all country regions or from where I can add them?

Please help me.

magento2 database country-regions

share|improve this question

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

share|improve this question

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

share|improve this question

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

edited Jul 24 at 4:40

poojan sharma

1,06322 silver badges1010 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

asked Jul 24 at 4:31

Himani TayalHimani Tayal

1091212 bronze badges

1 Answer
1

active

oldest

votes

1

Magento 1: You can use the direct SQL files to add regions into database. For this you can refer this post.

Another way is You can use the Magento custom code to add regions into database. For this you can refer this post.

Also I have found one extension "Regions Manager" that provide facility to add/update regions from backend.

UPDATE

The solution which I did to add United Kingdom Regions is: I found a
CSV for united Kingdom states here: Here is the CSV

Just import it in Database and its save my time and effort.

share|improve this answer

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f283070%2fmagento-2-how-to-add-all-country-regions-in-database%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

Magento 1: You can use the direct SQL files to add regions into database. For this you can refer this post.

Another way is You can use the Magento custom code to add regions into database. For this you can refer this post.

Also I have found one extension "Regions Manager" that provide facility to add/update regions from backend.

UPDATE

The solution which I did to add United Kingdom Regions is: I found a
CSV for united Kingdom states here: Here is the CSV

Just import it in Database and its save my time and effort.

share|improve this answer

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

add a comment | 

1

Magento 1: You can use the direct SQL files to add regions into database. For this you can refer this post.

Another way is You can use the Magento custom code to add regions into database. For this you can refer this post.

Also I have found one extension "Regions Manager" that provide facility to add/update regions from backend.

UPDATE

The solution which I did to add United Kingdom Regions is: I found a
CSV for united Kingdom states here: Here is the CSV

Just import it in Database and its save my time and effort.

share|improve this answer

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

add a comment | 

Magento 1: You can use the direct SQL files to add regions into database. For this you can refer this post.

Another way is You can use the Magento custom code to add regions into database. For this you can refer this post.

Also I have found one extension "Regions Manager" that provide facility to add/update regions from backend.

UPDATE

The solution which I did to add United Kingdom Regions is: I found a
CSV for united Kingdom states here: Here is the CSV

Just import it in Database and its save my time and effort.

share|improve this answer

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

share|improve this answer

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

edited Jul 24 at 5:23

Mohit Rane

1,1771818 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges

answered Jul 24 at 4:42

Himani TayalHimani Tayal

1091212 bronze badges