Google Sheets - Inventory Management System Template

Learn how to create an inventory management system template in Google Sheets.
Final Product:
docs.google.com/spreadsheets/...
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
Support the channel on Patreon / chicagocomputerclasses
Make a one time donation: www.chicagocomputerclasses.co...
#Inventory #GoogleSheets #tutorial

[@ExcelGoogleSheets]

Videos Worth to Check Out: Clock In, Clock Out System - kzbin.info/www/bejne/pZKQdKiul7l9b8k Budget Template Google Sheets - kzbin.info/www/bejne/h3i5lIOhj5ueoZo Calendar Template Google Sheets - kzbin.info/www/bejne/p6fMmGh4qMl1mtU

[@tomeknaj]

@Philip Elliott I think you forgot to type all the other responses, buddy

[@JimmyGrey-fl1kb]

This is absolutely one of the best Google Sheets 'How To' videos I've ever seen! I really appreciate how clear you've communicated the formulas along with all the shortcuts and formatting tips you explained. Thank you so much!

[@attiqrehman8550]

I have watched all your videos, liked all, subscribed on watching first video. I've learned more from your videos than i could learn from 1 year at school. You are brilliant sir, and THANK YOU.

[@wormemc]

Genius level Google sheets. Amazing! I managed to create this for my business after following along for a couple of hours. I never thought I could do that. Wow.

[@ExcelGoogleSheets]

:)

[@filmgirlpipes]

You are the man! Google Sheets hurt my little brain - but you just made it manageable for me. Thanks for taking the time to help us out! You have no idea how much I appreciate it! 👍

[@lornafletcher9362]

Thank you so much for this! I am an owner of a small business and just now starting, not even open yet. I just downloaded the template. I've been trying to figure out how I'm going to organize and keep track of my inventory. Thanks a bunch!

[@mistercarlacat]

I have struggled to wrap my head around Google sheets for a long time, this video is so clear and amazing! Thank you :)

[@ExcelGoogleSheets]

:)

[@ichAG]

Instead of looking for the needle in the haystack (on KZbin) I always go directly to your channel whenever I need help with Google Sheets. That's how good you are. Also, thank you for the template! It saved me some time.

[@KittyKam88]

FINALLY an actual tutorial that I needed! Thank you! I never knew how to make formulas! 💕

[@aashitgarodia]

EXACTLY WHAT I HAD BEEN LOOKING FOR, THANK YOU SO MUCH!

[@kevinmgibbons]

Thank you so so much for this tutorial! We have been trying to set up an inventory sheet for our global health non-profit, and this solution is perfect. Cheers!

[@airam4261]

Starting my small business, this tutorial was amazing, thank you so much!

[@camisartisandesigns66]

I'm literally in tears as I finished my own for my new business 😭😭 I've never been tech-savvy and it took me a few days but I got it. Thank you so much!!!!!

[@ExcelGoogleSheets]

👍

[@HaroonTahir]

The first channel i feel like donating to.

[@ajaydulani5496]

It's really gold.. Thank you very much for helping and sharing such tutorials...

[@chessandchips7016]

It's amazing, thank you for creating this video 🙏

[@kerenbanget1]

I thank you so much for this crystal clear and step-by-step explanation video.

[@bakso1]

Thanks exactly what I needed. A few tweaks and it was perfect for my use

[@CluelessWarren]

This is golden! Thank you so much for uploading this tutorial, it's so helpful!!

[@jettgonzalessubaba2053]

Thank you for your amazing tutorial and the google sheets as well. very helpful :)

[@lcoonfare164280]

This is AWESOME! From the co-owner of a new up and coming business this is very helpful!

[@ExcelGoogleSheets]

Great to hear!

[@dumarhidalgo1555]

Hello, thank you very much. Very useful video. I sell clothing so I added corresponding size columns to the overall layout in order to check available stock in the inventory. I also removed the first "Items" sheet because I consider I don't need it so the insert item option was moved to "Received" sheet. Thank you again, It was a very solid base to adapt it to me.

[@ExcelGoogleSheets]

:)

[@Polkizofficial]

WOW Thank you sooo much!! I made a copy of your spreadsheet and modified it for my inventory! thank you so much for helping, your video was so informative and I learned a lot.

[@learningcenterHD]

right and good job dear a lot of thanks for such amazing tutorials

[@saladen6411]

Awesome!! I'm using it and it works perfect. Very important, keeping updating what comes in and what goes out constantly.

[@ABANOB_MUSICIAN]

Dose google sheet do calculations mistakes or lagg ?

[@bernicephuah9599]

Thank you so much for this helpful tutorial.

[@meganhanson9402]

Love the final product! Thank you

[@th3mom3ntum]

Great tutorial! Helped me a lot! Thanks!

[@aureliasurja7449]

Im halfway through the video but I’m already learning so much, thanks a lot! Very insightful content

[@ExcelGoogleSheets]

👍

[@freeshybreeze]

Used this for my company thank you so much for your knowledge definetly subscribed and liked!!

[@kiannelabrador2259]

