Dussehra
The tenth day, closing Navratri. Tools, books and instruments are worshipped before being taken up again.
Where to buy it in Madurai
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
Tools, books and instruments are garlanded before being taken up again.
₹106for 1 kgNo 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.
—No shop in this area has it in stock.
—- Madurai Mala Kadai· Meenakshi Nagar · ₹129 / piece · Same day₹129for 1 piece
No shop in this area has it in stock.
—No shop in this area has it in stock.
—- ₹166for 1 piece
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: Banana Leaves, Betel Leaves & Nuts, Camphor, Kumkum +4 more
Still needed elsewhere: Banana Leaves, Betel Leaves & Nuts, God Garland (Small), Camphor +5 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
Banana Leaves — No vendor near you has Banana Leaves 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.
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.
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
Incense & Camphor(1)
- CamphorEssential1 packet₹90est.
Loose Flowers(1)
- Marigold (Loose)Essential1 kg
Tools, books and instruments are garlanded before being taken up again.
₹120est.
Offerings & Prasad(4)
- CoconutEssential2 pieces₹90est.
- AkshataEssential1 packet₹30est.
- Betel Leaves & NutsRecommended2 sets₹80est.
- JaggeryRecommended0.5 kg₹90est.
Sacred Leaves(1)
- Banana LeavesEssential6 pieces₹90est.
Sacred Powders(2)
- KumkumEssential1 packet₹40est.
- Turmeric PowderEssential1 packet₹45est.
Deity Garlands(1)
- God Garland (Small)Recommended1 piece₹150est.
Occasion Garlands(1)
- Photo Frame GarlandOptional1 piece₹180est.
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
Agarbathi
Bought by 21 people who also picked up Marigold (Loose) and Banana Leaves
Cotton Wicks
Bought by 21 people who also picked up Marigold (Loose) and Banana Leaves
Rangoli Powder
Bought by 19 people who also picked up Marigold (Loose) and Banana Leaves
Mango Leaves
Bought by 18 people who also picked up Marigold (Loose) and Banana Leaves
Bananas
Bought by 16 people who also picked up Marigold (Loose) and Banana Leaves
Jasmine (Malli)
Bought by 16 people who also picked up Marigold (Loose) and Banana Leaves
Sesame Oil
Bought by 16 people who also picked up Marigold (Loose) and Banana Leaves
Ghee
Bought by 15 people who also picked up Marigold (Loose) 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
Saraswati Pooja
Books and instruments are placed before the goddess and left untouched for the day. White flowers throughout.
Diwali
Five days of lamps. The largest single spike in demand for diyas, oil, marigold and rangoli powder in the…