Virtuemart to connect with an external data base (independent from Joomla and Virtuemart) to do through it the stock control.
Set up a cronjob for updates.
Virtuemart / Connecting external database for inventory update.
We already have components installed to connect virtuemart with an external database.
Require expertise in Mysql and Php to achieve the perfect solution.