A logistics and sales system for a network of agroecological producers and consumers
- Who is asking
- A network of agroecological producers and consumers.
- Who brought it
- A fessional who has been building it since before sidepro existed.
- The problem
- Every two weeks, orders have to be coordinated between a network of producers from Córdoba and other provinces and the families who buy. Loading products, putting the order form together, collecting orders, sending pick lists, receiving at the warehouse, adjusting shortages, delivering and settling were manual steps, spread across spreadsheets, WhatsApp and email.
- What exists today
- Each round depended on a single person, who handled all the information between more than 50 producers and 80 to 100 families. Before, a Google form took the orders and the rest was done by hand, between WhatsApp, Gmail and typing into spreadsheets. Today, custom forms in plain HTML and JavaScript, served by GitHub Pages, have fully replaced the Google form. Google Sheets works as the database of an automated system, not as a record edited by hand: more than thirty sheets (producers, products, consumers, rounds, orders, items, pick lists, receipts, adjustments, settlement, leftovers, stock, payments, change log). Around twenty Make scenarios, triggered by webhook, move data between forms and sheets; email and a WhatsApp group send the notices.
- What has to keep running
- That the network's team can open and close a full round, from loading products to settling with producers, guided step by step by the system and operable by whoever is in charge, with no bottlenecks or long manual data entry. That the system covers every operational case that can come up (shortages, adjustments, uncollected orders, leftovers, corrections) so the record is consistent and reliable end to end.
- Who operates it
- A person on the network's team, who already runs rounds on her own. Alternate: anyone else on the team; the system is simple and guides itself.
- Built with
- Plain HTML and JS forms on GitHub Pages · Google Sheets as database · Make (webhook scenarios, paid plan) · Google Drive for backups · email and WhatsApp for notices. The network pays for Make and its accounts. Next step: moving the database from Google Sheets to Supabase or similar. Plan B, if Make changes its price, goes in MANTENIMIENTO.md.
- Hours
- 4 a week, 12 weeks, as a pair. It was already under way when sidepro was born; it joined the method at stage 4.
- License
- The form code is already MIT, chosen by the network. The spreadsheet and the scenarios are documented in the network's repo.
- Funding
- Yes, in kind. An hourly value in pesos was agreed according to the network's real possibilities, and it was paid in agroecological food managed by the network. No invoice, since it was an exchange. Milestone: the system launched and used for a full round, replacing the previous one. It is not a precedent: it is one possible kind of agreement.
- Stage
- 4 Solo · of five, per RFC-001