Case Study Information
Summary
A custom portal for a Colorado based fulfillment company that focuses on product visibility and sustainability. The client wanted a way to effectively communicate with their clients and ensure products were delivered in a timely manner, while allowing them and their clients to have an effective way to communicate on items such as inventory and shipment tracking.
The Challenge
Our client could not find an efficient way to both communicate with their clients and also give clear visibility of products. Frequently in this industry items are recalled for various reasons. It can be a messy process to know which lots these came from and who ordered them. Our clients goal was to add significant traceability to these products, while also streamlining their internal processes for quicker turn around times on shipping.
The Solution
Pell Software designed and developed a robust system that allowed effective client communication, product organization and streamlined the way they process their orders. Our solution was built on a modern, highly scalable Microsoft stack, including C# .NET Core and Microsoft Azure.
The client portal tracked communication, product inventory and incoming and outgoing orders. In addition to that, there were metrics added to show where their products were going and the cost associated with those orders.
Finally for the warehouse management system we created a custom barcode creation system that allowed the workers to efficiently scan products, automatically tracking stats such as location, best by date and inventory. This allowed an accurate system to track all products from intake to outtake.
The Outcome
By implementing this software our client was able to successfully communicate with their clients as well as efficiently manage their warehouse. While there are products on the market that do this, they didn’t do it EXACTLY how they wanted it done. The glaring problem was visibility and traceability of products. By creating the system we did, we solved those problems by efficiently tracking extra data points on each product. By doing this, it also allowed our client to improve on their process and quickly find this data.
Date
June, 2024 – July, 2025
We started work on Phase 1 of the application in June 2024 and finished in July, 2025.
Major Features
- Custom Barcode Creation: Developed a system that allowed our client to create custom QR barcodes that would be used to track inventory. Each QR code held data such as Product Name, Inventory Levels, Location in Warehouse and more.
- Dashboard / Order, Shipment & Inventory Information: A clean and concise dashboard that showed metrics such as a heat map of where products were going, average label cost, and inventory information.
- Reporting: easy to run reports to show best by dates, current inventory and what carriers are being used.
- Purchase Order Submission: Clients could easily submit POs to our Client that would indicate either a shipment coming in or leaving the warehouse.
- API Integrations: Development of multiple integrations with software such as Airtable, UPS, USPS and other carriers. These saved our clients countless hours of double data entry and would find the best available prices.
- Intake of Products: The warehouse would get products in daily. We developed a seamless process for easily intaking orders and getting them organized in the warehouse.
- Inventory Tracking: Accurate inventory numbers are crucial in this business. By developing a connected system we were able to track inventory with acute accuracy providing visibility to their clients without having to call or email the warehouse.
- Location Tracking: A warehouse is a large area with 1,000s of products. We developed a system that allowed the warehouse workers to easily and efficiently find and pack orders via scanning barcodes.
- Outbound Management: Moving products from warehouse to warehouse is a crucial part of this business. Clients frequently will need to move large quantities of products for efficient product management. Our system allowed the clients to easily request products to be moved without having to call or email the warehouse.
Technologies Used & Keywords
Custom Software Development, Warehouse Management System (WMS), Client Portal Development, B2B Web Application, Inventory Management Software, Order Management System (OMS), Logistics Software, Fulfillment Services, Third-Party Logistics (3PL), Supply Chain Management, E-commerce Fulfillment, Warehouse Operations, Product Distribution, Product Fulfillment, Barcode Generation, QR Code Scanning, Inventory Tracking, Shipment Tracking, API Integration, Purchase Order Management, Custom Reporting, Business Intelligence Dashboard, Product Traceability, Lot Tracking, Real-time Inventory, C# .NET, .NET Core, Microsoft Azure, Custom API Development, Microsoft Stack, UPS API Integration, USPS API Integration, Streamline warehouse processes, Improve product visibility, Software for fulfillment centers, Custom WMS for 3PL, Automate shipping and logistics, Reduce double data entry, Real-time inventory visibility for clients
Client
Client Industry
Product Fulfillment
Client Description
We are a modern fulfillment and logistics agency built on the foundation of customer service and proprietary technology. Our custom portal gives you real-time inventory visibility, lot-level traceability, and instant reporting so you always know where your products are, from warehouse to doorstep.
