“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 in the admin panel's dashboard or analytics section and reproduce the negative “Total Stores Earnings” value. Trace how this metric is calculated and synced from store orders and commissions, including refund or return handling. Done means the dashboard shows the correct total and does not display negative earnings under normal circumstances.