Inventory Management System in Google Sheets - 2024 Edition

Подписаться 11 тыс.

Просмотров 14 тыс.

50% 1

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

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 54

@tabathanuttall111 20 дней назад

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.

@practicalsheets 16 дней назад

Thank you so much for the nice comment! Kind Regards

@abdullahquhtani4247 4 месяца назад

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 🙏🏻🌹

@practicalsheets 4 месяца назад

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!

@walidnazmifordigitization5204 4 месяца назад

Brilliant Thanks mate

@practicalsheets 4 месяца назад

Thank you for the comment!

@MirelleLpz 9 дней назад

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

@practicalsheets 8 дней назад

Yeah, it has been a normal issue. I will address it in a future video Thanks for commenting! Kind Regards

@MirelleLpz 4 дня назад

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

@nsvnav 29 дней назад

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

@nsvnav 29 дней назад

Humble reminder

@practicalsheets 29 дней назад

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

@amilapereragtaenergy 4 месяца назад

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

@theoriginalpsychocharlie 3 месяца назад

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

@practicalsheets 2 месяца назад

Excellent! Glad to know it is useful! I´ll write it down for the next video in the series Regards!

@lifeispain3557 4 месяца назад

Sir, waiting for the next video! ❤

@practicalsheets 4 месяца назад

Very soon it will come Thank you!

@BernardAnlageIV 4 месяца назад

Can this inventory be set up for FIFO? Would you do a video to show how?

@tripnivellie8393 8 дней назад

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

@practicalsheets День назад

You are right. I'll fix it for part 2 Kind Regards

@user-qh1yo7ys7s 26 дней назад

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?

@practicalsheets 22 дня назад

Hello! I have a video just for sales, but I'll try to merge them ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ns4F29hmsGA.html Kind Regards

@lifeispain3557 4 месяца назад

Agreed. ❤

@practicalsheets 4 месяца назад

Thank you!

@koolkiwikat 3 месяца назад

love your insights, could you make your mouse pointer larger, this makes it easier to watch on smaller devices

@practicalsheets 2 месяца назад

Thank you for the comment! I'll take into account for future videos Regards!

@juanitamerab73 3 месяца назад

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?

@practicalsheets 2 месяца назад

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

@javadhakimi2455 5 дней назад

خدا خیرت بده 🌹

@practicalsheets День назад

Thank you!

@rukevweasiebelaye3164 3 месяца назад

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

@practicalsheets 2 месяца назад

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!

@rukevweasiebelaye3164 2 месяца назад

@@practicalsheets Thanks for the response but don’t know how to do this Formula SUMIF(Jan)+ SUMIF(Feb)+SUMIF(March)

@practicalsheets 2 месяца назад

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

@zarlsss Месяц назад

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?

@practicalsheets Месяц назад

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

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

@practicalsheets 2 месяца назад

Hi! Do you mean for the video where I do the Inventory with Sheets and Forms? Regards!

@boristeka9515 3 месяца назад

Extremely helpful but i prefer the first version it seems simpler

@practicalsheets 2 месяца назад

Thanks for commenting YOu are right. Here I´m trying some newer formulas but may seem a bit more complex Regards!

@melissawallace6177 2 месяца назад

is there a version of this to download AND do you have a BOM sheet?

@practicalsheets 2 месяца назад

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

@melissawallace6177 2 месяца назад

can i be your beta tester? i have purchased two other spreadsheet and hired two Fiverr "experts" have not gotten what I need. @@practicalsheets

@user-fv4fm9tq9f 3 месяца назад

If a mistake is made in the purchases, how does one de-select the product, or make that entry blank again?

@practicalsheets 2 месяца назад

Just by deleting or removing the row, everything should work Regards!

@taogaming6134 2 месяца назад

explore zapier automations.

@emmanuelpatrick9758 Месяц назад

pls I was unable to download this template

@practicalsheets Месяц назад

Hello! Do you mean in the patreon page? Kind Regards

@emmanuelpatrick9758 Месяц назад

@@practicalsheets yes, I needed a data to practice the analysis

@practicalsheets 22 дня назад

@@emmanuelpatrick9758 I recommend using chat GPT. You could say: create sample data for the following headers Kind Regards

@UpInSmokeHeadshop 11 дней назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iIjSzk-3Zg0.html . if i could implement this on one of the systems you created, it would heavenly. Thank You

@practicalsheets 9 дней назад

I've done one example of using QRs in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-S-RL-Wp38as.html Let me know if it helps Regards!

@UpInSmokeHeadshop 8 дней назад

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

@practicalsheets 5 дней назад

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