When the stock count does not match, miscounting usually gets the blame. In the glass trade the real reason is different: the same product becomes two separate rows. Glass written one way on a quotation and another way on the stock list looks like two items. One runs out while the other still shows a count, and nobody can see the relationship between them.
The first job of a glass stock system is to close that split. Information such as thickness, type and colour lives in separate fields and the visible name is built from those fields. Two records with the same properties get the same name, because the name is not typed by hand. When someone's habits change or a new person starts, the catalogue is unaffected.
Once names are unified the count is unified too: a product gathers on a single line and the question of how many sheets there are has one answer. When an order is entered a selection is made from the list, and what is selected is a record rather than free text. Errors born of spelling differences are closed at entry.
This is also where a ready catalogue of more than seventy thousand records earns its place. The business does not build its list from nothing; it picks the products it uses and takes them into its own stock. The trouble with lists built from scratch is not that they stay incomplete but that they stay inconsistent: the first fifty records follow one logic and the next fifty another.
Offcuts are part of stock as well. Usable pieces from a cut become searchable once they are recorded with their dimensions, and they are tried first on the next order. Glass not written down with its dimensions does not exist in inventory even while it sits on the rack; nobody looks for it and nobody orders relying on it.
As the catalogue grows, search becomes important. Users rarely type the full name; they type a thickness and a colour and pick the rest from the list. When search works the way people behave, the size of the catalogue stops being a burden. Otherwise a long list pushes people towards their own abbreviations and the drift comes straight back.
The same structure keeps working as scale grows. The difference between stock tracking for a workshop and stock tracking for a factory is the number of records; the logic is the same. A warehouse system adds the physical location of the piece on top of that, but the foundation is still single: the same glass is called the same name everywhere.