Create Inventory Management System in Google Sheet | Complete Process
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- Hello Friends,
In this video, we have explained how to create an Inventory Management System in Google sheet. Below are the features of this template:
Product Search: You can search any product using Product ID and you can see the Available Stocks, Location within Store, Re-order level and Re-order required or not.
Inventory Summary: In this sheet tab, we have displayed the summary of all products as on today. Here we are showing, Opening Balance, In, Out, Closing Balance, Re-order level and Re-order Required or not.
Input Sheet: In this worksheet, User needs to enter the transaction data for In and out Qty for the product.
Product Master: In this worksheet, user needs to maintain the product details including the location of the product within store and re-order level.
Below is the google sheet link for Inventory Management System:
neotechnavigat...
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
• Project Plan (Gantt Ch...
Create Attendance Template in Google Sheet | Complete Process
• Create Attendance Temp...
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
• Best Google Sheet To-D...
How to create dynamic Calendar in Google Sheet
• How to create dynamic ...
Conditional formatting in Google Sheet Chart | Step by Step tutorial
• Conditional formatting...
Hi sir, how can I modify to add make and size in this sheet, and when I type product ID, size, and make want to show in stock, Vlaue can do that?
why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance
13:13 - everything is fine while I am trying to add a new entry and check, in the summery sheet its not reflecting changes, please let us know what went wrong?
In and out of stock is not reflecting
sir please suggest how to add unit in this sheet
This is very helpful for people like me who really wants to understand and know how to make such like this in google sheets. I am vwry much new at this. I would like to ask for more help if how to add the cost and total for each item and how to sort this or search by location? Thank you very much for giving us the opportunity to learn from you. 🙏
Thanks. Will add the more features in the next version
sir question, what if i have only 1 warehouse but i have 3 store / location to transfer item everyday. how i will compute the total qty transfer every month in 3 different location
Need Download link this format. For use
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
It's a wonderful concept; however, it's restricted to viewing transactions only within the specified day requested. How can you modify and view transactions within a range of dates? ie: (week, biweekly, monthly)?
Thank you this was wonderful, could you show how to rank best customers or products, thank you
welldone..impressive..now create payment ledger sheet for retailers.....
Sure will create
For some reason In & Out is not working for me
Same
How to fix this problem..?
In my project an item is located in many places.
So, what formulas can be used in "19:32" a product search sheet?
It is simple and has all important things for warehouse operation
Thanks for your valuable feedback
THIS FORMULA IS NOT WORKING I MEAN I CANT SEE Any number insed the OUT CELL PLEASE HELP ME (=SUMIFS('Input sheet '!$E:$E,'Input sheet '!E:E,"Out",'Input sheet '!$B:$B,$A6,'Input sheet '!$A:$A,$B$3)
Same here after putting formula 0 opening balance
Give a video on whether automatic salary pay slip can be done through Google Sheet
Sure. will create soon.
how to record ledger of daily in and out of an item
Will create a video on this soon
hi, how to do product creation for same product with different sizes?
Thank you for for this wonderful video. Please after entering the formula for the 'Opening Balance' 11:24 , it keeps showing 0. I have checked and rechecked the formula and nothing seems to be wrong, can you help me please? Your response is highly appreciated
Have you solve this error?
Hello, I'm having problem with opening balance it become zero instead of 100 i can't see which formula is not okay.
Same here bro.
Have you solve this error??
just use the link in description, im trying and fed-up and finding easy way😂
@@nuramalianadia872 I have resolved it.
@@nuramalianadia872 I have also create Google sheets like that but in a little nice way
opening balace showing zero how to fix that error sir,
Im having the same problem.
Hello sir kya aap es sheets ka formet de sakte hai . jisse mai acchi trah se sheekh sakoo .mujhe ye sheet bahut acchi lagi hai
We have added the link in the video's description box.
This is very good, thank you!
Most welcome
Can we create this in ms excel
Please watch the below video
th-cam.com/video/6kFmnt4dab0/w-d-xo.html
product master data is not getting update, how to link it with input sheet
Nice video! But why not include the link to the already made sheet for ease of following as you explain ?
We have added the link in the video's description box.
awesome@@NeotechNavigators . I would like to add a barcode line between the Product ID and Product name, so that the Product ID when entered will also automatically show the relative Barcode number, and I am getting an ERROR message. What do you advice?
Me to @NeotechNavigators same problem here
thanks so much this is so good!
Most welcome
Need Download link
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
Sir, you are fabulous it will help me a lot to do my work so easily.
Bhut khoob sir maja aa gya hindi mein bhi banya karo sir video ❤
Thanks
sir footwear ka liya bhi banao
sure. will create soon
I could not find the link to the demo Google Sheet file?
can i ask for a copy of this file?
File link is in the videos description box
Very nice explanation
Thanks
How to include Image. Please Help
THANKS... I AM GOING TO USE THIS
Great explanation....!!! Thanks for sharing
Most welcome
@@NeotechNavigators I'm getting 0 value in opening balance instead of 100
How can I solve it? There is no any mistake in formula
Can we have traceability by serial number and lot number
How I can contact with you?
Yes we can, I will try to in next version
Please let me know
Jb hum edit krte h to Request edit Access kehta h
Sir jo ap ne sheet ka link share kia h kia hum os ko edit nhe kr sakte kia .
i want to add a return section can you guide me how i add this i try butt not get success.
Will add in next version
How I contact you?
HOW CAN DO IN CYCLE FOR MONTH TO MONTH
Yes we can
same problem...but how can i do?
Thank you for this, I created a new Inventory Management using Google Sheet based on yours and have to modify a little bit to account for Cost per Item and FIFO which I needed for my accounting software.
Can you help me on how to add the cost and total of each item and to sort by location?