On the database side, we have added more data models to more accurately reflect customers, items, packages, suppliers, etc. We have made some progress on the QR code in terms of what we are going to use and what that QR code will contain. An item mapping utility is going to be created to map codes in the format XXX-XX-XXX to an actual item in the warehouses.
Earlier this month, we volunteered at Trusted World for hurricane Harvey disaster relief. We had a great time contributing to an organization that provides for the victims of the hurricane. By volunteering, we gained some insight into Trusted World’s operations. Although disaster relief can be considered quite a bit outside of normal operations, we saw that maybe we could design something that is capable of being used not only for day to day operations, but also for disaster relief.
We have very basic sketches of the system we designed. Essentially, what we have is a fully customized system that uses smart phone cameras to scan items into inventory. Whereas Trusted World’s current system relies heavily on 3rd party proprietary scanners and inventory tracking system, ours relies on free and open-source software (FOSS), for the most part. The advantage of FOSS is little to no cost for development and a large community of developers that provides documentation and resources. The preliminary design of our system is provided below, along with a photo of us volunteering with Trusted World. A few things are missing from the diagram, but we will continue to add paths and objects as we discover them.