Case Study Information
Summary
We partnered with the Iowa Food Foundation to build and maintain their custom Node.js eCommerce platform, which facilitates a unique, hybrid online-to-in-person farmer’s market experience. This specialized application seamlessly manages complex logistics, from time-gated ordering windows and multi-stage fulfillment to advanced payment and subscription features, ensuring small local farmers thrive and community buyers get fresh, reliable goods.
The Challenge
The Iowa Food Foundation operated a vital but logistically complex hybrid eCommerce platform connecting local farmers and consumers, where orders were placed online but fulfilled in-person at a bi-monthly market. They faced numerous technical hurdles, including unreliable inventory tracking across multiple sellers, clunky order management, and a lack of scalable infrastructure to support growing volumes. Critically, the manual processes surrounding the bi-monthly fulfillment cycle—managing time-sensitive ordering windows, complex product logistics (like cold storage items), and financial layers (payments, refunds, coupons)—were consuming unsustainable amounts of staff time.
The core challenge was transforming this complicated, error-prone manual fulfillment process into a smooth, automated digital experience that would boost operational efficiency, solidify the co-op’s reliability, and prepare the organization for significant future expansion. They needed a dedicated technical partner to provide continuous strategy and 24/7 support for their mission-critical platform.
They needed more than just a developer, they needed a dedicated technical partner capable of providing continuous strategy and 24/7 support for a mission-critical platform!
The Solution
Pell Software served as the client’s sole, dedicated technical partner for more than two years, taking over the development, design, and maintenance of the custom Node.js application and transforming it into a robust, world-class system.
Our approach began with a comprehensive audit and the adoption of the agile methodology, featuring two-week sprints and continuous strategic consulting, allowing us to align feature deployment perfectly with the client’s evolving operational needs. The core of the solution was the development of highly specialized, custom modules. We engineered a resilient custom fulfillment management module to manage the bi-monthly market cycle, implementing a time-gated ordering system to control sales windows and a multi-stage order status lifecycle to accurately track orders through picking, cold storage segregation, and customer pickup.
We also implemented a resilient custom inventory management system for multi-seller goods and integrated a sophisticated financial management layer supporting real-time payments, complex refunds, coupons, and user subscription tiers. The entire application was re-architected for scalability and hosted on Digital Ocean. Our comprehensive service included 24/7 monitoring and maintenance, ensuring the client had a stable, future-proof digital operational backbone to support their mission-critical services.
The Outcome
The partnership with Pell Software initiated a transformative period of growth and operational stability, resulting in a direct and measurable return on investment (ROI). First, the ROI was immediately realized through significant labor cost reduction. The newly automated order management and streamlined fulfillment system drastically reduced the time spent on administrative tasks. This allowed staff to reallocate time to high-value activities like farmer recruitment and community outreach. Second, the stability and customization of the platform fueled exponential business growth. The system successfully scaled to handle hundreds of users and tens of thousands of dollars in orders. Third, the reliability of the platform dramatically increased farmer and buyer satisfaction and trust. By engineering a stable, scalable, and custom-fit platform with 24/7 support, Pell Software provided the Iowa Food Foundation with a necessary digital infrastructure to thrive as a central, dependable hub for local commerce.
Date
September, 2021 – March, 2023
Pell Software took over development, maintenance, and strategic consulting for the application in September 2021. We served as the client’s sole, dedicated technical team through March 2023, implementing new features, optimizing workflows, and ensuring 24/7 platform stability.
Major Features
- Custom eCommerce Marketplace (B2B/B2C): A unified platform for hundreds of farmers and community buyers.
- Time-Gated Ordering Window Management: Automated system to open and close the store based on fixed, bi-monthly fulfillment dates.
- Bi-Monthly In-Person Fulfillment and Logistics System: Customized dashboard and reporting for on-site order picking and distribution.
- Farmer (Seller) and Buyer User Portals: Tailored user experiences for managing inventory, viewing orders, and accessing account details.
- Advanced Inventory and Stock Management: Handles multi-seller inventory, stock synchronization, and pre-order functionality.
- Multi-stage Order Status and Tracking Lifecycle: Granular tracking of orders through “Placed,” “Picking,” “Cooler/Freezer Segregation,” and “Customer Pickup.”
- Cold Storage/Freezer Item Segregation: Automated flagging and reporting for items requiring special climate-controlled handling during fulfillment.
- Integrated Payment Gateway: Secure processing of sales, immediate full/partial refunds, and payment reconciliation.
- Coupons, Discounts, and Order Cancellation: Complex logic implemented for various promotional and adjustment scenarios.
- Custom User Subscription Tiers and Membership Management: Supports different user access levels and benefits to generate recurring revenue.
Technologies Used & Keywords
- Programming Language(s): Javascript, MySQL, Express.js
- Framework(s): Node.js
- Infrastructure: Digital Ocean + various 24/7 monitoring routines
- Third-party Systems: Integrated Payment Gateway, various third-party APIs for logistics reporting and data analysis.
Client
Client Industry
Local Food Supply Chain & Nonprofit
Client Description
The Iowa Food Foundation operates a community-centered online marketplace that serves as a vital bridge between local Iowa farmers and consumers. Their mission is to foster a robust and equitable local food system by facilitating a unique co-op model where orders are placed online and reliably fulfilled through a recurring, in-person farmer’s market pickup.
Client Review
“We hired Pell to replace our original developer and we have had a wonderful experience. The team at Pell is great to work with. We have been very pleased with ease of communication and results.”
- Lisa Bean, Board President
1. We respond in 1 business day to schedule a 30-min call.
2. You speak directly with a US-based software expert, not a salesperson.
3. We’ll determine how we can help, or point you in the direction of someone who can!