This is so helpful, thank you so much!

[@brilliantpy]

Thank you for creating a very helpful and easy to follow video! Great job!!!

[@ExcelGoogleSheets]

😀

[@janiecardenas8835]

Thanks so much! This was so very helpful. :)

[@adamrounisto1875]

Wow, that was some really good content and you blew my mind away at the end when you were talking about having somebody program you a custom solution. I want to ask, where exactly would it be most efficient for me to go to find an engineer to program something for that and what kind of information should I consider having available to all in what metrics would you suggest that I should include in something like what you were just talking about?

[@KwanX1]

Very well explained, thank you!

[@hyl325]

This was super amazing! I learned a lot!

[@tiffanyfong3026]

u make it really clear , thank you:)

[@sweetworldreposteria3937]

Thanks, great tutorial as always, really useful for my store.

[@ExcelGoogleSheets]

Great to hear!

[@mitchikoy109]

Thank you so much for this! Learned a lot from this video. Subscribed! :D

[@SaadKhan-tk3dq]

Thank you for uploading Google sheets tutorials. These are very helpful. Can you please create a video on invoicing and automatoc reporting.

[@vitas2498]

Thank you so much for the awesome tutorial!!

[@ExcelGoogleSheets]

Glad it was helpful!

[@lawks56]

Awesome video. You make it look simple.

[@3rdaug]

Great Tutorial, very descriptive

[@kiskis4786]

Thank you very much. It helped me and saved me a lot of time.

[@thebestcrazyworld3713]

You're amazing. It's like you're reading my mind. Each time I al stuck at somthing, I come check your videos.... And bingo it solves my probleme. Fantastic job dud. Thank you so much.

[@ExcelGoogleSheets]

Thanks for watching!

[@emilioojeda3129]

Thank you so much!, i managed to make a personalized inventory with your instructions. You explain it very well.

[@ExcelGoogleSheets]

Fantastic!

[@josefmarzano3914]

Very simple explanation. Thanks (Obrigado)

[@jiannivega2209]

This is extremely helpful. Thank you so so much

[@CallUsTemily]

So thankful for your help 😊

[@melvinbertillo]

Thank you for the template link. God bless you!

[@mike23mtz]

Very useful video, and easy to understand. Thanks

[@OliverCarrington]

Exactly what I was looking for! Thank you for this.

[@ExcelGoogleSheets]

Cool!

[@joshuacaylor881]

That was extremely helpful and well-explained. Thank you

[@ExcelGoogleSheets]

👍

[@afaqbaig1919]

This is really Great, Thanks a lot man.

[@robertollovera]

First Comment! Yeah!!!! Thanks for all your videos! i Learn a lot!

[@ExcelGoogleSheets]

Thanks for watching!

[@SxcBebee]

Hi I followed you through this video to create my inventory and I was just wondering if you could do the steps for profit loss and gains, total profit as well as damaged items?

[@akashmurarka3344]

Amazing Videos! Really helpful. All your App script videos are really informative and make the task really easy. I have made some really great Web Apps which have made managing our vendors, purchase really easy. Thankyou for your help !!

[@ExcelGoogleSheets]

Great to hear!

[@daniellapcosta]

Great video! Thank you

[@mynetstart]

Thanks for the knowledge.

[@ericapura4851]

You are awsome! Thank you so much for sharing your knowledge with us!

[@xSyberprox]

Exactly what I was looking for, thank you very much sir

[@snehmehta]

Hey great tutorial really liked it ! I need a help in when sales data is added i want to generate an Invoice, how can i do it ? Thanks !

[@crashcompilations2352]

That was awesome thank you 🙂

[@Glorypma]

HI. your tutorial is amazing. thanks a lot! I wanted to know if there's a way to sort or filter (via the filter tool) the unique column in inventory? thanks

[@chavits8527]

Thank you so much for sharing this! I have further question on how to move further with this template in the "Average Cost aspects for each sales made" It would be greatly appreciated! The purpose is to identify specific cost at the time of a particular sales transaction :)

[@singlecylinderadv]

This is great. Thanks so much. But how can I set this up to keep track of inventory for an assembled product that has lots of small pieces coming in but then goes out as a package? I'm hoping to be able to subtract all the small pieces from my inventory once the product is sold. This way I can tell how much inventory I have left to build more. Thanks

[@nicoleivie]

I am sincerely impressed!!!!

[@austingriggs9100]

Hello, I love this inventory system and it works great for us. One question that I had was; Is it possible group some items together that are sold in a pack? So that if you marked a sale of that pack it would reduce inventory on all items included? Thanks so much!

[@inicahyaaa]

This is what I need.. This is what I find... Thankyou very much..

[@danielleamato2993]

I'm in love with this video

[@ZeeshanIqbal24]

Thank You Soo Much Man !

[@dnanton72]

Excellent videos, thanks for sharing your knowledge. The question, I need to read a value from one sheet, and bring all the data associated with that value from another sheet, how can I do it with query function? The actual issue is: Calculate the number of ingredients to be used for each recipe that has been ordered and add the amount of each ingredient needed.

