I am volunteering with a non-profit and trying to setup systems for them. We have donated goods sitting in several warehouses which are intended for distribution to refugee camps by other non-profits. I would like to setup a page where these other non-profits can see what is available at each warehouse and reserve items for pickup. Here is my idea of the workflow and tasks it needs to support:

• Warehouse manager receives a shipment and enters the goods into the system
• Approved non-profit user logs in and can view available items at each warehouse.
• User reserves items for pickup and adds to cart
• At check-out screen, selects a pick-up time for each warehouse from which they selected items (no payment)
• User receives an email with access instructions for each warehouse
• Warehouse manager receives a notice about the pickup
• After goods are picked up, someone (user or manager) completes the order and ensures inventory is accurate.

This is a bit pie in the sky. The bare minimum would be a system to track available inventory and display it online to authenticated users. A Google Sheet comes to mind.

I would be very grateful for any suggestions. If you have experience in this arena and would be willing to donate 15 minutes for a Zoom call I would appreciate it. This is a humanitarian effort and will hopefully alleviate a bottleneck of getting goods to people in need.