Elbatria Solutions
FREN

FOOD DISTRIBUTION / CASE STUDY

An order and delivery management system

A fruit and vegetable distributor in the New York area needed to move away from an operation heavily dependent on the owner and paper documents.

SECTORFood Distribution
MY ROLEDesign & improvement
ROLEJulien Mottet · consultant

Simplified representation of the system · illustrative data, not contractually binding

01

The starting point

Orders and preparation required significant involvement from the owner. Growth meant making the operation something others could take over.

02

My role

I designed a system connecting order intake, invoicing and delivery around Airtable.

03

The system

A B2B form is sent by text message. Shopify orders also flow into Airtable. Approved orders feed into QuickBooks and TrackPod. A summary of quantities is generated for the order preparation team.

04

The outcome

Truck preparation at 4 a.m. could be delegated. The system holds the information needed to carry out the work.

05

What this case shows

Connecting tools makes it possible to hand over an operation. No quantified time savings are claimed here.

01Order intake
02Approval
03Invoicing
04Delivery
How the system works · simplified diagram

THE NEXT STEP

Let’s talk about your project

Tell me what is causing you problems
in your organisation or current tools.