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,800
Estimated total
₹1,836 for essentials only
6
Shops nearby
anywhere
Essentials available from at least one shop100%

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

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.6
10 of 12 items83.3%
Basket here₹2,801

Still needed elsewhere: Camphor, Bananas

4.5
6 of 12 items50%
Basket here₹659

Still needed elsewhere: Agarbathi, Coconut, Ghee, Cotton Wicks +2 more

4.4
5 of 12 items41.7%
Basket here₹1,688

Still needed elsewhere: Camphor, Coconut, Bananas, Jaggery +3 more

Madurai Mala Kadai
Meenakshi Nagar
4.6
1 of 12 items8.3%
Basket here₹106

Still needed elsewhere: Agarbathi, Camphor, Coconut, Bananas +7 more

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

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

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