Hi Dona -
Airtable is a powerhouse so I defiantly believe you can achieve that goal!
There's a couple of ways you could set up a tracking system for your inventory
do you currently have your sales table linked to your products ? Is your re-order threshold a percentage?
Below I have a few samples to provide you with a potential solution :

- I have a field to 'count' the total sold and simple sum formula to track in stock - if your reorder threshold is based off of % inventory available you could implement an automation that is triggered if any item dips below a certain level.

You could also turn your first field in the product line into a conditional formula to flag the inventory that is low in stock, so that its visible as you input new sales :


Let me know if this helps or if I'm missing an important piece of the puzzle!
Katelyn
info@consultasolutionist.com