On checkout page using local database if customer enter zip code then city/state /country auto complete.
Is any free extension available which completes the customer's city/state/country by using only their zip code?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
This extension provides the functionality requested, allowing a local database to be added and edited for any region:
It does have some issues with 22.214.171.124+ which can be resolved by the following (taken from the Magento Connect page):
After installing this plugin the Region field was giving an error in the checkout. I solved this by editing the phtml files in the folder:
/app/design/frontend/<YOUR PACKAGE>/<YOUR THEME>/template/addresscomplete/checkout/onepage/
in billing.phtml :
Search for billingRegionUpdater
Replace line for:
var billingRegionUpdater = new RegionUpdater('billing:country_id', 'billing:region', 'billing:region_id', <?php echo $this->helper('directory')->getRegionJson() ?>, undefined, 'billing:postcode');
and in shipping.phtml:
Search for shippingRegionUpdater Replace line for :
var shippingRegionUpdater = new RegionUpdater('shipping:country_id', 'shipping:region', 'shipping:region_id', <?php echo $this->helper('directory')->getRegionJson() ?>, undefined, 'shipping:postcode');