Diwali
Five days of lamps. The largest single spike in demand for diyas, oil, marigold and rangoli powder in the entire calendar.
Where to buy each item
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
- ₹46for 2 packets
- ₹26for 1 packet
- ₹35for 1 packet
- ₹85for 2 pieces
- ₹115for 2 packets
Soak them in water for an hour first or they drink the oil.
₹451for 6 dozen- Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹101for 1 packet
Prices roughly double in the week before Diwali. Order early.
₹317for 3 kgRedrawn at the threshold on each of the five days.
₹138for 1 set- ₹387for 2 metres
- ₹420for 2 bottles
For the offering and for the boxes given to neighbours.
₹627for 2 packetsOut of season by Diwali in most years — check substitutes.
₹203for 5 pieces- ₹85for 1 kg
- Matunga Pooja Bhandar· Matunga · ₹403 / bottle · Next day₹403for 1 bottle
Lakshmi Pooja on the third day is the heart of Diwali.
₹851for 1 kit- ₹1,392for 1 piece
- ₹3,880for 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: Lotus, Marigold Torana, Camphor, Ghee +2 more
Still needed elsewhere: Lotus, Marigold Torana, Camphor, Kumkum +2 more
Still needed elsewhere: Lotus, Marigold Torana, Camphor, Coconut +4 more
Still needed elsewhere: Lotus, Marigold Torana, Agarbathi, Rangoli Powder +7 more
Still needed elsewhere: Agarbathi, Camphor, Kumkum, Rangoli Powder +11 more
Still needed elsewhere: Agarbathi, Camphor, Kumkum, Rangoli Powder +11 more
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
Loose Flowers(1)
- ₹360est.
Occasion Garlands(1)
- Marigold ToranaEssential2 metres₹440est.
Offerings & Prasad(4)
Oil Lamps(5)
- Sesame OilEssential2 bottles₹420est.
- Cotton WicksEssential2 packets₹50est.
- ₹480est.
- GheeRecommended1 bottle₹380est.
- Brass Lamp (Kuthu Vilakku)Recommended1 piece₹1,450est.
Sacred Powders(2)
- KumkumEssential1 packet₹40est.
- ₹150est.
Pooja Kits(1)
- ₹990est.
Sacred Leaves(1)
- ₹225est.
Home Decoration(1)
- Festival Home DecorationOptional1 service₹8,500est.
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
Banana Leaves
Bought by 19 people who also picked up Marigold (Loose) and Lotus
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Lotus
Turmeric Powder
Bought by 19 people who also picked up Marigold (Loose) and Lotus
Mango Leaves
Bought by 18 people who also picked up Marigold (Loose) and Lotus
Bananas
Bought by 16 people who also picked up Marigold (Loose) and Lotus
Jasmine (Malli)
Bought by 16 people who also picked up Marigold (Loose) and Lotus
Vibuthi
Bought by 13 people who also picked up Marigold (Loose) and Lotus
Red Hibiscus
Bought by 12 people who also picked up Marigold (Loose) and Lotus
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