Hello
I try to use daily, weekly, monthly revenue raport
I select the order status, daily or order and receive the correct result + total revenue
If I select to see the products sold (respectively their number) I receive correctly the number of orders ex 22, the number of items seen ex 48 but I can't see what products I sold and how many of each
Also here I receive the correct answer about the income report
VirtueMart 3.8.4 10335
Joomla! 3.9.20
I checked on another website VirtueMart version 3.0.18 and there it seems to work normally, I receive Total Items balance and in how many orders was the product
Can you help me ?
Hello again
Probably didn`t understand me, I wasn't explicit enough above
I want to make a daily weekly or monthly report of the products sold (I am interested in their number to reduce them in accounting)
I calculated the number of products sold in a table and compared it to what I have in the report for that day:
They are not the same, either I have an extra number of products in the report ... or in the report I can't find all the products sold
Basically the ratio is not the same as what is sold
You have a solution
Thank you
Does anyone know about this calculation error?
Can't you give me an answer?
I upgraded to VirtueMart version 3.8.6 10373.
I have the same error in the revenue report.
It seems to be a VM problem.
If you can't explain this to solve, can you recommend me a module, a plugin that would replace this?
if this does not work for you
Maybe you should write your own reporting using sql and excel
I don't know how to do that
Does it work for you?
I calculated on certain days and products are missing from the report
I return to this error , to specify that my products sold that I did not find in the daily report, are seen the day before
Maybe in this case there is a solution, maybe someone has encountered this problem before and a solution would be good for more people.
Are the products sold near 00:00 hours ?
Jörgen
00:32 one of them
Then there is an issue with the timestamp. Servertime is not the same as datetime for the order. People on GMT seldom see this issue.
I have not looked into this, but I have also seen this long ago. But I have not used VM to make daily reports. All my orders are taken
one by one to my bookkeeping program on paper.
Jörgen
Do I understand that it is a problem that has no solution at the moment?
For example, I have 18 orders that day with a value without shipping taxes 1782 (2106 with shipping included) and a total of 44 products sold.
The VM report shows a number of 29 orders, 34 products worth 1,352 It is a big difference
I try to solve this because I have a very large number of different products and on days with 100 orders it is difficult to write on the sheet.
Is there a small solution that I should at least try to solve?
Thank You
Correct you have a problem
there is no solution to your particular problem
Work out what the report is including/excluding and maybe you will be able to provide informatino as to what the order range is doing for you regarding products sold
you need to actually debug the sql to find out the data being included in your report
there is no solution to your particular problem >>> Are you telling me that only I have this problem? That you have the correct reports in VM?
"there is no solution to your particular problem "
When I run this report and review products - I see the correct figures for items sold by product line.
As a result - I do not understand your issue - as I do not have your data and cannot replicate an issue with my data - I also have no idea what settings you are using when running the report.
And as you can see from the replies to your post - no one else is confirming your issue or providing and more support.
If this particular area is causing you problems - then you may need to provide more information to help others understand and test on your behalf.
On November 14, 2020 (a day taken at random to check if the report is correct), I set a status report confirmed by the client (all my orders have this status on this day)
Set range: Products
Deadline: November 14, 2020
I receive a report that on that day I sold 34 items when I actually sold 44
If at the interval I select orders, (same day) I receive a report that I had 17 orders when in fact there were 20 that day
The correct value of all products sold that day is 1782.00, in my generated report I receive 1,352.00
Server-level time is set correctly, as is joomla
More than that I can not explain, in short the report is not correct
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
QuoteHave 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.
QuoteWhen 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.
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
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
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
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?
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
setup right time zone in joomla and server DB.
Issues for admin, not for VM
I an pretty this is the case. Why would two VM views give different times...
Quote from: pinochico on January 29, 2021, 18:17:53 PM
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
QuoteI 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
QuoteThis is not possible for most users on shared hosting
Aha
Quote from: AH on January 30, 2021, 13:18:23 PM
Quote from: pinochico on January 29, 2021, 18:17:53 PM
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
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
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
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
I have to correct you on this one AH.
There is both date, time and order number in the Revenue view, You just have to read the manual and figure out how to display this.
I am not making anything up, I know what I can see in the view, and so far my eyes are working.
Jörgen
Quote from: Jörgen on February 02, 2021, 12:22:30 PM
I have to correct you on this one AH.
There is both date, time and order number in the Revenue view, You just have to read the manual and figure out how to display this.
I am not making anything up, I know what I can see in the view, and so far my eyes are working.
Jörgen
Joerg - I am referring to the Products view as that is what this really was all about - both of you have now shown a date/time in an order view - that does not provide what was originally asked for:
I refer right back to your Iryn first postings:-
QuoteProbably didn`t understand me, I wasn't explicit enough above
I want to make a daily weekly or monthly report of the products sold (I am interested in their number to reduce them in accounting)
I calculated the number of products sold in a table and compared it to what I have in the report for that day
This was never about orders as that does not give the product detail required.
However I have just reviewed the order report for BST and seen that the order is showing with a time difference on the revenue report to that shown on the order list
AH Thank you for your interest
I will now report and ask why this is the case