How to locate warehouse shelves and find goods

The cargo map is useful for less materials, which is called cargo location management. Now warehouses are generally managed by computers. Warehouse code: unit 1, warehouse number 2, shelf number 3, material classification 4, material numbers 5 to 7. The easiest way is to use a spreadsheet. Create a simple table, such as number, code, material name, receipt quantity, receipt date, receipt quantity, receipt date, balance quantity, unit price and description. In this way, you can query the spreadsheet to find the balance of the goods and find the goods by coding. Of course, it would be better to write a simple database management program.