How to Track Inventory and Reordering in Airtable
17.1 هزار بار بازدید -
5 سال پیش
-
Tracking inventory is a vital
Tracking inventory is a vital part of so many businesses. Inventory is a tricky thing to manage - having too much is an inefficient use of capital, and having too little produces delays and lost opportunities. So how do you get that sweet spot and know how much inventory to keep on hand? How do you know when it's time to reorder?
Sure there are tons of expensive inventory solutions out there... but if you're looking for a simple way to organize that information, Airtable has you covered.
In this video I walk through the steps of organizing Inventory. We build four tables, Suppliers, Inventory, Stocking, and Usage. Stocking and Usage are used to record when inventory is added or subtracted from the supply. Then we can run a slew of calculations on the Inventory level in order to provide data suggesting when a reorder is in need.
For access to this template check out the read-only version here that you can copy and use for your own purposes. Happy inventory tracking!
Access the template from our blog:
https://www.garethpronovost.com/blog/...
_________________________________________
Learn more at these links: 🔗 👇
Join us for our next live training!
https://www.garethpronovost.com/webin...
Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...
Getting Stuck? See how we can help!
https://garethpronovost.com
Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...
_________________________________________
Table of Contents: 📖 👇
00:00 - What this video covers
01:18 - Explaining the Database Set-Up
01:48 - Outlining the 'Supplier' Dataset
02:52 - Outlining the 'Stocking' Dataset
04:21 - Outlining the 'Usage' Dataset
04:56 - Outlining the 'Inventory' Dataset
08:30 - Recording an Example in the Database
09:19 - Creating a 'Reorder' Status
_________________________________________
Software Resources (may contain affiliate links): 💻 👇
Airtable - https://airtable.com/invite/r/v0eI3ASY
_________________________________________
#GAPConsulting #GarethPronovost #Airtable
Sure there are tons of expensive inventory solutions out there... but if you're looking for a simple way to organize that information, Airtable has you covered.
In this video I walk through the steps of organizing Inventory. We build four tables, Suppliers, Inventory, Stocking, and Usage. Stocking and Usage are used to record when inventory is added or subtracted from the supply. Then we can run a slew of calculations on the Inventory level in order to provide data suggesting when a reorder is in need.
For access to this template check out the read-only version here that you can copy and use for your own purposes. Happy inventory tracking!
Access the template from our blog:
https://www.garethpronovost.com/blog/...
_________________________________________
Learn more at these links: 🔗 👇
Join us for our next live training!
https://www.garethpronovost.com/webin...
Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...
Getting Stuck? See how we can help!
https://garethpronovost.com
Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...
_________________________________________
Table of Contents: 📖 👇
00:00 - What this video covers
01:18 - Explaining the Database Set-Up
01:48 - Outlining the 'Supplier' Dataset
02:52 - Outlining the 'Stocking' Dataset
04:21 - Outlining the 'Usage' Dataset
04:56 - Outlining the 'Inventory' Dataset
08:30 - Recording an Example in the Database
09:19 - Creating a 'Reorder' Status
_________________________________________
Software Resources (may contain affiliate links): 💻 👇
Airtable - https://airtable.com/invite/r/v0eI3ASY
_________________________________________
#GAPConsulting #GarethPronovost #Airtable
5 سال پیش
در تاریخ 1398/12/26 منتشر شده
است.
17,177
بـار بازدید شده