Parts tracking is an unsolved problem in general. Everyone in manufacturing is winging it in Excel or runs into enough chaos-complexity that violates the bounds of whatever software they’re using (homegrown or bought) that they port a part of the problem to Excel.
This is a billion dollar problem.