Satyanarayan Pooja
A vrat performed on the full moon or after a milestone — a new job, a new house, a safe return. Tulsi is essential and has no accepted substitute.
Where to buy it in Mysuru
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
Prasad is served on these; count one per person present.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹14 / piece · Next day₹86for 6 piecesNo substitute is accepted for tulsi in Vishnu worship. Buy it fresh on the day.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹18 / bunch · Next day₹36for 2 bunchesFive leaves set in the mouth of the kalash.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹28 / bunch · Next day₹28for 1 bunchOne hundred and eight leaves, strung.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹137 / piece · Same day₹137for 1 pieceNo shop in this area has it in stock.
—No shop in this area has it in stock.
—No shop in this area has it in stock.
—The sheera prasad is jaggery, semolina and ghee in equal measure.
No shop in this area has it in stock.
—No shop in this area has it in stock.
—No shop in this area has it in stock.
—- —
Milk, curd, ghee, honey and sugar for the abhishekam.
No shop in this area has it in stock.
—- Mysuru Hoo Mandi· Devaraja Mohalla · ₹38 / set · Next day₹38for 1 set
No shop in this area has it in stock.
—No shop in this area has it in stock.
—Includes the katha booklet, which is read aloud during the pooja.
No shop in this area has it in stock.
—
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: God Garland (Small), Agarbathi, Camphor, Coconut +7 more
Can't get something? Use this instead
Alternatives for the items no shop nearby has in stock.
Substitutes chain. Jasmine is out of season, tuberose stands in for jasmine, chrysanthemum stands in for tuberose — the walk follows the chain and scores each extra hop lower on its own.Product → SUBSTITUTE_FOR*1..3 → Product
Agarbathi — No vendor near you has Agarbathi in stock, and there is no accepted substitute for it. It is worth widening your search area.
There is no accepted substitute for this one. It is worth widening your search area rather than replacing it.
Camphor — No vendor near you has Camphor in stock, and there is no accepted substitute for it. It is worth widening your search area.
There is no accepted substitute for this one. It is worth widening your search area rather than replacing it.
Coconut — No vendor near you has Coconut in stock, and there is no accepted substitute for it. It is worth widening your search area.
There is no accepted substitute for this one. It is worth widening your search area rather than replacing it.
Jaggery — No vendor near you has Jaggery in stock, and there is no accepted substitute for it. It is worth widening your search area.
There is no accepted substitute for this one. It is worth widening your search area rather than replacing it.
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(2)
- ₹120est.
- God Garland (Small)Recommended1 piece₹150est.
Offerings & Prasad(6)
- CoconutEssential2 pieces₹90est.
- ₹90est.
- AkshataEssential1 packet₹30est.
- ₹340est.
- Betel Leaves & NutsRecommended1 set₹40est.
- Dry FruitsRecommended1 packet₹320est.
Ritual Textiles(1)
- ₹160est.
Ritual Vessels(1)
- Kalash (Brass)Essential1 piece₹850est.
Sacred Leaves(3)
- Tulsi LeavesEssential2 bunches
No substitute is accepted for tulsi in Vishnu worship. Buy it fresh on the day.
₹40est. - ₹30est.
- ₹90est.
Pooja Kits(1)
- Satyanarayan Pooja KitRecommended1 kit
Includes the katha booklet, which is read aloud during the pooja.
₹1,150est.
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 Tulsi Leaves and Mango Leaves
Cotton Wicks
Bought by 21 people who also picked up Tulsi Leaves and Mango Leaves
Rangoli Powder
Bought by 19 people who also picked up Tulsi Leaves and Mango Leaves
Turmeric Powder
Bought by 19 people who also picked up Tulsi Leaves and Mango Leaves
Marigold (Loose)
Bought by 17 people who also picked up Tulsi Leaves and Mango Leaves
Bananas
Bought by 16 people who also picked up Tulsi Leaves and Mango Leaves
Jasmine (Malli)
Bought by 16 people who also picked up Tulsi Leaves and Mango Leaves
Sesame Oil
Bought by 16 people who also picked up Tulsi Leaves and Mango Leaves