Looking at your links, are you looking for a software solution that:
1). Integrates data from different systems into one "master" list
2). Report on the master list?
OR
are you looking to build a system to handling purchasing, restocking, inventory movement between locations, ordering and shipment tracking?
If the 2nd, then Aware is a great tool for this. If the 1st, then there is the issue with incorporating data from external systems. There are some better tools for this.
Bruce