API Bug (again): getdashboardstats per-product stats broken

[sven-bo]

The `getdashboardstats` endpoint is returning incorrect per-product revenue again. The fix from last Saturday (March 7) lasted about 4 days...

The same issue as before:
- `product_id = "all"` returns correct totals
- Querying each product individually and summing them up gives lower numbers
- The invoices endpoint confirms the sales exist and are paid

Affected product IDs:
- `67df6cc38bc1d43f886571b9` (QuickText)
- `6967786ce7afe3a7dfd3b033` (SimpleGantt)
- `68479a5cc4f87dcb824eca9b` (XLlama PRO)
- `6939242a5b3cab3a9ff89208` (TablePop)
- `65aa7c96665f810b1dcf0d36` (WhatsApp Blaster PRO)
- `665af7bc029326a7bb8e5a2d` (Twilio Excel Blaster)

How I verified: Same method as last time: compare the invoices endpoint (which shows all paid invoices correctly) against getdashboardstats per product. The invoices are there, the stats endpoint just isn't counting them.

 

[Preeti Paryani]

Hey @sven-bo,

We have escalated this issue to our technical team for further review. Kindly allow us some time to investigate this.

We will get back to you with an update as soon as we receive it from our team.

Thank you for your patience and cooperation.