“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 by reproducing the negative “Total Stores Earnings” value from the admin panel dashboard or analytics section. Trace the metric’s calculation and data source, then verify that the displayed total matches store earnings and does not become negative under normal circumstances, including the reported returns, refunds, or syncing cases.

Written by the indexing model from the issue text.