[@damianng1237]

Thanks for taking the time to share your knowledge. :)

[@ExcelGoogleSheets]

Thanks for watching!

[@ABC-ow5zs]

Thank you so much sir! Good job 👍

[@febriandee]

thanks for ur sharing. all the best

[@Emmy.Malfoy]

thanks for teaching us!!

[@maruman5776]

Thanks a lot... It's so useful for me

[@bushra6642]

really thank you

[@matthewpactat9884]

Thank you, amazing tutorial. Would be great if Delevery Notes could be generated automatically particularly as Xero does not do this. Is this possible and how would you do it ?

[@wendyho6126]

Excellent - thanks. How would you incorporate the expiry dates of products?

[@saadmalik6114]

very good to see the idea, for the current online delivery module. would like to see in transit and for sale inventory system. not just stock in hand.

[@m.a.rahman-rahim7092]

It helps me a lot.

[@computergeeks7546]

For removing #N/A if it appears, we can use also 'ifna()' function.

[@rosenguyen7912]

I would do =If(isblank(A2),"",vlookup(A2,...)

[@pikachumariachi]

@@rosenguyen7912Also, IFERROR

[@SherazAhmed-fg2cy]

very nice and simple, thanks

[@lisasaunders3777]

This is very helpful - great video. Is there a follow on video or something to help me track where the inventory ends up (sales, tracking who is buying what?)

[@Mrdealornodeal618]

This is a good video tutorial. Thank you!

[@ExcelGoogleSheets]

:)

[@jamillhr]

Great tutorial, helped me a lot. Now I want profits to be automatically calculated at the end of each month after deducting constant expenses like salaries, rent and electricity etc. Plz guide.

[@nsouwloukifach]

You don't know how much you solved in one video, thanks! 🙏 Quick question, how would you manage returns for individual products sold? Let's imagine we add a column where we scan a barcode so it's easier for input in quantity received and sold. How would you add the returns?

[@isabellefeyfant7577]

Thank you so much for your video. I am new and you explain everything so well. Thank you a million. Do you have a video where you add a barcode to this google sheet?

[@joegarth1208]

Excellent video, this helped me a lot, I just stumbled on an issue I'm using a dropdown box with the sumif as well but when I change the item the math doesn't follows the 6. Is there a way to store the data for each item automatically when the dropdown box changes.

[@kennjt5015]

Very helpful. Just subscribed.

[@ExcelGoogleSheets]

Thanks for the sub!

[@InsideMyWall]

Can you make a video to integrate Google sheets with QR code so that we can manage our Inventory just by scanning. Material in and out time can be monitored in log sheets

[@venesiahodges5609]

Were you able to obtain this information yet. I need something similar during check out with a qr code.

[@peyush19]

Hi, even I am looking for this solution, in case you know of it, please advise

[@dixonwilliam6694]

of course

[@bwesley26]

@@peyush19 this is what you do. Get the link for your Google sheet. Then you can get an NFC tag and program it with that link. After physically placing the tag by the item you want to inventory, all you have to do is go er your NFC capable device (android or iphone) over that tag and it will take you directly to that sheet.

[@darksquare687]

You need to learn google form pre filled for QR codes

[@mrnasrinasir]

question, so is there any way for me to keep track of storage in and out from warehouse to restaurant?

[@sokratakis1995]

good job!! thanks

[@rilindpozhegu841]

Great Job!

[@abajarde]

Genius, loved it. Thanks.

[@ExcelGoogleSheets]

:)

[@JohnDeir]

Nice, Thanks. Could you expand on this by creating an automatic reorder script that sends out an email when quantity of specific item reaches a low threshold (like 10 items in inventory)? Or maybe a notification of low inventory item?

[@bikashlalani2866]

Hi, I have already created such a code, checkout this github repository: github.com/vickylalani/Miscellaneous/tree/master

[@sudharsansomani3000]

@@bikashlalani2866 hey can you help me understand how to implement this?

[@bikashlalani2866]

@@sudharsansomani3000 Create a Google sheet with minimum three columns. The three columns will contain product name, quantity and rate and whatever else you would like. Now, create an onEdit function and put the GitHub code in it. Whenever you change a quantity in your Google sheet and if that quantity is below a certain number (for ex: 2 in the code) then an email message will be sent to the "email" provided in the script mentioning low inventory as the subject.

[@lukassurna2427]

Nice tutorial. Just have one question. If you have product with couple Batch numbers? How to do that on inventory tab it will show same item with difference batch number? Thanks

[@zayani360]

thanks a lot for this video it is really helped me out understanding things. I have one question. if I sold 1 piece of item let's say I have 14. in my stock. then after doing the selling how it can update automatically in my stock. also as a sales, I need to make limitations in case the item is out of stock. I hope I made my question clear. waiting for your reply. thanks again.

[@sandeeprkl]

I need a vlookup in side vlookup to match and search 3 criteria of any item, if you have not made this please make it. Thank you very much for this IMS, such a lovely system made available and explained so clearly.