Post by beheerderNVV » Fri Oct 04, 2024 3:30 pm

hi,
I have never noticed this happening before (and total sales for a yearly interval used to very accurately match total revenue), but on my installation now running v3.0.4.0, I am seeing incomplete sales reports, and certain sold products only showing up if I set the report date to a specific interval near when they were sold.
This primarily affects a ticket we briefly sold, after which all existing sales were set to canceled. Yet I can now only find these sales in the report if I set the report interval to the specific _week_ in which the sales were done/registered, and they don't show up at all if I set the interval to 2024-01-01 to today. Is anyone else seeing this, and/or does anyone have an idea what may be causing this, and/or how to fix it?

Newbie

Posts

Joined
Tue Oct 09, 2018 2:53 am

Post by softmonke » Sun Oct 06, 2024 7:53 am

beheerderNVV wrote:
Fri Oct 04, 2024 3:30 pm
hi,
I have never noticed this happening before (and total sales for a yearly interval used to very accurately match total revenue), but on my installation now running v3.0.4.0, I am seeing incomplete sales reports, and certain sold products only showing up if I set the report date to a specific interval near when they were sold.
This primarily affects a ticket we briefly sold, after which all existing sales were set to canceled. Yet I can now only find these sales in the report if I set the report interval to the specific _week_ in which the sales were done/registered, and they don't show up at all if I set the interval to 2024-01-01 to today. Is anyone else seeing this, and/or does anyone have an idea what may be causing this, and/or how to fix it?
It's kind of confusing what you are trying to say. Which report(s) are you using exactly?

For Sales Report, even if the order is canceled, if you set the "Status" filter option to "All Status", these canceled orders are included. If you are trying to exclude canceled orders, then you will need to specify an order status instead. The same goes for Products Purchased Report.

Check out our ever-growing list of extensions for OpenCart here.
Some useful extensions for a better admin experience: Image File Manager ProDrag & Drop Sort Order

Reach out to us at hello@softmonke.com for your OpenCart web development needs or feedback for our extensions.


User avatar
Active Member

Posts

Joined
Tue May 23, 2023 4:42 am


Post by beheerderNVV » Mon Oct 07, 2024 12:21 am

softmonke wrote:
Sun Oct 06, 2024 7:53 am
beheerderNVV wrote:
Fri Oct 04, 2024 3:30 pm
hi,
I have never noticed this happening before (and total sales for a yearly interval used to very accurately match total revenue), but on my installation now running v3.0.4.0, I am seeing incomplete sales reports, and certain sold products only showing up if I set the report date to a specific interval near when they were sold.
This primarily affects a ticket we briefly sold, after which all existing sales were set to canceled. Yet I can now only find these sales in the report if I set the report interval to the specific _week_ in which the sales were done/registered, and they don't show up at all if I set the interval to 2024-01-01 to today. Is anyone else seeing this, and/or does anyone have an idea what may be causing this, and/or how to fix it?
It's kind of confusing what you are trying to say. Which report(s) are you using exactly?

For Sales Report, even if the order is canceled, if you set the "Status" filter option to "All Status", these canceled orders are included. If you are trying to exclude canceled orders, then you will need to specify an order status instead. The same goes for Products Purchased Report.
To clarify: when it comes to certain (but not all) sales (which were ultimately all set to canceled), when I set the filter to "all statuses", the sales don't show at all on the sales report unless I set the start date of the filter interval to 4 days prior to the first sale, which happened to be on the 10th or 11th. They don't show up at all when I set the filter start date to June 7 or earlier in the year.

Newbie

Posts

Joined
Tue Oct 09, 2018 2:53 am

Post by JNeuhoff » Mon Oct 07, 2024 12:30 am

I am unable to reproduce your error. I just tested it on an OpenCart 3.0.4.0 site, with a Canceled order, and it shows up just fine in the sales report.

You probably haven't provided all the details, see forum rules.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 0 guests