Inventory Management System
I am looking for a system that will allow for individual order inventory tracking. Logging the lots numbers, number of items, or pictures of the inventory being sent out per order.
Some context- I run a chemical warehouse and send pallets of product out 25-30 times a week. We have an ongoing problem with customers coming back and stating that they were missing product when I know they're not. Currently we track inventory via Google Sheets and I go in manually to update each individual order for the number of each product and the coordinating lot numbers. As well, I have a separate phone that contains all the pictures of each customer order with lot numbers and product amount.
I am trying to find a solution that would allow for either barcode scanning or a mobile app that I can scan each product and have one place that I can track inventory and export a report per order if I need to verify an order for a customer.