Skip to content
POOJYO
FestivalShiva & MuruganAnnualNovember–DecemberTamil Nadu

Karthigai Deepam

Rows of clay lamps along every wall and threshold. Second only to Diwali for diya and oil demand in the south.

12
Items needed
8
Essential
Cannot be skipped
₹3,862
Estimated total
₹2,002 for essentials only
2
Shops nearby
in Chennai
Essentials you can buy in Chennai88%

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

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

4.5
10 of 12 items83.3%
Basket here₹2,492

Still needed elsewhere: Camphor, Ghee

4.3
1 of 12 items8.3%
Basket here₹108

Still needed elsewhere: Agarbathi, Camphor, Coconut, Bananas +7 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

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.

Ghee No vendor near you has Ghee in stock right now.

Sesame OilIn stock nearby

Acceptable for the lamp. Never substitute it in the prasad.

Match
60%
₹210
per bottle

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(2)

Offerings & Prasad(4)

Oil Lamps(5)

Loose Flowers(1)

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

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