Onam
Ten days, and a fresh flower carpet laid at the threshold each morning — the single largest loose-flower requirement in the calendar.
Where to buy each item
Every item on the list, resolved to a shop that has it in stock.
A four-hop traversal. The trailing variable-length step is what lets “Chennai” match a florist registered in T. Nagar without you having to know that.Occasion → NEEDS → Product → AVAILABLE_AT → Florist → LOCATED_IN → Location → PART_OF*0..3
Petals are separated by colour the night before.
₹317for 60 piecesThe sadya is served on a full leaf, tip to the left.
₹270for 20 pieces- ₹169for 4 pieces
- ₹378for 4 kg
The pookalam is laid fresh each of the ten mornings and grows daily.
₹528for 5 kgThe white band of the flower carpet.
₹180for 40 pieces- ₹168for 3 mozham
- ₹75for 1 dozen
- ₹167for 2 bunches
- ₹85for 1 kg
- ₹246for 2 kg
Some households book a decorator for the ten-day pookalam.
₹1,164for 1 service
Fewest stops
Which single shop covers the most of this list — because visiting four shops on a festival morning is not realistic.
Traverse out to every vendor, then aggregate back per vendor while remembering which items were never covered. In SQL this needs a four-table join, a GROUP BY, and a correlated NOT EXISTS per checklist item.aggregate back over the traversal
Still needed elsewhere: Coconut, Jaggery, Clay Diyas, Rangoli & Kolam Service
Still needed elsewhere: Marigold (Loose), Coconut, Jaggery, Clay Diyas +1 more
Still needed elsewhere: Yellow Marigold, Pink Rose, Chrysanthemum (Sevanthi), Arali (Oleander) +2 more
Still needed elsewhere: Yellow Marigold, Pink Rose, Chrysanthemum (Sevanthi), Coconut +3 more
Still needed elsewhere: Yellow Marigold, Pink Rose, Chrysanthemum (Sevanthi), Coconut +3 more
Still needed elsewhere: Yellow Marigold, Pink Rose, Banana Leaves, Coconut +3 more
The full checklist
Grouped by category, essentials first. Quantities and notes come from the relationship between this occasion and each item.
The quantity, the unit, the importance and the note all live on the NEEDS relationship — not on the flower and not on the occasion. That is the clearest single argument for modelling this as a graph.Occasion → NEEDS → Product → BELONGS_TO → Category
Archana Flowers(2)
- ₹360est.
- ₹200est.
Loose Flowers(3)
- ₹600est.
- Yellow MarigoldEssential4 kg₹440est.
- Pink RoseRecommended2 bunches₹190est.
Sacred Leaves(1)
- ₹300est.
Oil Lamps(1)
- Clay DiyasRecommended1 dozen₹80est.
Seasonal Flowers(2)
- Chrysanthemum (Sevanthi)Recommended2 kg₹280est.
- Crossandra (Kanakambaram Sara)Recommended3 mozham₹195est.
Home Decoration(1)
- ₹2,800est.
Others also bought
Discovered from real purchase history, not from anything an editor curated.
Three hops through the purchase history: what does this occasion need, who bought those things, and what else did those people buy.Occasion → NEEDS → Product ← BOOKS ← Customer → BOOKS → Product
Kumkum
Bought by 23 people who also picked up Marigold (Loose) and Yellow Marigold
Camphor
Bought by 22 people who also picked up Marigold (Loose) and Yellow Marigold
Agarbathi
Bought by 21 people who also picked up Marigold (Loose) and Yellow Marigold
Akshata
Bought by 21 people who also picked up Marigold (Loose) and Yellow Marigold
Cotton Wicks
Bought by 21 people who also picked up Marigold (Loose) and Yellow Marigold
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Yellow Marigold
Rangoli Powder
Bought by 19 people who also picked up Marigold (Loose) and Yellow Marigold
Turmeric Powder
Bought by 19 people who also picked up Marigold (Loose) and Yellow Marigold
Coming up next
What this occasion usually precedes — worth buying for at the same time.
Occasions are sequenced in the graph, so the app can suggest buying once for two events instead of twice.Occasion → PRECEDES → Occasion