Revenue report not working for me

[AH]

Have you ever checked to see if that report is correct with what you sell?
I think it's a general problem, not just a problem of mine, only no one has checked that

I am not in the habit of making statements without testing.  I am not saying you do not see an issue - I am only saying that I do not see the same issue.

When I run this report and review products - I see the correct figures for items sold by product line.

I am not doing anymore testing on this as I cannot see the issue and am no longer focusing my time on it.  Maybe someone else will take this up.

[Iryn3l]

Okay, no problem
When I run this report and review products - I see the correct figures for items sold by product line. >>> You see the correct report, I don't see the same

Thank You

[Iryn3l]

I return to this issue after several investigations at the suggestion of AH, with more details
I checked carefully and created a table with all the data for 7 days: Vm Report, Database, Reporter for Virtuemart and the orders received on those days between 00 -00. I counted them several times in Vm / Orders

1.Revenue Report from VM is not correct with the database
2.Extension ,, Reporter for Virtuemart from Virtueplanet ,, extracts data from the database and they are correct (what I have in the database I also have in Reporter for Virtuemart)

The orders received are more than those in the database and Reports.
It seems that the database does not take over some orders received in the VM backend

1. Orders received 247
2. Database 245
3. Revenue Report VM 244
4. Virteuplanet extension 245

I also attached an image to better understand me

[AH]

Iryn3

That is useful information and has made me remember my first reporting forrays -

Ignoring Virtueplanet for a moment what timezone are you in and what timezone is your database in

I had an issue some time back where I was using the datetime stored in the database tables as a date for my reports sql queries.  After developing all on my local server I found small errors when moving to the live server (not located in the same region as the Country in which the business traded)

Then I realised that the database timezone is the MYSQL time of the server and not of the "store"  which used a Joomla timezone setting of London

I.e.  The timezone was shifted by 2 hours so what was written to the database was not what is shown to the customer or admins.

Consequently when looking at the data in the database - any orders at the "thresholds" of these day/time variances were throwing my own direct SQL reports off with what I know were the date and times reported on screen or on printed reports in VM admin.

So for your data and each of those orders have you looked at the database time and compared to the Order displayed time - or am I completely wrong and your database times exactly match your order times

[Iryn3l]

Example:
Order No. 9UQ604303
-The correct order time In VM Order and e-mail -12: 46
-In Revenue Report and database 10:46:02

I tried to explain that in Revenue Report it's not the same time but I don't think I knew how to make myself understood

How do I solve this?

[Jörgen]

Hello

As I said earlier, this looks like a timezone issue. I have checked in the order view for the order created time. In my case I have 23:47 in this view. The same order appears on 22:47 in the report view. In the database 22:47 is stored.

It appears that the difference is 1 hour from my server time. I am on Stockholm/Paris time and my server is 1 hour behind in time. Receiving orders around 0:00 gives false reports.

This has not been a big issue for me, but it seems to be a bug in how the timestamp is handled in this report.

Jörgen @ Kreativ Fotografi

[pinochico]

setup right time zone in joomla and server DB.
Issues for admin, not for VM

[Jörgen]

I an pretty this is the case. Why would two VM views give different times...

[AH]

setup right time zone in joomla and server DB.
Issues for admin, not for VM

This is not possible for most users on shared hosting

[AH]

I an pretty this is the case. Why would two VM views give different times...

The person reporting just has to confirm that the order table date/time is the same as that shown on the screen for an order and is not timeshifted for his site deployment

[pinochico]

This is not possible for most users on shared hosting

Aha

[Iryn3l]

setup right time zone in joomla and server DB.
Issues for admin, not for VM

This is not possible for most users on shared hosting

I can do this, I own a rented server
I talked some time ago with those who manage the server but they said that the date and time of the server are set correct.
In joomla / global configuration / Time Zone Website is just as correctly set

[Jörgen]

Hello Iryn31

If I get it correctly, You get this result

In the Order edit view: Order time 12:46
In the Revenue view :  Order Time 10:46

This has as I see it nothing to do with incorrect Server times or Joomla time zone settings.

These are the data shown from two different VM view. They should use the same settings and produce the same order time. One of the views uses the time zone offset, the other one does not. I would say the Revenue view is at fault here.

I consider this to be a bug in the Revenue view.

Jörgen @ Kreativ Fotografi

[Iryn3l]

Hello
Thanks for the reply.
Your answer confirms the situation I thought of from the beginning
Probably in the next versions things will be resolved because know about this bug now

[AH]

Unfortunately that confirmation - is not really any confirmation.

I will do some more digging - but if you check your order tables - are you confirming that the order time and created_on times are shifted by 2 hours

In the Order edit view: Order time 12:46
In the Revenue view :  Order Time 10:46

There is no time in the revenue view - so that detail could not have come from this report  on screen

However - if reporting by products - they are not separated by period - but are consolidated by product_id/period - showing only the first instance of date

So if product_id 21 sold on the 2021/02/01 and 2021/02/02 and you are reporting over a period that includes those dates - you would see all item sales rolled into the date of the 2021/02/01