Magento – How to change Magento timezone

magento-1.9timezone

I have used Magento 1.9 initially timezone was America/Los_Angeles in app/etc/config.xml file and set India/Calcutta timezone in

System -> Configuration -> General -> Locale Options ->Timezone

at that time Magento function Mage::getModel('core/date')->date('Y-m-d H:i:s') return correct date.
But order placed time was -5:30 to real time.

For set Asia/Calcutta timezone, I have changed app/etc/config.xml general->locale->timezone to Asia/Calcutta and in app/Mage.php I have changed UTC to Asia/Calcutta,

And it has changed the timezone in the backend, it means order placed time is correct as real-time but the function Mage::getModel('core/date')->date('Y-m-d H:i:s') return me +5:30 time to real time.

Is there any place where I missed to change?

Or Is there another method to change the timezone of the Magento store?

Best Answer

You can set timezone from Admin panel ,

Go to :

System => Configuration => General => Locale Options =>Timezone

AND

Change the default timezon in file app/Mage.php

date_default_timezone_set('UTC');

Replace above line with following

date_default_timezone_set('Asia/Calcutta');

AND

Copy file app/code/core/Mage/Core/Model/Locale.php to app/code/local/Mage/Core/Model/Locale.php then find line 38

const DEFAULT_TIMEZONE = 'UTC';

Replace above line with following

const DEFAULT_TIMEZONE = 'Asia/Calcutta';

Note: If still it will not work. Dig in to following function in app/code/local/Mage/Core/Model/Locale.php.

public function storeDate($store=null, $date=null, $includeTime=false, $format = null)
    {
        $timezone = Mage::app()->getStore($store)->getConfig(self::XML_PATH_DEFAULT_TIMEZONE);
        $date = new Zend_Date($date, $format, $this->getLocale());
        $date->setTimezone($timezone);
        if (!$includeTime) {
            $date->setHour(0)
                ->setMinute(0)
                ->setSecond(0);
        }
        return $date;
    }

Hope this helps

Related Solutions

Magento – Magento 1.9.2 not sending new order confirmation emails

The cronjob is working (otherwise you would not get this exception) and if your hoster said, that Magento did not try to send any emails, the exception has another reason.

Unfortunately the message is not very precise, but you do get it when the email has no subject or no recipient, so you should double check your email templates and your sales email configuration.

To debug, I suggest to inspect the parameters for mail(): Edit lib/Zend/Mail/Transport/Sendmail.php around line 100 and replace:

set_error_handler(array($this, '_handleMailErrors'));
$result = mail(
    $this->recipients,
    $this->_mail->getSubject(),
    $this->body,
    $this->header);
restore_error_handler();

with

set_error_handler(array($this, '_handleMailErrors'));

Mage::log("MAIL RECIPIENTS: " . $this->recipients, null, 'mail.log', true);
Mage::log("MAIL SUBJECT: " . $this->_mail->getSubject(), null, 'mail.log', true);

$result = mail(
    $this->recipients,
    $this->_mail->getSubject(),
    $this->body,
    $this->header);
restore_error_handler();

Then check var/log/mail.log after a failed email to see if recipients or subject are missing.

Magento – Magento checking order updated_at using Magento date and time

All magento transaction data it's saved in UTC so you need to start with the UTC now not your store or server now.

To get the NOW in UTC you can use:

// Get Store ID
$store = $this->getCurrentStoreId(); // You can change it

// Get Store Now (Zend_Date)
$nowStore = Mage::app()->getLocale()
    ->storeDate($store, null, true);

// Get Store Now (String)
$nowStoreDatetime = $nowStore->toString('y-MM-dd HH:mm:ss');

// Get Now UTC
$nowUtc = Mage::app()->getLocale()
    ->utcDate($store, $date, true);

Now you can play with Zend_Date:

/** @var Zend_Date $nowUtc */

$nowUtc->subHour(1);
$finalDatetime = $nowUtc->toString('y-MM-dd HH:mm:ss');

Using $finalDatetimein your query you should get the orders you want.

Note that updated_at date can change if you add a comment to the order or some cron/payment gateway do something, so if you want to track the exactly moment that the order was set to 'pending' you should add a join with status_history table. If that were your case, just let me know and i'll update the answer.

EDIT

Adding a Join with Sales_Order_Status_History to filter by the date when the order was set as 'pending'.

    $orders = Mage::getModel('sales/order')->getCollection()
    $select = $orders->getSelect();
    $select->join(
        array('sfosh' => 'sales_flat_order_status_history'),
        'sfosh.parent_id = main_table.entity_id',
        array()
    )
    ->group('main_table.entity_id');

    $orders
        ->setOrder('sfosh.created_at', 'ASC')
        ->addFieldToFilter('sfosh.created_at', array('lteq' => $finalDatetime))
        ->addFieldToFilter('main_table.status', array('eq' => 'pending'))
    ;

Best Answer

Related Solutions

Magento – Magento 1.9.2 not sending new order confirmation emails

Magento – Magento checking order updated_at using Magento date and time

Related Topic