“Total Stores Earnings” Displaying Negative Values in Admin Panel

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 at the admin panel's dashboard or analytics entry point and trace how “Total Stores Earnings” is calculated and populated. Reproduce the negative value with the reported steps, then verify the metric against store orders and commissions; done means the dashboard reports the correct non-negative total under normal conditions.

Written by the indexing model from the issue text.