How Web Development Is Used in Indian Retail Companies Today

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "Product",
  "name": "Cotton Kurta - Indigo",
  "sku": "KRT-IND-042",
  "image": "https://www.example-retail.in/img/krt-ind-042.webp",
  "offers": {
    "@type": "Offer",
    "priceCurrency": "INR",
    "price": "1299.00",
    "availability": "https://schema.org/InStock"
  }
}
</script>

<img
  src="/img/krt-ind-042-400.webp"
  srcset="/img/krt-ind-042-400.webp 400w,
          /img/krt-ind-042-800.webp 800w"
  sizes="(max-width: 600px) 400px, 800px"
  width="400" height="500"
  loading="lazy"
  alt="Indigo cotton kurta, front view">

from math import radians, sin, cos, asin, sqrt
from flask import Flask, jsonify, request

app = Flask(__name__)
STORES = [
    {"id": 1, "name": "Sector 18", "lat": 28.5708, "lng": 77.3260},
    {"id": 2, "name": "Connaught Place", "lat": 28.6315, "lng": 77.2167},
]

def km(lat1, lng1, lat2, lng2):
    lat1, lng1, lat2, lng2 = map(radians, [lat1, lng1, lat2, lng2])
    a = sin((lat2 - lat1) / 2) ** 2 + cos(lat1) * cos(lat2) * sin((lng2 - lng1) / 2) ** 2
    return 6371 * 2 * asin(sqrt(a))

@app.get("/stores")
def nearest_stores():
    lat, lng = float(request.args["lat"]), float(request.args["lng"])
    ranked = sorted(STORES, key=lambda s: km(lat, lng, s["lat"], s["lng"]))
    return jsonify([{**s, "km": round(km(lat, lng, s["lat"], s["lng"]), 1)} for s in ranked])

navigator.geolocation.getCurrentPosition(async (pos) => {
  const { latitude, longitude } = pos.coords;
  const res = await fetch(`/stores?lat=${latitude}&lng=${longitude}`);
  const stores = await res.json();
  console.log("Nearest store:", stores[0].name, stores[0].km, "km");
});

-- Items below reorder level in one store
SELECT p.sku, p.name, i.qty_on_hand, p.reorder_level
FROM inventory i
JOIN products p ON p.sku = i.sku
WHERE i.store_id = 18
  AND i.qty_on_hand < p.reorder_level
ORDER BY i.qty_on_hand ASC;

from functools import wraps
from flask import abort, g

def require_role(role):
    def decorator(view):
        @wraps(view)
        def wrapped(*args, **kwargs):
            if role not in getattr(g, "user_roles", []):
                abort(403)
            return view(*args, **kwargs)
        return wrapped
    return decorator

@app.post("/admin/prices")
@require_role("merchandiser")
def update_prices():
    ...

1. Product catalogue with filters (size, colour, price)
2. Store locator with distance and opening hours
3. Stock check by SKU and store (with mock data)
4. Store manager dashboard: daily sales, low stock
5. Price admin with approval before publishing

GET  /products?category=&size=&sort=
GET  /products/{sku}
GET  /stores?lat=&lng=   (or ?pincode=)
GET  /inventory/{sku}?store_id=
POST /reservations        {sku, store_id, phone}
GET  /admin/low-stock?store_id=
POST /admin/prices        (role: merchandiser)

# Mini Retail Platform
Problem: Customers want to know if items are in stock nearby
Stack: Python (Flask), PostgreSQL, HTML/CSS/JS
Features: catalogue, store finder, stock check, admin
Data: synthetic stores, products and inventory
How to run: ...
Screenshots: ...
What I would add next: reservations with expiry