Skip to content
POOJYO
FlowersPinkSeason: June–SeptemberConsumable

Lotus

Offered whole to Lakshmi and Vishnu. Scarce outside the monsoon months and priced accordingly.

₹45per piece

Where to buy

Every shop that carries it, cheapest in-stock first.

Price, stock and lead time are properties of the AVAILABLE_AT relationship — the same product costs different amounts at different shops, and that fact belongs to the pairing.Product → AVAILABLE_AT → Florist → LOCATED_IN → Location

Shops selling Lotus
ShopAreaRatingPriceAvailability
Sri Kamakshi Flower StallT. Nagar 4.7(412)₹41In stock · Next day
Madurai Mala KadaiMeenakshi Nagar 4.6(288)₹42In stock · Next day
Kapali Flower MartMylapore 4.3(201)₹43In stock · Next day
Dadar Phool GalliDadar 4.7(891)₹44In stock · Next day
Dadar Mala CornerDadar 4.3(224)₹48In stock · Next day
Mysuru Hoo MandiDevaraja Mohalla 4.6(267)₹49In stock · Next day
Jayanagar Hoovina AngadiJayanagar 4.7(466)₹52In stock · Next day
Meenakshi Flower HouseMeenakshi Nagar 4.9(754)₹40Out of stock
Kovai Poo NilayamR. S. Puram 4.6(324)₹49Out of stock

7 of 9 shops have it in stock right now.

If you can't get it

Alternatives found by walking the substitution chain up to three hops.

Closeness is multiplied along the chain, so a substitute reached in two hops automatically scores lower than a direct one — no rule had to say so.Product → SUBSTITUTE_FOR*1..3 → Product

Pink RoseIn stock nearby

Widely accepted for Lakshmi outside the monsoon, when lotus simply is not available.

Match
60%
₹95
per bunch
Red RoseIn stock nearby2 hops away

Widely accepted for Lakshmi outside the monsoon, when lotus simply is not available.

Match
54%
₹90
per bunch
Red HibiscusIn stock nearby3 hops away

Widely accepted for Lakshmi outside the monsoon, when lotus simply is not available.

Match
30%
₹8
per piece

Needed for

Every occasion that calls for this, and how much each one needs.

Exactly the same relationship as the checklist, traversed in the other direction and at the same cost. A relational schema would need a second index for this.Occasion → NEEDS → Product (read backwards)

How Lotus connects to Lakshmi Pooja

The route the graph took, not just the fact that a route exists.

This is the query with no relational equivalent. A join returns rows; the joins that connected them are gone by the time the result exists. Only a graph can hand back the path itself.shortestPath, up to 6 hops

  1. Lotus is needed by
  2. Lakshmi Pooja

1 hop through the graph