| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Calendar (calendar) • Contacts (contacts) • Discuss (mail) |
| Lines of code | 1650 |
| Technical Name |
cold_storage_roi |
| License | LGPL-3 |
| Website | https://github.com/Javoh1r121/odoo-cold-storage-roi |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Calendar (calendar) • Contacts (contacts) • Discuss (mail) |
| Lines of code | 1650 |
| Technical Name |
cold_storage_roi |
| License | LGPL-3 |
| Website | https://github.com/Javoh1r121/odoo-cold-storage-roi |
Overview
This module helps cold storage rental companies close more deals by giving salespeople a powerful ROI calculator inside every CRM opportunity. When a farmer calls, the salesperson can instantly show how much more profit they'll earn by storing their harvest instead of selling at harvest-time prices.
The calculator handles multiple crop types per farmer, applies real seasonal price curves (growth → peak → crash), deducts biological weight loss, and computes tiered electricity costs — all configurable by admin without touching code.
Key Features
Any Crop Type
Add unlimited fruit and vegetable types. Each crop has its own price curve, weight loss rates, and electricity consumption — all managed from admin UI.
Seasonal Price Curves
3-phase price model: growth (smoothstep curve to peak), golden period (peak maintained), and crash phase (geometric decline when new season arrives).
Biological Weight Loss
Automatically deducts fixed spoilage (3%), monthly moisture loss (0.8%/month), and accelerated decay for long-term storage (after month 8: +15%/month).
Tiered Electricity Costs
Calculates electricity costs using progressive tariff bands. The more and longer you store, the higher the per-unit cost — just like real utility billing.
Optimal Month Finder
Automatically calculates net profit for all 12 months and highlights the optimal storage duration — the month that maximizes farmer's profit.
Saved to CRM Record
Calculation results are saved directly to the CRM opportunity. Review historical calculations anytime, and track which leads received ROI analysis.
How It Works
Admin configures crop types
Go to CRM → Configuration → Sovuq Ombor → Crop Configuration. Add any fruit or vegetable with its seasonal price multiplier, weight loss rates, and electricity consumption. Default crops (Apple, Grape, Pomegranate, Peach, Pear, Melon) are pre-loaded on installation.
Salesperson opens a CRM opportunity
When a farmer lead comes in, open the opportunity and navigate to the ❄️ Cold Storage ROI tab. It appears automatically in every opportunity form.
Enter farmer's data
Add one row per crop type. For each crop enter: harvest volume (tonnes), current market price (per kg), and planned storage duration (months). Add as many crops as needed — a farmer can store multiple fruit types simultaneously.
Instant ROI calculation
Click ⚡ Calculate ROI. Results appear instantly (no server roundtrip): current revenue, future revenue, electricity costs, net profit, weight loss breakdown, and the optimal storage month for maximum profit.
Save and close the deal
Click Save Result to store the calculation on the CRM record. The farmer sees exactly how much more they earn by storing — making the sale much easier to close.
Seasonal Price Model
Prices don't rise linearly — they follow a real agricultural market curve:
📈 Phase 1: Growth
Months 1–7
Smoothstep curve up to peak multiplier
⭐ Phase 2: Peak
Months 7–9
Golden period — maximum price maintained
📉 Phase 3: Crash
Month 9+
New season arrives — 40%/month decline
Pre-loaded Crop Configurations
All values are editable from admin UI. Add new crops anytime.
| Crop | Peak Multiplier | Peak Period | Crash Rate/month | Accel. Decay after |
|---|---|---|---|---|
| 🍎 Apple | 2.4x | Month 7–9 | 40% | Month 8 |
| 🍇 Grape | 3.2x | Month 7–9 | 40% | Month 8 |
| 🍈 Pomegranate | 2.8x | Month 7–9 | 40% | Month 8 |
| 🍑 Peach | 2.6x | Month 6–8 | 45% | Month 6 |
| 🍐 Pear | 2.2x | Month 7–9 | 35% | Month 8 |
| 🍈 Melon | 2.0x | Month 5–7 | 50% | Month 5 |
Compatibility
No third-party dependencies. Pure Odoo OWL framework for frontend, standard Python/XML for backend.
Configuration
After installation:
- Go to CRM → Configuration → Sovuq Ombor → Crop Configuration to manage crops
- Go to CRM → Configuration → Sovuq Ombor → Electricity Tariffs to update utility rates
- Open any CRM Opportunity → ❄️ Cold Storage ROI tab to use the calculator
Please log in to comment on this module