Inventory with QR Codes in Google Sheets and Google Forms

In this project we will learn how to use QR codes with Google Forms and Google Sheets to easily input new items to your inventory system

➤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

[practicalsheets]

ATTENTION: (9/4/24): The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com

Here is an example of its use

[khcscij]

I would love to see a part 2 of this that includes the output and how to create a form where you can select the quantities that are received/removed in bulk.

[stuartmcneill]

Would love to see a part 2 on the output, thank you for this great explaining video

[malukufree]

First of all have a Merry Christmas.

Thanks for the clear explanation, this was really helpful. Looking forward to your next video for the output version.
🎄🎄🎄

[sarahbutti]

Thank you….. nice solution and great explanation

[liching]

Thanks very much. that's very well explained and followed. Would definitely appreciate part 2 of video

[gabrielcambronero]

Bro muchas gracias por el video!! Te ganaste un seguidor!!

[bwmkkjj]

hi there very interesting video soo much to learn about it!
with this technique is it possible to create the input/output forms for different users (only for output and some in and output).
and when you scan the QR code that you can put in the number of items you in input or output so that you dont have to scan 10 times the same code to have the right amount of items in or out?

I'm looking to do this for a long long time but never find how to do it! this idea of you may bring me to the good path. just wondering is the items mentioned above were possible to add in ? :)

kind regards

[thethtoonaing]

Hi Sri, great video. Is there anyway to add quantity when doing inventory input QR scanning? Where can i check part 2 for output inventory qty? thank you

[srisukartimostafa]

Thank you for the video.. It is very clear..

[rmwaye]

I've added another qr code for when items are scanned out. How would I update the quantity in stock logic so it shows the correct quantity when an item has been scanned out?

[lauradziuban]

If I wanted to be able to input a number for the quantity of item from just scanning the QR once, like if I purchased 20 shirts that were all the same and wanted to add them into the inventory. Instead of just scanning 20 times, can I somehow have the google form recognize the different unique names still but also keep a running quantity total? Sorry if this didn't make sense

[sclhioi]

Hello, Thank you so much for your video. I tried adding new products and dragging the URLs and the QR code. I also added the product name onto the google form, when I tried to scan the qr code it kept saying a new question was added, and it didn't let me automatically submit the form. How can I add new products and have everything else work?

[krissabastian]

Can we move a column in Google Spreadsheet for validating what has been scanned ?

[kevingalang]

It works!
However after I created another multiple choice, it didn't work. Do you know how to solve it?
Thanks in advance!

[rotg]

Great video, How do you auto update the form if you keep adding new products in google sheet?

[bryanasiimwe]

Hello, How are you? Thank you for your videos and the effort you put behind them. However, at 4:54, you talked of sharing the link on the automatic way of updating the Google form once you input data in the sheet. You mentioned including the link in the description, which I can't find. Could you have forgotten to include it or if it doesn't bother you, kindly share it as a reply to this comment. Thanks!

[am]

great video, is there a way to close the google form after the qr code reads it? the camera appear so it can scan the qr code again. Thanks

[ntuljhj]

I spent a lot of time searching for videos and this was by far the best easy to follow video. I simply want to track company assets as they leave the warehouse and when they get returned so I have set up two bar codes per asset but how do I get google sheets to enter the name of the individual that is scanning the item to appear on the spreadsheet without the employee having to enter their name each time in a field on the google form or is this not an option? Also, how do I print the QR codes and possible name them with the asset name (ie. baker-1, baker-2, baker-3)?

[alanalejandroaranzola]

Can we modify the quantity displayed from the QR? (for example if in a reading there´s 50 of the same product i just scan 1 and i can count the whole batch)