While inventory tracking can often be seen as a ‘counting’ issue, it should also be seen as an issue of identifying, recording, managing and maintaining accurate data.

You may know how many items you should have but struggle to find them and know if your data is up-to-date.

Your inventory tracking system should be able to identify key events and maintain accurate data.

Create Your Inventory Data Model

Decide what data you want to keep track of.

At its simplest you may want data such as:

Unique item/asset ID

Description of the item/asset

Expected location

Current status

Quantity (if applicable)

Last event

Depending on how your inventory will work, you may want to track individual items (serialized), batches or quantities of interchangeable items.

If you are tracking individual assets then each item may have its own ID.…