Hi,
The simplest would be to use HikaMarket Multivendor (
www.hikashop.com/hikamarket-multi-vendor.html
). Then, just create one vendor account for each foundation and link each product to the corresponding vendor.
HikaMarket will then handle the mailing of the vendors automatically, you can set the fees/commissions so that the system will calculate the amount earned by each vendor automatically, and you can create a menu item of the type "HikaMarket vendor control panel" to give them access to their sales and statistics on the frontend.
So it does everything you requested automatically for you once setup.
The alternative would be hiring a developer to forward the emails based on the category of the products, and develop the frontend interfaces for the reporting. So it would cost a lot of money.