Import Region - Magento 1

-
Import Region for countries


In magento, there are several countries for which states/regions already available, but for others like India, New-zealand and many more have not region list available. However, an input type text is available to enter state/region manually. 

Usually, it is always better to have selectable state from the list. Actually, it is more convenient to use dropdown as region/states selection country-wise. 

Simply take an example of India where a user has to enter states/regions manually. Now need to convert it into dropdown require SQL script and prepare this script. These all seem hectic. 

It would be very appropriate if a developer can do this by CSV and piece of code. Well, here is the solution to it which is illustrate below.

Firstly, need a csv file to this. For an example India's states CSV is below.

Download CSV file from here → Indian Regions

To download the file as CSV, follow below steps:
  1. Go to link.
  2. Select File from top-left.
  3. Download as -> Comma -Separated Values (.csv)


















Secondaly, need a script to perform the task.

Script available → Import Region

How to import regions using the script?

The script and CSV file both should be in the same hierarchy means both are should be on root directory of magento.

Run this script from magento root directory.

Imported regions successfully!! Cheers!!


Please share, comment and subscribe for future posts.

Comments

Post a Comment

Popular posts from this blog

Hosting and Goodies

-
Image
Magento 2 Hosting , but where to? Are you thinking to build to Magento 2 website? You have planned everything but confused about hosting. Don't worry we will have thoughts for you from where you can choose better hosting. Note : All hosting provider prices are as per October 2018. 1) Milesweb   Miles web is the very very good hosting company which we personally recommending. We have hosted many Magento and other framework website. 2) Hostgator India's leading hosting provider is Hostgator.  it is one of the good hosting provider. We have used Hostgator services in past and we have good experience with them. 3) GoDaddy GoDaddy is world wide known hosting provider. 4) Cloudways Cloudways gives more options with different hosting services. That makes it an unique. 5) a2hosting An a2hosting is another good hosting provider for magento framework. Although it prices are high but it still takes a place in our top 5 hosting provider. I
Read more

Magento 2 Import Scripts

-
Magento 2 Import Scripts Simple and faster way to import data scripts for magento 2. https://github.com/Extrembler/Magento-2-Import-Scripts Keep your self updated by subscribing our website so whenever we update with new import scripts we can inform you. #import #importmagento2 #magento2 #simpleimport  If like efforts, Please share, comment and subscribe for future posts and inspire more.
Read more

How to add product attribute value in minicart magento 2

-
How to add product attribute value in minicart magento 2? First need to do is create a plugin so add plugin at di.xml at first. di.xml <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nonamespaceschemalocation="urn:magento:framework:ObjectManager/etc/config.xsd"> <type name="Magento\Checkout\CustomerData\DefaultItem"> <plugin disabled="false" name="AddAttPlug" sortorder="10" type="Your\Module\Plugin\DefaultItem"> </plugin></type> </config> Now create a plugin class and below line of code.   Default.php <?php namespace Your\Module\Plugin; use Magento\Quote\Model\Quote\Item; class DefaultItem { public function aroundGetItemData($subject, \Closure $proceed, Item $item) { $data = $proceed($item); $product = $item->getProduct(); $atts = [ "product_weight" => $product->ge
Read more