“Total Stores Earnings” Displaying Negative Values in Admin Panel

Nobody has claimed this yet.

Describe the bug
The “Total Stores Earnings” metric in the admin dashboard is showing negative values, which is incorrect. This value should reflect the total amount earned by all stores and should not drop below zero under normal circumstances.

To Reproduce
Steps to reproduce the behavior:

Log in to the admin panel
Navigate to the dashboard or analytics section
Check the value under “Total Stores Earnings”
Observe that it is displaying a negative number
Expected behavior
The "Total Stores Earnings" should always represent the correct positive total of what stores have earned. Negative earnings are illogical and suggest a calculation or data syncing issue.

Screenshots

Image

Desktop (please complete the following information):

OS: Windows 11

Browser: Chrome

Version: [e.g., 123.0.6312.86]

Additional context
This may be caused by incorrect financial calculations, returns/refunds not handled properly in reporting, or a data mismatch between store orders and commissions. Needs urgent review to maintain financial data integrity.

Start by reproducing the negative value in the admin panel's dashboard or analytics section. Trace the Total Stores Earnings calculation and compare it with store orders, commissions, returns, and refunds to identify the data mismatch. Done means the metric reports the correct total and does not become negative under normal circumstances.

Written by the indexing model from the issue text.