Navratri
Nine nights, and in the south nine days of golu display. A different colour is kept each day, which makes the flower list unusually specific.
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
- ₹26for 1 packet
Given to every woman who visits the golu.
₹70for 2 packets- ₹41for 1 packet
- ₹127for 3 pieces
- ₹115for 2 packets
- ₹189for 3 dozen
- ₹243for 3 bunches
- Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹202for 2 packets
Refreshed every second day across the nine.
₹211for 2 kg- ₹387for 3 pieces
- ₹144for 1 piece
Installed on the first day and kept for all nine.
₹731for 1 pieceA different colour is kept each day; sevanthi covers the yellow days.
₹123for 1 kg- ₹138for 1 set
Sown on the first day and left to sprout through the nine.
₹194for 1 set- ₹3,880for 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 Rose, Chrysanthemum (Sevanthi), God Garland (Small), Camphor +2 more
Still needed elsewhere: Red Rose, Chrysanthemum (Sevanthi), God Garland (Small), Camphor +3 more
Still needed elsewhere: Red Rose, Chrysanthemum (Sevanthi), God Garland (Small), Camphor +5 more
Still needed elsewhere: Red Rose, Chrysanthemum (Sevanthi), God Garland (Small), Agarbathi +6 more
Still needed elsewhere: Chrysanthemum (Sevanthi), Agarbathi, Camphor, Kumkum +9 more
Still needed elsewhere: God Garland (Small), 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
Deity Garlands(1)
- God Garland (Small)Essential3 pieces₹450est.
Loose Flowers(2)
- ₹240est.
- Red RoseEssential3 bunches₹270est.
Offerings & Prasad(4)
Ritual Textiles(1)
- Red Ritual ClothEssential1 piece₹160est.
Ritual Vessels(1)
- ₹850est.
Sacred Powders(3)
- ₹80est.
- Turmeric PowderEssential1 packet₹45est.
- Rangoli PowderRecommended1 set₹150est.
Seasonal Flowers(1)
- Chrysanthemum (Sevanthi)Recommended1 kg
A different colour is kept each day; sevanthi covers the yellow days.
₹140est.
Home Decoration(1)
- Festival Home DecorationOptional1 service₹8,500est.
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 Rose
Jaggery
Bought by 21 people who also picked up Marigold (Loose) and Red Rose
Banana Leaves
Bought by 19 people who also picked up Marigold (Loose) and Red Rose
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Red Rose
Mango Leaves
Bought by 18 people who also picked up Marigold (Loose) and Red Rose
Jasmine (Malli)
Bought by 16 people who also picked up Marigold (Loose) and Red Rose
Sesame Oil
Bought by 16 people who also picked up Marigold (Loose) and Red Rose
Ghee
Bought by 15 people who also picked up Marigold (Loose) and Red Rose
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