Warehouse Inventory Management
Many companies have warehouse inventory data in SQL databases. Keeping the data up-to-date might work fine, but it’s still a big job to dig up relevant product information – especially when you’re in the warehouse and not on your computer. Furthermore, there’s additional content like PDF manuals that you’d like to be able to access easily.
Composer lets us create an app that allows warehouse workers to use their mobile phones to scan a product’s barcode, which instantly brings up that product’s data record from the SQL database, including attached files. (Of course, you could import the product data from a CSV file, fetch it from an API or even input it manually for each product.)
Example App Features
- Scan barcode with mobile app to bring up product data
- Get up-to-date product data from an SQL database
- Attach PDF manuals and other files to each product
- Let warehouse workers add comments to individual products
- If the inventory data in the database doesn’t match what’s on the self, make corrections from the app
We connect our Composer to our SQL database, which automatically creates an app that lets us browse and manage product data (if desired, we can make the data read-only). We then add a QR reader feature to our app and point towards our newly-created “Products” resource.
Next, we need to provide an unique identifier for each product. This allows our Composer app to know which product data record to bring up when the barcode is scanned.
To identify individual products, we’ll use the unique Stock-Keeping Unit (SKU) numbers that are already included for each product in the database, as well as printed on barcodes on each product.
In Composer, we select the SKU field as the identifier for our QR reader feature. We’ll also add the Comments and Files features for each product, which allows us to add comments and attach PDF manuals to each individual product.
Now, when we scan a product’s barcode with our Composer app, we get a record that shows the product information from the database, as well as files and comments related to the product. The same data is also available in the web app, which we can use to upload the PDF manuals for each product.
Since the database connection is two-way, we can e.g. quickly see if the database inventory count doesn’t match what’s on the shelf and adjust it on the fly.
Other examples for this case
Repair History and Service Ordering App for Rocla
Rocla (a subsidiary of Mitsubishi), a global manufacturer of forklifts
For each forklift sold and delivered to a client by Rocla, there exists a lot of relevant data: warranty dates, contact phone numbers, user manuals, repair orders, lists of past repairs done, and more. However, the data was spread out to over different systems, and accessing it in the context of the physical forklift was not as fluent and efficient as it could be.
This meant huge losses in efficiency and even actual money: with customer satisfaction foremost in mind, Rocla ended up performing maintenance for free when they could’ve charged for it. This was a consequence of the problems that arose when working to combine all the relevant data from the various systems.
Using Composer, AppGyver created a mobile app for Rocla that allowed the relevant data for every forklift to be easily accessed on-the-go. Each forklift will be equipped with a heavy-duty QR code sticker, suitable for warehouse conditions. When the QR code is scanned with Rocla’s app, the data record for that particular forklift is automatically pulled up.
The data contains basic information like forklift identifier numbers, models, current warehouse location and customer contact information. Additionally, each forklift record includes PDF user manuals, a list of past repairs (brought in via an API from an existing external system) and outstanding and completed repair orders.
Finally, a web app interface is also available for admins to locate forklifts by customer, identifier and any other properties.
Forklift data is now readily accessible, allowing Rocla’s employees to quickly check e.g. warranty validity. Customers can also easily reference the attached user manuals, without having to store physical paper copies in each forklift.
Customers can now create repair orders for broken forklifts directly from the app, and even attach photos to better show the damages. When a new repair order is created, an email is automatically sent to the maintenance engineer responsible for that customer’s forklifts. Since everything is available from the app, there’s no need to go back to the computer to order repairs.
The forklift’s repair history then enables Rocla’s maintenance engineers to immediately see how the particular forklift has been serviced in the past, and plan repairs accordingly.
“AppGyver has enabled us to truly free our business data from the depths of legacy systems. Both our employees and customers can now access relevant information in the field with unsurpassed speed. This greatly increases our ability to communicate and create value with our customers. With Composer, we can design the app around the business process, not the other way around. AppGyver is a fantastic partner to work with, and we can't wait to create more apps with Composer.”