Varalakshmi Vratham
Kept by married women on the Friday before the full moon of Shravana. The kalash is dressed as the goddess herself.
Where to buy it in Chennai
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
- Adyar Pooja Mart· Adyar · ₹32 / packet · Next day₹32for 1 packet
- Adyar Pooja Mart· Adyar · ₹33 / bunch · Next day₹33for 1 bunch
Given to every woman who visits, with turmeric and betel.
Adyar Pooja Mart· Adyar · ₹35 / packet · Next day₹35for 1 packet- Adyar Pooja Mart· Adyar · ₹42 / packet · Next day₹42for 1 packet
- Adyar Pooja Mart· Adyar · ₹43 / piece · 2 days₹86for 2 pieces
Tied on the wrist and kept until it falls away on its own.
Adyar Pooja Mart· Adyar · ₹50 / packet · Next day₹50for 1 packet- ₹158for 3 mozham
- Adyar Pooja Mart· Adyar · ₹70 / dozen · Next day₹140for 2 dozen
- Kapali Flower Mart· Mylapore · ₹83 / bunch · 2 days₹166for 2 bunches
- Adyar Pooja Mart· Adyar · ₹94 / kg · Next day₹94for 1 kg
- ₹264for 2 pieces
The kalash is dressed as the goddess herself — face, jewellery and saree.
Adyar Pooja Mart· Adyar · ₹731 / piece · Next day₹731for 1 pieceNo shop in this area has it in stock.
—- ₹122for 3 pieces
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: Red Rose, Jasmine (Malli), Lotus, God Garland (Small) +2 more
Still needed elsewhere: Mango Leaves, God Garland (Small), Kumkum, Turmeric Powder +8 more
Still needed elsewhere: Red Rose, Mango Leaves, Kumkum, Turmeric Powder +8 more
Still needed elsewhere: Red Rose, Jasmine (Malli), Lotus, Mango Leaves +10 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
Red Ritual Cloth — No vendor near you has Red Ritual Cloth 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.
Lakshmi Pooja Kit — No vendor near you has Lakshmi Pooja Kit 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(1)
- God Garland (Small)Essential2 pieces₹300est.
Loose Flowers(1)
- Red RoseEssential2 bunches₹180est.
Offerings & Prasad(4)
Ritual Textiles(2)
- Red Ritual ClothEssential1 piece₹160est.
- ₹50est.
Ritual Vessels(1)
- Kalash (Brass)Essential1 piece
The kalash is dressed as the goddess herself — face, jewellery and saree.
₹850est.
Sacred Leaves(2)
- Mango LeavesEssential1 bunch₹30est.
- LotusRecommended3 pieces₹135est.
Sacred Powders(2)
- ₹40est.
- Turmeric PowderEssential1 packet₹45est.
Seasonal Flowers(1)
- Jasmine (Malli)Essential3 mozham₹180est.
Pooja Kits(1)
- Lakshmi Pooja KitRecommended1 kit₹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 Jasmine (Malli)
Agarbathi
Bought by 21 people who also picked up Red Rose and Jasmine (Malli)
Cotton Wicks
Bought by 21 people who also picked up Red Rose and Jasmine (Malli)
Banana Leaves
Bought by 19 people who also picked up Red Rose and Jasmine (Malli)
Betel Leaves & Nuts
Bought by 19 people who also picked up Red Rose and Jasmine (Malli)
Rangoli Powder
Bought by 19 people who also picked up Red Rose and Jasmine (Malli)
Marigold (Loose)
Bought by 17 people who also picked up Red Rose and Jasmine (Malli)
Sesame Oil
Bought by 16 people who also picked up Red Rose and Jasmine (Malli)
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