Inventory Management System in Google Sheets - 2024 Edition

preview_player
Показать описание
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

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

Any suggestion, question or insights, feel free to comment below
Рекомендации по теме
Комментарии
Автор

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

abdullahquhtani
Автор

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
Автор

Hello and thanks for this useful video.
Suppose I would like to add the column of quantity in my product list.How do I get a formula to minus the quantity from my product list to my sales sheet using reference in A2 in sales sheet to get quantity left in sales sheet.I am using your templates as ref. Your help will be appreciated.

Malindibrasslampshadesandglass
Автор

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?

zarlsss
Автор

pls I was unable to download this template

emmanuelpatrick
Автор

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?

MinseoKo-vn
Автор

Hello thank you so much for your time and effort I have to say I learnt a lot from you, I would be very glad if you could help everyone setup a retailing business for clothes, how a Google sheet of that looks like !!! Thank you once again

manikbhattaraii
Автор

This has helped me so much. Thank you for taking the to put such a detailed video out for us. Wonderful

MsLadyG
Автор

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

tripnivellie
Автор

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?

juanitamerab
Автор

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!

trcedcc
Автор

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

theoriginalpsychocharlie
Автор

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

amilapereragtaenergy
Автор

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

koolkiwikat
Автор

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

AcueductoPlanManzano
Автор

Thank you. I do wish you had done cost.

razorsedge
Автор

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

MirelleLpz
Автор

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

rukevweasiebelaye
Автор

Extremely helpful but i prefer the first version it seems simpler

boristeka
Автор

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

melissawallace