All case studies

Edible Garden: Farm-to-Retail Operations Platform

An operations platform we built and maintain for Edible Garden, a hydroponic herb grower, that replaces manual re-keying of partner sales emails with automatic data import, forecasting and scheduled reporting.

Industry
Agriculture and fresh produce distribution (USA)
Services
Custom Software Development, Cloud Application Development, Cloud Data Engineering
Technology
Angular, ASP.NET Web API, Entity Framework, SQL Server on AWS RDS, AWS S3, Azure AD, Microsoft Graph, Exchange Web Services, Application Insights
Engagement
January 2020 - present (ongoing maintenance)

Problem

Edible Garden grows hydroponic herbs and supplies them to retail grocery chains across the US. Running that well means coordinating sowing schedules, greenhouse space, harvest timing, ageing inventory and two delivery channels, direct to store and through distribution centres. Each channel has its own orders and reporting, and the largest grocery accounts expect timely, accurate fill-rate reports.

Existing process

Much of the daily data arrived as emailed sales reports from distribution partners. Staff read each email and typed the figures into the system by hand. Reporting to retail accounts and planning ahead depended on that manual work being done correctly and on time.

What we built

Since January 2020 we have built and maintained one system that covers the whole cycle from greenhouse to retail account.

  • An admin portal for farm and sowing administration, spacing and transplant scheduling, cut-herb tracking, inventory, cost of goods and profit reporting by customer, and traceability.
  • A mailbox monitor that watches the shared reporting mailbox for the daily call sheet emails, collects the CSV attachments and imports them with no re-keying.
  • A forecasting engine that works from weekly sales per farm and product and year-over-year trends, and allows for each crop’s sow-to-harvest time, since a three-week crop and a six-week crop need different forecasts.
  • Scheduled fill-rate reports sent to retail accounts, including a dedicated report for the largest national grocery account.
  • Barcode and QR scanning for purchase orders on direct-to-store routes.

Architecture / technology

The portal is an Angular application on a .NET Web API with Entity Framework and SQL Server on AWS RDS, with separate production and UAT environments and the front end hosted on S3. The mailbox monitor uses Microsoft Graph and Exchange Web Services, sign-in uses Azure AD, and Application Insights provides monitoring. The scanning feature is a reusable component that plugs into the existing portal.

Outcome

Staff no longer retype partner sales emails: the data arrives in the system by itself. The business has a forecast that reflects how long each crop actually takes to grow, and regular reports reach retail accounts on schedule without anyone assembling them. The platform has run in production for more than four years and continues to change as the business does.

Related service: Custom Software Development

Ready to Transform Your Business?

Let's discuss how TechFlock can help you achieve your digital transformation goals.