Google Sheets - Inventory Management System Template 

Videos Worth to Check Out: Clock In, Clock Out System - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oa-CuxbTJ9g.html Budget Template Google Sheets - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QGVcPkZ6kk8.html Calendar Template Google Sheets - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qvig5BsdBds.html

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!

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.

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.

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! 👍

Instead of looking for the needle in the haystack (on RU-vid) 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.

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

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

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!

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

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

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!!!!!

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

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.

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.

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

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

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

The first channel i feel like donating to.

Love the final product! Thank you

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

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

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

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

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

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

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.

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

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?

Thank you so much for this helpful tutorial.

Great tutorial! Helped me a lot! Thanks!

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

Very well explained, thank you!

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

Awesome video. You make it look simple.

Very simple explanation. Thanks (Obrigado)

This is so helpful, thank you so much!

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

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

I am sincerely impressed!!!!

Great Tutorial, very descriptive

This was super amazing! I learned a lot!

I'm in love with this video

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 !!

Thank you for the template link. God bless you!

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

u make it really clear , thank you:)

So thankful for your help 😊

This is extremely helpful. Thank you so so much

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 !

Great video! Thank you

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

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

Very useful video, and easy to understand. Thanks

Thank you so much for the awesome tutorial!!

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?

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

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

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

Thanks for the knowledge.

That was extremely helpful and well-explained. Thank you

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

This is really Great, Thanks a lot man.

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!

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

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

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 :)

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

thanks for ur sharing. all the best

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

That was awesome thank you 🙂

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

thanks for teaching us!!

“Arrayformula” will help a lot, no need for dragging the formula. 😊

It helps me a lot.

very nice and simple, thanks

really thank you

Great Job!

Thank you so much sir! Good job 👍

Thank You Soo Much Man !

Genius, loved it. Thanks.

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

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.

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 ?

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.

This is a good video tutorial. Thank you!

Very helpful. Just subscribed.

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.

Thank you this is very educational. But I have a question. How do you make an arrayformula with if statement. I've been trying to make it work but to no avail.

amazing, thanks

good job!! thanks

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.

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

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

I learned a lot. Wow!

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

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?)

Great help thank you! Is there any way to make the color from 'sheet 1' to then match the drop down selection?? TIA!

Hi, thanks a lot for the content, How can I auto-update the price when selling the product? I want the price to change automatically as it does on the inventory sheet when entering a new price in the receiving sheet without affecting the older prices.

thx great video