Stock room inventory

[StormTrooper59]

Hello,

 

Does anyone use a system whereby you have an inventory of what's in your stock room? I work in a MAT with multiple sites so we have a few different store rooms, it's hard to keep track with what is in stock at each school. I was thinking along the lines of a QR code sticker that we can scan on a mobile phone to "Check out" the item. I guess it would be similar to an asset management system except we wouldn't ordinarily put small items on it so I think some other type of inventory system would be better suited to our needs. Preferably something that doesn't cost a stupid amount!

 

I was thinking of a Google Sheets spreadsheet but it would be time consuming to manually make a change every time we take an item out.

 

Thanks

[jthompson]

On the Google front, have a look at using AppSheet. It's a really nice make-your-own-app thing, which I believe will also support QR scanning on mobile. Super flexible and good fun to play about with. We're using it to good effect to keep track of little ad-hoc temporary loans of chargers, dongles, extension leads, etc.

 

Our asset management system is GLPI, which includes consumables management. We use that to keep track of replacement projector lamps, etc.

[dhicks]

I was thinking of a Google Sheets spreadsheet but it would be time consuming to manually make a change every time we take an item out.

 

EduGeek's webinar from Tuesday from Google about their various handy development tools might be worth a quick skim:

 

EduGeek.net - EduGeek January Webinars - Recordings

[localzuk]

We use Snipe-IT. Can add consumables, components etc to that. Just have to remember to keep it up to date!