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?

closed as unclear what you're asking by Rubén, serenesat, user79865, jonsca Feb 23 '16 at 2:41

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    A good question. Does the Inventory Key have items in rows and products in columns, or the other way around? The function used will depend on the structure. – user79865 Oct 30 '15 at 5:38
  • @NormalHuman The Inventory Key has the products in columns (since we only have 6 at the moment) and items in rows. Hope that helps! – johnnyg Oct 30 '15 at 17:33
  • Have you looked at low cost web services available? – user109808 Dec 9 '15 at 21:33
  • Create a demo spreadsheet, share it with anyone with the link for view only. and add the link to the question. – Rubén Dec 30 '15 at 2:01
  • 1
    Can you add a sample of the sheet? Much easier to give an answer if we can take a look – Aurielle Perlmann Jan 2 '16 at 21:45

Browse other questions tagged or ask your own question.