[Skip to main content](#vessel-content) # No correlation between orders and reports ## - **[theguy](/forum/user/32584-theguy "View theguy's Profile")** - [![theguy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32584-theguy "View theguy's Profile") Topic Author - [ Offline](/forum/user/32584-theguy) Less More - Posts: 228 - Thank you received: 8 - - 8 years 6 days ago [\#300243](#300243) by [theguy](/forum/user/32584-theguy "View theguy's Profile") *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300243 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* was created by *[theguy](/forum/user/32584-theguy "View theguy's Profile")* -- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/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 6 days ago [\#300246](#300246) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300246 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hi, Well, everything matches on our end. So we would need more information on how you configure your reports, like screenshots of their settings. Also, a backend access would help so that we could look at the mysql query generated for the report. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[theguy](/forum/user/32584-theguy "View theguy's Profile")** - [![theguy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32584-theguy "View theguy's Profile") Topic Author - [ Offline](/forum/user/32584-theguy) Less More - Posts: 228 - Thank you received: 8 - - 8 years 3 days ago [\#300368](#300368) by [theguy](/forum/user/32584-theguy "View theguy's Profile") Replied by *[theguy](/forum/user/32584-theguy "View theguy's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300368 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hello Nicolas, I've made several attempts and managed to understand the issue on our end. I'm trying to generate a sales report for a single day. No matter what I select from the settings, the day is broken into two days. This causes disorder when we try to generate a report for several days or a week report. Please see attached screen shot. Much appreciated, Guy. - [ ![Sales_report.png](/forum/attachment/45375) ](/forum/attachment/45375 "Sales_report.png") [ ](/forum/attachment/45375?download=1 "Sales_report.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/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 2 days ago [\#300394](#300394) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300394 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hi, This indicates an issue with the timezones. Can you check that the timezone of your server, in your Joomla configuration and in your Joomla user account all match up ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[theguy](/forum/user/32584-theguy "View theguy's Profile")** - [![theguy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32584-theguy "View theguy's Profile") Topic Author - [ Offline](/forum/user/32584-theguy) Less More - Posts: 228 - Thank you received: 8 - - 8 years 2 days ago [\#300412](#300412) by [theguy](/forum/user/32584-theguy "View theguy's Profile") Replied by *[theguy](/forum/user/32584-theguy "View theguy's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300412 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hi, That was the first thing I suspected off. Checked the time zone and it was correct, as well as the Joomla configuration time zone. In addition, orders arrive at the right time. Guy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/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) - 7 years 11 months ago [\#300614](#300614) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300614 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hello, What are your time zone settings ? HikaShop store the timestamp in the database to avoid timezone issues ; the display is then made via Joomla and its timezone. Regarding the reports ; maybe an important timezone could generate an issue in your side and, before we only have 2 hours in our end, the issues are not visible. So, knowing more about your timezone setting would help us to see where we should take a look. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[theguy](/forum/user/32584-theguy "View theguy's Profile")** - [![theguy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32584-theguy "View theguy's Profile") Topic Author - [ Offline](/forum/user/32584-theguy) Less More - Posts: 228 - Thank you received: 8 - - 7 years 11 months ago [\#300653](#300653) by [theguy](/forum/user/32584-theguy "View theguy's Profile") Replied by *[theguy](/forum/user/32584-theguy "View theguy's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300653 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hello, The time zone i set to Jerusalem (Israel Time). Thank you, Guy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/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) - 7 years 11 months ago [\#300734](#300734) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300734 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Hello, I reproduced your configuration and was able to see a small timestamp sliding regarding the timezone. I worked on a patch, unfortunately that patch have too many modifications in the widget system to be listed in the forum here. So I prefer to include it in a future package of HikaShop 4.0.1 But the main idea of the patch is the same system that we have for the new dashboard system ; get the timezone value and process the dates using "gmmktime" and subtract the timezone value. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[theguy](/forum/user/32584-theguy "View theguy's Profile")** - [![theguy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32584-theguy "View theguy's Profile") Topic Author - [ Offline](/forum/user/32584-theguy) Less More - Posts: 228 - Thank you received: 8 - - 7 years 11 months ago [\#300746](#300746) by [theguy](/forum/user/32584-theguy "View theguy's Profile") Replied by *[theguy](/forum/user/32584-theguy "View theguy's Profile")* on topic *[No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300746 "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.")* Thank you very much Jerome. Looking forward for the next release ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYxODYtbm8tY29ycmVsYXRpb24tYmV0d2Vlbi1vcmRlcnMtYW5kLXJlcG9ydHM/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.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)