How to Exceed the Google Geocode Limits?

Google only allow 2500 Geocode request per 24Hr. Follow below step to increase the limit & for the best response time.

  • Upgrade to Google Maps API for Business to extend the daily limit to 10,000 requests from 2,500. In addition, the Business API gives you greater control over the results, improved support and business-friendly terms.
  • Cache the JSON or XML results returned by the Geocoding API, especially for common searches. This both allows you to give your customers more rapid results and keeps redundant searches from taking up space in your daily request limit.
  • Fetch geocoding results only when specifically requested by your website visitors rather than fetching them by default. For instance, only load a request when a viewer clicks on a “Find on Map” link. If the visitor is not looking for map data you should not waste the resources fetching map results.
  • Fetch geocoding results only when specifically requested by your website visitors rather than fetching them by default. For instance, only load a request when a viewer clicks on a “Find on Map” link. If the visitor is not looking for map data you should not waste the resources fetching map results.
  • If you have specified number of searches then you can try batch geo coding website to get latitude,longitude values & store these values in DB. Get values during search call & load map by providing lat & lon values in map loading url.

    Batch Geo Coding Websites
    findlatitudeandlongitude
    mapdevelopers

    Free Geo Coding API’s List
    Free Geo Coding API’s List

    How to add payment method column in magento order grid?

    Copy From app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php To app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php

    Add Below line right before $this->setCollection($collection);

     $collection->getSelect()->joinLeft(array('payment' => $collection->getTable('sales/order_payment')), 'payment.parent_id=main_table.entity_id',array('payment_method' => 'method'));
    

    Add below code block in function _prepareColumns()

    $this->addColumn('payment_method', array(
                'header' => Mage::helper('sales')->__('Payment Method'),
                'index' => 'payment_method',
                'filter_index'      => 'payment.method',
            ));
    

    How to change paypal standard method title on magento checkout page?

    Paypal allows various Payment Method options with Magento.Even after changing the title of the Payment Method through Magento Admin Panel, The new title is not reflected on the Magento One Page checkout. Following steps were followed to change the title for the Paypal Standard Payment Method.

    Set the New Method Title from Admin >> Config >> Payment Methods
    Copy the file Form.php from app\code\core\Mage\Paypal\Block\Standard\Form.php to app\code\local\Mage\Paypal\Block\Standard\Form.php
    In Form.php change the line

    ->setMethodTitle() // Output PayPal mark, omit title 
    

    to

    ->setMethodTitle(($this->getMethodTitle())) // Output PayPal mark, omit title
    

    Modify the CSS to align Paypal Method Name and the Paypal Logo and “What is Paypal?” Link
    Comment out

    ->setMethodLabelAfterHtml($mark->toHtml())
    

    if you do not want the “what is Paypal” and the paypal logo

    Magento Orders Email Sending Issue

    In Magento 1.9.1.0 new order emails are now not sent upon the processing of the order (as they used to be) but instead sent via a cron job. If you’ve followed the information in this post and all other emails, other than new order emails, are being sent properly, then the next thing to do is check that your cron job is set up and running properly.

    You need to follow the below step to resolve the email sending issue

    Both of these checks can be done outside Magento. For the former, it just requires a very simple script (download it below) which checks to see if mail() is enabled on the server – it’s frequently not enabled for security reasons, because if hijacked it can be used to send large quantities of spam email very quickly.

    The following script very simply checks if mail() is enabled on the server, and tells you :

    <?php
    if(function_exists('mail')) {
    	echo 'mail() is enabled';
    } else {
    	echo 'mail() is not enabled';
    }  
    ?>
    

    To run it, create empty php file copy above code, upload it to the web root of your site as mail.php, then visit http://www.yoursite.com/mail.php in a browser to see the output.

    If mail() isn’t enabled, then you’ll have to liaise with your hosts to get it turned on, or alternatively set up Magento to use a separate mail server to send its emails through.

    If mail() is enabled, but Magento’s not sending emails, then the next step is to send a test email from the server, not from Magento. Again, this can be done very simply using a script along the lines below.

    <?php
    $to = "you@youraddress.com";
    $subject = "Test email";
    $message = "This is a test email.";
    $from = "from@fromaddress.com";
    $headers = "From:" . $from;
    if (mail($to, $subject, $message, $headers)) {
    	echo("Your message has been sent successfully");
    	} else {
    	echo("Sorry, your message could not be sent");
    }
    ?>
    

    Change the “to” and “from” addresses, and then upload it to your server as test-email.php (or similar) and visit http://www.yoursite.com/test-email.php in a browser. If it reports that the message has been sent successfully, then you should receive the test email at the “to” address relatively shortly thereafter. If it is, then it’s indicative that the error lies with your Magento installation or its configuration, and not with your server configuration.

    If, however, it reports that the message has been sent successfully but it doesn’t make it to the “to” email address, then the first thing to check is that it’s not in the spam bin. If it’s not, then it’s almost certain that the error lies somewhere in your server configuration…so at least you now know where best to start looking!

    How to setup Cron job for magento using Control Panel?

    If you’ve got access to a server control panel, setting up the cronjob is as easy as going to the Cronjob Manager inside the control panel. Make sure no other cronjob has been set up calling the cron.php file of Magento, and if that’s the case, remove it before adding this cronjob. Add a cronjob with the following parameters:
    Minute: */5
    This means the cronjob will be run every 5 minutes. It is very important that the cron.php file of Magento gets executed every five minutes. Do not change this to a longer interval.
    Hour: *
    Day: *
    Month: *
    Weekday: *
    Command:

    wget -O /dev/null -q http://www.YOURDOMAIN.com/PATH_TO_MAGENTO/cron.php > /dev/null
    

    Replace YOURDOMAIN.com and PATH_TO_MAGENTO with the URL of the root directory of your Magento installation.
    Please try to call the URL you’ve entered using your browser. A blank page should be returned. If the page can’t be found (404), that means the URL to the cronjob manager of Magento (cron.php) is wrong. This means the cron job won’t execute and hasn’t been set up properly. It is really important you enter the correct URL – it is always the URL to the cron.php file sitting inside the root directory of your Magento installation.
    Click Add New Cron Job

    Magento

    How to get Magento Base Url, Skin Url, Media Url, JS Url, Store Url?

    Get Url in phtml files

    1. Get Base Url :

    Mage::getBaseUrl();

    2. Get Skin Url :

    Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);
    

    (a) Unsecure Skin Url :

    $this-&gt;getSkinUrl('images/imagename.jpg');
    

    (b) Secure Skin Url :

    $this-&gt;getSkinUrl('images/imagename.gif', array('_secure'=&gt;true));

    3. Get Media Url :

    Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);

    4. Get Js Url :

    Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);

    5. Get Store Url :

    Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);

    6. Get Current Url

    Mage::helper('core/url')-&gt;getCurrentUrl();

    Get Url in cms pages or static blocks

    1. Get Base Url :

    {{store url=""}}

    2. Get Skin Url :

    {{skin url='images/imagename.jpg'}}
    

    3. Get Media Url :

    {{media url='/imagename.jpg'}}

    4. Get Store Url :

    {{store url='mypage.html'}}