[Skip to main content](#vessel-content) # Report Statistic Date & Order actual date difference ## - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 11 months ago [\#284504](#284504) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284504 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* was created by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* -- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 8 years 10 months ago [\#284523](#284523) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284523 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hello, Checking the value of your "Server Time Zone" Joomla option via "Global Configuration" -> tab "Server" -> section "Location Settings" will probably help. If it still not working you should check your server configuration. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#284706](#284706) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284706 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* May i know what to check and can you specified which is the thing possible to go wrong? As mentioned everything is correct Our Global Configuration are using MYT time zone as well as the server Date is MYT Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#284707](#284707) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284707 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* I would like to highlight, this problem only occur after ugprade to 3.2.1 date on Order listing (administrator) page is correct, however, dashboard and report can not calculate sales bases on the date Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 10 months ago [\#284715](#284715) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284715 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hi, Do you have the "dashboard legacy" setting activated or deactivated in the HikaShop configuration ? If you change that setting, does it change anything for the data on the dashboard ? Also, which version of HikaShop were you using before updating ? I've been looking in our SVN for changes to the reports system regarding the dates and I've been up to 2 years and a half in the past and didn't see any change which would affect the date restrictions. Also, how did you configure the report? Could you provide a screenshot ? Could you also tell us how you configure your timezone in your Joomla configuration and in your user account in Joomla ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago - 8 years 10 months ago [\#284781](#284781) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284781 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Both legacy and non legacy dashboard have this problem we upgrade it from 2.6.5 Let me provide a screen shot for better understanding Joomla & Server timezone are using +8:00 Kuala Lumpur/Singapore As you can see in screenshot, there is a big difference of amount between two report, we do not know which is correct when the transaction is big - [ ![FireShotCapture7-ShutterFashion-A_-http___www.shutterfashion.com.my_administrator_index.php.png](/forum/attachment/41890) ](/forum/attachment/41890 "..._index.php.png") [ ](/forum/attachment/41890?download=1 "..._index.php.png") - [ ![FireShotCapture9-ShutterFashion-A_-http___www.shutterfashion.com.my_administrator_index.php.png](/forum/attachment/41891) ](/forum/attachment/41891 "..._index.php.png") [ ](/forum/attachment/41891?download=1 "..._index.php.png") Last edit: 8 years 10 months ago by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 10 months ago [\#284783](#284783) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284783 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hi, Well, you're not comparing the same data on both screenshots. On the report, you have many order statuses selected but on the new dashboard, only the "statistics" statuses from the System>Order statuses menu are taken into account. Also, if the "created" order status is enabled as a "statistics" status, then it's the order creation date of orders that is used for the dashboard, and if not, it's the invoice creation date of orders that is used, while in your report, you're using the "last modified" date which is again another date. The order creation date is the date the order was created in the shop. The invoice creation date is the date the order was paid. The last modified date is the date the last time something was changed in th order. Normally, a customer will pay the order directly after it is created and you won't edit the order afterwards, so all these dates would be almost identical. But it's possible that the order was created two weeks ago, paid last week and that you modified it yesterday. So because of these, it's totally possible to get results way off between the reports and the dashboard because you're not necessarily comparing the same things and it's highly likely that both are correct for what they are trying to display. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#284865](#284865) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284865 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* now i understand is it possible to let dashboard report to use creation date instead of invoice date? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#284866](#284866) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284866 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* i still found problem, i had changed the statistic with created status , here is the screen shot for reference [ ![Untitled3.png](/forum/attachment/41916) ](/forum/attachment/41916 "Untitled3.png") [ ![Untitled4.png](/forum/attachment/41917) ](/forum/attachment/41917 "Untitled4.png") [ ![Untitled2.png](/forum/attachment/41918) ](/forum/attachment/41918 "Untitled2.png") [ ![Untitled_2017-12-21.png](/forum/attachment/41919) ](/forum/attachment/41919 "...2017-12-21.png") - [ ![Untitled3.png](/forum/attachment/41916) ](/forum/attachment/41916 "Untitled3.png") [ ](/forum/attachment/41916?download=1 "Untitled3.png") - [ ![Untitled4.png](/forum/attachment/41917) ](/forum/attachment/41917 "Untitled4.png") [ ](/forum/attachment/41917?download=1 "Untitled4.png") - [ ![Untitled2.png](/forum/attachment/41918) ](/forum/attachment/41918 "Untitled2.png") [ ](/forum/attachment/41918?download=1 "Untitled2.png") - [ ![Untitled_2017-12-21.png](/forum/attachment/41919) ](/forum/attachment/41919 "...2017-12-21.png") [ ](/forum/attachment/41919?download=1 "...2017-12-21.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 10 months ago [\#284868](#284868) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284868 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hi, Well, first if you want the same data as on the reports, you might want to deactivate the "dashboard legacy" setting of the HikaShop configuration. Otherwise, regarding the new dashboard, as I said in my previous message, if you enable the "created" status in the "statistic" column of the menu System>Order statuses, it will be the order creation date that will be used. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago - 8 years 10 months ago [\#284901](#284901) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284901 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Dear Nicolas We had already checked the created status as per in the screen shot in the statistic (you can see it from the screen shot) However, the data for the order list, report, dashboard are still different (you can see from the screen shot, dash board record the last on the next day date which is not even logic with the order or invoice date) Last edit: 8 years 10 months ago by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 8 years 10 months ago [\#284970](#284970) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#284970 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hello, The processing of the date (based on the timestamp) is made directly by MySQL ; so it is possible that you have some timezone in your PHP and that your MySQL do not have the same timezone. So when MySQL convert the timestamp into a date, due to the different timezone, the result date is different. And please note that we had to do that task by MySQL because it then aggregate the values depending the date ; it provides better performances (memory and CPU) that getting all the data and process it using PHP. Regarding the Joomla timezone, it is handle by the statistic system, which add that information in the SQL query Code: 'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_invoice_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis'; Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#285036](#285036) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#285036 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* date.timezone = Asia/Kuala_Lumpur [root@shutter3 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1189698 Server version: 5.5.48 MySQL Community Server (GPL) by Remi Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select now(); + --- + | now() | + --- + | 2017-12-27 08:17:43 | + --- + 1 row in set (0.01 sec) Both the MYSQL and PHP are in same timezone, Joomla time for all other components are correct, only hikashop provide different timing.....as per earlier screen shot Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 10 months ago [\#285048](#285048) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#285048 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hi, Well, we don't have the problem on our end. So we need a concrete example to be able to understand the situation on your end. Please pick an order and in your phpmyadmin, open the table hikashop_order and provide the order_invoice_created and the order_created values that you have for that order. Then, run that query: SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP); and provide the result. It should display the offset from UTC that is used by your MySQL. Also, after the line: $this->timeoffsetStr = '+' . $this->timeoffset ; in the file administrator/components/com_hikashop/classes/statistics.php pleas add the line: var_dump($this->timeoffsetStr); and access your dashboard. You should then see the offset (in seconds) that is used by HikaShop and coming from the configuration of your Joomla at the top of the statistics area. Please provide that value. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 8 years 10 months ago [\#285082](#285082) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#285082 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP) -> result -> 08:00:00 var_dump result -> string(6) "+28800" server timezone in Joomla - > Kuala Lumpur For the order_created & invoice created in the screen shot order list SF05273 - 1513840307 - 0 SF05274 - 1513841158 - 1514009010 SF05275 - 1513842841 - 1513911458 SF05276 - 1513858081 - 0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 8 years 10 months ago [\#285093](#285093) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#285093 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?")* Hi, Thanks. So for the order SF05273, the timestamp 1513840307 corresponds to 2017-12-21 07:11:47 UTC ( [ www.unixtimestamp.com/index.php](https://www.unixtimestamp.com/index.php) ) The code of the statistics system is: Code: 'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_invoice_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis'; So that means that the system interprets that 1513840307 with something like that: Code: SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(1513840307 AS SIGNED)+28800), '%Y-%m-%d %T') On my end, this MySQL query results in: 2017-12-21 16:11:47 So this means that there is the timezone shift of Joomla plus the one from mysql (UTC+1) as it should normally output 2017-12-21 15:11:47 So let's try this: Add the code: $this->db->setQuery('SET @@session.time_zone = \'+00:00\''); $this->db->query(); before the line: $this->db->setQuery($query, $offset, $limit); in the file administrator/components/com_hikashop/classes/statistics.php That should remove the timezone issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTMxOTctcmVwb3J0LXN0YXRpc3RpYy1kYXRlLW9yZGVyLWFjdHVhbC1kYXRlLWRpZmZlcmVuY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.101 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)