Lakshmi Pooja
Worship of Lakshmi for prosperity, kept on Fridays and at the peak of Diwali. Lotus and red cloth are the signatures.
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
Lakshmi is seated on the lotus; it is her flower before any other.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹49 / piece · Next day₹243for 5 piecesNo 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.
—No shop in this area has it in stock.
—No shop in this area has it in stock.
—Ghee rather than oil for the lamp on a Friday.
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.
—Spread beneath the idol and the kalash.
No shop in this area has it in stock.
—- Mysuru Hoo Mandi· Devaraja Mohalla · ₹94 / bunch · Next day₹94for 1 bunch
Made to order and only in season — ask two days ahead.
Mysuru Hoo Mandi· Devaraja Mohalla · ₹1,044 / piece · Same day₹1,044for 1 piece- —
Covers most of this list in one box if you are short on time.
No shop in this area has it in stock.
—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: Kumkum, Turmeric Powder, Rangoli Powder, Coconut +8 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
Kumkum — No vendor near you has Kumkum 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.
Turmeric Powder — No vendor near you has Turmeric Powder 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.
Bananas — No vendor near you has Bananas 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
Offerings & Prasad(4)
Oil Lamps(3)
- ₹380est.
- Cotton WicksEssential1 packet₹25est.
- Brass Lamp (Kuthu Vilakku)Essential1 piece₹1,450est.
Ritual Textiles(1)
- ₹160est.
Sacred Leaves(1)
- ₹225est.
Sacred Powders(3)
- KumkumEssential1 packet₹40est.
- Turmeric PowderEssential1 packet₹45est.
- Rangoli PowderOptional1 set₹150est.
Deity Garlands(1)
- ₹900est.
Loose Flowers(1)
- Red RoseRecommended1 bunch₹90est.
Pooja Kits(1)
- ₹990est.
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
Camphor
Bought by 22 people who also picked up Red Rose and Lotus
Agarbathi
Bought by 21 people who also picked up Red Rose and Lotus
Banana Leaves
Bought by 19 people who also picked up Red Rose and Lotus
Betel Leaves & Nuts
Bought by 19 people who also picked up Red Rose and Lotus
Mango Leaves
Bought by 18 people who also picked up Red Rose and Lotus
Marigold (Loose)
Bought by 17 people who also picked up Red Rose and Lotus
Jasmine (Malli)
Bought by 16 people who also picked up Red Rose and Lotus
Sesame Oil
Bought by 16 people who also picked up Red Rose and Lotus