eProvenance Case Study

eProvenance
Case Study

Costa Rica Software Services began working with eProvenance in 2021 to improve software systems, increase security, integrate 3rd party APIs, and custom build core functions for their proprietary software platform. Read more about how we helped eProvenance modernize their systems to create value for their customers.

The Challenge: Legacy Systems

eProvenance’s legacy systems codebase was built primarily in Perl on top of an outdated MySQL database. The Online Management System (OMS) didn’t meet internal stakeholder needs or customer expectations. Key features such as Fedex tracking were nonfunctional. Important internal tools such as email were unreliable and difficult to use.

Solutions: Integrating Systems

eProvenance tasked CRSS Developers with integrating online monitoring systems for tracking wine shipments, including data collected from sensors for geolocation, temperature, humidity and other data. In addition, the team created and integrated an Android application for mobile devices. Keeping eProvenance’s legacy system in place was important, while adding the ability for direct to consumer shipments through CRSS’s integration of services including Fedex.

Outcomes

• Updating eProvenance’s core services CRSS Engineers updated the
• eProvenance MySQL DB, jumping forward several iterations to the latest version.
• Reconfiguring their email services to the Cloud using AWS which made a “tremendous difference” for internal stakeholders.
• Our team took a large vendors ledger software which was cumbersome and slow and created a proprietary distributed ledger for eProvenance. The new systemcut time to handle transactions down from 45 minutes pershipment to 2 minutes per shipment.
CRSS developed internalsoftware system(s) to help eProvenance move from a sensor centric system to a shipment focused system that integrated with our mobile app and OMS. Our system

integrates multiple data points including weather, geolocation data, individual container numbers for shippers (e.g., Mersk) into a dashboard of data that is used internally and by customers such as wineries, importers, auction houses and collectors.

At a glance

Industry

Monitored shipping of perishable items.

Company Size

Not known

Project Summary

systems integration work for eProvenance across multiple projects including a new email system, integrating new API functionality rather than rebuilding legacy code from scratch, and integrating multiple sources of external data for their analytics platform

Primary Technologies

• Pearl
• Python
• Django
• aws
• MySql

Download Pdf Version

Understand what happens to your precious cargo, connect with your customers, create brand value and build market share.

Wineries produce their vintages with extraordinary care. Importers are highly selective about the wines included in their portfolio. However, improper temperature is a top cause of damage to wine shipments. We know monitoring shipments and storage conditions lowers instances of damage and increases customer engagement, which often leads to higher sales.

With monitoring solutions at the container, pallet and case level to fit a wide range of needs and budgets, eProvenance can help assure your shipments are handled properly and facilitate feedback to channel partners when results are good or when problems arise. Whatever the size or the distance of your shipments, we have the solution to fit your needs.

Our proprietary, scientifically-based algorithm determines if wine is still fresh or if quality may have been compromised, not just whether inappropriate temperatures have been encountered; the resulting eProvenance Score (0-100) clearly tells you if there are any changes in wine quality. Monitoring helps enhance customer loyalty and strengthen brand differentiation by assuring your wines always taste as the winemaker intended.

“CRSS did an incredible job. They successfully and effectively performed systems integration work for eProvenance across multiple projects including a new email system, integrating new API functionality rather than rebuilding legacy code from scratch, and integrating multiple sources of external data for our analytics platform.”