Ganesh Chaturthi
Eleven days from installation to immersion. Durva grass in bunches of twenty-one and red hibiscus are non-negotiable; twenty-one modaks are offered on the first day.
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
Red hibiscus is Ganesha’s flower. Buy on the morning — they wilt within hours.
₹155for 21 piecesTwenty-one blades per offering. Nothing else may be substituted for durva.
₹40for 3 bunches- ₹108for 8 pieces
- ₹26for 1 packet
- ₹53for 2 bunches
- ₹35for 1 packet
- ₹127for 3 pieces
- ₹115for 2 packets
Twenty-one modaks, and jaggery is the filling.
₹85for 1 kgEleven days of aarti, morning and evening.
Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹202for 2 packets- ₹211for 2 kg
Sized to the idol. Measure before ordering.
₹387for 1 piece- ₹150for 2 dozen
- ₹138for 1 set
- ₹144for 1 piece
- ₹234for 1 piece
Includes the modak mould and the printed vidhi.
₹819for 1 kitFor a community installation rather than a household one.
₹18,540for 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: Red Hibiscus, God Garland (Large), Camphor, Red Ritual Cloth +3 more
Still needed elsewhere: Mango Leaves, God Garland (Large), Camphor, Kumkum +3 more
Still needed elsewhere: Red Hibiscus, God Garland (Large), Agarbathi, Rangoli Powder +4 more
Still needed elsewhere: Red Hibiscus, Banana Leaves, God Garland (Large), Camphor +4 more
Still needed elsewhere: God Garland (Large), Agarbathi, Camphor, Kumkum +9 more
Still needed elsewhere: Red Hibiscus, Agarbathi, Camphor, Kumkum +9 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(1)
- Red HibiscusEssential21 pieces
Red hibiscus is Ganesha’s flower. Buy on the morning — they wilt within hours.
₹168est.
Deity Garlands(1)
- ₹450est.
Incense & Camphor(2)
- AgarbathiEssential2 packets₹120est.
- ₹180est.
Loose Flowers(1)
- Marigold (Loose)Essential2 kg₹240est.
Offerings & Prasad(3)
Sacred Leaves(3)
- Durva GrassEssential3 bunches
Twenty-one blades per offering. Nothing else may be substituted for durva.
₹45est. - Mango LeavesEssential2 bunches₹60est.
- Banana LeavesEssential8 pieces₹120est.
Sacred Powders(2)
- KumkumEssential1 packet₹40est.
- Rangoli PowderRecommended1 set₹150est.
Oil Lamps(1)
- Clay DiyasRecommended2 dozen₹160est.
Pooja Kits(1)
- ₹890est.
Ritual Textiles(1)
- Red Ritual ClothRecommended1 piece₹160est.
Ritual Vessels(1)
- Modak MouldRecommended1 piece₹260est.
Temple Decoration(1)
- ₹32,000est.
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
Cotton Wicks
Bought by 21 people who also picked up Marigold (Loose) and Red Hibiscus
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Turmeric Powder
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Bananas
Bought by 16 people who also picked up Marigold (Loose) and Red Hibiscus
Jasmine (Malli)
Bought by 16 people who also picked up Marigold (Loose) and Red Hibiscus
Sesame Oil
Bought by 16 people who also picked up Marigold (Loose) and Red Hibiscus
Ghee
Bought by 15 people who also picked up Marigold (Loose) and Red Hibiscus
Vibuthi
Bought by 13 people who also picked up Marigold (Loose) and Red Hibiscus
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