So I'm trying to create a rudimentary inventory management system in Google Sheets. I want this inventory guide to keep track of my product inventory, as well as my packaging inventory. So if a customer orders Product A, it means we're using 1 of Item 1 (product), Item 2 (box), and Item 3 (label) from our inventory.
I have a sheet that tracks orders by day. I've also created a Master Inventory List (issues each item an item #, name, etc. for referencing later) and a Received Inventory List (when I get new stock of inventory in). I've also created a "Inventory Key" sheet which lists all items in our warehouse and says how many of each item will be needed/issued if a customer orders Product X.
And here comes the question: how do I create an Inventory Issued sheet that takes the number of orders for Product A from the Daily Orders sheet, reference the Inventory Key, and then output the total number of items used for that day?