how to reset booked/ordered pruduct field of 2800 products at once to zero?

[Renata]

Dear all

I have a problem and i hope you can advise/help me:

a third party has migrated the database of an oscommerce (source) website to Virtuemart 2.0.x. (target). We are now using VM 2.0.6.

The source website crashed in the past which resulted in wrong numbers of booked/ordered. As Virtuemart does not show products in the frontend if booked/ordered exceeds stock, a lot of products are missing at the frontend. For now we have made all products visible at the frontend, but this is not what we want.

We would like to make a fresh start so as from now we can manage the booked/ordered in combinance with shipped etc the way it should be.

The stock numbers are in good order, but not the booked ordered.

We have over 2800 products. is there a way to set all booked/ordered to zero at once? Can i do that via phpmyadmin/database? If so, can you explain how exactly?

I hope you can help me.

Thanks in advance
Kind regards
Renata