Create an Inventory Management System with Google Forms and Google Sheets

In this project we will use Google Forms to easily submit inputs and outputs to an Inventory Management System in Google Sheets, as always, from scratch.

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[janemitchell]

I have built this Google Sheet and 2 forms, input and output. This works great. Thank you! Can you tell me how I can wipe everything out to start fresh? I have done tons of testing and have inventory amounts but I am concerned about running out of usable rows. How can I refresh without affecting my Inventory totals?

[schmonkeytube]

This is great! How would you build in tracking inventory on one product with various types, for example, Hat sizes S, M, L, as well as colors blue, red, green? Would you just create various Product Names: Hat Sm Blue, Hat Med Red, Hat Large Green, etc., or is there a formula that can accomodate it?

[walterwa]

I have already like and subscribed before watching

[ricoadhyasta]

Hello, can you make if the stock of the product is 0(zero), so the product he product doesn't appear on the output form?

[stuartmcneill]

Could you also in addition to this create this very system with using the QR codes? Nice explanation.

[Makmaven]

Thanks for this very useful project, meanwhile, please if the price of some of the products change how do we manage it, to keep the former one but update the new one, thanks

[zarlsss]

Any chance you could instruct how to shift from a dropdown to multiple choice?
I need to add images next to each product but still need an accurate count for each item. Perhaps you have another suggestion?

[BraveHeart-htzf]

problem if use google form to create inventory is difficult to update

[hhlngro]

Hello. Can you advice how to add another condition in the sum if equation

[divyasaibabu]

How do I get my output form to update as per changes in the input form

[zjctgvy]

How can i reset my numbers to start over in my stock

[NabeelAhmed-fgit]

i tried input answer is perfect while for output i am unable to get answer i am getting 0 for the column. while i submit data in the form.Could you please advise where i am mistaken.

[PizzaCircle-ynbg]

We have to select each different item in one form and how to calculate their quantity.

[jayplaays]

Hello, I have question? This is very informative. But some of the data in input doesn't show up. It is just zero even though I putted it multiple times. Do you have a solution for that?

[GAMESKICRAZE]

Sir, I am not technical so plz tell me I can share the link of output form to my customer.And if I purchase template I can add more fields i.e name, address ect. input, product form.plz reply me.

[makelifeeasy]

you said free membership, when i got membership and see temple it again say 5$. now i m not sure after 5$ paid, you connect to anoth page for 100$ then 10000$ then million $ for your marverlous impossible templates. regards. no hot feeling.

[ladykew]

HORRIBLE! YOU DIDN'T EXPLAIN WHAT TO HIT TO CREATE THE FORM TO ENTER THE SHEETS. I'M TOTALLY LOST WITH YOUR VIDEO. IT SUCKS!