HI,

First of all you have to trace and understand how this issue is happens in your instance, are you using any wrong modules or performed any wrong SQL operations in the database level.

If you feel the current inventory is wrong and if you are sure that it wont happen again, i will ask you to go with an inventory adjustment.

Thanks

you can update it through the database or by server action

there is multiple ways to do that but why this wrong data happened?