I don't know if it's exactly what you are looking for, but you could use our premium add-on ATUM Export Pro. This add-on allows you to export almost any kind of data of your site, edit this info quickly on a spreadsheet and then import it to your site.
In this way, you will be able to update the products in bulk.
Regarding see how many products parts have been sold you could export this info too from Manufacturing Central.
I leave you here the add-on documentation where you will find a lot of info about how it works: https://forum.stockmanagementlabs.com/t/atum-export-pro-documentation
And the link to the demo site in case you want to try the free trial: https://www.stockmanagementlabs.com/addons/atum-export-pro/
Please, let me know if this helps and if I can do anything else for you.