In my country we have states and then local provinces under each state.

I want to reflect this in the shipping address and billing address so the states are listed in a drop down just like countries. And then the user can select their local province after selecting a state.

I need some guidance on how to properly create the states and local provinces in the database and how to tell Magento to display them in the frontend.

  • Thanks for the correction but can you also assist in solving this problem. Aug 24, 2016 at 14:52

1 Answer 1


follow this tutorial it may help you for adding new field




for adding states as it is already there in magento

follow these links.

How add indian State?


  • Thank you Arjun it worked well as I was able to create the states. The only draw back is that I did not find any tables for the city field in the database, how do I add the cities under each state. Aug 23, 2016 at 14:45
  • For cities you need to add custom field. The above links might help you to create a custom field and you may search for other links as well on net.
    – Arjun
    Aug 24, 2016 at 4:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.