Inventory Management System in Google Sheets - 2024 Edition
Vložit
- čas přidán 16. 07. 2024
- In this video we´ll start from scratch an Inventory Management System in Google Sheets.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤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:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Thank you again! I just found your video from 2022 yesterday and was having some issues with repeated orders not compiling in the inventory sheet right, but this tutorial WORKED!! Thank you a million times over for doing a whole new updated video with updated formulas.
Thank you so much for the nice comment!
Kind Regards
Excellent. With few comments ☺️.
1-I hope you consider use html input form.
2- I hope you consider add main dashboard with chats as a general summary for all parts ( purchase, sell and inventory items)
Finally, I hope you make a personal budget which almost looks like inventory project soon.
Thank you 🙏🏻🌹
Hello!
1.Yes, I´m doing the html input in a different video series
2. Yes, also, very important to have a good dashboard
I´ll take it into account
Very insightful as always
Regards!
Brilliant
Thanks mate
Thank you for the comment!
Absolutely love your videos!! They have helped me within my job so much!! Could I make a request for the Category/SubCategory you mentioned in this video?
Thank you for all of your help!!
Excellent! Glad to know it is useful! I´ll write it down for the next video in the series
Regards!
Can this inventory be set up for FIFO?
Would you do a video to show how?
Sir, waiting for the next video! ❤
Very soon it will come
Thank you!
@@practicalsheets Very interested in the adjustment sheet video
@@hartlandhillfarm3312 Very soon...for real this time ;)
love your insights, could you make your mouse pointer larger, this makes it easier to watch on smaller devices
Thank you for the comment!
I'll take into account for future videos
Regards!
Assalamualaikum brother, I have been using your techniques for quite a few months and it's amazing helping me setup my administration and monitoring I need some help in a formula for inward and outward can you guide me or spare 5-10 min to help me out I'll be thankful to you and will appreciate your kind guidance
Humble reminder
Hello!
Thanks for the words
Please write me an email to practical.sheets@gmail.com
You're welcome to include a video
If you prefer a quicker answer I invite you to the patreon page
Kind Regards
Agreed. ❤
Thank you!
Thanks a bunch. This has been very helpful. Just wanted to know how to correct the dates entry, because from the video, incase I enter a purchase date that is after a sales date, there's no check. What formula can help check that?
Interesting
It is not easy, because even if you have a previous purchase, how do you know if you already have product in inventory
I think we need to employ a mix of formulas and GAS
Im preparing a video in something similar
Kind Regards
I found your video very useful, thank you! :D
Now I have a very nice inventory system and my only problem is to add the previous items I had whithout buying them
Yeah, it has been a normal issue. I will address it in a future video
Thanks for commenting!
Kind Regards
@@practicalsheets I fix it adding 2 more sheets, one for entres and the other for losses sinnce my product has expiration date, now I´ll try to make a counttdown for that. Keep going :D
@@MirelleLpz Excellent!
Hello. I really love your videos. I've been trying to find videos about inventory management with google sheets, and your video helped me a lot!
One question. Will you make another video on tracking how much sales that you did in terms of money? Like the total sales price after selling certain amount of units. it would be nice to have another formula to multiply the number of units sold, and the price of the product, and make it automatically show how much money I have made.
Do I need to add another column on the sales to add the formula, and multiply the units with the product price?
Hello!
I have a video just for sales, but I'll try to merge them
czcams.com/video/ns4F29hmsGA/video.html
Kind Regards
this is wonderful.. thank you so much.. if i add a new items to the "product" it's not showing on the "Inventory" sheet, Can you please help me to fix it.. thanks..
Could you show me the formula you have for the inventory?
Is it UNIQUE?
Kind Regards
Hello!
I'm wondering how I can clean the Input/Output sheets up so that after populating my Inventory sheet I'm able to start with an empty page. I have about 500 items so entering each individually will add a lot of clutter to my Input. Is there a way to populate my Inventory without adding each items count manually in Inputs?
Interesting!
Maybe we could create a fake input (via code) that summarizes the stock in a given date
Ill take note for a future video
Regards!!
This is beautiful and the explanation is explicit
My question
How can the sheet be created monthly using different sheet for every month to track the inventory ?
Thanks in advance
Thx for the words! In this case, althought I wouldn´t recommend it, if that is the only way, you would have to create a bigger formula for inputs and outputs and always be checking that it has all the Sheets
Something like
SUMIF(Jan)+SUMIF(Feb)+SUMIF(Mar)
Regards!
@@practicalsheets
Thanks for the response but don’t know how to do this Formula SUMIF(Jan)+ SUMIF(Feb)+SUMIF(March)
@@rukevweasiebelaye3164 Something like this:
In cell C" of "Inventory", you would change the formula to this
=SUMIF(Jan!A:A,A2,Jan!D:D)+SUMIF(Feb!A:A,A2,Feb!D:D)+SUMIF(Mar!A:A,A2,Mar!D:D)...etc
Kind Regards
Thanx for this video sir. Now i easily monitor my sales and inventory, but my problem is if no available in purchase. it will negative in inventory
You are right. I'll fix it for part 2
Kind Regards
Thank you sir , hoping for the part 2
I am really hoping that you will include dropping an item for the Google form when there is no inventory left to sell. Thank you!
Hi!
Do you mean for the video where I do the Inventory with Sheets and Forms?
Regards!
If a mistake is made in the purchases, how does one de-select the product, or make that entry blank again?
Just by deleting or removing the row, everything should work
Regards!
explore zapier automations.
is there a version of this to download AND do you have a BOM sheet?
Hi Melissa
Yes, you can downolad it in the patreon page
Haven´t created a BOM, but I will work on a video for that
Kind Regards
can i be your beta tester? i have purchased two other spreadsheet and hired two Fiverr "experts" have not gotten what I need. @@practicalsheets
Extremely helpful but i prefer the first version it seems simpler
Thanks for commenting
YOu are right. Here I´m trying some newer formulas but may seem a bit more complex
Regards!
خدا خیرت بده 🌹
Thank you!
pls I was unable to download this template
Hello!
Do you mean in the patreon page?
Kind Regards
@@practicalsheets yes, I needed a data to practice the analysis
@@emmanuelpatrick9758 I recommend using chat GPT. You could say: create sample data for the following headers
Kind Regards
i watched alot of your videos, they are great, and i much appreciate them, very helpful. but i was wondering if you could teach us to do something like this czcams.com/video/iIjSzk-3Zg0/video.html . if i could implement this on one of the systems you created, it would heavenly. Thank You
I've done one example of using QRs in this video
czcams.com/video/S-RL-Wp38as/video.html
Let me know if it helps
Regards!
@@practicalsheets thank you for prompt response. But generating QR code is not what i need to learn. But no worries, i appreciate your help sir.
@@UpInSmokeHeadshop Hi! Sorry I didn't watch the full video. Now I understand. In reality you don't need to have a popup, if you stand in the cell, and scan, the code should appear. Do you think it is best with a button as in the video?
Kind Regards
@@UpInSmokeHeadshop Now I understand. Sorry.. You want to scan a code with an external device
In theory if you are in Sheets in a cell, and use the device, the number will write itself in the cell
Kind Regards