Hi,
A customer that works with Ecommerce statistics reported that going into Orders and filtering by a certain date, provided a different amount of orders when compared to the "Turnover" report. After some digging we discovered this is because the Turnover statistics don't filter by Orders only.
Consider the attachment. It's not excluding Recurring order templates OrderIsRecurringOrderTemplate=0 and since all of these records are OrderComplete=1 and the order state may not be excluded from statistics (i.e. same as with orders), we run into some issues.
(The fact is that we never excluded the default order state from statistics, so it would take some customization to force recurring order templates to be changed to an order state that would not be tracked by statistics - it feels like it could be simpler to update the sql query attached)
That said, our main problem was with (batch imported) Ledgers. We could have also assigned them to an order state that is not tracked by statistics, but that means having a new order flow for this, where noting is tracked by statistics. If insterad we had a parameter to filter by "All", "Orders" or "Ledgers" (just like we have for Shops), would give us a lot more freedom to use the Statistics.
(in case you're wondering, right now we end up creating a dummy shop to assign all ledgers, and we also o that with non-web orders, so we can still benefit from all web order based statistics and insights by filtering on the order, but still show B2B customers a list of they entire orders in the frontend, whether those are online or offline orders)
Best Regards,
Nuno Aguiar
