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?

  • 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.