Case Study: Enhancing Warehouse Productivity
Size
Over 1,000 employees
Industry
Mining, construction, forestry, power systems
Integrations
API, Data Push, and Reports
Background
The world's largest dealer of Caterpillar (CAT) equipment – serving major industries such as mining, construction, forestry, and power systems across multiple locations – was looking for an efficient warehouse management system with seamless data integration.
Their primary warehouse operations utilized Kardex Vertical Lift Modules (VLMs) and Vertical Buffer Modules (VBMs) managed by the Power Pick software system. It was critical that these records remained perfectly synced with their Infor M3 ERP system. Leveraging ItemPath's API tool was a logical step to integrate these critical systems and support their workforce.
The Challenge: Unable to Effectively Bridge Systems
The customer faced several challenges in optimizing their warehouse management:
- Data Synchronization & Errors: Ensuring real-time, accurate data flow between Infor M3 and Power Pick was crucial but complex. Manual processes or less robust integrations risked data discrepancies and operational delays.
- Power Pick Limitations: While effective for storage, Power Pick was limited in advanced analytics, reporting flexibility, and efficient integration with their existing ERP middleware (Boomi). Tasks like calculating order processing duration or efficiently accessing large history logs were cumbersome and slow.
- Need for Automation: The customer sought to automate processes as much as possible, reducing manual intervention and potential errors, particularly in order handling and data transfer.
- Scalability & Reliability: With multiple warehouses (including VLMs and VBMs managed by separate Power Pick instances) and high transaction volumes (e.g., 10,000+ orders/week), they required a scalable and reliable integration solution with robust error handling and support.
The Solution: ItemPath Integration Suite
The customer partnered with ItemPath leveraging specialized software solutions designed to enhance Power Pick’s capabilities.
- ItemPath API: Provided the core mechanism for seamless, secure, two-way communication between Infor M3 (via Boomi middleware) and Power Pick. A key customization involved adding an initialHandlingUnit parameter to the orders endpoint. This seemingly small change eliminated the need for manual scanning at the start of the process, saving time per order and significantly reducing the risk of mis-assignment at the VLM/VBM.
- ItemPath Data Push: This application actively polled Power Pick for new transactions (picks, puts, inventory changes) and automatically pushed the data back to the ERP in the required format. It included data mapping features and logged all attempts for transparency and traceability.
- Custom Reporting & Dashboard: ItemPath's reporting tools offered a significant upgrade over Power Pick's native capabilities, allowing the customer to:
- Quickly load, filter, and sort large volumes of history records on demand.
- Create custom reports, such as order duration analysis (calculating time between order start and modification).
- Develop dashboard widgets for warehouse overviews and productivity tracking.
- Export data easily to Excel/CSV for further analysis.
- Report on error logs to diagnose issues quickly.
- On-Premise Deployment & Support: ItemPath was deployed on-premise across the customer's infrastructure (4 warehouses across 2 installations), backed by a Service Level Agreement (SLA), including weekend support, ensuring prompt assistance when needed.
The Results: Crucial Insights Provided and Integrated
The ItemPath integration has become fundamental to the customer's warehouse operations across their locations.
Seamless Integration & Accuracy
The API and Data Push apps successfully bridge the gap between the ERP and Power Pick, ensuring data synchronization.
Enhanced Productivity & Automation
Automation reduced manual tasks and potential errors, leading to a significant reduction in the average order cycle time. The Edmonton Location alone processes over 10,000 orders per week, and an average of 40,000 transactions are sent monthly via Data Push across all locations.
Improved Analytics & Visibility
Custom reports and dashboard views provide crucial insights into operations, productivity, and potential bottlenecks. History logs can be generated in seconds, drastically improving diagnostic capabilities.
Rapid Error Detection & Resolution
Detailed logging allows the customer to quickly identify and troubleshoot issues (e.g., mapping errors, network problems, Power Pick timeouts). The system boasts a 99.4% successful transaction rate, with near-instant updates and downtime typically under 2 minutes.
Transaction Success Rate
High-Volume Scalability
Conclusion
By leveraging ItemPath’s powerful API integration and customized reporting, the company successfully transitioned from a reactive, manual system to a proactive fulfillment model. The ability to identify and resolve critical shortages instantly before trucks leave has virtually eliminated costly last-minute freight and event delays, ensuring their complex equipment logistics now support, rather than hinder, their global event operations.
"I had several questions and clarity was very much appreciated. ItemPath was able to support and configure locally, follow instructions, and give timely responses to issues."
Brad J.
Global Application Manager
Explore more ItemPath solutions
Sync inventory records
Use the Variance app to compare stock levels between Power Pick and an external system. Workflows check for discrepancies and catch deviations early.
Customizable reports
Use templates to build specific to your data needs. The Reporting feature captures data progression so you can see your results over time.
Data mapping
To successfully populate Power Pick with data, you must create a mapping. Here are detailed instructions on how to effectively translate and transfer information from your connected service.