Magento – Magento reports and timezone issues

magento-1.8reportstimezone

When viewing the Total Ordered Report I'm getting the following error message

This report depends on timezone configuration. Once timezone is changed, the lifetime statistics need to be refreshed.

I have my /app/etc/config and it has the following

<general>
<locale>
    <code>en_GB</code>
    <timezone>Europe/London</timezone>
</locale>

This matches what is set in the admin system under System->Configuration->General->Locale options.

I have tried to refresh the lifetime stats but this message still appears.

Please could someone advise

Best Answer

This is a normal message that is always added to the page with reports.

If it irritates you, you can remove it from the layout (app/design/adminhtml/default/default/layout/sales.xml and app/design/adminhtml/default/default/layout/report.xml).

It will be no any problems for you if you have set up timezone and doesn’t change it. If your repots don’t work, it is another problem. Exactly can say that before viewing reports, you should update the statistics if it is outdated

Related Solutions

Magento 1.8 – Can’t Filter ‘reports/product_collection’ on Category

Try building your reports like this:

$category = Mage::getModel('catalog/category')->load({category_id});
$reports = Mage::getResourceModel('reports/product_collection')
             ->addAttributeToSelect('*')
             ->addOrderedQty()
             ->addCategoryFilter($category)
             ->setOrder('ordered_qty', 'desc');

I mean use addCategoryFilter after addOrderQty. in the method addOrderQty there is this line $this->getSelect()->reset() that seams to remove your category filter.

Magento – How to change Magento timezone

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

Best Answer

Related Solutions

Magento 1.8 – Can’t Filter ‘reports/product_collection’ on Category

Magento – How to change Magento timezone

Related Topic