Synthetic data, shaped after an Indian restaurant platform, with a UAE arm Canon Ops
World clock Fri 23:00:00 IST paused · 20×

Map

Which system each fact comes from, who owns it, and how fresh it is at 23:00:00 IST.

Systems

7
SystemWhat it holdsOwnerRefreshLast refreshed (IST)AgeKeysNote
Orders APIapiPlatform Engineering streamingFri 22:59 2 s ago
POS integration logslog_streamIntegrations streamingFri 22:59 19 s ago
Menu serviceserviceCatalogue every 15 minFri 22:45 14 min ago
BillingerpFinance daily 02:00Fri 02:04 20 h 55 min ago
CRMsaasSales Ops hourlyFri 22:00 59 min ago
Support desksaasCustomer Success every 5 minFri 22:57 2 min ago
DispatchapiLogistics streamingFri 22:59 10 s ago

Markets in this world

world preset india: shaped after an Indian restaurant platform, with a UAE arm · clock IST
CodeMarketCurrencyTime zoneCities
INIndiaINR Asia/Kolkata (IST)Mumbai, Bengaluru, Delhi, Hyderabad
AEUAEAED Asia/Dubai (GST)Dubai, Abu Dhabi
Public knowledge
  • INR at the fixed demo rate 1 INR = 0.0437 AED (canon/fx.py); India runs on IST (Asia/Kolkata, UTC+5:30, no daylight saving), so the world clock is IST and the UAE sits 1.5 hours behind it.
  • GST on restaurant food is 5%; UAE VAT is 5%. The Indian working week mostly rests Saturday and Sunday.
  • Zomato and Swiggy carry most food-delivery orders in India; magicpin and Thrive also take restaurant orders, and ONDC is the government-backed open network some restaurants list on. Restaurants also take orders on their own website or app and by phone.
  • Petpooja, Restroworks (formerly Posist), Rista, Torqus and LimeTray sell restaurant POS in India; Shadowfax, Porter, Delhivery and Dunzo run hyperlocal delivery for businesses; Tally is the common accounting system for Indian SMBs; Epson, Star and TVS Electronics sell receipt printers there; Oracle Simphony is common in large hotels.
  • Mumbai, Bengaluru, Delhi and Hyderabad are the large food-delivery metros; neighbourhood names and their approximate centres are public geography.
  • Zomato and Swiggy have publicly reported average food order values in the ₹400s; the price level here is set so the average delivered Indian order lands near that.
  • The UAE part (Dubai and Abu Dhabi, its apps, POS vendors and dispatch fleets) is the gulf preset's UAE with fewer stores.
Assumed
  • Every share and probability: which apps a store is listed on and how its demand splits (Zomato 52%, Swiggy 40%, magicpin 4%, ONDC 2%, Thrive 2% of aggregator demand where listed); POS, printer, KDS, ERP and dispatch shares; the cuisine mix.
  • Commission ranges and menu mark-ups per app, the order volume per store, and the number of stores per city (Mumbai 1,100, Bengaluru 1,100, Delhi 1,050, Hyderabad 650; Dubai 560, Abu Dhabi 240).
  • The hourly order curve (lunch peak 13:00-14:00, dinner peak 20:00-22:00 IST) and no seasonal dip.
  • Dunzo's share is kept small: its operations were scaled back sharply and its current state is not verified here.
  • Vendor version numbers, install weights, error rates and token lifetimes, Fresh KDS as the kitchen display, the Petpooja 3.19.1 release regression and every other incident are invented.
  • Menu items and prices come from the shared cuisine catalogue converted at the price level, so single items can look cheap or dear for a given city.
  • Platform fees (subscription, per-order and setup) are the platform's AED list prices converted at the fixed rate, not an Indian price list.
  • Merchant, brand-group and hotel names come from the shared name parts, which lean Gulf (brand groups such as 'Al Marri Hospitality', hotel outlets such as 'Al Majlis'); customer success managers are invented people.

Facts and their source

FactSystemTable / columnJoin keyUsed by
accepted_atOrders APIorders.accepted_at
first_order_atOrders APImerchants.first_order_at
order_eventsOrders APIorder_events.type
orders_dailyOrders APIorders_daily.orders
placed_atOrders APIorders.placed_at
rejection_reasonOrders APIorders.rejection_reason
statusOrders APIorders.status
totalOrders APIorders.total
auth_expires_atPOS integration logsintegrations.auth_expires_at
injected_atPOS integration logsorders.injected_at
integration_eventsPOS integration logsintegration_events.type
integration_statusPOS integration logsintegrations.status
last_sync_atPOS integration logsintegrations.last_sync_at
pos_versionPOS integration logsintegrations.version
ready_atPOS integration logsorders.ready_at
base_priceMenu servicemenu_items.base_price
item_availableMenu servicebranch_menu.available
menu_priceMenu servicebranch_menu.price
menu_synced_atMenu servicebranch_menu.last_synced_at
commission_pctBillingbranch_channels.commission_pct
due_atBillinginvoices.due_at
invoice_amountBillinginvoices.amount
issued_atBillinginvoices.issued_at
paid_atBillinginvoices.paid_at
capacity_per_15minCRMbranches.capacity_per_15min
channel_statusCRMbranch_channels.status
churned_atCRMmerchants.churned_at
contract_signed_atCRMmerchants.contract_signed_at
csm_ownerCRMmerchants.csm_owner
onboarded_atCRMmerchants.onboarded_at
planCRMmerchants.plan
segmentCRMmerchants.segment
ticket_categorySupport desktickets.category
ticket_closed_atSupport desktickets.closed_at
ticket_opened_atSupport desktickets.opened_at
delivered_atDispatchorders.delivered_at
picked_up_atDispatchorders.picked_up_at

Keys