PuzzlersWorld.com

  • Hacker Puzzle
  • Interview Puzzles
  • Number Puzzles
  • Maths Puzzles

Magento

How to add new Region/State in Magento

March 2, 2013 by puzzler 4 Comments

Magento by default has states only for few selected countries and you might want to include your country’s states in your site for various purpose, to give a select option in state on checkout page, to configure some rules etc.

There is no direct UI available as of now but otherwise also it is quite simple to upload this information using a CSV file and phpmyadmin. you need two to create two csv files

Step 1: directory_country_region.csv => this should include four colums region_id, country_id(in ISO-2), region code, region name.
region_id is nothing but auto incrmented id directory_country_region table, so fill this column with incremented numbers(greater then current auto_increment number)
country_id > ISO-2 code, ex. US, UK, IN
region_code => You can fill iso-2 codes for states(find it using google)
region_name => default name for the state

Step 2: directory_country_regions_name.csv => this should include 3 columns locale, region_id and region_name

locale => ex. en_us etc.
take region_id from previous file and change the default name to the locale.
It is not compulsory to fill this table, you can skip it, unless you want to support multiple locale.

I have created sample files for Indian states, directory_country_region_IN.csv and directory_country_regions_name_IN.csv
[Read more…]

Checkout more Technical Tags: Magento

Magento Plugin for Twitter Card

December 1, 2012 by asinghal Leave a Comment

What is Twitter Card?

I recently came to know about twitter cards from my brother, As such twitter allows only 140 characters to tweet, but to compete with Facebook they have launched a feature called twitter cards. Basically after adding the specific twitter meta tags to your page, twitter will give an option to expand the post, after expanding the post, user will see photo, title, description with link to your site, for example visit this funnychutkule’s twitter page. This is a great feature from twitter to promote your website and in my point of view it is a must.

To know more about types of twitter cards please visits official twitter page

I have written a small Twitter card plugin to add the twitter meta tags to your website’s product page, Click here to visit official magento connect page of this twitter card plugin.

How to install Twitter card Magento plugin from puzzlersworld?

  1. Login to your magento admin panel.
  2. Go to System->Magento Connect->Magento Connect Manage.
  3. You need to login again with the same credentials as in first step.
  4. Paste this extension key http://connect20.magentocommerce.com/community/Pw_Twittercard under Install New Extensions section and click on install.
  5. Confirm the installation once again, after installation you have to set your twitter username.

[Read more…]

Checkout more Technical Tags: Magento, Solved Puzzles

Submit your Puzzle

You may also like

    Categories

    • Aive hi Puzzles
    • Akbar and Birbal
    • Alphabetical Puzzles
    • Bollywood Puzzles
    • Google Code jam
    • Hindi Riddles
    • Interview Puzzles
    • Interview Questions
    • Logical Puzzles
    • Malayalam Puzzles
    • Maths Puzzles
    • Miscellaneous
    • Number Puzzles
    • Picture Puzzles
    • Riddles
    • Tamil Puzzles
    • Technical

    Social

    • View puzzlersworld’s profile on Twitter
    privacy policy

    Copyright © 2025 · eleven40 Pro Theme on Genesis Framework · WordPress · Log in

    • Hacker Puzzle
    • Logo Puzzles
    • Optical Illusions
    • WhatsApp Puzzles
    • Picture Puzzles
    • Riddles
      ▼
      • Hindi Riddles
    • Bollywood Puzzles
    • Alphabetical Puzzles
    • Aive hi Puzzles
    • Interview Puzzles
    • Logical Puzzles
    • Interview Questions
      ▼
      • Data Structures
      • Binary Tree
      • Algorithms
      • Recursion Questions
      • Amazon Interview Questions
      • Snapdeal Interview Questions
      • Google Code jam
    • Technical
    • Akbar and Birbal
    • Number Puzzles
    • Maths Puzzles
    • Miscellaneous