Google Sheets - Inventory Management System Template

[@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

[@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]

👍

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

[@RifatKarim-b5f]

You are awesome, you have no idea what you have for me to organize my startup business. I looked everywhere to get my solutions and I think you are the only one who made it simple enough and went through all the scenarios perfectly. Thank you so much!!!

[@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]

:)

[@HaroonTahir]

The first channel i feel like donating to.

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

[@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.

[@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.

[@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]

:)

[@rodolfoperez325]

Pretty cool! I was designing an inventory for a book database but I had several doubts and some misconceptions about an effective flow of the data. This was very clarifying, thank you. I loved the array formula method.

[@lcoonfare164280]

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

[@ExcelGoogleSheets]

Great to hear!

[@KittyKam88]

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

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

[@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

[@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]

:)

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

[@aashitgarodia]

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

[@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

[@meganhanson9402]

Love the final product! Thank you

[@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?

[@GreatSeaReef]

Great tutorial. Can you crate tut on a simple invoice that updates the stock inventory?

[@melvinbertillo]

Thank you for the template link. God bless you!

[@emilioojeda3129]

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

[@ExcelGoogleSheets]

Fantastic!

[@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 ?

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

[@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.

[@brilliantpy]

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

[@ExcelGoogleSheets]

😀

[@soniahernandez4168]

After watching many videos this is the ONLY one that is clear. Do you have a video on how to add a picture to each item

[@lahtermanaxel2581]

Thanks for the tutorial! It helped me a great deal. I have got a specific problem that I can't solve with the information in the video. When I buy products, they have a limit date for consumption and a series number I need to keep track of. Hence in the receive sheet, I added a limit date column and a series number column. However when i apply the formula in the sales sheet to be able to display the limit date and series number, I always end up with the same limit date and same series number for the selected SKU. To explain in more details, the Vlookup will automatically select the first limit date and the first series number that appears in the receive sheet for the selected SKU even if the SKU was received multiple times with a different limit date and series number each time. I am struggling to understand how to make it so that the limit date and series number can be different so I can keep track of them on the sales sheet. I hope that makes sense and that you will read this comment!

[@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

[@ajaydulani5496]

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

[@xSyberprox]

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

[@kerenbanget1]

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

[@kiskis4786]

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

[@freeshybreeze]

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

[@inicahyaaa]

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

[@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.

[@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.

[@mohdfit394]

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

[@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?

[@lawks56]

Awesome video. You make it look simple.

[@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?

[@ericapura4851]

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

[@daniellapcosta]

Great video! Thank you

[@steverichter6135]

Thank you for this! Does anyone have advice on how to setup kit sales? Meaning I sell a kit with several of my ‘items’ so instead of adding each piece of the kit sold in my sales tab, I’d like to select ‘Kit’ on my sales sheet and each item in the kit are automatically reduced in the inventory sheet. Possible?

[@ExcelGoogleSheets]

Probably not with formulas, but could be done with scripts.

[@inocentmakuwaza4656]

Thank you for the informative video. Do you have anything one can use for Profit and Loss?.

[@aureliasurja7449]

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

[@ExcelGoogleSheets]

👍

[@CallUsTemily]

So thankful for your help 😊

[@danielleamato2993]

I'm in love with this video

[@learningcenterHD]

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

[@ABD56836]

how to delete orders in sales sheets, it says " The data you entered in cell A2 violates the data validation rules set on this cell." kindly tell me how to resolve this issue, thanks for this video by the way.. an honest buttering compliment 😢

[@Woodchuckinthesouth]

I like the information in this video. You are clear and concise with your instruction. Thank you. Thinking about the inventory check. would it be best to make a google form with inventory items and the count (on the shelves or in the warehouse) and link it to the sheet... This will auto include a timestamp for when the inventory check was completed (and how far the check got) as opposed to the date picker... I wonder if that is better... or maybe just different. I don't know... Again, thank you!

[@ExcelGoogleSheets]

Why not. You could do the same for inventory received and sold.

[@Woodchuckinthesouth]

@@ExcelGoogleSheets I really love the interconnectedness of most of Google's things.

[@CluelessWarren]

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

[@damianng1237]

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

[@ExcelGoogleSheets]

Thanks for watching!

[@Quodex]

Great 👍 sir thank you am use your format Big thanks you sir small question first new product sales entry not showing last report

[@christianjohnmacaraeg4652]

I hope you can make video tutorial of inventory for food business, like for example for a burger business, how will automatically deduct the inventory of bun, patty, wrapper etc.

[@esmeraldalunalongoria7067]

Glad you made this video I will try to make and Inventory sheet for business. Question can you make a video with excel?

[@ExcelGoogleSheets]

I'll try to make one for Excel.

[@ouldsaidmohamednadhir1841]

Bro you killed it !

[@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.

[@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.

[@luckylukman8977]

it's very helpful ,thanks . maybe u can share how to use 2 appscript for input 1 spreadsheet like inbound Inventorry and outbound inventory

[@israelsanchez9371]

Hi. I am new working on spread sheets. I thinks it’s amazing, specially for inventory management. I would like to know the formulas, functions or the coding in general. Where do I learn all this things? Is there a course or something?

[@wendyho6126]

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

[@nicoleivie]

I am sincerely impressed!!!!

[@joshuacaylor881]

That was extremely helpful and well-explained. Thank you

[@ExcelGoogleSheets]

👍

[@Mrdealornodeal618]

This is a good video tutorial. Thank you!

[@ExcelGoogleSheets]

:)

[@3rdaug]

Great Tutorial, very descriptive

[@xGSTQ]

Liked how you got the current cost on the inventory sheet, not seen row & max & index used like that before, cheers

[@ExcelGoogleSheets]

Cheers!

[@xGSTQ]

@@ExcelGoogleSheets I was going to ask what and why do you use the multiplication *ROW( on the row function. I've seen it used a few times in functions but never understood why. (I should just Google it 😄)

[@ExcelGoogleSheets]

@@xGSTQ kzbin.info/www/bejne/nYqal4mDfLVqes0

[@xGSTQ]

@@ExcelGoogleSheets Brilliant, your a star. Thanks

[@Viiskz]

How do I make it so that changing the price of the item in my "items" sheet (in the case the price goes up) doesnt affect the previously logged entries in "received", only the future ones? A way around it would be to make new product entry in the drop down menu, but then i have two of the same product.

[@OliverCarrington]

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

[@ExcelGoogleSheets]

Cool!

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

[@najeebsharifi2713]

Have you done a video on e.g manufacturing where you buy raw material, make goods and sell. pricing per piece of goods, cost, earnings etc? Thanks

[@mikehh8020]

This is good but it doesn't take into consideration different pack quantities of the same product. 12 or 24 packs of soda for example. Different pack sizes require a different SKU if the pack size is to be included in the items table, but when the packs are broken down for individual sale, they result in the same product.

[@jettgonzalessubaba2053]

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

[@josefmarzano3914]

Very simple explanation. Thanks (Obrigado)

[@bijanbaniasadi6559]

Thanks a lot , is there any idea for adding qr code also to track it online just by using operation cellphone camera !

[@KwanX1]

Very well explained, thank you!

[@jiannivega2209]

This is extremely helpful. Thank you so so much

[@abelardotalavera9461]

Hi, this is very helpful. thank you very much. but I have an additional question, how if I have a Freight cost, how can I incorporate that?

[@inventoryLuthrad]

thank you for this tutorial, lets assume this tutorial stands for the year 2023, pls how do I continue for 2024?

[@bakso1]

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

[@th3mom3ntum]

Great tutorial! Helped me a lot! Thanks!

[@emmanueloffei9015]

Thank you very much. Please how do you calculate the average cost per unit at the closing stock side

[@SherazAhmed-fg2cy]

very nice and simple, thanks

[@bernicephuah9599]

Thank you so much for this helpful tutorial.

[@adrianwhiteheadgolf]

Would it be possible to add a daily sales sheet that can automatically effect the stock totals as and when the items are sold?

[@febriandee]

thanks for ur sharing. all the best

[@chessandchips7016]

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

[@SaadKhan-tk3dq]

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

[@kennjt5015]

Very helpful. Just subscribed.

[@ExcelGoogleSheets]

Thanks for the sub!

[@mike23mtz]

Very useful video, and easy to understand. Thanks

[@m.a.rahman-rahim7092]

It helps me a lot.

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

[@mrnasrinasir]

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

[@laxsicanmahesan4125]

awsome video, i need some help, if i have many product in single order code, how can i input it ?? eg, cc6 include coco cola 4L-2 and 2L-2

[@robertollovera]

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

[@ExcelGoogleSheets]

Thanks for watching!

[@JennySimon206]

I'm inventorying my stuff because I'm moving. I already have a bunch of boxes packed and numbered. I want to list all the contents in each box. How do I do that? I wanted to be able to add a row or column when I find a box with whatever number but it would shift all the cells above or to the right. How do u keep all the cells in a row or column from moving? What's the best way to do this u think?

[@romaknafel4116]

Thanks a alot buddy! how could i add items sku and description with automation? not by manually