House Warming (Griha Pravesh)
Entering a new home. Milk is boiled over until it spills, the kalash is carried in first, and the threshold is drawn with kolam.
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 · ₹33 / bunch · Next day₹67for 2 bunches
- Adyar Pooja Mart· Adyar · ₹35 / packet · Next day₹35for 1 packet
- Adyar Pooja Mart· Adyar · ₹42 / packet · Next day₹42for 1 packet
One for the kalash, one broken at the threshold, one for the prasad.
Adyar Pooja Mart· Adyar · ₹43 / piece · 2 days₹130for 3 piecesThe kolam is drawn before anyone steps inside.
Adyar Pooja Mart· Adyar · ₹141 / set · Next day₹141for 1 setMeasure the main door frame before ordering.
₹634for 3 metresNine grains for the nine planets, placed at the corners.
Adyar Pooja Mart· Adyar · ₹246 / set · Next day₹246for 1 setCarried in first, ahead of any person or furniture.
Adyar Pooja Mart· Adyar · ₹731 / piece · Next day₹731for 1 pieceFor the lamp and for the milk that is boiled over.
No shop in this area has it in stock.
—- ₹132for 8 pieces
- ₹70for 2 sets
One lamp in every room, lit the same evening.
Adyar Pooja Mart· Adyar · ₹91 / dozen · 2 days₹182for 2 dozenTraditionally the first purchase for a new altar.
Adyar Pooja Mart· Adyar · ₹1,682 / piece · Next day₹1,682for 1 pieceBook at least five days ahead; decorators are busiest on auspicious dates.
Anna Nagar Event Decorators· Anna Nagar · ₹6,300 / service · 4 days₹6,300for 1 serviceBundles the kalash, navadhanya and boiling vessel together.
No shop in this area has it in stock.
—- Anna Nagar Event Decorators· Anna Nagar · ₹2,825 / service · 2 days₹2,825for 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: Marigold Torana, Ghee, Griha Pravesh Kit, House Warming Decoration +1 more
Still needed elsewhere: Mango Leaves, Marigold Torana, Kumkum, Turmeric Powder +10 more
Still needed elsewhere: Mango Leaves, Banana Leaves, Kumkum, Turmeric Powder +10 more
Still needed elsewhere: Mango Leaves, Banana Leaves, Kumkum, Turmeric Powder +10 more
Still needed elsewhere: Mango Leaves, Banana Leaves, Betel Leaves & Nuts, Marigold Torana +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
Ghee — No vendor near you has Ghee in stock right now.
Griha Pravesh Kit — No vendor near you has Griha Pravesh 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
Occasion Garlands(1)
- ₹660est.
Offerings & Prasad(3)
- ₹135est.
- ₹220est.
- Betel Leaves & NutsRecommended2 sets₹80est.
Oil Lamps(3)
- ₹380est.
- ₹160est.
- ₹1,450est.
Ritual Vessels(1)
- ₹850est.
Sacred Leaves(2)
- Mango LeavesEssential2 bunches₹60est.
- Banana LeavesRecommended8 pieces₹120est.
Sacred Powders(3)
- KumkumEssential1 packet₹40est.
- Turmeric PowderEssential1 packet₹45est.
- ₹150est.
Home Decoration(2)
- House Warming DecorationRecommended1 service
Book at least five days ahead; decorators are busiest on auspicious dates.
₹12,000est. - Entrance Torana SetupOptional1 service₹4,500est.
Pooja Kits(1)
- ₹1,650est.
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 Mango Leaves and Banana Leaves
Agarbathi
Bought by 21 people who also picked up Mango Leaves and Banana Leaves
Akshata
Bought by 21 people who also picked up Mango Leaves and Banana Leaves
Cotton Wicks
Bought by 21 people who also picked up Mango Leaves and Banana Leaves
Jaggery
Bought by 21 people who also picked up Mango Leaves and Banana Leaves
Marigold (Loose)
Bought by 17 people who also picked up Mango Leaves and Banana Leaves
Bananas
Bought by 16 people who also picked up Mango Leaves and Banana Leaves
Jasmine (Malli)
Bought by 16 people who also picked up Mango Leaves and Banana Leaves
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